select

avg(price) as n_op_price

from optimism.core.fact_hourly_token_prices

where symbol in ('OP')

and date_trunc ('hour', hour) = '2022-11-9 10:00:00.000'

)

,

f_op_price_tab as (select

avg(price) as f_op_price

from optimism.core.fact_hourly_token_prices

where symbol in ('OP')

and date_trunc ('hour', hour) = '2022-12-14 15:00:00.000')

SELECT *,

( 1-( n_op_price/f_op_price))*100 as "Price growth percentage"

from n_op_price_tab join f_op_price_tab