select count(distinct address)as osmo_users
,case
when balance_type='liquid' and balance_type<>'staked' then 'Liquid Holders'
when balance_type='staked' and balance_type<>'liquid' then 'Staked Holders' end as holders_type
from osmosis.core.fact_daily_balances
where currency = 'uosmo'
and date = current_date
and holders_type is not null
group by 2