with tab1 as (
select
hour,
symbol,
price
from optimism.core.fact_hourly_token_prices
where symbol in ('WETH', 'OP', 'WBTC')
and hour = '2022-11-06 00:00' )
select
hour,
symbol,
Case
when symbol like 'OP' then ((price-1.31)/1.31) * 100
when symbol like 'WETH' then ((price-1624.49)/1624.49) * 100
when symbol like 'WBTC' then ((price-21290.66)/21290.66) * 100
End as Percent_Change
from optimism.core.fact_hourly_token_prices
where symbol in ('WETH', 'OP', 'WBTC')
and hour > '2022-11-06 00:00'