date_trunc('hour', CONVERT_TIMEZONE('America/New_York', block_timestamp)) as date,

avg(price_usd) as avg_price

FROM terra.oracle_prices

WHERE SYMBOL = 'LUNA'

AND block_timestamp > CURRENT_DATE - INTERVAL '3 days'

GROUP BY 1

ORDER BY 1