zakkisyedStaking Percentage & their decline
Updated 2023-07-19
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
›
⌄
WITH eth_deposited AS (
SELECT
FROM_ADDRESS AS address,
SUM(ETH_VALUE) AS staked_eth,
DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) AS month_year
FROM
ethereum.core.fact_traces
WHERE
BLOCK_TIMESTAMP > '2020-10-14'
AND TO_ADDRESS = '0x00000000219ab540356cbb839cbe05303d7705fa'
GROUP BY 1, 3
),
depositors_monthly AS (
SELECT
(case when address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' then 'Lido Finance'
when address = '0xd4039ecc40aeda0582036437cf3ec02845da4c13' then 'Kraken'
when address = '0x39dc6a99209b5e6b81dc8540c86ff10981ebda29' then 'Staked.us'
when address = '0xa40dfee99e1c85dc97fdc594b16a460717838703' then 'Kraken'
when address = '0x0194512e77d798e4871973d9cb9d7ddfc0ffd801' then 'stakefish'
when address = '0xc2288b408dc872a1546f13e6ebfa9c94998316a2' then 'Bitcoin Suisse'
when address = '0xf2be95116845252a28bd43661651917dc183dab1' then 'Figment'
when address = '0xc874b064f465bdd6411d45734b56fac750cda29a' then 'Stakewise'
when address = '0xeee27662c2b8eba3cd936a23f039f3189633e4c8' then 'Celsius'
when address = '0xbdd75a97c29294ff805fb2fee65abd99492b32a8' then 'Binance'
when address = '0x50ff765a993400cd62b61cfa4bb33b1ddf694ec7' then 'Binance'
when address = '0xfa5f9eaa65ffb2a75de092eb7f3fc84fc86b5b18' then 'Abyss Finance'
when address = '0x02cee8dd7581946bef23102e69869f8da96ee502' then 'eth2 depositor 1'
when address = '0x84db6ee82b7cf3b47e8f19270abde5718b936670' then 'Ankr'
when address = '0xdd9663bd979f1ab1bada85e1bc7d7f13cafe71f8' then 'Bitcoin Suisse'
when address = '0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd' then 'Cream.Finance'
when address = '0xbca3b7b87dcb15f0efa66136bc0e4684a3e5da4d' then 'SharedStake'
when address = '0xdfe66b14d37c77f4e9b180ceb433d1b164f0281d' then 'Stakehound'
when address = '0x430cf6dd3e289adae63b50ff661d6bba2dbb3f28' then 'StaFi'
when address = '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58' then 'Rocket Pool'
when address = '0xdfe66b14d37c77f4e9b180ceb433d1b164f0281d' then 'Stakehound'
ELSE 'Others'
Run a query to Download Data