date_trunc('day',hour) as daily,

avg (price) as Price ,

case when hour >= '2022-08-01' and hour < '2022-09-15' then 'Before Merge'

when daily >= '2022-09-15' then 'After Merge' else null end as Merge

from ethereum.core.fact_hourly_token_prices

where symbol = 'WETH'

and daily >= '2022-09-05' and daily <= '2022-09-24'

group by daily,Merge

order by Merge