flipside

    sum Wallet Balance OSMO by type
    Madisum Wallet Balance OSMO by type
    Updated 2022-10-24
    select
    date,
    'Liquid' as type,
    sum(balance/pow(10,decimal)) as sum_balance
    from osmosis.core.fact_daily_balances
    where
    currency = 'uosmo' and BALANCE_TYPE = 'liquid'
    group by DATE

    UNION

    select
    date,
    'Staked' as type,
    sum(balance/pow(10,decimal)) as sum_balance
    from osmosis.core.fact_daily_balances
    where
    currency = 'uosmo' and BALANCE_TYPE = 'staked'
    group by DATE
    Run a query to Download Data