date_trunc('day', hour) as date,

token_address,

symbol,

decimals,

avg(price) as price

from optimism.core.fact_hourly_token_prices

where 1 = 1 and hour >= CURRENT_DATE - {{n_days}}

and symbol = 'ETH'

group by date, symbol, decimals, token_address