amirkhannoriiLuna price Classification
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT COUNT(CASE WHEN price_USD < 52 then 1 ELSE NULL END) as "The number of days", 'Lower_than_52' as Classification
from terra.oracle_prices
where symbol = 'LUNA'
and substr(block_timestamp, 1, 10) >= '2022-01-10'
and substr(block_timestamp, 12, 13) = '00:00:00.000'
Union
select COUNT(CASE WHEN price_usd >= 52 then 1 ELSE NULL END), 'Higher_than_52'
from terra.oracle_prices
where symbol = 'LUNA'
and substr(block_timestamp, 1, 10) >= '2022-01-10'
and substr(block_timestamp, 12, 13) = '00:00:00.000'
Run a query to Download Data