i_danAPTOS: 30d Price Change
Updated 2025-05-12
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 latest_prices AS (
SELECT
symbol
, token_address
, name
, price
, hour
FROM aptos.price.ez_prices_hourly
WHERE hour = (SELECT MAX(hour)
FROM aptos.price.ez_prices_hourly)
),
Last_30d_prices AS (
SELECT
symbol,
token_address,
name,
price,
hour
FROM aptos.price.ez_prices_hourly e
WHERE hour = (SELECT
MAX(hour)
FROM aptos.price.ez_prices_hourly p
WHERE p.token_address = e.token_address
AND hour = CURRENT_DATE - INTERVAL '30 DAYS'
)
)
SELECT
l.symbol AS "Token"
, ROUND((l.price - p.price)/p.price * 100, 2) AS "Price Change"
, CASE WHEN "Price Change" > 0 THEN '🟢' ELSE '🔴' END AS "Change"
, l.token_address AS "Address"
FROM latest_prices l
JOIN Last_30d_prices p
ON l.token_address = p.token_address
Last run: 12 days ago
20
2KB
1s