0xHaM-dratio
Updated 2022-10-25Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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