# Snapshot Balances on the hour - query request

**URL:** <https://community.bitquery.io/t/snapshot-balances-on-the-hour-query-request/1673>\
**Category:** GraphQL API\
**Created:** [September 17, 2023, 6:10pm UTC](https://community.bitquery.io/t/snapshot-balances-on-the-hour-query-request/1673 "2023-09-17T18:10:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![NoFace](https://avatars.discourse-cdn.com/v4/letter/n/41988e/32.png) [@NoFace](https://community.bitquery.io/u/NoFace)\
**Post date:** [September 17, 2023, 6:10pm UTC](https://community.bitquery.io/t/snapshot-balances-on-the-hour-query-request/1673/1 "2023-09-17T18:10:24Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![gaurav](https://avatars.discourse-cdn.com/v4/letter/g/b487fb/32.png) [@gaurav](https://community.bitquery.io/u/gaurav)\
**Post date:** [September 18, 2023, 6:30pm UTC](https://community.bitquery.io/t/snapshot-balances-on-the-hour-query-request/1673/2 "2023-09-18T18:30:54Z")

</div>

Currently you can query balance upto a date [balance up to a date](https://ide.bitquery.io/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

---

<div class="post-metadata">

**Author:** ![NoFace](https://avatars.discourse-cdn.com/v4/letter/n/41988e/32.png) [@NoFace](https://community.bitquery.io/u/NoFace)\
**Post date:** [September 19, 2023, 3:30pm UTC](https://community.bitquery.io/t/snapshot-balances-on-the-hour-query-request/1673/3 "2023-09-19T15:30:19Z")

</div>

It would be very helpfull, thank you

---

<div class="post-metadata">

**Author:** ![NoFace](https://avatars.discourse-cdn.com/v4/letter/n/41988e/32.png) [@NoFace](https://community.bitquery.io/u/NoFace)\
**Post date:** [September 21, 2023, 9:19am UTC](https://community.bitquery.io/t/snapshot-balances-on-the-hour-query-request/1673/4 "2023-09-21T09:19:43Z")

</div>

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