feyikemidreadful-teal
Updated 2024-11-18
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 tb1 AS (
SELECT
DATE_TRUNC('month', BLOCK_TIMESTAMP) AS Month,
SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS Total_Trading_Volume
FROM near.defi.ez_dex_swaps
WHERE TOKEN_IN_CONTRACT = 'blackdragon.tkn.near' OR TOKEN_OUT_CONTRACT = 'blackdragon.tkn.near'
GROUP BY 1
),
tb2 AS (
SELECT
Month,
Total_Trading_Volume,
LAG(Total_Trading_Volume) OVER (ORDER BY Month) AS Previous_Month_Volume
FROM tb1
)
SELECT
Month,
Total_Trading_Volume,
Previous_Month_Volume,
(Total_Trading_Volume - Previous_Month_Volume) AS Volume_Change,
ROUND((Total_Trading_Volume - Previous_Month_Volume) / Previous_Month_Volume * 100, 2) AS Percent_Change
FROM tb2
WHERE Previous_Month_Volume IS NOT NULL
QueryRunArchived: QueryRun has been archived