datavortexfascinating-red
Updated 2025-01-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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;
QueryRunArchived: QueryRun has been archived