WITH Stats AS (

SELECT

Platform,

Swapper,

SUM(COALESCE(amount_in_usd, amount_out_usd)) AS Total_Traded_Volume

FROM

aptos.defi.ez_dex_swaps

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

AND amount_in_usd < 1e6

AND amount_out_usd < 1e6

GROUP BY 1, 2

Platform,

COUNT(DISTINCT Swapper) AS Traders

FROM Stats

WHERE Total_Traded_Volume > 1000000

GROUP BY Platform

ORDER BY Traders DESC