davidpee0718-ITr-tHGetting Started
Updated 2024-10-19Copy Reference Fork
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
36
›
⌄
WITH volume_data AS (
SELECT
DATE,
SUM(VOLUME) AS daily_volume
FROM external.defillama.fact_dex_volume
WHERE Chain = 'flow'
AND DATE >= '2024-01-01'
GROUP BY DATE
),
total_volume AS (
SELECT
SUM(daily_volume) AS total_volume_2024
FROM volume_data
),
volume_last_20_days AS (
SELECT
SUM(daily_volume) AS volume_last_20
FROM volume_data
WHERE DATE >= CURRENT_DATE - INTERVAL '20 days'
),
volume_change AS (
SELECT
(vl.volume_last_20 - (tv.total_volume_2024 - vl.volume_last_20)) AS change_in_volume
FROM total_volume tv, volume_last_20_days vl
),
percentage_change_volume AS (
SELECT
(vc.change_in_volume / NULLIF((tv.total_volume_2024 - vl.volume_last_20), 0)) * 100 AS percent_change
FROM volume_change vc, total_volume tv, volume_last_20_days vl
)
SELECT
tv.total_volume_2024 AS "Total Volume for 2024",
vl.volume_last_20 AS "Volume in Last 20 Days",
vc.change_in_volume AS "Change in Volume in Last 20 Days",
pcv.percent_change AS "% Change in Volume in Last 20 Days"
QueryRunArchived: QueryRun has been archived