CDN_EVM

Returns balance updates and blocks on Ethereum, where balance update address starts with address.startsWith(example:"0x00"), balance update type is block_reward and balance update type is genesis, sorted by transaction hash: block, theil index of block nonce and rank correlation.

By Stanley Lail · saved 13 February 2025 · Bitquery API v2

What it returns

• block
• theil index of block nonce
• rank correlation

Filters

• balance update address starts with address.startsWith(example:"0x00")
• balance update type is block_reward
• balance update type is genesis
• balance update type is not fee
• balance update type is not transfer
• balance update URI contains path
• balance update URI is URI
• balance update URI starts with https://
• balance update amount is ::
• balance update amount is above ::
• balance update amount is below ::
• balance update amount is at most ::
• balance update amount is at least ::
• balance update amount in USD is ::
• balance update amount in USD is above ::
• balance update amount in USD is at least ::
• balance update ID is ::
• balance update ID is not ::

The query

query MyQuery {
  EVM(
    aggregates: yes
    dataset: realtime
    mempool: false
    network: eth
    select_blocks: trunk
  ) {
    BalanceUpdates(
      limit: {offset: 20, count: "SELECT COUNT(*) FROM orders;"}
      orderBy: {ascending: Transaction_Hash, ascendingByField: "SELECT * FROM orders ORDER BY price ASC;ASC", descending: Transaction_Hash, descendingByField: "SELECT * FROM orders ORDER BY price DESC;"}
      where: {BalanceUpdate: {Address: {endsWith: "const address = (address) const endsWithZeros = address.endsWith \"0000\"; console.log (endsWithZeros); // output: false", startsWith: "address.startsWith(example:\"0x00\")"}, Amount: {eq: "::", gt: "::", lt: "::", le: "::", ge: "::", ne: "::"}, AmountInUSD: {eq: "::", ne: "::", gt: "::", ge: "::"}, Type: {is: block_reward, in: genesis, not: fee, notIn: transfer}, URI: {endsWith: ".info", includes: "path", is: "URI", startsWith: "https://"}, Id: {eq: "::", in: "::", notIn: "::"}}, Block: {}}
      limitBy: {by: Block_L1_Hash, count: 10, offset: 20}
    )
    Blocks(limit: {}, limitBy: {}, orderBy: {})
    Uncles(where: {Uncle: {}, ChainId: {}}) {
      Uncle {
        Block
      }
      Block
      theil_index(of: Block_Nonce)
      rank_correlation(if: {Block: {BaseFee: {}}})
    }
  }
}

Similar queries

• eth balance · Ethereum · BalanceUpdates
• Ethereum balance view · Ethereum · BalanceUpdates
• Balance update API explanation · Ethereum · BalanceUpdates
• MyQuery EVM · BNB Chain · BalanceUpdates
• usdt_holder_balance_update_ · Ethereum · BalanceUpdates