select

hour::date as date,

token_address,

symbol,

avg(price) as price

from ethereum.token_prices_hourly

where hour::date >= CURRENT_DATE - {{n_days}}

and symbol = 'WETH'

group by date, symbol, token_address

select * from token_price