elect

ADDRESS,

SUM (BALANCE/pow(10,DECIMAL)) AS BALANCE

FROM osmosis.core.fact_daily_balances

WHERE CURRENCY = 'uosmo'

AND DATE = CURRENT_DATE - 1

GROUP BY 1 ORDER BY BALANCE DESC LIMIT 100