Methodology

Introduction

The Solana blockchain’s SOL token, one of the hardest-hit digital assets this week amid a steep sell-off across crypto markets triggered by the swift collapse of Sam Bankman-Fried’s business empire, slid further on Friday after the one-time billionaire’s main holding company filed for bankruptcy protection.

SOL's price had tumbled to a record low earlier this week of around $12 and then surged 26% to as high as $19 on Thursday.

But on Friday, after the FTX bankruptcy news, the price was back down to around $16, off 6.4% on the day. The SOL price is down 50% in the past seven days.

The additional volatility has sparked a debate among crypto analysts and blockchain developers and executives over Solana’s long-term future, with nagging questions about the prospects for the blockchain and how severely it might be affected by this week’s fallout in the industry.

The SOL token’s recent price movements were tied to speculation about Solana’s close connection with Alameda Research, a trading firm that was founded by Bankman-Fried. SOL was Alameda's second-largest holding, according to Riyad Carey, a research analyst at crypto data firm Kaiko.

The theory was that Alameda might need to dump its SOL tokens to raise liquidity. SOL jumped Thursday after Solana Foundation postponed a plan to "unstake" 28.5 million SOL tokens – implying an immediate relief from additional selling pressure.

Source

• We use solana.core.fact_stake_pool_actions , solana.core.ez_staking_lp_actions , solana.core.fact_swaps tables.

  \

  We see 4 actions:

• Deposit/Stake

• Withdrawal/Unstake

• Order_unstake

• Claim rewards

Sections:

• Staking pool actions
• Stake pools
• Validators
• Top Users
• Bridges
• Swaps

Overall Staking actions

• About 42% of Tx numbers in last week related to Stake.
• After November 8, 8:00 the number of unstake increse.
• On November8, 9:00 we see the largest number of unstake, order to unstake and claim rewards.
• So we can see that the increasing trend of unstaking and order to unstake since November 8 to November 10.

• About 37% of users in past 7 days had stake action and 27% of them had unstake action.

• On November 10, 8:00 we can see that the largest number of users with unstake action.

• On November 10, 9:00 we see the largest number of users with claim reward action.

• On November 5, 6 and 7 the users number is about 200 but since November 8 to 10 the users number increase and reach around 1000 with large number of users that have unstake action.

  But after November 8 users number decrease.

• Most of the volume related to unstaking actions. (65% of total volume)
• Except November 6, see can see that in other days most of the volume is for unstake.
• On November 10 , 8:00 we have the highest amount of unstake about 113.38K.
• And on November 10, 13:00 we see about 458K claim reward.
• On November 10, we see highest total actions volume about 3 times more than last days and also we see highest unstake volume about 2 times more that last days.

• We can see that the average volume of claim rewards is more than unstake volume.

• On November 8 , 1:00 we have highest average volume.

• Total average volume on November 8, is more than other days.

• Users unstake since November 8, 16:00 increase we can see the slop of cumulative users count chart change.
• Also we can see the same trend in cumulative tx count.
• in volume chart we can see the unstake slop decrease after November 10, 9:00.

Stake Pools Stats

• On November 9, we can see the most number of stakes more than 500 stakes. and most of them are in Marinade , Jpool and Lido respectively.
• On staking chart we can see the increasing trend till November 9, and after that the trend decrease.
• On November 10, we can see that unstake number increase and most of them related to Lido, Marinade and socean respectively.
• the unstake number on November 10, is more than 1000 while the stake number on this day is about 400.

• The largest number of users that stake in pools is about 250 and the largest number of users that unstake is about 600 more than 2 times stake users.
• Most of the users with stake action is related to Marinade and Lido.
• the largest number of staking users happened on November 8.
• And the largest number of users with unstaking action happened on November 10 and related to Marinade and Lido pool.

• The highest volume that stake in pools is about 80K and the highest volume that unstake is about 0.8M.
• Most of the volume stake action is related to Marinade, Lido and Jpool.
• the highest volume of staking users happened on November 8.
• And the highest volume of unstaking action happened on November 10 and related to Lido pool.

• We can see that most number of stakes, order to unstake and claim rewards happen in Marinade.

• In the second place is for lido and we can see more unstake actions and users than stake.

• about 1.9M of lido pool volume is related to unstake.

• highest average volume is for Marinade and is for Claime rewards.

  In other pools we can see that the highest Average volume is for unstake.

• The average volume of stakes on Solana stake pool on November6 , 7, 8 are about 500.
• The highest average volume of unstakes on Solana stake pool on November 8 is about 10K and most of them related to Jpool and Lido.

• We can see that the slop of Marinade pool stake volume chart is increase.
• Also we can see the increasing trend in slop of Lido unstake volume chart increase.

• We can see that Validator everstake has most number of stake and unstake also most number of stakers and unstakers.
• Validator q9xw….. and Validator everstake have most stake volume during last week.
• Validators hz5a…. , butfh….and 56o7ja ….. have most unstake volume during last week.

• About 30-50% of stake and unstake numbers related to Validator everstake.
• And 10-25% of stake and unstake numbers related to Validator q9xw….
• The above sentences correct for stakers and unstakers.
• Validator q9xw….. has most stake volume during last week.

Top Users

• E9Y6m…..DZ9P has about 241 stakes number during past week, also this address has 258 unstake number.

• while other top addresses in average have 50 unstakes number.

• UefNb….kP5Q has about 75K stake volume.

• 2KEtA…9vhh1 has about 159K volume unstake .

  \

Bridges

Validators Stats

• On November 7 and 8 we have largest number of bridge and its about 7000 after this time the bridge number decrease.
• On November 9 we have the largest number of bridgers about 470 users and after that we see the decreasing trend.
• On November 9 and 12 we have the highest volume of bridge and it is about 260M.
• We can see the most of these bridge volume is USD Coin that bridges from Ethereum to Solana.

Swaps

• On November 8, we see the largest number of swap to SOL and on November 10 we have the highest number of swap from SOL.
• The number of daily swappers on November 9, is in the largest number for both swap from and swap to SOL and after that the number of swappers decrease.
• On November 9, we have highest volume of swap volume for both swap to SOL and swap from SOL during past week and after that the daily swap volume decrease.
• The average SOL swap volume from November 8 to November 10 has increasing trend and after that the average volume reach about 20.
• The Daily average volume swap to SOL is more than swap from SOL.

Conclusion

• About 42% of Tx numbers in last week related to Stake.

• After November 8, 8:00 the number of unstake increse.

• So we can see that the increasing trend of unstaking and order to unstake since November 8 to November 10.

• About 37% of users in past 7 days had stake action and 27% of them had unstake action.

• On November 5, 6 and 7 the users number is about 200 but since November 8 to 10 the users number increase and reach around 1000 with large number of users that have unstake action.

  But after November 8 users number decrease.

• Most of the volume related to unstaking actions. (65% of total volume)

• On November 10 , 8:00 we have the highest amount of unstake about 113.38K.

• And on November 10, 13:00 we see about 458K claim reward.

• On November 10, we see highest total actions volume about 3 times more than last days and also we see highest unstake volume about 2 times more that last days.

• most number of stakes, order to unstake and claim rewards happen in Marinade.

• On November 9, we can see the most number of stakes more than 500 stakes. and most of them are in Marinade , Jpool and Lido respectively.

• On November 10, we can see that unstake number increase and most of them related to Lido, Marinade and socean respectively.

• The largest number of users that stake in pools is about 250 and the largest number of users that unstake is about 600 more than 2 times stake users.

• The highest volume that stake in pools is about 80K and the highest volume that unstake is about 0.8M.

• About 30-50% of stake and unstake numbers related to Validator everstake.

• Validator q9xw….. has most stake volume during last week.

• The Daily average volume swap to SOL is more than swap from SOL.

• On November 9, we have highest volume of swap volume for both swap to SOL and swap from SOL during past week and after that the daily swap volume decrease.

• On November 7 and 8 we have largest number of bridge and its about 7000 after this time the bridge number decrease.

• On November 9 and 12 we have the highest volume of bridge and it is about 260M.

Thanks for reading!

Also Thanks to Alik110

All queries credit to this dashboard!

tweet link:

• Unstake distribution

  36% of unstake is 10-100 SOL and 37% of unstake number are more than 100 SOL and 16% of unstakes are 1-10 SOL.

  \

• Stake distribution

  41% of them are 10-100 SOL and 30% of stake number are 1-10 SOL and 18% of stakes are less than 1 SOL.

  \

• Claim rewards distribution

  37% of Claim rewards is 10-100 SOL and 34% of Claim rewards number are more than 100 SOL and 21% of Claim rewards are 1-10 SOL.