FrogWifHat

Returns 10 blocks and balance updates on Optimism and Tron, where balance update type is uncle_reward, balance update type is not uncle_reward and balance update amount is 100, sorted by price average mean: balance update address, balance update amount, amount in USD, balance update ID, balance update type, block date, block hash and 5 more fields.

By Ernest Torrence · saved 24 December 2025 · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(
    aggregates: yes
    dataset: realtime
    mempool: true
    network: optimism
    select_blocks: trunk
  ) {
    Blocks
    BalanceUpdates(
      limit: {count: 10, offset: 10}
      limitBy: {by: Currency_Delegated, count: 10, offset: 10}
      orderBy: {ascending: Currency_Delegated, ascendingByField: "10", descending: Currency_Delegated, descendingByField: "10"}
      where: {BalanceUpdate: {Address: {endsWith: "", in: "", includes: "", includesCaseInsensitive: "", is: "", like: "", likeCaseInsensitive: "", not: "", notIn: "", notIncludes: "", notIncludesCaseInsensitive: "", notLike: "", notLikeCaseInsensitive: "", startsWith: "", startsWithCaseInsensitive: ""}, Amount: {eq: "100", ge: "", gt: "", le: "", lt: "", ne: ""}, AmountInUSD: {eq: "", ge: "", gt: "", le: "", lt: "", ne: ""}, Id: {eq: "", ge: "", gt: "", in: "", le: "", lt: "", ne: "", notIn: ""}, Type: {in: uncle_reward, is: uncle_reward, not: uncle_reward, notIn: uncle_reward}, URI: {endsWith: "", in: "", includes: "", includesCaseInsensitive: "", is: "", like: "", likeCaseInsensitive: "", not: "", notIn: "", notIncludes: "", notIncludesCaseInsensitive: "", notLike: "", notLikeCaseInsensitive: "", startsWith: "", startsWithCaseInsensitive: ""}}, Block: {Date: {after: "", before: "", in: "", is: "", not: "", notIn: "", since: "", till: ""}, Hash: {endsWith: "", in: "", includes: "", includesCaseInsensitive: "", is: "", like: "", likeCaseInsensitive: "", not: "", notIn: "", notIncludes: "", notIncludesCaseInsensitive: "", notLike: "", notLikeCaseInsensitive: "", startsWith: "", startsWithCaseInsensitive: ""}}}
    ) {
      BalanceUpdate {
        Address(
          maximum: ChainId
          minimum: ChainId
          selectWhere: {endsWith: "", in: "", includes: "", includesCaseInsensitive: "", is: "", like: "", likeCaseInsensitive: "", not: "", notIn: "", notIncludes: "", notIncludesCaseInsensitive: "", notLike: "", notLikeCaseInsensitive: "", startsWith: "", startsWithCaseInsensitive: ""}
        )
        Amount(
          maximum: ChainId
          minimum: ChainId
          selectWhere: {eq: "", ge: "", gt: "", le: "", lt: "", ne: ""}
        )
        AmountInUSD(
          maximum: ChainId
          minimum: ChainId
          selectWhere: {eq: "", ge: "", gt: "", le: "", lt: "", ne: ""}
        )
        Id(
          maximum: ChainId
          minimum: ChainId
          selectWhere: {eq: "", ge: "", gt: "", in: "", le: "", lt: "", ne: "", notIn: ""}
        )
        Type
      }
      Block {
        Date(maximum: ChainId, minimum: ChainId)
        Hash(maximum: ChainId, minimum: ChainId)
        L1 {
          BaseFee(maximum: ChainId, minimum: ChainId, selectWhere: {})
          Coinbase(maximum: ChainId, minimum: ChainId)
          GasLimit(maximum: ChainId, minimum: ChainId)
          GasUsed(maximum: ChainId, minimum: ChainId)
          Time
        }
      }
    }
  }
  Tron(
    aggregates: yes
    dataset: realtime
    mempool: true
    network: tron
    select_blocks: branches
  )
  Trading(aggregates: yes, dataset: realtime) {
    Currencies(
      limit: {count: 10, offset: 10}
      orderBy: {ascending: Price_Average_Mean, ascendingByField: ""}
      limitBy: {count: 10}
      where: {Currency: {}, Interval: {TargetVolume: {eq: 1.5, ge: 1.5, le: 1.5, lt: 1.5}, Time: {Duration: {eq: 10, in: 10}, End: {after: "", before_relative: {}}}}}
    )
  }
}

Similar queries