CryptoIcicleLiquid Staking ETH Platforms Analysis - Deposit Metrics over time
Updated 2022-09-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- Payout 150 USDC
-- Grand Prize 450 USDC
-- Payout Network Ethereum
-- Level Advanced
-- Difficulty Elite
-- Consider all possible liquid staking ETH platforms. Then, find out the following:
-- How much ETH was staked over time?
-- How many unique depositors are there?
-- How likely are depositors to use multiple platforms vs using a single platform?
-- Are depositors Dollar cost averaging their ETH into the platforms?
-- What is the avg/median/max/min/distribution of ETH deposits?
-- Compare all the metrics above between the various ETH staking methods/platforms
-- Hint - Staking Platform Addresses:
-- Stakewise: '0xC874b064f465bdD6411D45734b56fac750Cda29A'
-- stkr: '0x84db6eE82b7Cf3b47E8F19270abdE5718B936670'
-- Cream: '0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd'
-- Rocket_pool: '0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58'
-- Lido: '0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84'
-- Direct staking: '0x00000000219ab540356cBB839Cbe05303d7705Fa'
with txns as (
select
CASE eth_to_address
WHEN '0xc874b064f465bdd6411d45734b56fac750cda29a' THEN 'stakewise'
WHEN '0x84db6ee82b7cf3b47e8f19270abde5718b936670' THEN 'stkr'
WHEN '0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd' THEN 'cream'
WHEN '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58' THEN 'rocket_pool'
WHEN '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' THEN 'lido'
WHEN '0x00000000219ab540356cbb839cbe05303d7705fa' THEN 'direct staking'
END as type,
*
from ethereum.core.ez_eth_transfers
where 1=1
Run a query to Download Data