superflyUntitled Query
Updated 2022-10-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select date,typeQ,
sum(balance/pow(10,decimal)) as balanc
from osmosis.core.fact_daily_balances
where currency = 'uosmo'
GROUP by 1 ,2
UNION
select
date,
'ratio' as typeQ,
(sum(case when typeQ in ('liquid') then (balance/pow(10,decimal)) end) / sum(case when typeQ in ('staked') then (balance/pow(10,decimal)) end)) as ratio
from osmosis.core.fact_daily_balances
where currency = 'uosmo'
GROUP by 1 ,2
Run a query to Download Data