hessTotal Swaps
Updated 2023-05-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with swap_to as ( select block_timestamp,'Swap to' as type,symbol_in, tx_hash, origin_from_address, amount_out as amount
from avalanche.core.ez_dex_swaps
where symbol_out = 'EUROC'
UNION
select block_timestamp,'Swap From' as type,symbol_out, tx_hash, origin_from_address, amount_in as amount
from avalanche.core.ez_dex_swaps
where symbol_in = 'EUROC')
select type, count(DISTINCT(tx_hash)) as total_tx,
count(DISTINCT(origin_from_address)) as users, sum(amount) as amount, avg(amount) as avg_amount
from swap_to
group by 1
Run a query to Download Data