Celo — Balance of an address at a past date

What one Celo address held as of a chosen date. Move the date in the Variables pane.

By gaurav · saved 27 August 2026 · Bitquery API v1

What it returns

Filters

The query

# Celo - Balances & Holders - Balance of an address at a past date
#
# Balances are cumulative state, so this cannot be answered from the realtime
# window alone - a realtime-only balance is the change over the last few
# hours, not the balance.
#
# Bitquery V1 query - send it to https://graphql.bitquery.io. The V2 endpoint
# does not serve this chain.
#
# The date bound stops this scanning the whole chain - without one it fails
# with ClickHouse Code 241 (memory limit). Move `since` in the Variables pane;
# the safe window differs per chain.
#
# Datasets:  https://docs.bitquery.io/docs/graphql/dataset/archive/
# Retention: https://docs.bitquery.io/docs/graphql/data-coverage-retention/

query ($address: String!, $till: ISO8601DateTime) {
  ethereum(network: celo_mainnet) {
    received: transfers(receiver: {is: $address}, date: {till: $till}) {
      currency { symbol address }
      amount(calculate: sum)
    }
    sent: transfers(sender: {is: $address}, date: {till: $till}) {
      currency { symbol address }
      amount(calculate: sum)
    }
  }
}

Variables

{"address": "0x765de816845861e75a25fca122bb6898b8b1282a", "till": "2026-06-01T00:00:00Z"}

Similar queries