SYMBOL_IN,

SUM(AMOUNT_IN_USD) AS volume,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS swappers,

COUNT(DISTINCT TX_HASH) AS swaps

FROM avalanche.defi.ez_dex_swaps

WHERE AMOUNT_IN_USD IS NOT NULL

AND BLOCK_TIMESTAMP > CURRENT_DATE - INTERVAL '{{trading_period}} days'

GROUP BY SYMBOL_IN

ORDER BY volume DESC

LIMIT 10;