strawbetty2023-02-11 07:58 PM
    Updated 2023-02-11
    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
    Run a query to Download Data