Bounty Content :

Q21. How are users in incentivized pools behaving vs. non-LP OSMO token holders?

What about versus stakers? Create an analysis that shows activity for the various types of OSMO holders and chart out some additional activities they’re undertaking. Are users LPing or staking more likely to increase their amount staked? What group is receiving the most IBC transfers into Osmosis? 

Method :

In this analysis, I consider the following assumptions :

• Definition of OSMO holder : All users whose amount of OSMO input minus OSMO output from their wallets is greater than zero. I consider transfer_type = 'OSMOSIS'(non IBC_TRANSFERs).

• Definition of LPERs : users added_liquidity to OSMO pools minus removed_liquidity greater then zero (

  pool_joined and pool_exited actions )

• Definition of stakers : users staked OSMO recorded on osmosis.core.fact_staking table.

  
  \

LPERs vs HODLERs :

In this section, I will analyze LPERs vs HODLERs.

• 54% of wallets only HODL OSMO.

• 40% of wallets only OSMO LPER.

• 5% of wallets are both a holder and LPER.

  NOTE : I considered the wallet that holds less than 5 OSMO as the wallet that is the only LPER.

  \

• More LPER wallets have participated in governance voting.

• More LPER wallets have a minimum a swap on Osmosis network than holders and LPER/HOLDERs .

• Since February 21, 2022, the number of transactions of wallets with the holder tag is more than the transactions of wallets with the Lper tag. This is despite the fact that before this date, the number of L-per transactions was more than holder transactions.

• Over time, the number of transactions of holders has exceeded the number of transactions of Lp-ers.

LPERS vs stakers :

In this section, I will analyze LPERs vs Stakers.

• 81 K of wallets are staker and LPER on Osmosis network.

• The number of stakers participated in the governance voting is more than the number of LPERs participated in governance voting. This shows that stakers are more willing to participate in governance voting than holders and LP-ers.

• The number of wallets that have at least one swap and are both stakers and LP-ers is more than the number of wallets that are only stakers or LP-ers.

• The number of transactions of stakers/Lp-ers is more than wallets only Lp-er or only staker over time.

• The number of staker transactions over time has surpassed the number of LP-er transactions over time.

• Most LP-ers have not increased their stacked OSMO amount.

• 49% of stakers not increased their staking amount .
• 28.8% of stakers decreased their staking amount.

What group is receiving the most IBC transfers into Osmosis?

The stakers group receiving the most IBC transfers into Osmosis.

Concolusion :

From the above analysis, we obtained the following results:

1. 54% of wallets only HODL OSMO.
2. 40% of wallets only OSMO LPER.
3. 5% of wallets are both a holder
4. More LPER wallets have participated in governance voting.
5. More LPER wallets have a minimum a swap on Osmosis network than holders and LPER/HOLDERs.
6. Since February 21, 2022, the number of transactions of wallets with the holder tag is more than the transactions of wallets with the Lper tag. This is despite the fact that before this date, the number of L-per transactions was more than holder transactions.
7. the number of transactions of holders has exceeded the number of transactions of Lp-ers.
8. 81 K of wallets are staker and LPER on Osmosis network.
9. The number of stakers participated in the governance voting is more than the number of LPERs participated in governance voting. This shows that stakers are more willing to participate in governance voting than holders and LP-ers.
10. The number of wallets that have at least one swap and are both stakers and LP-ers is more than the number of wallets that are only stakers or LP-ers.
11. The number of transactions of stakers/Lp-ers is more than wallets only Lp-er or only staker over time.
12. The number of staker transactions over time has surpassed the number of LP-er transactions over time.
13. Most LP-ers have not increased their stacked OSMO amount.
14. 49% of stakers not increased their staking amount .
15. 28.8% of stakers decreased their staking amount.
16. The stakers group receiving the most IBC transfers into Osmosis.