strawbettyUntitled Query
    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