address_stats_v2

Returns transfers and transactions, where call from is 0x9522…Afe5, balance update address is 0x9522…Afe5 and block date since 2020-01-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, unique of transaction hash and 6 more fields.

By UppsalaBitqueryDev · saved 21 February 2025 · run 2 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM {
    Transfers(
      where: {Block: {Date: {since: "2020-01-01", till: "2025-01-01"}}, any: [{Transfer: {Sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}, {Transfer: {Receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}]}
    ) {
      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: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}, Currency: {SmartContract: {is: ""}}}}
      )
      sent_amount: sum(
        of: Transfer_Amount
        if: {Transfer: {Sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}, Currency: {SmartContract: {is: ""}}}}
      )
      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"}}}
      )
    }
    Transactions(
      where: {any: [{Transaction: {To: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}, {Transaction: {From: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}]}
    ) {
      gasValue: Fee {
        SenderFee
      }
      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: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}) {
      call_txn_count: count
      Block {
        Time(minimum: Block_Date)
      }
    }
    BalanceUpdates(
      where: {BalanceUpdate: {Address: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}, Currency: {SmartContract: {is: ""}}}
    ) {
      balance: sum(of: BalanceUpdate_Amount)
      Currency {
        Name
        Symbol
        SmartContract
      }
    }
  }
}

Similar queries