date_trunc('day', recorded_hour) as day,

AVG(price) as average_price

FROM osmosis.price.ez_prices

WHERE symbol = 'WLD'

AND recorded_hour >= current_date - interval '1 year'

GROUP BY day