alirsOsmo-WB-09-A-1
    Updated 2022-10-26
    with holder as (select address, sum(balance/ pow(10,decimal)) as balance
    from osmosis.core.fact_daily_balances
    where CURRENCY = 'uosmo'
    and date = '2022-10-24'
    group by 1
    order by balance desc NULLS LAST
    limit 100),
    rank as (select
    address,balance,
    row_number() over (order by balance desc) as ranking
    from holder)
    select
    address,balance,ranking,
    sum(balance) over (order by ranking asc) as holder_Growth
    from rank
    order by holder_Growth desc NULLS LAST

    Run a query to Download Data