SELECT

date_trunc('day', block_timestamp) as dt,

avg(price_usd) as lunaprice

from terra.oracle_prices

where symbol = 'LUNA'

and block_timestamp >= '2021-12-01'

and block_timestamp < '2022-03-10'

group by 1