with base as (select

distinct ADDRESS,max(DATE) as date ,avg(BALANCE/1e6) as balance

from osmosis.core.fact_daily_balances

where currency = 'ibc/0954E1C28EB7AF5B72D24F3BC2B47BBB2FDF91BDDFD57B74B99E133AED40972A'

and date>= CURRENT_date - 7

group by 1

order by 3 desc

)

select

distinct address,substr(address,5,6) as short_address,balance from base

order by 3 desc limit 10