SELECT
address,
SUM(balance/POW(10,decimal)) AS current_balance,
SUM(current_balance) OVER (ORDER BY current_balance) AS total_balance
FROM
osmosis.core.fact_daily_balances
WHERE
date = CURRENT_DATE()
AND
balance_type = 'liquid'
AND
currency = 'uosmo'
GROUP BY address
ORDER BY current_balance DESC
LIMIT 100