(

select

recorded_at::date as "date",

symbol as stars_symbol,

avg(price) as stars_price,

avg(volume_24h) as stars_volume

from osmosis.core.dim_prices

where 1=1

and symbol='STARS'

and recorded_at > '2022-09-12'

group by "date",stars_symbol

),

btc_price as

(

select

recorded_at::date as "date",

symbol as btc_symbol,

avg(price) as btc_price,

avg(volume_24h) as btc_volume

from osmosis.core.dim_prices

where 1=1

and symbol='WBTC'

and recorded_at > '2022-09-12'

group by "date",symbol

)

select s.*,b.* from stars_price s inner join btc_price b on s."date"=b."date"