mz0111osmo dash 2
    Updated 2022-10-27
    --credit to l4dyros4
    select
    DATE,

    /*COUNT ( DISTINCT ADDRESS) AS USERS,
    SUM (BALANCE/pow(10,DECIMAL)) AS VOLUME,
    AVG (BALANCE/pow(10,DECIMAL)) AS AVG_VOLUME,*/

    SUM (CASE WHEN BALANCE_TYPE = 'liquid' THEN BALANCE/pow(10,DECIMAL) END) AS LIQUID_VOLUME,
    SUM (CASE WHEN BALANCE_TYPE = 'staked' THEN BALANCE/pow(10,DECIMAL) END) AS STAKED_VOLUME,

    LIQUID_VOLUME / STAKED_VOLUME AS RATIO,

    SUM (LIQUID_VOLUME) over (order by Date) as CUM_LIQUID,
    SUM (STAKED_VOLUME) over (order by Date) as CUM_STAKED
    FROM osmosis.core.fact_daily_balances
    WHERE CURRENCY = 'uosmo'
    AND BALANCE_TYPE IN ('liquid','staked')
    AND DATE >= '2022-01-01'
    GROUP BY 1
    Run a query to Download Data