hour::date AS day,

symbol,

AVG(price) AS price

FROM aptos.price.ez_hourly_token_prices

WHERE symbol IN ('APT')

GROUP BY 1,2