Pool Liquidity
Returns 10 balance updates on Ethereum, where balance update address is 0x88e6…5640, currency smart contract is 0xa0b8…eb48 or 0xc02a…6cc2 and block time till 2024-05-29, sorted by block time: sum of balance update amount, balance update address, currency name, currency symbol, smart contract, block time, balance update amount and balance update type.
What it returns
- sum of balance update amount
- balance update address
- currency name
- currency symbol
- smart contract
- block time
- balance update amount
- balance update type
Filters
- balance update address is 0x88e6…5640
- currency smart contract is 0xa0b8…eb48 or 0xc02a…6cc2
- block time till 2024-05-29
- block time since 2023-11-27
The query
{
EVM(dataset: combined, network: eth) {
BalanceUpdates(
where: {Block: {Time: {till: "2024-05-29T00:00:00Z"}}, BalanceUpdate: {Address: {is: "0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640"}}, Currency: {SmartContract: {in: ["0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48", "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"]}}}
) {
balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
BalanceUpdate {
Address
}
Currency {
Name
Symbol
SmartContract
}
}
liquidityChanges: BalanceUpdates(
where: {Block: {Time: {since: "2023-11-27T00:00:00Z"}}, BalanceUpdate: {Address: {is: "0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640"}}, Currency: {SmartContract: {in: ["0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48", "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"]}}}
orderBy: {ascending: Block_Time}
limit: {count: 10}
) {
Currency {
Name
}
Block {
Time
}
BalanceUpdate {
Amount
Type
}
}
}
}
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