Ethereum Token Captable

Returns 100 token holders on Ethereum, where holder address is not 0x and balance amount is above 0, sorted by balance amount, highest first: holder address, balance amount, currency symbol, currency name, native, protocol name and decimals.

By Naresh · saved 11 February 2025 · Bitquery API v2

What it returns

Filters

The query

query FETCH_ETHEREUM_TOKEN_BALANCES($address: String!,
                                        $till_date: String!,
                                        $top_n_count: Int) {
    EVM(network: eth, dataset: archive) {
    
    # top 100 holders
    token_holders: TokenHolders(
      date: $till_date
      tokenSmartContract: $address
      where: {Balance: {Amount: {gt: "0"}}, Holder: {Address: {notIn: ["0x"]}}}
      orderBy: {descending: Balance_Amount}
       limit: {count: $top_n_count}
    ) {
      Holder {
        Address
      }
      Balance {
        Amount
      }
      Currency {
        Symbol
        Name
        Native
        ProtocolName
        Decimals
      }
      }
  }
}

Variables

{"address": "0x7712c34205737192402172409a8f7ccef8aa2aec", 
 "till_date": "2025-02-10",
 "top_n_count": 100}

Similar queries