Current liquidity and initial liquidity of pools on etherum
Returns transfers and balance updates on Ethereum, where transfer receiver is 0xf48a…528a and balance update address is 0xf48a…528a, sorted by balance, highest first: transaction hash, receiver, transfer amount, smart contract, currency name, currency symbol, sum of balance update amount and balance update address.
What it returns
- transaction hash
- receiver
- transfer amount
- smart contract
- currency name
- currency symbol
- sum of balance update amount
- balance update address
Filters
- transfer receiver is 0xf48a…528a
- balance update address is 0xf48a…528a
The query
query MyQuery ($poolAddresses: [String!]){
EVM(dataset: combined, network: eth) {
Initial_liquidity: Transfers(
limitBy:{by:Transfer_Receiver count:2}
orderBy: {ascending: Block_Time}
where: {Transfer: {Receiver: {in: $poolAddresses }}, TransactionStatus: {Success: true}}
) {
Transaction {
Hash
}
Transfer {
Receiver
Amount
Currency {
SmartContract
Name
Symbol
}
}
}
Current_liquidity: BalanceUpdates(
where: {BalanceUpdate: {Address: {in: $poolAddresses}}}
orderBy: {descendingByField: "balance"}
) {
Currency {
Name
SmartContract
Symbol
}
balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
BalanceUpdate {
Address
}
}
}
}
Variables
{"poolAddresses":["0xf48a0f3e96607833447d83d29fba99c2721b528a"]}
Similar queries
- Ethereum Address Latest Transfers In and Out · Ethereum · Transfers
- Tornado Cash: ETH paid into the four ETH pools, Jan 1 to Sep 27 2026 · Ethereum · Transfers