SELECT
hour,
cast(price as decimal(10,4)) as price,
LAG(price, 24) OVER (ORDER BY hour) AS price_24h_ago,
((price - price_24h_ago)/price_24h_ago)*100 as price_change
FROM
arbitrum.core.fact_hourly_token_prices
where
SYMBOL = 'WINR'
ORDER BY hour desc