date_trunc(day, block_timestamp) as block_day,

price_usd as price,

lead(price, 1, 0) over (order by block_day) as closing_price

from terra.oracle_prices

where block_timestamp >= '2021-11-8' and block_timestamp <= current_date

and symbol = 'LUNA'

and date_part('hour', block_timestamp) = '00')

select *, 52 as "$52 level" from data

where block_day < '2022-3-1'

order by block_day