rezarwzratio of liquid to staked OSMO
Updated 2022-10-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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