recorded_hour::DATE AS date,

symbol,

AVG(price) AS price_usd

FROM

osmosis.price.ez_prices

WHERE

symbol IN ('ATOM', 'OSMO', 'JUNO', 'STARS', 'EVMOS', 'LUNA', 'INJ', 'UMEE', 'CMDX', 'IBCX', 'SOMM')

GROUP BY

date,

symbol