DATE,

BALANCE_TYPE as GROUPS,

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 (VOLUME) over (partition by GROUPS order by DATE ) as cum_VOLUME,

SUM (AVG_VOLUME) over (partition by GROUPS order by DATE ) as cum_AVG_VOLUME

FROM osmosis.core.fact_daily_balances

WHERE CURRENCY = 'uosmo'

AND BALANCE_TYPE IN ('liquid','staked')

AND DATE >= '2022-01-01'

GROUP BY 1,2