feyikemiTraded Volume Perc. Diff
Updated 2025-01-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH August_stats AS (
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
)
SELECT
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
QueryRunArchived: QueryRun has been archived