query_support_ticket_3025521294
Returns 2 transfers and balance updates on Ethereum, where transfer receiver is 0x0315…c0ef, balance update address is 0x0315…c0ef and currency smart contract is 0xc02a…6cc2 or 0xDF52…fA0E, sorted by block time: transaction hash, transfer amount, smart contract, currency name, currency symbol, sum of balance update amount, balance update address and 3 more fields.
What it returns
- transaction hash
- transfer amount
- smart contract
- currency name
- currency symbol
- sum of balance update amount
- balance update address
- sum of trade buy amount
- sum of trade sell amount
- count
Filters
- transfer receiver is 0x0315…c0ef
- balance update address is 0x0315…c0ef
- currency smart contract is 0xc02a…6cc2 or 0xDF52…fA0E
- pair smart contract is 0x0315…c0ef
- block time since 2023-12-28
The query
{
EVM(dataset: combined, network: eth) {
Initaial_liquidity: Transfers(
limit: {count: 2}
orderBy: {ascending: Block_Time}
where: {Transfer: {Receiver: {in: "0x0315953c51a0adb4bd0b9f672f5c3ca9653ec0ef"}}}
) {
Transaction {
Hash
}
Transfer {
Amount
Currency {
SmartContract
Name
Symbol
}
}
}
Current_lquidity: BalanceUpdates(
where: {BalanceUpdate: {Address: {is: "0x0315953c51a0adb4bd0b9f672f5c3ca9653ec0ef"}}, Currency: {SmartContract: {in: ["0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2", "0xDF52961d40047d30e77990E4d23A1B01Dd28fA0E"]}}}
) {
Currency {
Name
SmartContract
}
balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
BalanceUpdate {
Address
}
}
volume: DEXTrades(
where: {Block: {Time: {since: "2023-12-28T10:01:55.000Z"}}, Trade: {Dex: {Pair: {SmartContract: {is: "0x0315953c51a0adb4bd0b9f672f5c3ca9653ec0ef"}}}}}
) {
token1_vol: sum(of: Trade_Buy_Amount)
token2_vol: sum(of: Trade_Sell_Amount)
}
transactions: DEXTrades(
where: {Block: {Time: {since: "2023-12-28T10:01:55.000Z"}}, Trade: {Dex: {Pair: {SmartContract: {is: "0x0315953c51a0adb4bd0b9f672f5c3ca9653ec0ef"}}}}}
) {
count: count
}
}
}
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