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

\n

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

Approach

To get better understanding of the questions asked in the question I have observed 3 platforms of Lido, Rocket pool and stkr and by comparing them together we can access how they performed compared to each other.

Methodology

To extract the data needed for solving this bounty i used contract addresses of three platforms as

CONTRACT_ADDRESS= lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670') or CONTRACT_ADDRESS= lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58') or CONTRACT_ADDRESS= lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84') )

with condition of ETH_VALUE>0 from ethereum.core.fact_event_logs inner join ethereum.core.fact_transactions

Total : Ethereum staked, unique depositors and transaction fees

As shown on single numbers above calculated for total Ethereum of staked, unique depositors and transaction fees i have reached following results

• Total Ethereum Staked in 3 platforms is 13.41M Ethereum
• Total Unique Depositors of 3 platforms is 94.4K users
• Total Transaction Fees paid in 3 platforms is 3,520 Ethereum
• Average staked Ethereum by each user is 142 Ethereum
• Average transaction fee paid by each user is 0.037 Ethereum
• Average transaction fee for each staked Ethereum is 2.624906785980611e-4 Ethereum

Total data of each platform : Ethereum staked, unique depositors and transaction fees

As shown on table above calculated for Total data of each platform of Ethereum staked, unique depositors and transaction fees I have reached following results

• Ethereum staked : 1-Lido / 2-Rocket pool / 3-stkr
• Transaction fees : 1-Lido / 2-Rocket pool / 3-stkr
• Unique depositors : 1-Lido / 2-Rocket pool / 3-stkr

As shown above Lido is top protocol in all of observed data , Rocket pool is at second place and stkr is third in all three. Lido is leading platform with best performance at least among these three platforms which its data is more than other two’s combined.

Monthly data of each platform : Ethereum staked, unique depositors and transaction fees

As shown on table above calculated for Monthly data of each platform of Ethereum staked, unique depositors and transaction fees I have reached following results

we can see that has bearish trend in all three which is not strange according its performance place among all three which is last.

Lido shows over all growth in its trends but with slight slope

Rocket pool has been growing since Oct 2021

Maximum amounts of Lido and Rocket pool maxed on 2021 and 2022 which is another sign of their growing performance but stkr maxed amount all occurred on 2020 and was decreasing since which shows weak performance of it.

Total data of each platform : Max & Min, Average and Median of Ethereum staked

As shown on table above calculated for Total data of each platform of Max & Min, Average and Median of Ethereum staked I have reached following results

• Max of Ethereum staked : 1-Lido / 2-Rocket pool / 3-stkr
• Min of Ethereum staked : 1-stkr/ 2-Rocket pool / 3-Lido
• Average of Ethereum staked : 1-Lido / 2-Rocket pool / 3-stkr
• Median of Ethereum staked : 1-stkr/ 2-Rocket pool / 3-Lido

As shown above Lido is top protocol in two of observed data , stkr is top protocol in two of observed data and Rocket pool is top in none of them. Lido is leading platform in average and maximum of staked Ethereum which shows its usage among Ethereum stakers, stkr has highest maximum and median of staked Ethereum which does not shows at least its usage and popularity among Ethereum stakers.