PERIOD | TOTALSWAPVOLUMEUSD | VOLUMECHANGEPCT | AVGSWAPAMOUNTUSD | AVGAMOUNTCHANGEPCT | TOTALSWAPSCOUNT | SWAPCOUNTCHANGEPCT | SWAPPERCOUNT | SWAPPERCHANGEPCT | |
|---|---|---|---|---|---|---|---|---|---|
1 | Last 30 Days | 2030741035.02695 | -13.224754994 | 1468.923379133 | 48.266723638 | 552693 | -17.8555 | 27356 | -3.0479 |
datavortex1 month changes
Updated 2025-05-07
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 PeriodMetrics AS (
SELECT
CASE
WHEN block_timestamp >= DATEADD(day, -30, CURRENT_DATE) THEN 'Last 30 Days'
WHEN block_timestamp >= DATEADD(day, -60, CURRENT_DATE) THEN 'Previous 30-60 Days'
WHEN block_timestamp >= DATEADD(day, -90, CURRENT_DATE) THEN 'Previous 60-90 Days'
END AS Period,
SUM(from_amount_usd) AS TotalSwapVolumeUsd,
AVG(from_amount_usd) AS AvgSwapAmountUsd,
COUNT(DISTINCT tx_id) AS TotalSwapsCount,
COUNT(DISTINCT from_address) AS SwapperCount
FROM
thorchain.defi.fact_swaps
WHERE
block_timestamp >= DATEADD(day, -90, CURRENT_DATE)
GROUP BY
1
),
PeriodChanges AS (
SELECT
Period,
TotalSwapVolumeUsd,
LAG(TotalSwapVolumeUsd) OVER (
ORDER BY
Period DESC
) AS PrevPeriodVolume,
AvgSwapAmountUsd,
LAG(AvgSwapAmountUsd) OVER (
ORDER BY
Period DESC
) AS PrevPeriodAvgAmount,
TotalSwapsCount,
LAG(TotalSwapsCount) OVER (
ORDER BY
Period DESC
) AS PrevPeriodSwapCount,
Last run: 16 days ago
1
107B
5s