dayname(to_date(block_timestamp::date)) as weekday,

COUNT(DISTINCT TX_HASH) AS Total_Trades_Aug,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS Total_Traders_Aug,

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

avalanche.defi.ez_dex_swaps

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

GROUP BY 1

ORDER BY 2 DESC