Latest balance and gas fee paid for an address

Returns the latest transaction balance on Ethereum, where token balance address is 0x18bb…b290 and token balance balance change reason code is 6: block time, pre balance, pre balance in USD, post balance, post balance in USD and calculate.

By Kshitij Mahajan · saved 7 November 2025 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(network: eth) {
    TransactionBalances(
      where: {TokenBalance: {BalanceChangeReasonCode: {eq: 6}, Address: {is: "0x18bb896994283bd9c16aa2072777a97c12f1b290"}}}
      limit: {count: 1}
      orderBy: {descending: Block_Time}
    ) {
      Block{
        Time
      }
      TokenBalance {
        PreBalance
        PreBalanceInUSD
        PostBalance
        PostBalanceInUSD
      }
      fee_paid: calculate(
        expression: "$TokenBalance_PreBalance - $TokenBalance_PostBalance"
      )
      fee_paid_usd: calculate(
        expression: "$TokenBalance_PreBalanceInUSD - $TokenBalance_PostBalanceInUSD"
      )
    }
  }
}

Similar queries