select date_trunc('day', date) date,

balance_type,

sum(balance/ power(10,6)) balance

from osmosis.core.fact_daily_balances

where balance_type in ('liquid', 'staked')

and currency = 'uosmo'

group by date, balance_type

),

list2 as (

select date_trunc('day', recorded_at) date,

avg(price) price

from osmosis.core.dim_prices

where symbol = 'OSMO'

group by date

),

list3 as (

select date, balance_type, balance, price

from list1 join list2

using (date)

order by date

date, liquid.balance as liquid_balance, stake.balance as stake_balance, liquid.price

from list3 liquid join list3 stake

where 1 = 1

and liquid.price = stake.price

and liquid.balance_type = 'liquid'

and stake.balance_type = 'staked'

order by date