Balance EoD

Returns the latest balance updates on Arbitrum, where balance update address is 0xE66B…fF6c and block date till 2023-12-31: block time, currency name, smart contract and sum of balance update amount.

By Michael Wong · saved 12 February 2025 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query ($network: evm_network, $address: String!, $till: String!) {
  EVM(dataset: archive, network: $network) {
    BalanceUpdates(
      where: {BalanceUpdate: {Address: {is: $address}}, Block: {Date: {till: $till}}}
      orderBy: {descending: Block_Time}
    ) {
      Block {
        Time
      }
      Currency {
        Name
        SmartContract
      }
      balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
    }
  }
}

Variables

{"limit":10,"offset":0,"network":"arbitrum","address":"0xE66BAa0B612003AF308D78f066Bbdb9a5e00fF6c","till":"2023-12-31","dateFormat":"%Y-%m-%d"}

Similar queries