headitmanagerQuery1
Updated 2022-02-27
9
1
2
3
4
5
6
7
8
9
›
⌄
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