flipside

    Top 100 OSMO holders now (Staked Wallets)
    MadiTop 100 OSMO holders now (Staked Wallets)
    Updated 2022-10-26
    select
    distinct ADDRESS as holder,
    balance/pow(10,decimal) as balance
    from osmosis.core.fact_daily_balances
    where BALANCE_TYPE = 'staked' and currency = 'uosmo' and date = CURRENT_DATE - 1
    --group by holder
    order by balance DESC
    limit 100
    Run a query to Download Data