rahoWeekly Volume II
Updated 2023-08-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH WeeklyVolume AS (
SELECT
DATE_TRUNC('week', date) AS week,
chain AS chain,
SUM(volume) AS weekly_volume
FROM external.defillama.fact_dex_volume
WHERE chain = lower('{{Chain}}')
GROUP BY 1, 2
ORDER BY week
)
SELECT
week,
chain,
weekly_volume AS "Weekly Volume",
((weekly_volume - LAG(weekly_volume) OVER (ORDER BY week)) / LAG(weekly_volume) OVER (ORDER BY week)) * 100 AS "Weekly Volume Increase (%)"
FROM WeeklyVolume
ORDER BY week DESC;
Run a query to Download Data