select POOL_NAME as "Trading Pair", count(distinct tx_hash) as "⭐Swap Count",
count(distinct origin_from_address) as "Swapper", sum(amount_in_usd) as "Swap Volume",
avg(amount_in_usd) as "Average Swap Volume", median(amount_in_usd) as "Median Swap Volume",
max(amount_in_usd) as "Maximum Swap Volume", sum(amount_in_usd)/count(distinct origin_from_address) as "Volume per User"
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
order by 2 desc
limit 10