--Credits to Ali3N https://flipsidecrypto.xyz/Ali3N/dashboards
SELECT
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
FROM
avalanche.defi.ez_dex_swaps
WHERE BLOCK_TIMESTAMP :: Date BETWEEN '{{Start_Date}}' AND '{{End_Date}}'
GROUP BY 1
ORDER BY 4 DESC