rezarwzratio of liquid to staked OSMO
    Updated 2022-10-25
    WITH daily_staked_balance as(
    SELECT
    date,
    balance_type,
    sum(BALANCE/pow(10,decimal)) as staked_balance
    from osmosis.core.fact_daily_balances
    where CURRENCY='uosmo' and BALANCE_TYPE='staked'
    GROUP BY 1,2),
    daily_liquid_balance as(
    SELECT
    date,
    balance_type,
    sum(BALANCE/pow(10,decimal)) as liquid_balance
    from osmosis.core.fact_daily_balances
    where CURRENCY='uosmo' and BALANCE_TYPE='liquid'
    GROUP BY 1,2)
    SELECT
    date(lq.date) as date,
    liquid_balance/staked_balance as ratio,
    (SELECT avg(liquid_balance/staked_balance) from daily_staked_balance st inner join daily_liquid_balance lq on st.date=lq.date) as average_ratio
    from daily_staked_balance st inner join daily_liquid_balance lq on st.date=lq.date
    Run a query to Download Data