ML6Quantity & Volume Ratios of Liquid OSMO 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
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with liquids as (select count(*) as liquid_c ,sum(BALANCE/1e6) as liquid_a ,date as liquid_d from osmosis.core.fact_daily_balances
where BALANCE_TYPE='liquid' and CURRENCY='uosmo'
group by liquid_d)
, staked as (select count(*) as staked_c ,sum(BALANCE/1e6) as staked_a ,date as staked_d from osmosis.core.fact_daily_balances
where BALANCE_TYPE='staked' and CURRENCY='uosmo'
group by staked_d)
, top100_all as (select sum(BALANCE/1e6) , address from osmosis.core.fact_daily_balances
where CURRENCY='uosmo'
group by address
order by 1 DESC
limit 100)
, top100_2022 as (select sum(BALANCE/1e6) , address from osmosis.core.fact_daily_balances
where date<'2022-01-01' and CURRENCY='uosmo'
group by address
order by 1 DESC
limit 100 )
, avg_osmo as ( select sum(balance/1e6)/count(distinct address) from osmosis.core.fact_daily_balances
where CURRENCY='uosmo')
, avg_osmo_overtime as ( select sum(balance/1e6)/count(distinct address) , date from osmosis.core.fact_daily_balances
where CURRENCY='uosmo'
group by date)
, avg_osmo_overtime_users as ( select sum(balance/1e6)/count(distinct address) as avg , count(distinct address) as users, date from osmosis.core.fact_daily_balances
where CURRENCY='uosmo'
group by date)
, top10_osmo as (select sum(BALANCE/1e6) , address from osmosis.core.fact_daily_balances
where CURRENCY='uosmo'
group by address
order by 1 DESC
limit 10)
,top10_another as (select sum(BALANCE/(case when DECIMAL is null then 6 else DECIMAL end )) , address from osmosis.core.fact_daily_balances
where CURRENCY like '%ibc%'
group by address
order by 1 DESC
limit 10)
Run a query to Download Data