0xHaM-dratio
    Updated 2022-10-25
    select
    (sum(case when balance_type in ('liquid') then (balance/pow(10,decimal)) end) / sum(case when balance_type in ('staked') then (balance/pow(10,decimal)) end)) as ratio
    from osmosis.core.fact_daily_balances
    where currency = 'uosmo'
    and date = (select max(date) from osmosis.core.fact_daily_balances)

    UNION

    select
    avg(balance/pow (10,decimal)) as avg_osmo_bal
    from osmosis.core.fact_daily_balances
    where currency = 'uosmo'
    and date = (select max(date) from osmosis.core.fact_daily_balances)
    Run a query to Download Data