v1_address stats

Returns transfers and transactions on Ethereum, where caller is 0x9522…Afe5, address is 0x9522…Afe5 and date since 2020-01-01: minimum of block, maximum of block, amount, count, gas value, currency name, currency symbol and balances value.

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

What it returns

Filters

The query

{
  ethereum(network: ethereum) {
    transfers(
      date: {since: "2020-01-01", till: "2025-01-01"}
      any: [{receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}, {sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}]
    ) {
      first_transfer_at: minimum(of: block, get: time)
      last_transfer_at: maximum(of: block, get: time)
      receive_amount: amount(
        calculate: sum
        receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}
        currency: {is: "ETH"}
      )
      send_amount: amount(calculate: sum, sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}, currency: {is: "ETH"})
      receive_from_count: count(uniq: senders, receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"})
      send_to_count: count(uniq: receivers, sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"})
      receive_from_currencies: count(uniq: currencies, receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"})
      send_to_currencies: count(uniq: currencies, sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"})
      days_with_received: count(uniq: dates, receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"})
      days_with_sent: count(uniq: dates, sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"})
      days_with_transfers: count(uniq: dates)
      send_tx_count: count(uniq: txs, sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"})
      receive_tx_count: count(uniq: txs, receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"})
    }
    transactions(any: [{txTo: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}, {txSender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}]) {
      fee_amount: gasValue
      first_tx_at: minimum(of: block, get: time)
      last_tx_at: maximum(of: block, get: time)
      days_with_transactions: count(uniq: dates)
    }
    smartContractCalls(caller: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}) {
      call_tx_count: count
      minimum(of: block, get: date)
    }
    balancedata: address(address: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}) {
      balances(currency: {is: "ETH"}) {
        currency {
          name
          symbol
        }
        value
      }
    }
  }
}

Similar queries