flipside

    Average balance & User growth
    xeejsgr478Average balance & User growth
    Updated 2022-10-26
    SELECT
    date,
    COUNT(DISTINCT address) AS wallets,
    AVG(balance/POW(10,decimal)) AS balance
    FROM
    osmosis.core.fact_daily_balances
    WHERE
    date >= '2022-01-01'
    AND
    currency = 'uosmo'
    GROUP BY 1
    ORDER BY 1
    Run a query to Download Data