Stellar — Balance of an address at a past date

What one Stellar 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

# Stellar - 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) {
  stellar(network: stellar) {
    received: payments(receiver: {is: $address}, date: {till: $till}) {
      currencyTo { name symbol }
      amountTo(calculate: sum)
    }
    sent: payments(sender: {is: $address}, date: {till: $till}) {
      currencyFrom { name symbol }
      amountFrom(calculate: sum)
    }
  }
}

Variables

{"address": "GB3LKXDV7MKIJ7YTCFBVGPMGH3CTXMR4DESXS2XUM6FH32HR6NCYOXCC", "till": "2026-08-01T00:00:00Z"}

Similar queries