ZBGK

Returns 10000 balance updates and miner rewards on Ethereum, sorted by currency delegated to: balance update address, chain ID, decimals, delegated, log index, nakamoto of reward tx fees in USD, balance amount and 2 more fields.

By Jamond-Dominic Adams-Taylor · saved 25 May 2024 · run 1 time · Bitquery API v2

What it returns

The query

query MyQuery($Call: EVM_BalanceUpdate_Input_Call_InputType = {}, $eq: String = "") {
  EVM(mempool: false, dataset: realtime, network: eth, select_blocks: trunk) {
    BalanceUpdates(
      limit: {count: 10000, offset: 10000}
      limitBy: {by: Transaction_Time, count: 100000, offset: 11000000}
      orderBy: {ascending: Currency_DelegatedTo, ascendingByField: "999999", descending: BalanceUpdate_AmountInUSD, descendingByField: ""}
    ) {
      BalanceUpdate {
        Address(
          if: {Call: $Call, BalanceUpdate: {Address: {in: "99999", includes: "99999", is: "9999"}}}
        )
      }
      ChainId(maximum: ChainId, selectWhere: {eq: $eq, ge: "999", gt: "999"})
      Currency {
        Decimals(
          minimum: Block_Date
          maximum: Currency_HasURI
          selectWhere: {eq: "eth", ge: "btc", gt: "usd", in: "usdc"}
        )
        Delegated
      }
      Log {
        Index(maximum: Currency_Decimals, minimum: Currency_Decimals)
      }
    }
    MinerRewards {
      ChainId
      nakamoto(of: Reward_TxFeesInUSD)
    }
    TokenHolders(
      date: ""
      tokenSmartContract: "0x68c54186AC84158a1c64BC794b1AdD82DA8ed19e"
    ) {
      Balance {
        Amount(maximum: Currency_Native)
      }
      Currency {
        Decimals(maximum: BalanceUpdate_InAmount)
        Symbol(selectWhere: {startsWith: "0x68c54186AC84158a1c64BC794b1AdD82DA8ed19e"})
      }
      Holder {
        Address(maximum: BalanceUpdate_InAmount)
      }
    }
  }
}

Similar queries