MONTH | MONTHLY_SWAP_COUNT | MONTHLY_GROWTH_PERCENTAGE | |
|---|---|---|---|
1 | 2023-09-01 00:00:00.000 | 13739 | -31.239678 |
2 | 2023-10-01 00:00:00.000 | 4362 | -68.250964 |
3 | 2023-11-01 00:00:00.000 | 7962 | 82.530949 |
4 | 2023-12-01 00:00:00.000 | 201377 | 2429.226325 |
5 | 2024-01-01 00:00:00.000 | 431890 | 114.468385 |
6 | 2024-02-01 00:00:00.000 | 74490 | -82.752553 |
7 | 2024-03-01 00:00:00.000 | 199672 | 168.052088 |
8 | 2024-04-01 00:00:00.000 | 76060 | -61.907528 |
9 | 2024-05-01 00:00:00.000 | 48744 | -35.913752 |
10 | 2024-06-01 00:00:00.000 | 94721 | 94.323404 |
11 | 2024-07-01 00:00:00.000 | 245926 | 159.631972 |
12 | 2024-08-01 00:00:00.000 | 424525 | 72.623065 |
13 | 2024-09-01 00:00:00.000 | 323311 | -23.841705 |
14 | 2024-10-01 00:00:00.000 | 407094 | 25.914058 |
15 | 2024-11-01 00:00:00.000 | 923472 | 126.844906 |
16 | 2024-12-01 00:00:00.000 | 950331 | 2.90848 |
17 | 2025-01-01 00:00:00.000 | 806651 | -15.118943 |
18 | 2025-02-01 00:00:00.000 | 892153 | 10.599627 |
19 | 2025-03-01 00:00:00.000 | 871594 | -2.304425 |
20 | 2025-04-01 00:00:00.000 | 1260746 | 44.648311 |
datavortexfascinating-red
Updated 5 days ago
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
25
26
27
28
29
30
31
32
33
34
35
›
⌄
WITH monthly_growth AS (
SELECT
DATE_TRUNC('month', block_timestamp) AS month,
COUNT(DISTINCT tx_id) AS monthly_swap_count,
LAG(COUNT(DISTINCT tx_id)) OVER (
ORDER BY
DATE_TRUNC('month', block_timestamp)
) AS prev_month_swap_count,
(
COUNT(DISTINCT tx_id) - LAG(COUNT(DISTINCT tx_id)) OVER (
ORDER BY
DATE_TRUNC('month', block_timestamp)
)
) * 100 / NULLIF(
LAG(COUNT(DISTINCT tx_id)) OVER (
ORDER BY
DATE_TRUNC('month', block_timestamp)
),
0
) AS monthly_growth_percentage
FROM
sei.defi.ez_dex_swaps
GROUP BY
month
)
SELECT
month,
monthly_swap_count,
monthly_growth_percentage
FROM
monthly_growth
WHERE
MONTHLY_GROWTH_PERCENTAGE IS NOT NULL
ORDER BY
month ASC;
Last run: 5 days ago
21
950B
4s