FROM (

SELECT SYMBOL_IN AS ASSET,

DATE_TRUNC('week', BLOCK_TIMESTAMP) AS DATE,

SUM(COALESCE(AMOUNT_IN_USD, 0)) + SUM(COALESCE(AMOUNT_OUT_USD, 0)) AS TOTAL_VOLUME,

COUNT(*) AS NUMBER_OF_TRANSACTIONS,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS NUMBER_OF_SWAPPERS,

ROW_NUMBER() OVER(PARTITION BY SYMBOL_IN, DATE_TRUNC('week', BLOCK_TIMESTAMP) ORDER BY TOTAL_VOLUME DESC) AS RN

FROM avalanche.core.ez_dex_swaps

WHERE BLOCK_TIMESTAMP >= DATEADD('week', -{{time_period_weeks}}, CURRENT_TIMESTAMP())

AND SYMBOL_IN IN ('WAVAX', 'USDC', 'USDC.e', 'USDt', 'USDT.e', 'WETH.e')

GROUP BY 1, 2

) WHERE RN <= 6

ORDER BY DATE ASC, TOTAL_VOLUME DESC;