SELECT
date_trunc('day',hour) as time,
avg(price) as price,
symbol
FROM ethereum.token_prices_hourly
WHERE
LOWER(symbol) = 'eth'
OR LOWER(symbol) = 'alcx'
OR LOWER(symbol) = 'alusd'
AND hour >= '2021-02-27T00:00:00Z'
GROUP BY time, symbol
ORDER BY 1 DESC
LIMIT 90