Introduction

Delegating your tokens to a service that stakes on your behalf is known as "liquid staking," and it allows you to keep full access to your tokens and funds at all times. With liquid staking, you can still access the funds you stake at any time. The money is held in escrow, but it isn't "locked" and inaccessible like it would be with PoS staking.

Lido is a Ethereum-staking platform that pays daily. The user's balance increases by one unit per day, allowing easier access to staked money. They must stake ETH. Lido lets users unstake whenever they want by tapping stETH-ETH liquidity pools. Once Ethereum transactions are implemented, it will be returned to the issuer. The issuer will then return the user's initial ETH investment plus any rewards they received for helping secure the network. The user can unstake ETH tokens by trading them.

StakeWise is an Ethereum 2.0 staking service that maximises returns. Our unique tokenomics and low fees allow us to run a banking-grade infrastructure and support yield farming and compound staking. Join if you have 0.001 ETH. StakeWise tokenizes your initial investment and staking profits. sETH2 (staking Ethereum) and rETH2 (reward Ethereum) represent user deposits and rewards. As long as you hold sETH2, you'll earn rETH2 from staking.

Rocket Pool is the first decentralized Ethereum staking pool. It was created in 2016 using Vitalik's Mauve Paper. Your custom node software will let you run a node on our network, stake ETH for free, and profit. For ETH depositors, bad node losses are shared across the network to minimise user impact. Rocket Pool's network is redundant and decentralised. This reduces problems and their effects.

Ankr, also known as StakeFi, is a platform built on the concept of staking. With Ankr, we set out to give anyone, anywhere quick and simple access to the cryptocurrency market's many potential revenue streams. The Ankr platform's goal is to create a cloud environment that makes utilising blockchain and all of its capabilities easy and inexpensive for users.

Method

In this dashboard I tried to addressed the the above mentioned questions on liquid staking ETH platforms, for this I used ethereum.core.ez_token_transfers table and filtered it by following contract addresses:

contract_address = lower('0xFe2e637202056d30016725477c5da089Ab0A043A') then 'Stakewise' 
contract_address = lower('0xE95A203B1a91a908F9B9CE46459d101078c2c3cb') then 'stkr' 
contract_address = lower('0xae78736Cd615f374D3085123A210448E74Fc6393') then 'Rocket Pool'
contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84') then 'Lido'    

then calculate the mentioned metrics when from_address = '0x0000000000000000000000000000000000000000', that shows Staked ETH goes to Stakers address as Depositors.

I set

date_trunc('{{interval}}', block_timestamp) as date, 

and used

WHERE platform LIKE '{{platform}}' AND Date >= '{{ُsince_date}}' 

to separate the calculating metrics by staking platforms, timeframe and since date of calculations, therefore you can chose your Intended platform and interval and set a date on the above platform name, interval and date tape to calculate mentioned metrics for your favorite platform and click on Apply All Parameters.

Also I used ethereum.core.dim_dates table by join function and block_timestamp::date = MONTH_START_DATE as mutual column to find the name of months of year to calculate mentioned metrics on each months of year.

NOTE: The codes and most definitions are credited to my previous dashboard.

So, Let’s take a look at visualizations results.

Analysis

Part I: Overall View

In this part I tried to achieve an overall view of each platform separately as below.

This calculation does for Rocket Pool staking platform since 2022 and in weekly timeframe, but you can change that to your own choice by using above tape.

Conclusion

• Rocket Pool had more Staking transactions and unique depositors on August 29.
• Most ETH staked volume was deposited on March 7.
• On May 9th, about $1.7B or 620k ETH were staked on Rocket Pool. January 21 and April 11 of 2022 averaged 48 and 15.6.
• May 27 saw over 497 Staked volume in deposits.
• Over 44% of depositors, or Small Whales, risked 1,000 to 5,000 ETH, while 21% risked 500 to 1,500 ETH.
• 51% of Staked ETH volume deposited on Mars.
• August was the month that most of depositors Staked their ETHs with 18% of total count of unique depositors.

About:

• Author: HaM☰d

  \

• Discord: 0xHaM☰d#8391

  \

• Twitter: @arjmandi_hamed

  \

• Email: h_arjmandi2012@yahoo.com

Choose 1 liquid staking provider (Ankr / Lido / rocketpool, etc) and answer the following question:

The aims of this dashboard is looking at: \n

• How much ETH was staked?
• How many unique depositors are there?
• What is the avg/median/max/min/distribution of ETH deposits?

\n

Hey there 👋!

Firstly, I appreciate you sticking with it until the conclusion.

I’m Hamed, Ph.D. In Civil Engineering and interested in data science.

I've made many similar dashboards and visualizations since I started at Flipside in January.

Please have a look at my various contact information and let me know what you think.

🔭 Findings:

On August 29th there was a spike on Staking transactions count and unique depositors for Rocket Pool platform.

Most of amount ETH staked volume were deposited on Mar 7th.

In cumulative growth, more than 620k ETH in worth of $1.7B was staked on Rocket Pool till May 9th.

💧 Part III: Assessed Metrics on Months of Year

Categorizing :fish: => :whale2: :

To find the distribution of Staked ETH I used following categorize to identify types of depositores:

when eth_staked <= 10 then 'Shrimp' 
when eth_staked between 10 AND 20 then 'Fish'
when eth_staked between 20 AND 35 then 'Octopus'
when eth_staked between 35 AND 50 then 'Dolphin' 
when eth_staked between 50 AND 100 then 'Small Shark' 
when eth_staked between 100 AND 250 then 'Shark' 
when eth_staked between 250 AND 500 then 'Medium Shark'
when eth_staked between 500 AND 1000 then 'Big Shark'
when eth_staked between 1000 AND 5000 then 'Small Whale' 
when eth_staked between 5000 AND 10000 then 'Whale' 
when eth_staked between 10000 AND 20000 then 'Medium Whale'
when eth_staked > 20000 then 'Big Whale'

💧 Part II: What is the avg/median/max/min/distribution of ETH deposits?

🔭 Findings:

• The days with the highest average and median, 48 and 15.6, occurred on Jan 21nd and April 11st, 2022, respectively.
• The day with the highest deposit amount was May 27th, with over 497 Staked volume.
• More than 44% of depositors staked between 1k ~ 5k ETH, referred to as Small Whales in our category, and 21% of depositors staked 500 to 1k ETH, referred to as Big Sharks in our category.