flipside

    Wallet Balances & Ecosystem Growth - Average staked OSMO per wallet liquid
    saeedmznWallet Balances & Ecosystem Growth - Average staked OSMO per wallet liquid
    Updated 2022-10-26
    select
    avg (BALANCE/pow(10,DECIMAL)) avg_BALANCE
    from osmosis.core.fact_daily_balances
    where CURRENCY ='uosmo'
    and BALANCE_TYPE = 'staked'
    and DATE = (select max(date) from osmosis.core.fact_daily_balances)

    Run a query to Download Data