select date_trunc('day', block_timestamp) as dt, avg(price_usd) as LUNA_price, round(((LUNA_price - lag(LUNA_price) OVER (ORDER BY dt asc))/LUNA_price)*100,2) as percentage_drop
from terra.oracle_prices
where symbol = 'LUNA' and year(block_timestamp) in ('2021', '2022')
group by 1