Updated 2022-02-27
    with luna_prices as (select case
    when price_usd < 50 then 'fewer'
    when price_usd >=50 then 'more'
    end as price
    from terra.oracle_prices where SYMBOL='LUNA' and BLOCK_TIMESTAMP:: date > '2021-01-01' and HOUR(BLOCK_TIMESTAMP)=0
    )
    select count(*) ,price from luna_prices
    group by price

    Run a query to Download Data