Hossein2023-07-10 09:33 AM
Updated 2023-07-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date_trunc('week', block_timestamp)::date as week,
count(distinct tx_hash) as swaps,
count(distinct sender) as swappers,
sum(amount_in_usd) as volume_usd,
avg(amount_in_usd) as average_volume_usd,
sum(swaps) over (order by week) as cumulative_swaps,
sum(volume_usd) over (order by week) as cumulative_volume_usd
from avalanche.core.ez_dex_swaps
where '0xa25eaf2906fa1a3a13edac9b9657108af7b703e3' in (token_in, token_out)
and amount_in_usd > 0
group by 1
order by 1
Run a query to Download Data