WITH August_stats AS (

SELECT

Platform,

ORIGIN_FROM_ADDRESS,

SUM((AMOUNT_IN_USD + AMOUNT_OUT_USD)/2) AS Total_Traded_Volume_Aug

FROM

avalanche.defi.ez_dex_swaps

WHERE BLOCK_TIMESTAMP :: Date BETWEEN '{{Start_Date}}' AND '{{End_Date}}'

GROUP BY 1, 2

SELECT

Platform,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS Traders

FROM August_stats

WHERE Total_Traded_Volume_Aug > 1000000

GROUP BY 1

ORDER BY 2 DESC