address stats

Returns 10 transactions and balance updates on BNB Chain, where balance update address is 0x175d…b92c: block time, unique of block date, call count and sum of balance update amount in USD.

By Akshat · saved 4 November 2024 · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(network: bsc, dataset: realtime) {
    Transactions(
      limit: {count: 10}
      where: {any: [{Transaction: {From: {is: "0x175d44451403Edf28469dF03A9280c1197ADb92c"}}}, {Transaction: {To: {is: "0x175d44451403Edf28469dF03A9280c1197ADb92c"}}}]}
    ) {
      firstTxAt: Block {
        Time(minimum: Block_Time)
      }
      lastTxAt: Block {
        Time(maximum: Block_Time)
      }
      daysWithTransactions: uniq(of: Block_Date)
      callTxCount: Transaction {
        CallCount
      }
    }
    BalanceUpdates(
      where: {BalanceUpdate: {Address: {is: "0x175d44451403Edf28469dF03A9280c1197ADb92c"}}}
    ) {
      sendAmount: sum(
        of: BalanceUpdate_AmountInUSD
        if: {BalanceUpdate: {AmountInUSD:{lt:"0"}}}
      )
      
    }
  }
}

Similar queries