v1 to v2 transfer stats

Returns transfers on Ethereum: 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 Divyasshree · saved 24 February 2025 · run 3 times · Bitquery API v2

What it returns

The query

query MyQuery {
  EVM(network: eth, dataset: combined) {
    Transfers(
      where: {any: [{Transfer: {Sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}, {Transfer: {Receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}]}
    ) {
      receive_amount: sum(
        of: Transfer_Amount
        if: {Transfer: {Receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
      )
      sent_amount: sum(
        of: Transfer_Amount
        if: {Transfer: {Sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
      )
      receive_from_count: uniq(
        of: Transfer_Sender
        if: {Transfer: {Receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
      )
      send_to_count: uniq(
        of: Transfer_Receiver
        if: {Transfer: {Sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
      )
      receive_from_currencies: uniq(
        of: Transfer_Currency_SmartContract
        if: {Transfer: {Receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
      )
      send_to_currencies: uniq(
        of: Transfer_Currency_SmartContract
        if: {Transfer: {Sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
      )
      days_with_receive: uniq(
        of: Block_Date
        if: {Transfer: {Receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
      )
      days_with_sent: uniq(
        of: Block_Date
        if: {Transfer: {Sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
      )
      days_with_transfers: uniq(of: Block_Date)
      send_txn_count: uniq(
        of: Transaction_Hash
        if: {Transfer: {Sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
      )
      receive_txn_count: uniq(
        of: Transaction_Hash
        if: {Transfer: {Receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
      )
    }
  }
}

Similar queries