v2 address stats- Slow

Returns transfers, where block time since 2021-08-01: block time, sum of transfer amount, unique of transfer sender, unique of transfer receiver, unique of transfer currency smart contract, unique of block date and unique of transaction hash.

By Akshat · saved 26 February 2025 · Bitquery API v2

What it returns

Filters

The query

query MyQuery($sender: String, $receiver: String, $since: DateTime, $currency: String) {
  EVM(dataset: combined) {
    Transfers(
      where: {Block: {Time: {since: $since}}, any: [{Transfer: {Sender: {is: $sender}}}, {Transfer: {Receiver: {is: $receiver}}}]}
    ) {
      Block {
        first_transfer_at: Time(minimum: Block_Time)
        last_transfer_at: Time(maximum: Block_Time)
      }
      receive_amount: sum(
        of: Transfer_Amount
        if: {Transfer: {Receiver: {is: $receiver}, Currency: {SmartContract: {is: $currency}}}}
      )
      sent_amount: sum(
        of: Transfer_Amount
        if: {Transfer: {Sender: {is: $sender}, Currency: {SmartContract: {is: $currency}}}}
      )
      receive_from_count: uniq(
        of: Transfer_Sender
        if: {Transfer: {Receiver: {is: $receiver}}}
      )
      send_to_count: uniq(
        of: Transfer_Receiver
        if: {Transfer: {Sender: {is: $sender}}}
      )
      receive_from_currencies: uniq(
        of: Transfer_Currency_SmartContract
        if: {Transfer: {Receiver: {is: $receiver}}}
      )
      send_to_currencies: uniq(
        of: Transfer_Currency_SmartContract
        if: {Transfer: {Sender: {is: $sender}}}
      )
      days_with_receive: uniq(
        of: Block_Date
        if: {Transfer: {Receiver: {is: $receiver}}}
      )
      days_with_sent: uniq(of: Block_Date, if: {Transfer: {Sender: {is: $sender}}})
      days_with_transfers: uniq(of: Block_Date)
      send_txn_count: uniq(
        of: Transaction_Hash
        if: {Transfer: {Sender: {is: $sender}}}
      )
      receive_txn_count: uniq(
        of: Transaction_Hash
        if: {Transfer: {Receiver: {is: $receiver}}}
      )
    }
  }
}

Variables

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

Similar queries