DATE,

COUNT ( DISTINCT ADDRESS) AS WALLET,

SUM (WALLET) over (order by Date) as CUM_WALLET,

SUM ( BALANCE/pow(10,DECIMAL)) AS TOTAL_BALANCE,

AVG ( BALANCE/pow(10,DECIMAL)) AS AVG_BALANCE,

TOTAL_BALANCE / WALLET AS OSMO_PER_WALLET

FROM osmosis.core.fact_daily_balances

WHERE CURRENCY = 'uosmo'

AND DATE >= '2022-01-01'

GROUP BY 1