DAY | SYMBOL_IN | DAILY_VOLUME | PREVIOUS_DAY_VOLUME | VOLUME_CHANGE_PERCENTAGE | |
|---|---|---|---|---|---|
1 | 2024-10-01 00:00:00.000 | BUSD | 25.92 | ||
2 | 2024-10-01 00:00:00.000 | DAI | 3224266.23 | ||
3 | 2024-10-01 00:00:00.000 | EURS | 24295.26 | ||
4 | 2024-10-01 00:00:00.000 | TUSD | 0.59 | ||
5 | 2024-10-01 00:00:00.000 | USDC | 51846254.7 | ||
6 | 2024-10-01 00:00:00.000 | USDT | 16081015.69 | ||
7 | 2024-10-01 00:00:00.000 | UST | 1612.98 | ||
8 | 2024-10-02 00:00:00.000 | BUSD | 6.67 | 25.92 | -74.27 |
9 | 2024-10-02 00:00:00.000 | DAI | 2774795.7 | 3224266.23 | -13.94 |
10 | 2024-10-02 00:00:00.000 | EURS | 4043.65 | 24295.26 | -83.36 |
11 | 2024-10-02 00:00:00.000 | TUSD | 0 | 0.59 | -100 |
12 | 2024-10-02 00:00:00.000 | USDC | 44192518.54 | 51846254.7 | -14.76 |
13 | 2024-10-02 00:00:00.000 | USDT | 12962468.57 | 16081015.69 | -19.39 |
14 | 2024-10-02 00:00:00.000 | UST | 1125.18 | 1612.98 | -30.24 |
15 | 2024-10-03 00:00:00.000 | BUSD | 59.25 | 6.67 | 788.31 |
16 | 2024-10-03 00:00:00.000 | DAI | 2909761.05 | 2774795.7 | 4.86 |
17 | 2024-10-03 00:00:00.000 | EURS | 17430.03 | 4043.65 | 331.05 |
18 | 2024-10-03 00:00:00.000 | TUSD | 122.62 | 0 | |
19 | 2024-10-03 00:00:00.000 | USDC | 38704921.42 | 44192518.54 | -12.42 |
20 | 2024-10-03 00:00:00.000 | USDT | 12333050.27 | 12962468.57 | -4.86 |
datavortexminimum-cyan
Updated 2025-04-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
25
26
27
28
29
30
31
32
33
›
⌄
WITH daily_volume AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
symbol_in,
SUM(amount_in_usd) AS daily_volume
FROM polygon.defi.ez_dex_swaps
WHERE symbol_in IN ('USDT', 'USDC', 'EURS', 'DAI', 'UST', 'BUSD', 'TUSD')
AND block_timestamp >= '{{ start_date }}'
AND block_timestamp < '{{ end_date }}'
GROUP BY day, symbol_in
),
volume_with_previous AS (
SELECT
dv.day,
dv.symbol_in,
dv.daily_volume,
LAG(dv.daily_volume) OVER (PARTITION BY dv.symbol_in ORDER BY dv.day) AS previous_day_volume
FROM daily_volume dv
)
SELECT
day,
symbol_in,
daily_volume,
previous_day_volume,
CASE
WHEN previous_day_volume IS NULL OR previous_day_volume = 0 THEN NULL
ELSE ROUND((daily_volume - previous_day_volume) * 100.0 / previous_day_volume, 2)
END AS volume_change_percentage
FROM volume_with_previous
ORDER BY day, symbol_in;
Last run: 29 days ago
...
209
12KB
2s