0xHaM-dDaily OSMO Balance of Top 100 (2023) OSMO Holders Over Time
    Updated 2023-01-20
    with top100 as (
    select address,
    balance / pow (10,decimal) as OSMO_Balance
    from osmosis.core.fact_daily_balances
    where currency = 'uosmo'
    and date = (select max(date) from osmosis.core.fact_daily_balances)
    order by 2 DESC
    limit 100)

    select date,
    sum (balance / pow (10,decimal)) as Total_OSMO_Balance,
    avg (balance / pow (10,decimal)) as Average_OSMO_Balance
    from osmosis.core.fact_daily_balances
    where currency = 'uosmo'
    and address in (select address from top100)
    group by 1
    order by 1
    Run a query to Download Data