Snapshot Balances on the hour - query request

I need a way to snapshot balances,

I need a range of a day, 24 hours, snapshot balances on each of those hours.

How can I do this? The sum of balanceupdates seems a really bad approach to do this.

Currently you can query balance upto a date balance up to a date

but not do daily snapshop of balance in 1 query.

We have timeinterval inside Block-> time but it doesn’t work in this case.

We will think about it

It would be very helpfull, thank you

Bro I need some help, I’m doing something that can be profitable for Bitquery, but I need some help with the queries