feyikemiDaily Trends
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
›
⌄
WITH August_stats AS (
SELECT
Date_trunc('day', Block_timestamp) AS Date,
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
)
SELECT
Date,
Total_Trades_Aug AS Total_Trades,
Total_Traders_Aug AS Total_Traders,
Total_Traded_Volume_Aug AS Total_Traded_Volume,
SUM(Total_Trades_Aug) OVER (ORDER BY Date) AS Cumulative_Trades,
SUM(Total_Traders_Aug) OVER (ORDER BY Date) AS Cumulative_Traders,
SUM(Total_Traded_Volume_Aug) OVER (ORDER BY Date) AS Cumulative_Traded_Vol
FROM
August_stats
QueryRunArchived: QueryRun has been archived