Arbitrum Main Transactions till an audit date in ascending order

Returns 10 transactions on Arbitrum, where transaction from is 0xc5d5…dde3 and block time till 2024-04-28, sorted by block time: count, chain ID, block time, block number, sum of fee sender fee, transaction hash, to and 3 more fields.

By Saloni Shaswat · saved 28 August 2024 · Bitquery API v2

What it returns

Filters

The query

query ($network: evm_network, $limit: Int, $offset: Int, $address: String!, $till: DateTime) {
  EVM(dataset: combined, network: $network) {
    Transactions(
      where: {Transaction: {From: {is: $address}}, Block: {Time: {till: $till}}}
      orderBy: {ascending: Block_Time}
      limit: {count: $limit, offset: $offset}
    ) {
      count
      ChainId
      Block {
        Time
        Number
      }
      gas_cost: sum(of: Fee_SenderFee)
      Transaction {
        Hash
        To
        From
        Value
      }
      TransactionStatus {
        Success
      }
    }
  }
}

Variables

{"limit":10,"offset":10,"network":"arbitrum","till":"2024-04-28T11:59:00Z","address":"0xc5d5846b013d7929dac053d4030b00047a14dde3","dateFormat":"%Y-%m"}

Similar queries