Eman-RazSwap BY dex
Updated 2023-05-05
9
1
2
3
4
5
6
7
8
9
›
⌄
select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", platform as "DEX", count(distinct origin_from_address) as "Swapper Count",
sum(amount_in_usd) as "Swap Volume", count(distinct tx_hash) as "Swap Count",
avg(amount_in_usd) as "Average Swap Volume", median(amount_in_usd) as "Median Swap Volume",
sum(amount_in_usd)/count(distinct origin_from_address) as "Volume per User", max(amount_in_usd) AS "Maximum Swap Volume"
from avalanche.core.ez_dex_swaps
where amount_in_usd is not null AND
(block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}')
group by 1,2
order by 1
Run a query to Download Data