I have a stock tick data which is stored in timescale DB… the data starts from 9.15AM to 3.30PM (market hours).
I have created continuous aggregates in 5m, 15m, 30m, 1H, 75m, 2H, 4H…
the problem I am facing is, the aggregates start time should always consider 9.15AM. But timescale DB considers according to the clock time.
for example, 4H aggregate I expect it to calculate from 9:15am to 12.15pm, 12.15pm to 3.30pm… instead, timescale DB uses clock time of 4H intervals, 8am to 12pm, 12pm to 4pm…
how to solve for this?