mohammadhCosmoverse Free Play 4) top holder
    Updated 2022-10-10
    select
    ADDRESS,
    (BALANCE/1e6) as user_balance
    from osmosis.core.fact_daily_balances
    where CURRENCY = 'ibc/0954E1C28EB7AF5B72D24F3BC2B47BBB2FDF91BDDFD57B74B99E133AED40972A'
    and DATE = (select max(DATE) from osmosis.core.fact_daily_balances)
    order by user_balance desc
    limit 20