NuveveCryptoArchivedStaked to Liquid OSMO Over Time
Updated 2023-04-23
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 liquid as (
select
date,
sum(balance) as total
from osmosis.core.fact_daily_balances
where currency = 'uosmo'
and balance_type = 'liquid'
group by date
),
staked as (
select
date,
sum(balance) as total
from osmosis.core.fact_daily_balances
where currency = 'uosmo'
and balance_type = 'staked'
group by date
),
sfstaked as (
select
date,
sum(balance) as total
from osmosis.core.fact_daily_balances
where currency = 'uosmo'
and balance_type = 'superfluid staked'
group by date
)
select
liquid.date as date,
liquid.total as liquid,
staked.total as staked
from liquid
inner join staked on liquid.date = staked.date
Run a query to Download Data