osmosis.core.fact_daily_balances.ADDRESS,

sum(balance/ power(10, decimal)) as _balance

FROM osmosis.core.fact_daily_balances

LEFT outer JOIN osmosis.core.dim_labels

ON CURRENCY = osmosis.core.dim_labels.ADDRESS

WHERE project_name LIKE 'OSMO'

AND date = '2022-01-01'

GROUP BY 1

ORDER BY _balance DESC

LIMIT 100