Copy of New Query

Returns 100000000 balance updates and transfers on Ethereum, where balance update type is transfer, balance update address is 1 and balance update address contains 1, sorted by currency symbol: balance update address, balance update amount, amount in USD, balance update ID, balance update type, URI, call path and 4 more fields.

By khaled elean · saved 9 February 2025 · Bitquery API v2

What it returns

Filters

The query

query MyQuery($limitBy: EVM_BalanceUpdate_LimitBy = {}, $ascendingByField: String = "") {
  EVM(
    aggregates: yes
    dataset: realtime
    mempool: false
    network: eth
    select_blocks: tree
  ) {
    BalanceUpdates(
      limit: {count: 100000000, offset: 18}
      limitBy: $limitBy
      where: {BalanceUpdate: {Address: {in: "", is: "1", startsWith: "", like: "1", includes: "1"}, Amount: {eq: "", ge: "", gt: "", le: "", lt: ""}, Id: {eq: "", ge: "", gt: "", in: "", le: "", lt: "", ne: ""}, Type: {in: transfer, is: transfer}, URI: {endsWith: "", in: "", includes: "", startsWith: ""}}, Block: {Date: {after: "", before: "", not: "", till: ""}}}
      orderBy: {ascending: Currency_Symbol, descending: Transfer_Index, descendingByField: "0", ascendingByField: ""}
    ) {
      BalanceUpdate {
        Address(minimum: Block_L1_Number, maximum: Transfer_Index)
        Amount(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
        AmountInUSD(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
        Id(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
        Type(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
        URI(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
      }
      Call {
        CallPath(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
      }
      ChainId(if: {BalanceUpdate: {}, Transfer: {Index: {}}})
      Transfer {
        Index(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
      }
      Currency {
        Decimals(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
        Delegated
      }
    }
    Transfers
  }
}

Similar queries