Initial and current liquidity of a pool
Returns transfers and balance updates on Ethereum, where transfer receiver is 0x4261…c344 or 0x44cc…c8e7 and balance update address is 0x4261…c344 or 0x44cc…c8e7, 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 0x4261…c344 or 0x44cc…c8e7
- balance update address is 0x4261…c344 or 0x44cc…c8e7
The query
query MyQuery ($poolAddresses: [String!]){
EVM(dataset: realtime, network: eth) {
Initial_liquidity: Transfers(
limitBy:{by:Transfer_Receiver count:2}
orderBy: {ascending: Block_Time}
where: {Transfer: {Receiver: {in: $poolAddresses }}}
) {
Transaction {
Hash
}
Transfer {
Receiver
Amount
Currency {
SmartContract
Name
Symbol
}
}
}
Current_liquidity: BalanceUpdates(
where: {BalanceUpdate: {Address: {in: ["0x42619f1eb89b993f7f5193de6ab1423a703fc344","0x44cc738e692921e7ac967367b800b8e132e5c8e7"]}}}
orderBy: {descendingByField: "balance"}
) {
Currency {
Name
SmartContract
}
balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
BalanceUpdate {
Address
}
}
}
}
Variables
{
"poolAddresses" : ["0x42619f1eb89b993f7f5193de6ab1423a703fc344","0x44cc738e692921e7ac967367b800b8e132e5c8e7"]
}
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