select case when RECORDED_HOUR::DATE < '2023-01-14' then 'week before the launch'
else 'week after the launch' end AS TIME,* from crosschain.core.fact_hourly_prices
where ID='terra-luna-2' and RECORDED_HOUR::DATE between dateadd('week',-1,'2023-01-14') and dateadd('week',+1,'2023-01-13')