rackhaelStaked and Liquid Osmo Overtime
    Updated 2022-10-27
    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
    Run a query to Download Data