HOUR,

case

when hour>'2022-09-15 03:00:00.000' then 'Post-merge period'

else 'Pre-merge period'

end as gp,

avg(price) as ETH_price

from ethereum.core.fact_hourly_token_prices

WHERE hour>='2022-09-01' and SYMBOL='WETH'

group by 1,2