date_trunc('day', hour) AS hour_date,

Avg(price) as daily_price

FROM ethereum.token_prices_hourly

WHERE token_address = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'

GROUP by hour_date