WITH wallet_bal as (
SELECT date,
CASE WHEN balance_type = 'staked' THEN balance/pow(10, decimal) ELSE 0 END AS staked_osmo,
CASE WHEN balance_type = 'liquid' THEN balance/pow(10, decimal) ELSE 0 END AS liquid_osmo
FROM osmosis.core.fact_daily_balances
WHERE currency = 'uosmo' AND balance_type IN ('staked', 'liquid')
AND Date > '2022-01-01'
)
SELECT date,
sum(staked_osmo) as "Staked_Osmo",
sum(liquid_osmo) as "Liquid_Osmo"
FROM wallet_bal
GROUP BY 1