balance of an address on multiple chains

Returns balance updates on Ethereum, BNB Chain, Base and Arbitrum, where balance update address is 0xcf1D…35f6, sorted by balance, highest first: currency name, smart contract, sum of balance update amount and sum of balance update amount in USD.

By gaurav · saved 17 March 2025 · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  eth: EVM(dataset: archive, network: eth) {
    BalanceUpdates(
      where: {BalanceUpdate: {Address: {is: "0xcf1DC766Fc2c62bef0b67A8De666c8e67aCf35f6"}}}
      orderBy: {descendingByField: "balance"}
    ) {
      Currency {
        Name
        SmartContract
      }
      balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
      balanceInUSD: sum(of: BalanceUpdate_AmountInUSD, selectWhere: {gt: "0"})
    }
  }
  bsc: EVM(dataset: archive, network: bsc) {
    BalanceUpdates(
      where: {BalanceUpdate: {Address: {is: "0xcf1DC766Fc2c62bef0b67A8De666c8e67aCf35f6"}}}
      orderBy: {descendingByField: "balance"}
    ) {
      Currency {
        Name
        SmartContract
      }
      balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
      balanceInUSD: sum(of: BalanceUpdate_AmountInUSD, selectWhere: {gt: "0"})
    }
  }
  base: EVM(dataset: archive, network: base) {
    BalanceUpdates(
      where: {BalanceUpdate: {Address: {is: "0xcf1DC766Fc2c62bef0b67A8De666c8e67aCf35f6"}}}
      orderBy: {descendingByField: "balance"}
    ) {
      Currency {
        Name
        SmartContract
      }
      balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
      balanceInUSD: sum(of: BalanceUpdate_AmountInUSD, selectWhere: {gt: "0"})
    }
  }
  arbitrum: EVM(dataset: archive, network: arbitrum) {
    BalanceUpdates(
      where: {BalanceUpdate: {Address: {is: "0xcf1DC766Fc2c62bef0b67A8De666c8e67aCf35f6"}}}
      orderBy: {descendingByField: "balance"}
    ) {
      Currency {
        Name
        SmartContract
      }
      balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
      balanceInUSD: sum(of: BalanceUpdate_AmountInUSD, selectWhere: {gt: "0"})
    }
  }
}

Similar queries