select origin_from_address as "Swapper", count(distinct tx_hash) as "⭐Swap Count",
sum(amount_in_usd) as "Total Swap Volume", count(distinct platform) as "Dex Count",
avg(amount_in_usd) as "Average Swap Volume", max(amount_in_usd) AS "Maximum Swap Volume",
count(distinct block_timestamp::date) as "Num of days of activity"
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 5