DATE_TRUNC('day', HOUR) AS "Date",

AVG(PRICE) AS "Average Token Price ($)"

FROM

base.price.ez_prices_hourly

GROUP BY

DATE_TRUNC('day',HOUR)

ORDER BY

"Date";