MrftiCurrent average OSMO per wallet
    Updated 2022-10-24
    WITH wallets_no as
    (
    SELECT count(address) as user_no
    from osmosis.core.fact_daily_balances
    where currency = 'uosmo'
    and balance_type in ('liquid')
    and date=CURRENT_DATE
    ),
    total as
    (
    SELECT sum(balance/pow(10,decimal)) as total_osmo
    from osmosis.core.fact_daily_balances
    where currency = 'uosmo'
    and balance_type in ('liquid')
    and date=CURRENT_DATE

    )

    SELECT total_osmo/user_no as avg_osmo
    from wallets_no, total
    Run a query to Download Data