Flash Bounty: Merge Staking Providers
Total Volume/Number of Transactions/Unique Users of ETH Deposit on Lido Platform
Average/Median/Max/Min of ETH Deposit on Lido Platform
Average Time Difference Between Deposits
Conclusion
> Summary of analysis from Lido platform
- Total Stake ETH (in ETH)=> 2.94M ETH
- Total Stake ETH (in USD)=> 8.55B USD
- Total Stake Transactions => 103k transactions
- Total Unique Depositors => 74.8k depositors
- Average Time difference between deposits => 23.8 days
- Average Stake ETH (in ETH) => 28.6 ETH
- Average Stake ETH (in USD) => 83.1k USD
- Median Stake ETH (in ETH) => 0.6 ETH
- Median Stake ETH (in USD) => 1642 USD
- Max Stake ETH (in ETH) => 62k ETH
- Max Stake ETH (in USD) => 201M USD
- Min Stake ETH (in USD) => 0 USD
- From the beginning of 2021, 58% of Lido platform users have staked more than one Ethereum about 43k users.
- 85.2% of Lido platform users have staked more than one Ethereum about 6232 users in last 30 days.
Users Breakdown Based on Total Stake ETH on Lido Platform
Top 10 Depositors

Introduction
What is Lido?
Lido is a liquid staking service, that lets users deposit assets like Ethereum, Solana, Polygon, and others to earn a yield. Whenever users stake these assets, they receive another staked version of the same token, which can be used elsewhere in the market.
What Will You Read?
In this analysis you will read:
-
Total Staked ETH/number of Transactions/number of unique depositor/average/median/max/min on Lido.
-
Total Monthly Staked ETH/number of Transactions/number of unique depositor/average/median/max/min on Lido.
-
User breakdown based on total staked ETH.
-
Average time difference (day) between deposits.
-
Top 10 depositors by ETH volume and number of deposits.
Method
-
Lido: '0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84'
-
I first got the transactions from the
ethereum.core.fact_event_logs
table by filteringcontract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' and
event_name = 'Transfer' and event_inputs:from = '0x00000000000000000000000000000000000000000')
and then joined with the
ethereum.core.ez_eth_transfers
table to get the amount of staked ETH to ETH and USD. -
I divided my findings into two-time frames monthly and last 30 days.
-
Also, I used avg, Median, Max, and Min function to calculate these parameters.
Total Stake ETH Over Time
Cumulative Volume/Number of Transactions/Unique Users of ETH Deposit on Lido Platform