symbol_in AS Asset,

COUNT(DISTINCT tx_hash) AS Total_Trades,

COUNT(DISTINCT swapper) AS Total_Traders,

SUM(COALESCE(amount_in_usd, amount_out_usd)) AS Total_Traded_Volume

aptos.defi.ez_dex_swaps

WHERE block_timestamp::DATE >= '{{Start_Date}}'

AND amount_in_usd < 1e6

AND amount_out_usd < 1e6

GROUP BY 1

ORDER BY Total_Traders DESC

LIMIT 10