Bitcoin — Balance of an address at a past date
What one Bitcoin address held as of a chosen date. Move the date in the Variables pane.
What it returns
- value
- count
Filters
- output address is 1KHc5U…Ez1E
- input address is 1KHc5U…Ez1E
- date till 2026-06-01
The query
# Bitcoin - 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!, $asof: ISO8601DateTime) {
bitcoin(network: bitcoin) {
received: outputs(outputAddress: {is: $address}, date: {till: $asof}) {
value(calculate: sum)
count
}
spent: inputs(inputAddress: {is: $address}, date: {till: $asof}) {
value(calculate: sum)
count
}
}
}
Variables
{"address": "1KHc5UvBRfF6ZLLbMbF8Yh2vLxHRe4Ez1E", "asof": "2026-06-01T00:00:00Z"}
Similar queries
- Bitcoin balance using input outputs · Bitcoin · inputs
- bitcoin balance api · Bitcoin · inputs
- Details of Bitcoin Transaction · Bitcoin · Transactions
- Bitcoin sent and received daily · Bitcoin · inputs
- 13_TxDetails_a6793e35 · Bitcoin · inputs