flipside

    Average Osmo per wallet against user growth over time
    leo-lZzln2Average Osmo per wallet against user growth over time
    Updated 2022-10-24
    select trunc(date, 'day') as date, avg (balance/ pow(10,6)) as average,
    median (balance/ pow(10,6)) as median, count(distinct address) as users
    from osmosis.core.fact_daily_balances
    where CURRENCY = 'uosmo'
    group by 1
    order by 1
    Run a query to Download Data