v2 stats- slow

Returns transactions and calls, where call from is 0xe25F…04b4, balance update address is 0xe25F…04b4 and currency smart contract is 0x: block time, unique of block date, count, sum of balance update amount, currency name, currency symbol and smart contract.

By Akshat · saved 26 February 2025 · run 15 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery($sender: String, $receiver: String,$currency: String) {
  EVM(dataset: combined) {
    Transactions(
      where: {any: [{Transaction: {To: {is: $receiver}}}, {Transaction: {From: {is: $sender}}}]}
    ) {
      Block {
        first_transaction_at: Time(minimum: Block_Time)
        last_transaction_at: Time(maximum: Block_Time)
      }
      days_with_transactions: uniq(of: Block_Date)
    }
    Calls(where: {Call: {From: {is: $sender}}}) {
      call_txn_count: count
      Block {
        Time(minimum: Block_Date)
      }
    }
    BalanceUpdates(
      where: {BalanceUpdate: {Address: {is: $sender}}, Currency: {SmartContract: {is: $currency}}}
    ) {
      balance: sum(of: BalanceUpdate_Amount)
      Currency {
        Name
        Symbol
        SmartContract
      }
    }
  }
}

Variables

{
  "sender":"0xe25F68282AFB652A9573D9C5c730f7C7c59c04b4",
  "receiver": "0xe25F68282AFB652A9573D9C5c730f7C7c59c04b4",
  "since":"2021-08-01T00:00:00Z",
  "till": "2022-05-01T00:00:00Z",
  "currency": "0x"
}

Similar queries