date_trunc('day', recorded_hour) as "Date",

symbol,

avg(close) as "Price (USD)"

from

solana.price.ez_token_prices_hourly

where "Date" >= '2022-10-01' and symbol='sol'

group by "Date", symbol