last 10 blocks avg tip in native eth

Returns the latest 10 transaction balances on Ethereum, where token balance balance change reason code is 5: block number, balance change reason code, currency name, currency symbol, smart contract, sum of token balance post balance, sum of token balance post balance in USD and 4 more fields.

By Akshat · saved 6 November 2025 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(network: eth, dataset: realtime) {
    TransactionBalances( 
      limit: {count: 10}
      orderBy: {descending: Block_Number}
      where: {TokenBalance: {BalanceChangeReasonCode: {eq: 5}}}
    ) {
      Block {
        Number
      }
      TokenBalance {
        BalanceChangeReasonCode
        Currency {
          Name
          Symbol
          SmartContract
        }
      }
      Post: sum(of: TokenBalance_PostBalance)
      Post_USD: sum(of: TokenBalance_PostBalanceInUSD)
      Pre: sum(of: TokenBalance_PreBalance)
      Pre_USD: sum(of: TokenBalance_PreBalanceInUSD)
      Total_tip_native: calculate(expression: "$Post - $Pre")
      Total_tip_usd: calculate(expression: "$Post_USD - $Pre_USD")
      number_of_tips: count
      avg_tip_in_this_block: calculate(
        expression: "$Total_tip_native / $number_of_tips"
      )
      avg_tip_usd_in_this_block: calculate(
        expression: "$Total_tip_usd / $number_of_tips"
      )
    }
  }
}

Similar queries