CURRENT_PRICE | PRICE_24H_AGO | PRICE_7D_AGO | PRICE_30D_AGO | GROWTH_24H | GROWTH_7D | GROWTH_30D | |
|---|---|---|---|---|---|---|---|
1 | 0.00003256222222 | 0.00003235041667 | 0.000030675 | 0.00006660208333 | ⬆️ 0.65 | ⬆️ 6.15 | ⬇️ -51.11 |
zyroqprice metrics
Updated 2025-03-22
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_avg_prices AS (
SELECT
hour::date AS date,
AVG(price) AS avg_price
FROM aptos.price.ez_prices_hourly
WHERE TOKEN_ADDRESS='0x96baeee6d7a4a8cd712144d1225cfcb6c26d0c6fefd463bd77a878e4526c7411::hair_coin::HairCoin'
GROUP BY 1
),
price_snapshots AS (
SELECT
MAX(CASE WHEN date = CURRENT_DATE THEN avg_price END) AS current_price,
MAX(CASE WHEN date = CURRENT_DATE - INTERVAL '1 day' THEN avg_price END) AS price_24h_ago,
MAX(CASE WHEN date = CURRENT_DATE - INTERVAL '7 day' THEN avg_price END) AS price_7d_ago,
MAX(CASE WHEN date = CURRENT_DATE - INTERVAL '30 day' THEN avg_price END) AS price_30d_ago
FROM daily_avg_prices
)
SELECT
current_price,
price_24h_ago,
price_7d_ago,
price_30d_ago,
CASE
WHEN price_24h_ago > 0 THEN
CASE
WHEN ((current_price - price_24h_ago) / price_24h_ago) * 100 > 0 THEN '⬆️ ' || ROUND(((current_price - price_24h_ago) / price_24h_ago) * 100, 2)
WHEN ((current_price - price_24h_ago) / price_24h_ago) * 100 < 0 THEN '⬇️ ' || ROUND(((current_price - price_24h_ago) / price_24h_ago) * 100, 2)
ELSE '0%'
END
ELSE NULL
END AS growth_24h,
CASE
WHEN price_7d_ago > 0 THEN
CASE
Last run: 23 days ago
1
110B
1s