Current liquidity, historical liquidity and initial liquidity of pools on etherum
Returns transfers and balance updates on Ethereum, where transfer receiver is 0xd726…25Bd, balance update address is 0xd726…25Bd and block time till 2024-08-04, 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 0xd726…25Bd
- balance update address is 0xd726…25Bd
- block time till 2024-08-04
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
}
}
}
historical_liq_at_some_time: BalanceUpdates(
where: {BalanceUpdate: {Address: {in: $poolAddresses}} Block:{Time:{till: "2024-08-04T01:00:00Z"}}}
orderBy: {descendingByField: "balance"}
) {
Currency {
Name
SmartContract
Symbol
}
balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
BalanceUpdate {
Address
}
}
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":["0xd726e3B6858d81aB6Ad5b7cbb7a62EA00C5C25Bd"]}
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