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.
What it returns
- balance update address
- balance update amount
- amount in USD
- balance update ID
- balance update type
- block date
- block hash
- base fee
- coinbase
- gas limit
- gas used
- l 1 time
Filters
- balance update type is uncle_reward
- balance update type is not uncle_reward
- balance update amount is 100
- interval target volume is 1.5
- interval target volume is at least 1.5
- interval target volume is at most 1.5
- interval target volume is below 1.5
- time duration is 10
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
- AllEvmMaxBlock EVM · Ethereum · Blocks
- optimism_min_block · Optimism · Blocks
- Bitget hack: ETH on Optimism and Base to the attacker, Sep 24, 2026 · Optimism · Transfers
- Velodrome v2 Pool Swaps on Optimism · Optimism · DEXTrades
- Optimism — Current balance of an address · Optimism · Balances