strawbettyLUNA price below and over 52
    Updated 2022-03-12
    with luna_price as (
    SELECT block_timestamp::date as date, avg(price_usd) as price,
    case when price >= 52 then 'Above 52'
    else 'Below 52' end as label
    FROM terra.oracle_prices
    WHERE date >= '2021-12-01'
    AND date < '2022-03-10'
    AND symbol = 'LUNA'
    GROUP BY 1
    ORDER BY 1
    )

    select label, count(*) as total_days from luna_price group by 1
    Run a query to Download Data