date_trunc('day', block_timestamp) as dates,

SYMBOL,

avg(price_usd)

FROM

terra.classic.dim_oracle_prices

WHERE

SYMBOL = 'LUNA' AND BLOCK_TIMESTAMP::date >= '2023-01-01'

GROUP BY

1, 2

LIMIT 10