(

select

recorded_at::date as "date",

symbol as stars_symbol,

avg(price) as stars_price,

avg(volume_24h) as stars_volume,

case

when "date" < '2022-09-26' then 'before cosmoverse'

else 'after cosmerverse'

end as event

from osmosis.core.dim_prices

where 1=1

and symbol='STARS'

and recorded_at > '2022-09-12'

group by "date",stars_symbol

)

select * from stars_price