Fees Analysis

Returns 10 transactions on Arbitrum, where block date since 2025-02-05, block date till 2025-02-12 and transaction gas price is above 0, sorted by fee sender, highest first: to, from, count, average of transaction gas price, average of transaction gas price in USD, sum of fee sender fee, sum of fee sender fee in USD and 8 more fields.

By Nadia · saved 12 February 2025 · run 2 times · Bitquery API v2

What it returns

Filters

The query

query ($network: evm_network, $limit: Int, $from: String, $till: String) {
  EVM(dataset: combined, network: $network) {
    Transactions(
      limit: {count: $limit}
      where: {Block: {Date: {since: $from, till: $till}}, Transaction: {GasPrice: {gt: "0"}}}
      orderBy: {descendingByField: "fee_sender"}
    ) {
      Transaction {
        To
        From
      }
      count
      gas_price: average(of: Transaction_GasPrice)
      gas_price_usd: average(of: Transaction_GasPriceInUSD)
      fee_sender: sum(of: Fee_SenderFee)
      fee_sender_usd: sum(of: Fee_SenderFeeInUSD)
      fee_reward: sum(of: Fee_MinerReward)
      fee_reward_usd: sum(of: Fee_MinerRewardInUSD)
      fee_saving: sum(of: Fee_Savings)
      fee_saving_usd: sum(of: Fee_SavingsInUSD)
      fee_burnt: sum(of: Fee_Burnt)
      fee_burnt_usd: sum(of: Fee_BurntInUSD)
      gas_used: sum(of: Receipt_GasUsed)
      ChainId
    }
  }
}

Variables

{
  "limit": 10,
  "network": "arbitrum",
  "from": "2025-02-05",
  "till": "2025-02-12",
  "dateFormat": "%Y-%m-%d",
  "date_middle": "2025-02-08"
}

Similar queries