Event statistic by date

Returns the latest 10 events on Arbitrum, where signature signature hash is 8c5be1…b925, block date since 2024-01-03 and block date till 2024-01-10: block date, chain ID, count, unique of call from, unique of call to, unique of transaction from, unique of transaction to and 4 more fields.

By Nadia · saved 20 February 2025 · Bitquery API v2

What it returns

Filters

The query

query ($network: evm_network, $limit: Int, $method: String, $from: String, $till: String) {
  EVM(dataset: combined, network: $network) {
    Events(
      where: {Log: {Signature: {SignatureHash: {is: $method}}}, Block: {Date: {since: $from, till: $till}}}
      limit: {count: $limit}
      orderBy: {descending: Block_Date}
    ) {
      Block {
        Date
      }
      ChainId
      count
      call_from: uniq(of: Call_From)
      call_to: uniq(of: Call_To)
      transaction_from: uniq(of: Transaction_From)
      transaction_to: uniq(of: Transaction_To)
      smart_contract: uniq(of: Log_SmartContract)
      daily_total_value: sum(of: Transaction_Value)
      daily_total_value_usd: sum(of: Transaction_ValueInUSD)
      daily__avg_value: average(of: Transaction_Value)
    }
  }
}

Variables

{
  "limit": 10,
  "network": "arbitrum",
  "from": "2024-01-03",
  "till": "2024-01-10",
  "method": "8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925"
}

Similar queries