hessTotal Swaps
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with final as ( select tx_hash, origin_from_address, amount_out as amount
from avalanche.core.ez_dex_swaps
where TOKEN_OUT in (lower('0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E'),lower('0xA7D7079b0FEaD91F3e65f86E8915Cb59c1a4C664'))
UNION
select tx_hash,origin_from_address, amount_in as amount
from avalanche.core.ez_dex_swaps
where TOKEN_IN in (lower('0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E'),lower('0xA7D7079b0FEaD91F3e65f86E8915Cb59c1a4C664'))
)
select count(DISTINCT(tx_hash)) as total_tx,count(DISTINCT(origin_from_address)) as users, sum(amount) as usdc_amount,
avg(amount) as avg_amount
from final
Run a query to Download Data