I am recording price data on influx. The problem is that the price data comes every minute but sometimes for example 13.40.1 clock and other times 13.40.13 [hours,minutes,seconds].
I want to pull the last price one hour ago but if I enter this command:
select “value” from “ethereum” where “currency” = ‘usd’ and “tag” = ‘price’ and “time” = 10h
I get nothing cause the seconds are not the same from now like they from ten hours ago. You know ?
How can I fix this ?
Thanks for help and sorry for bad explaining