Description of work

In this work, we want to analyze the status of unstakes and the behavior of wallets after unstacking Osmo from different perspectives, including:

1 - The number and volume of Osmosis unstakes over time

2 - How frequently do delegators on Osmosis unstake their Osmosis?

3 - What do delegators do with the OSMO once staked?

4 - do delegators re-delegate to specific validators more frequently than others?

First of all, let's explain the concepts of Validator and Delegator

A validator is a node participating in the verification and consensus process of the block. The nodes included in the Validator set decide whether to agree to the proposed block by voting based on their voting power.

\

Even if it is not a Validator, there is a way to participate indirectly in the consensus process. It is to delegate stake to a specific Validator. Every node on the network can delegate stake to a specific Validator. This node is called Delegator.

The voting power of the delegated Validator will be increased by the delegated stake, and the compensation to be received by the Validator will also increase accordingly. At this time, the Delegator that has delegated his own stake will also receive a portion of the compensation that the Validator will receive as compensation for delegation

To answer this question, we use the data in the [osmosis.core.fact_staking] table.

To calculate unstake intervals:
- we first calculate the date of the first stake for each delegator using the following query.
  - SELECT DELEGATOR_ADDRESS, MIN(BLOCK_TIMESTAMP) "STAKE DATE" FROM osmosis.core.fact_staking WHERE TX_STATUS = 'SUCCEEDED' AND ACTION = 'delegate' AND CURRENCY = 'uosmo'GROUP BY DELEGATOR_ADDRESS
- Then we calculate the date of the last unstake and the number of unstakes for each delegator using the following query.
  - SELECT DELEGATOR_ADDRESS, MAX(BLOCK_TIMESTAMP) "LAST UNSTAKE", COUNT(*) "Number of unstakes" FROM osmosis.core.fact_staking WHERE TX_STATUS = 'SUCCEEDED' AND ACTION = 'undelegate' AND CURRENCY = 'uosmo' GROUP BY DELEGATOR_ADDRESS
Then we join these two results together. The resulting table contains the address of each delegator, the date of the first stake, the date of the last unstake, and the number of unstakes. Using this information, we can calculate unstake intervals for all wallets

According to the results:

So far, 46.1K wallets have unstaked Osmo.

\
Osmo has been unstaked 85K times so far.

\
So far, 59M Osmo tokens have been unstaked.
The charts related to the number of unstakes, the number of wallets that have unstaked Osmo, and the amount of Osmo unstaked over time are highly correlated.

\
On May 3, 2022(6.62M Osmo), April 20, 2022(3.38M Osmo), and June 26, 2022(1.4M Osmo), respectively, the highest amount of Osmo unskated.
On May 3, 2022(6.62M Osmo), April 20, 2022(3.38M Osmo), and June 26, 2022(1.4M Osmo), respectively, the highest amount of Osmo unskated.
On March 12, 2022(1139 unstakes), June 13, 2022(1001 unstakes), and May 11, 2022(983 unstakes), the highest number of Osmo unskates occurred.

According to the results:

According to the results:

According to the results:

The largest volume of redelegated Osmos is related to **Sentinel dVPN validator. (**2.77M Osmo)
The second largest volume of redelegated Osmos is related to **Cosmostation validator. (**2.16M Osmo)
The third largest volume of redelegated Osmos is related to **Figment validator. (**1.034M Osmo)

So far, 46.1K wallets have unstaked Osmo.

\
So far, 59M Osmo tokens have been unstaked.
22% of wallets (10.14K) staked Osmo perform unstake between 12 to 26 days.
19.1% of wallets (8.788K) staked Osmo perform unstake between 27 to 46 days.

\
17.2% of wallets (7.93K) staked Osmo perform unstake between 47 to 76 days.
73% of wallets staked Osmo perform unstake between 2 and 76 days.
80.8% of wallets staked Osmo perform unstake between 2 and 166 days.
53.7% of wallets perform swap with unstaked Osmo.
23.8% of wallets redelegate unstaked Osmo.
The most significant volume of redelegated Osmos is related to **Sentinel dVPN validator. (**2.77M Osmo)