feyikemiDaily Stats
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
24
›
⌄
With stats AS(
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS Date,
COUNT (DISTINCT TX_HASH) AS swaps,
COUNT(DISTINCT SWAPPER) AS swappers,
SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS swap_Volume
FROM aptos.defi.ez_dex_swaps
WHERE EVENT_ADDRESS='0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af'
-- AND block_timestamp::DATE >= '2024-01-01'
GROUP by 1
)
SELECT
Date,
Swaps AS Total_Swaps,
Swappers AS Total_Swappers,
swap_Volume AS Total_Swapped_Volume,
SUM(Swaps) OVER (ORDER BY Date) AS Cumulative_Swaps,
SUM(Swappers) OVER (ORDER BY Date) AS Cumulative_Swappers,
SUM(swap_Volume) OVER (ORDER BY Date) AS Cumulative_Volume
FROM Stats
ORDER BY 1 DESC
QueryRunArchived: QueryRun has been archived