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.
What it returns
- currency to name
- currency to symbol
- amount to
- currency from name
- currency from symbol
- amount from
Filters
- receiver is GB3LKX…OXCC
- sender is GB3LKX…OXCC
- date till 2026-08-01
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
- Stellar — Latest payments · Stellar · payments
- payments of DBTK · Stellar · payments
- Stellar_balance · Stellar · payments
- Stellar_transactions_ · Stellar · payments
- payments · Stellar · payments