SELECT

symbol,

price AS current_price,

LAG(price, 1) OVER (ORDER BY hour) AS price_24h_ago,

LAG(price, 7) OVER (ORDER BY hour) AS price_7d_ago,

LAG(price, 30) OVER (ORDER BY hour) AS price_30d_ago

FROM aptos.price.ez_prices_hourly

WHERE symbol = 'SHRIMP'

ORDER BY hour DESC

current_price,

(current_price - price_24h_ago) / price_24h_ago * 100 AS price_change_24h,

(current_price - price_7d_ago) / price_7d_ago * 100 AS price_change_7d,

(current_price - price_30d_ago) / price_30d_ago * 100 AS price_change_30d

FROM price_changes

LIMIT 1;