SELECT

symbol,

token_address,

hour,

price,

AVG(price) OVER (

PARTITION BY symbol, token_address

ORDER BY hour

ROWS BETWEEN 168 PRECEDING AND CURRENT ROW

) AS rolling_7d_avg,

AVG(price) OVER (

PARTITION BY symbol, token_address

ORDER BY hour

ROWS BETWEEN 720 PRECEDING AND CURRENT ROW

) AS rolling_30d_avg

FROM

ethereum.price.ez_prices_hourly

WHERE

hour >= DATEADD(DAY, -60, CURRENT_DATE) -- Ensure a 60-day window

),

latest_price AS (

SELECT

symbol,

token_address,

MAX(hour) AS latest_hour

FROM

rolling_averages

WHERE

hour >= CURRENT_DATE

GROUP BY

symbol, token_address

),

latest_price_details AS (

SELECT

lp.symbol,