Solos

( separate queries )

Returns transactions and transfers on Ethereum, where transaction from is 0x4838…5f97, transfer receiver is 0x4838…5f97 and transfer sender is 0x4838…5f97: sum of fee sender fee, sum of fee sender fee in USD, count, chain ID, block time, unique of block date, sum of transfer amount and 2 more fields.

By Joeia shaud · saved 8 April 2026 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query ($network: evm_network, $address: String!) {
  EVM(dataset: archive, network: $network, select_blocks: branches) {
    fee: Transactions(where: {Transaction: {From: {is: $address}}}) {
      tx_fee: sum(of: Fee_SenderFee)
      tx_fee_usd: sum(of: Fee_SenderFeeInUSD)
      tx_count: count
    }
    currencies_reciiver: Transfers(where: {Transfer: {Receiver: {is: $address}}}) {
      ChainId
      r_currencies: count(distinct: Transfer_Currency_SmartContract)
      Block {
        r_from: Time(minimum: Block_Time)
        r_to: Time(maximum: Block_Time)
      }
      r_days: uniq(of: Block_Date)
    }
    receiver: Transfers(
      where: {Transfer: {Currency: {Native: true}, Receiver: {is: $address}}}
    ) {
      r_amount: sum(of: Transfer_Amount)
      r_amount_usd: sum(of: Transfer_AmountInUSD)
    }
    currencies_sender: Transfers(where: {Transfer: {Sender: {is: $address}}}) {
      ChainId
      s_currencies: count(distinct: Transfer_Currency_SmartContract)
      Block {
        s_from: Time(minimum: Block_Time)
        s_to: Time(maximum: Block_Time)
      }
      s_days: uniq(of: Block_Date)
    }
    sender: Transfers(
      where: {Transfer: {Currency: {Native: true}, Sender: {is: $address}}}
    ) {
      s_amount: sum(of: Transfer_Amount)
      s_amount_usd: sum(of: Transfer_AmountInUSD)
    }
    MinerRewards {
      ChainId(maximum: Reward_TotalInUSD, minimum: Reward_Dynamic)
      joinBalanceUpdates(BalanceUpdate_Address: Block_Hash, join: left) {
        BalanceUpdate {
          Address(
            if: {BalanceUpdate: {Amount: {le: "126wND9vrfFTfbZTZnE7zN4sfxKvBRRqKo"}}}
          )
        }
      }
    }
  }
}

Variables

{"network":"eth","address":"0x4838b106fce9647bdf1e7877bf73ce8b0bad5f97","mempool":false}

Similar queries