date

,sum (iff(balance_type ='liquid' , div0(balance , pow (10,decimal)),0)) as liquid

,sum (iff(balance_type ='staked' , div0(balance , pow (10,decimal)),0)) as stake

,div0(stake,liquid) as Stake_To_Liquid

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

and balance>0

and date>='2021-12-14'

group by 1

order by 1