1d spread query - wrong timestamp (previous day 20:00 ?)

I guess you’re using Influx? Maybe you could share more details about

In principle that should be the solution to this kind of behavior. See also Daily chart starting at midnight - #4 by svetb