DATE_TRUNC('day', hour) as date,

AVG(price) as avg_daily_price,

MAX(price) as high_price,

MIN(price) as low_price

FROM near.price.ez_prices_hourly

WHERE symbol = 'REF'

AND date >= '2025-01-01'

GROUP BY date

ORDER BY date DESC