osmosis.core.fact_daily_balances.ADDRESS,

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

-- sum(balance/ power(10, decimal)) / count(DISTINCT osmosis.core.fact_daily_balances.address) as avg_bal

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-10-20'

GROUP BY 1

ORDER BY 2 DESC

LIMIT 10