historical liq at a certain time
Returns balance updates on Ethereum, where balance update address is 0xd726…25Bd and block time till 2024-08-05, sorted by balance, highest first: currency name, smart contract, currency symbol, sum of balance update amount and balance update address.
What it returns
- currency name
- smart contract
- currency symbol
- sum of balance update amount
- balance update address
Filters
- balance update address is 0xd726…25Bd
- block time till 2024-08-05
The query
query MyQuery($poolAddresses: [String!]) {
EVM(dataset: combined, network: eth) {
historical_liq_at_some_time: BalanceUpdates(
where: {BalanceUpdate: {Address: {in: $poolAddresses}}, Block: {Time: {till: "2024-08-05T01:00:00Z"}}}
orderBy: {descendingByField: "balance"}
) {
Currency {
Name
SmartContract
Symbol
}
balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
BalanceUpdate {
Address
}
}
}
}
Variables
{"poolAddresses":["0xd726e3B6858d81aB6Ad5b7cbb7a62EA00C5C25Bd"]}
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