Copy of New Query
Returns 100000000 balance updates and transfers on Ethereum, where balance update type is transfer, balance update address is 1 and balance update address contains 1, sorted by currency symbol: balance update address, balance update amount, amount in USD, balance update ID, balance update type, URI, call path and 4 more fields.
What it returns
- balance update address
- balance update amount
- amount in USD
- balance update ID
- balance update type
- URI
- call path
- chain ID
- transfer index
- decimals
- delegated
Filters
- balance update type is transfer
- balance update address is 1
- balance update address contains 1
The query
query MyQuery($limitBy: EVM_BalanceUpdate_LimitBy = {}, $ascendingByField: String = "") {
EVM(
aggregates: yes
dataset: realtime
mempool: false
network: eth
select_blocks: tree
) {
BalanceUpdates(
limit: {count: 100000000, offset: 18}
limitBy: $limitBy
where: {BalanceUpdate: {Address: {in: "", is: "1", startsWith: "", like: "1", includes: "1"}, Amount: {eq: "", ge: "", gt: "", le: "", lt: ""}, Id: {eq: "", ge: "", gt: "", in: "", le: "", lt: "", ne: ""}, Type: {in: transfer, is: transfer}, URI: {endsWith: "", in: "", includes: "", startsWith: ""}}, Block: {Date: {after: "", before: "", not: "", till: ""}}}
orderBy: {ascending: Currency_Symbol, descending: Transfer_Index, descendingByField: "0", ascendingByField: ""}
) {
BalanceUpdate {
Address(minimum: Block_L1_Number, maximum: Transfer_Index)
Amount(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
AmountInUSD(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
Id(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
Type(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
URI(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
}
Call {
CallPath(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
}
ChainId(if: {BalanceUpdate: {}, Transfer: {Index: {}}})
Transfer {
Index(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
}
Currency {
Decimals(maximum: BalanceUpdate_Amount, minimum: BalanceUpdate_Amount)
Delegated
}
}
Transfers
}
}
Similar queries
- eth balance · Ethereum · BalanceUpdates
- Ethereum balance view · Ethereum · BalanceUpdates
- Balance update API explanation · Ethereum · BalanceUpdates
- MyQuery EVM · BNB Chain · BalanceUpdates
- usdt_holder_balance_update_ · Ethereum · BalanceUpdates