date_trunc('day',hour) as day,

symbol,

AVG(price)

FROM ethereum.token_prices_hourly

WHERE

LOWER(symbol) = 'alcx'

-- OR LOWER(symbol) = 'eth'

AND hour >= getdate() - interval '2 months'

GROUP BY date_trunc('day',hour), symbol

ORDER BY 1