(select * from ethereum.core.fact_hourly_token_prices

where symbol = 'WETH'

and hour > CURRENT_DATE - 90

select

hour,

price,

LAG(price) over (order by hour asc) as prev_price,

price - prev_price as diff

from raws

order by hour desc