datavortexsocialist-ivory
Updated 2024-11-06
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 SwapVolume AS (
SELECT
SUM(from_amount_usd) AS TotalSwapVolumeUsd_7d,
COUNT(DISTINCT tx_id) AS TotalSwapsCount_7d,
COUNT(DISTINCT from_address) AS TotalSwappers_7d
FROM
thorchain.defi.fact_swaps
WHERE
block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '7 day'
),
SwapVolumePrevious AS (
SELECT
SUM(from_amount_usd) AS TotalSwapVolumeUsd_7d_previous,
COUNT(DISTINCT tx_id) AS TotalSwapsCount_7d_previous,
COUNT(DISTINCT from_address) AS TotalSwappers_7d_previous
FROM
thorchain.defi.fact_swaps
WHERE
block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '14 day'
AND block_timestamp < CURRENT_TIMESTAMP - INTERVAL '7 day'
)
SELECT
sv.TotalSwapVolumeUsd_7d,
svp.TotalSwapVolumeUsd_7d_previous,
CASE
WHEN svp.TotalSwapVolumeUsd_7d_previous = 0 THEN NULL
ELSE (
sv.TotalSwapVolumeUsd_7d - svp.TotalSwapVolumeUsd_7d_previous
) / svp.TotalSwapVolumeUsd_7d_previous * 100
END AS VolumeChangePercentage,
sv.TotalSwapsCount_7d,
svp.TotalSwapsCount_7d_previous,
CASE
WHEN svp.TotalSwapsCount_7d_previous = 0 THEN NULL
ELSE (
sv.TotalSwapsCount_7d - svp.TotalSwapsCount_7d_previous
QueryRunArchived: QueryRun has been archived