flipside

    Average Balance and Total Holders (total) Since Start of Year
    olavAverage Balance and Total Holders (total) Since Start of Year
    Updated 2022-10-26
    select
    address,
    avg (balance/ pow(10, 6)) as "Average Balance",
    median (balance/ pow(10, 6)) as "Median Balance"
    from osmosis.core.fact_daily_balances
    where currency = 'uosmo'
    and date::date >= '2022-01-01'
    group by 1
    order by 2 desc
    limit 100
    Run a query to Download Data