select
date_trunc('day', hour) as dly_d
,symbol
,avg(price) as price
,avg(decimals) as decimals
from ethereum.token_prices_hourly
where upper(symbol) in ('WETH', 'AAVE', 'MATIC', 'USDC', 'USDT', 'DAI', 'WBTC')
and hour > current_date - 10
group by 1,2
order by 2,1
limit 100