count (case when price_usd > '52 ' then 'above 52'

ELSE NULL end )

from terra.oracle_prices

where block_timestamp > current_date -100

and hour(block_timestamp) = 0

and SYMBOL = 'LUNA'

union

select

count (case when price_usd < '52 ' then 'below 52'

ELSE NULL end )

from terra.oracle_prices

where block_timestamp > current_date -100

and hour(block_timestamp) = 0

and SYMBOL = 'LUNA'