avg(price) as "Average price"

from ethereum.core.fact_hourly_token_prices

where token_address = '0x8400d94a5cb0fa0d041a3788e395285d61c9ee5e'

and DATE_TRUNC('day',hour) = '2023-01-01'

limit 10000;