select ADDRESS as holder

,BALANCE/pow(10,DECIMAL) as balance

from osmosis.core.fact_daily_balances

where DATE=current_date

and CURRENCY='uosmo'

and BALANCE_TYPE='liquid'

select count(holder) as holders

,sum(balance) as total_supply

from tab1