Intro:

In this bounty the behavior of users unstake their Osmosis is analyzed and possible activities they do with their unstaked OSMOSIS are investigated.

First of all, the unstake frequency is estimated based on the amount and number of unstakes over time.

After that and by obtaining the group of users unstake their Osmosis, the possible activities are analyzed based on these actions:

• Swap to other currency
• Enter a LP position on pools
• Re-delegate via Validators
• Transfer to another address

Finally, as question wants dive deep on re-delegation activity and find out the most popular Validators by users unstake their Osmosis.

Method:

• Used table-→ osmosis.core.fact_staking and ACTION=undelegate

• identification of users unstake their Osmosis-→ distinct DELEGATOR_ADDRESS

• Possible activities-→

  • Swap-→ osmosis.core.fact_swaps
  • Enter a LP-→ osmosis.core.fact_liquidity_provider_actions WHERE ACTION='pool_joined'
  • Re-delegate-→ osmosis.core.fact_staking and ACTION=redelegate
  • Transfer-→ osmosis.core.fact_transfers

• Currency -→ CURRENCY='uosmo'

• Status of each action-→ TX_STATUS='SUCCEEDED'

• Time frame-→ BLOCK_TIMESTAMP>='2022-05-01'

• Validator find-→ VALIDATOR_ADDRESS from osmosis.core.fact_staking

  \

Outcomes:

The time frame of this bounty is set to start of May, 2022.

• Date from June 8 to 12 is not available on Flipside tables
• The frequency of unstaking increased on May 10 to 14 and the main reason of that is because of market crash on these dates.
• Also, the highest unstaking happened on June 13 with more than 1000 unstakes.
• The highest volume of unstake happened on May 3 with 6.63 million OSMO.
• The activities by unstaked OSMO shown in three charts based on number of action and number of users unstake their Osmosis.
• The most used action by users unstake their Osmosis is swapping according to all of the charts.
• The next most used action is transferring OSMO to another address with 32.7% of unstakers.
• Small part of users unstake their Osmosis re-delegate on OSMOSIS by 4.26% of unstakers.
• On June 16 about 42% of users transfer their unstaked OSMO to other accounts and its the highest usage of transfer action.
• On market downturn, most of the unstakers swap their OSMO to another currencies to avoid loss.
• Detail analysis on re-delegation by users unstake their Osmosis shown in the table and donut.
• Based on the results, most of the unstakers use osmovaloper1ej2es5fjztqjcd4pwa0zyvaevtjd2y5w37wr9t Validator to re-delegate their unstaked OSMOSIS.