Top 10 holders of multiple tokens on Base at a specific time holder api
Historical data This query already reads history - it uses the combined dataset, which needs the historical data add-on for this chain. Without the add-on it fails with 'access restricted: your plan only allows realtime'. Drop the dataset argument to fall back to the recent window. Datasets: https:
What it returns
- holder address
- currency name
- balance amount
Filters
- currency smart contract is 0x3B86…931f
- balance last change time till 2025-05-01
The query
# Historical data
# This query already reads history - it uses the combined dataset, which
# needs the historical data add-on for this chain.
#
# Without the add-on it fails with 'access restricted: your plan only allows
# realtime'. Drop the dataset argument to fall back to the recent window.
#
# Datasets: https://docs.bitquery.io/docs/graphql/dataset/archive/
# Retention: https://docs.bitquery.io/docs/graphql/data-coverage-retention/
#
# For more info on the endpoint visit -
# https://docs.bitquery.io/docs/blockchain/Base/
# For faster results try using indexed feilds in where and orderBy clause -
# https://docs.bitquery.io/docs/graphql/indexed-fields-reference/
query MyQuery($network: evm_network, $tokens: [String!]) {
EVM(network: $network, aggregates: yes, dataset: combined) {
Holders(
orderBy: {descending: Balance_Amount}
limitBy: {count: 10 by:Currency_SmartContract}
where: {Balance:{LastChangeTime:{till:"2025-05-01T01:00:00Z"}} Currency: {SmartContract: {in: $tokens}}}
) {
Holder {
Address
}
Currency{
Name
}
Balance{
Amount(selectWhere: {gt: "0"})
}
}
}
}
Variables
{
"network": "base",
"tokens": [
"0x3B86Ad95859b6AB773f55f8d94B4b9d443EE931f"
]
}
Similar queries
- token holder count base · Base · Holders
- incorrect Token Holder Stats · Base · Holders
- token-holder-snapshot-base · Base · Holders
- EVM Address Native Balance on Ethereum, BSC, Base and Arbitrum · Ethereum · Balances
- EVM Transactions · Base · Transactions