SELECT

DATE_TRUNC('month', block_timestamp) AS month,

--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 >= '{{Start_Date}}'

AND block_timestamp::DATE < '{{End_Date}}'

GROUP BY 1

Month,

Total_Traded_Volume_Aug,

LAG(Total_Traded_Volume_Aug) OVER (ORDER BY Month) AS Previous_month_traded_Volume,

((Total_Traded_Volume_Aug - LAG(Total_Traded_Volume_Aug) OVER (ORDER BY Month)) / LAG(Total_Traded_Volume_Aug) OVER (ORDER BY Month)) *100 AS Txns_diff

FROM August_stats

ORDER BY Month DESC