date_trunc('day',hour) as day,

symbol,

AVG(price)

FROM ethereum.token_prices_hourly

WHERE

-- LOWER(symbol) = 'alcx'

LOWER(symbol) = 'eth'

-- OR LOWER(symbol) = 'alcx'

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

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

ORDER BY date_trunc('day',hour) ASC