Latest Transactions

Returns the latest call on Ethereum, where call to is 0xc02a…6cc2, currency smart contract is 0xc02a…6cc2 and block date since 2023-08-07: chain ID, block time, block number, transaction hash, sum of fee sender fee, sum of fee sender fee in USD, from and 8 more fields.

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

What it returns

Filters

The query

query ($network: evm_network, $limit: Int, $address: String, $from: String, $till: String) {
  EVM(dataset: archive, network: $network) {
    Calls(
      where: {Call: {To: {is: $address}}, Block: {Date: {since: $from, till: $till}}}
      limit: {count: $limit}
      orderBy: {descending: Block_Time}
    ) {
      ChainId
      Block {
        Time
        Number
      }
      Transaction {
        Hash
      }
      sum(of: Fee_SenderFee)
      sum_usd: sum(of: Fee_SenderFeeInUSD)
      Call {
        From
        Value
        ValueInUSD
        Signature {
          Name
          Signature
          SignatureHash
        }
      }
    }
    Transfers(
      limit: {count: 1}
      where: {Transfer: {Currency: {SmartContract: {is: $address}}}}
    ) {
      Transfer {
        Currency {
          Name
          SmartContract
          Symbol
        }
      }
    }
  }
}

Variables

{
  "limit": 10,
  "offset": 0,
  "network": "eth",
  "address": "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2",
  "from": "2023-08-07",
  "till": "2023-08-07"
}

Similar queries