saber-jlweekly osmo balance type from 1jan
    Updated 2022-10-24
    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

    Run a query to Download Data