select concat(substr(ADDRESS,0,3),'...',substr(ADDRESS,36,8)) as USER_ADDRESS, balance/1e6 as bal from osmosis.core.fact_daily_balances
where currency='ibc/987C17B11ABC2B20019178ACE62929FE9840202CE79498E29FE8E5CB02B7C0A4'
and date = CURRENT_DATE - 1
order by bal desc
limit 10