SYMBOL | PRICE_PREVIOUS_HOUR | PRICE_DAY_AGO | PERCENTAGE_CHANGE | |
|---|---|---|---|---|
1 | BUSD | 0.999631 | 0.998566 | 0.1066529403 |
2 | DAI | 1 | 1 | 0 |
3 | EURS | 1.091 | 1.089 | 0.1836547291 |
4 | TUSD | 0.995212 | 0.99538 | -0.01687797625 |
5 | USDC | 0.997354 | 0.9999253911 | -0.257158292 |
6 | USDT | 0.998982 | 1.003 | -0.4005982054 |
7 | UST | 0.02239712 | 0.02299242 | -2.589114152 |
datavortexPrice Change 2
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
34
35
36
›
⌄
WITH prices AS (
SELECT
symbol,
hour,
price,
ROW_NUMBER() OVER (PARTITION BY symbol ORDER BY hour DESC) AS rn
FROM polygon.price.ez_prices_hourly
WHERE symbol IN ('USDT', 'USDC', 'EURS', 'DAI', 'UST', 'BUSD', 'TUSD')
AND hour >= '{{ start_date }}'
AND hour < '{{ end_date }}'
),
latest_prices AS (
SELECT
symbol,
price AS price_previous_hour,
hour AS hour_previous
FROM prices
WHERE rn = 1
),
previous_hour_prices AS (
SELECT
symbol,
price AS price_previous_hour
FROM prices
WHERE rn = 2
),
day_ago_prices AS (
SELECT
symbol,
price AS price_day_ago,
ROW_NUMBER() OVER (PARTITION BY symbol ORDER BY hour DESC) AS day_rn
FROM prices
WHERE hour < (SELECT MAX(hour) FROM prices WHERE rn = 1)
)
SELECT
l.symbol,
Last run: about 1 month ago
7
255B
9s