SELECT
date_trunc('week',date) as week,
CASE
WHEN BALANCE_TYPE = 'liquid' THEN 'liquid'
WHEN BALANCE_TYPE = 'staked' THEN 'stake'
WHEN BALANCE_TYPE = 'superfluid staked' THEN 'superfluid staked'
WHEN BALANCE_TYPE = 'locked liquidity' THEN 'loked liq'
end as type,
sum(balance/pow(10,6)) as total_liq_amount
FROM osmosis.core.fact_daily_balances
WHERE CURRENCY = 'uosmo'
AND date >= '2022-01-01'
group by 1,2
order by 1 asc