SELECT

block_timestamp::date as fecha_dia,

block_timestamp as fecha_hora,

price_usd as price

FROM

terra.oracle_prices

WHERE

fecha_dia >= '2021-11-01'

AND symbol = 'LUNA'

ORDER BY 1

),

CLOSE AS (

SELECT

fecha_dia,

max(fecha_hora) as fecha_cierre

FROM

PRICE_2021

GROUP BY fecha_dia

ORDER BY 1

),

FLOOR52 AS (

SELECT

fecha_dia,

fecha_hora,

price,

CASE

WHEN price < 52 THEN 'BELOW'

WHEN price >= 52 THEN 'ABOVE'

END AS FLOOR

FROM

PRICE_2021

WHERE

fecha_hora IN (SELECT fecha_cierre FROM CLOSE)