-- forked from daily @ https://flipsidecrypto.xyz/studio/queries/fa611747-7986-4455-aeb1-928fceb28114
select SYMBOL_in , count(DISTINCT tx_hash) as swap_count,
count (DISTINCT trader) as swapper , sum(amount_in_usd) as vol
from near.defi.ez_dex_swaps
where BLOCK_TIMESTAMP>=current_date-60 and platform='v2.ref-finance.near' and amount_in_usd is not null
GROUP by 1
order by 4 DESC limit 5