articoloquintoOsmosis unstaking over time
Updated 2022-07-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select sum("count") as "count", date from(
select count(*) as "count", date_trunc('day', block_timestamp) as date
from osmosis.core.fact_staking
where block_timestamp >= '2022-01-01'
and action = 'undelegate'
and TX_STATUS = 'SUCCEEDED'
group by 2
UNION
select count(*) as "count", date_trunc('day', block_timestamp) as date
from osmosis.core.fact_superfluid_staking
where block_timestamp >= '2022-01-01'
and action = 'SuperfluidUndelegate'
and TX_STATUS = 'SUCCEEDED'
group by 2)
group by 2
order by 2 asc
Run a query to Download Data