date(block_timestamp) AS "Block date",

avg(price_usd) AS "LUNA price"

FROM terra.oracle_prices

WHERE symbol = 'LUNA'

AND date(block_timestamp) BETWEEN '2021-01-01' AND '2021-12-31'

GROUP BY 1