Hello,
i am pretty much new to influxDB and i’m having some problems trying to figure out how to store and query ohlc data.
I do not have raw prices so i would not like to aggregate results. I would like to store already aggregated OHLC data.
For instance:
rows would like something like this
Open Close Low High Volume _time
85.55 86.55 84.55 88.66 11343.22 2023-08-23 09:15:00
85.55 86.55 84.55 88.66 11343.22 2023-08-23 09:16:00
85.55 86.55 84.55 88.66 11343.22 2023-08-23 09:17:00
When I store the data, the _start
and _end
fields are hardcoded to now()
and i can manipulate _time
field using time()
function from python client
Can I tell range()
function to use _time field instead of _start and _end ?
In this scenario, i would have one bucket for each timeframe … so 1m data would be in ohlc_1m bucket, and 60m data in ohlc_60m bucket.
Would that make sense or would it better to just to store minute ohlc and then do aggregation like presented in this thread?