Open-source Data Analytics of Ethereum Staking Pools

Data Science
1

TL;DR
We conduct an open-source data analysis on Ethereum staking pools. Check the following links for details:

Background

Ethereum staking is the act of depositing 32 ETH to the deposit contract, calling the “deposit” ABI, and emitting a “DepositEvent”. A validator‘s pubkey is then valid for staking on the beacon chain.

Since beacon chain staking is complicated and requires some professional knowledge, many staking pools provide simpler staking services to ordinary ETH holders based on the beacon chain. These staking pools generate many validators by depositing ETH from the same address or addresses with the same “name tag”. It is possible to group validators into different staking pools for further analysis according to such features.

Several projects are working on analyzing Ethereum staking pools, like rated.network, beaconcha.in, ethereumpools.info, pools.invis.cloud, and showing different analyzing results. However, these projects are not open-source, resulting in the uncertainty of the data accuracy and thus confusing us with which one we should refer to.

Therefore, we decide to conduct open-source data analytics on Ethereum staking pools. The source code is uploaded to Github and the data is visualized on ethsta.com.

How it works

image
image656×649 32.2 KB

ETL

All the raw data is obtained from Etherscan APIs.

  1. DepositEvent
    1. txid: the transaction that calls the deposit contract and emits the event
    2. eth2_validator: the validator pubkey in the calldata
  2. Internal transaction (the contract caller is another contract, like Lido)
    1. txid: the transaction id that generates the internal transaction
    2. from: the address that creates the transaction
    3. value: the ETH amount of the internal transaction
  3. Transaction (the contract caller is an EOA, like Coinbase)
    1. txid: the transaction id
    2. from: the address that creates the transaction
    3. value: the ETH amount of the transaction
  4. Tag
    1. address: an EOA address or contract address
    2. name: the “name tag” of the address on Etherscan

Grouping

The grouping process is written in Python, but we’d like to describe it with SQL for simplicity as follows.

SELECT
   name,
   COUNT(eth2_validator) as validator_count,
   SUM(value) as total_value,
   COLLECT_SET(eth2_validator) as eth2_address,
   COLLECT_SET(from) as eth1_address
FROM event, internal_transaction, transaction, tag
WHERE
   event.txid = internal_transaction.txid
   AND event.txid = transaction.txid
   AND tag.address = internal_transaction.from
   AND tag.address = transaction.from

Visualization

Since at most only one media could be embedded in the topic for a new account, you can visit the full version document to see the charts.

From the pie chart on ethsta.com, we can see that Lido owns more than 1/4 validators. The top 3 staking pools, Lido, Coinbase, Kraken, own more than 1/2 validators. We can also see from the table that the top 3 staking pools are still growing fast in validator counts and deposit amounts. Besides, about 30% of validators are classified into “others”, since we are not able to obtain their address tags.

Future Work

We will continue to analyze the validators in “others”, trying to find out the entities behind them. Welcome to raise issues to point out data faults. BTW, we are also interested in the data analytics of client diversity which may help in the upcoming Ethereum “the merge”.

7 Likes
3

Great work on the website, we need more eth staking analytics/stats overall.

A question, how are you adding labels for the entities? It seems that entity_list.py & label.py are related but can’t find any documentation on where the data is coming from.

4

Yes, We download the label from etherscan. All the methods are in the label.py

1 Like