I would like to query data at a specific timestamp from a database where a datapoint for this timestamp not necessarily exists.
I would like to query data at “2020-04-02 02:30:00” from the following measurement table:
time value ================================== 2020-04-02 01:00:00 10 2020-04-02 02:00:00 20 2020-04-02 03:00:00 30 2020-04-02 04:00:00 40
Since there is no data available for this timestamp I would like to get data which got somehow interpolated, like the mean between the two closest datapoints or even just the closest or the previous datapoint.
I saw that one can do interpolation in a group by statement (https://www.influxdata.com/blog/working-with-irregular-time-series/). So my question is if there is a way to get interpolated data at a specific timestamp in a single select-statement as well.