select
date_trunc('day', recorded_hour) as days,
avg(open) as avax_price,
CASE
WHEN (days >= '2023-01-01') then 'the peak'
else 'other days'
end as specific_time
from
crosschain.core.fact_hourly_prices
where
id ilike 'avalanche-2'
and days >= '2022-08-01'
group by
1