Stablecoins on Aptos | Average Daily Price Change | Volatility Index | DAYS | |
|---|---|---|---|---|
1 | USDT | 0.1163216802 | 0.5703938587 | 2625 |
2 | MOD | 0.1185420308 | 0.2291234064 | 697 |
3 | USDC | 0.3118207684 | 4.797418573 | 1130 |
4 | BUSD | 20.575465704 | 41.67393196 | 335 |
Kruys-Collinszippy-aqua
Updated 2025-03-09
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 daily_prices AS (
SELECT
DATE_TRUNC('day', hour) AS day,
symbol as token,
AVG(price) AS daily_avg_price
FROM
aptos.price.ez_prices_hourly
WHERE
symbol IN ('MOD', 'USDT', 'USDC', 'BUSD', 'DAI') --
GROUP BY
1,2
),
price_changes AS (
SELECT
day,
token,
daily_avg_price,
LAG(daily_avg_price) OVER (PARTITION BY token ORDER BY day) AS previous_day_price
FROM
daily_prices
),
volatility AS (
SELECT
day,
token,
daily_avg_price,
previous_day_price,
CASE
WHEN previous_day_price IS NULL THEN NULL
ELSE ABS((daily_avg_price - previous_day_price) / previous_day_price) * 100
END AS daily_price_change
FROM
price_changes
)
SELECT
token as "Stablecoins on Aptos",
Last run: about 2 months ago
4
156B
3s