sum(balance/pow(10,6)) as liq_amount

FROM osmosis.core.fact_daily_balances

WHERE BALANCE_TYPE = 'liquid'

and currency = 'uosmo'

and date = '2022-10-24'