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:

By Kshitij Mahajan · saved 11 December 2025 · run 3 times · Bitquery API v2

What it returns

Filters

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