zakkisyedUsers in LSD Platforms
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 staking_contracts(address, name) AS (
SELECT * FROM VALUES
('0xae7ab96520de3a18e5e111b5eaab095312d7fe84', 'Lido Finance'),
('0xd4039ecc40aeda0582036437cf3ec02845da4c13', 'Kraken'),
('0x39dc6a99209b5e6b81dc8540c86ff10981ebda29', 'Staked.us'),
('0xa40dfee99e1c85dc97fdc594b16a460717838703', 'Kraken'),
('0x0194512e77d798e4871973d9cb9d7ddfc0ffd801', 'stakefish'),
('0x0194512e77d798e4871973d9cb9d7ddfc0ffd801', 'stakefish'),
('0xc2288b408dc872a1546f13e6ebfa9c94998316a2', 'Bitcoin Suisse'),
('0xf2be95116845252a28bd43661651917dc183dab1', 'Figment'),
('0xc874b064f465bdd6411d45734b56fac750cda29a', 'Stakewise'),
('0xeee27662c2b8eba3cd936a23f039f3189633e4c8', 'Celsius'),
('0xbdd75a97c29294ff805fb2fee65abd99492b32a8', 'Binance'),
('0x50ff765a993400cd62b61cfa4bb33b1ddf694ec7', 'Binance'),
('0xfa5f9eaa65ffb2a75de092eb7f3fc84fc86b5b18', 'Abyss Finance'),
('0x02cee8dd7581946bef23102e69869f8da96ee502', 'eth2 depositor 1'),
('0x84db6ee82b7cf3b47e8f19270abde5718b936670', 'Ankr'),
('0xdd9663bd979f1ab1bada85e1bc7d7f13cafe71f8', 'Bitcoin Suisse'),
('0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd', 'Cream.Finance'),
('0xbca3b7b87dcb15f0efa66136bc0e4684a3e5da4d', 'SharedStake'),
('0xdfe66b14d37c77f4e9b180ceb433d1b164f0281d', 'Stakehound'),
('0x430cf6dd3e289adae63b50ff661d6bba2dbb3f28', 'StaFi'),
('0xae78736cd615f374d3085123a210448e74fc6393', 'Rocket Pool'),
('0x4d05e3d48a938db4b7a9a59a802d5b45011bde58', 'Rocket Pool'),
('0xdfe66b14d37c77f4e9b180ceb433d1b164f0281d', 'Stakehound'),
('0xbe9895146f7af43049ca1c1ae358b0541ea49704', 'Cbeth'),
('0xe95a203b1a91a908f9b9ce46459d101078c2c3cb', 'stkr'),
('0x5e8422345238f34275888049021821e8e08caa1f', 'frax-eth')
),
user_stakes AS (
SELECT
ORIGIN_FROM_ADDRESS,
CASE
WHEN sum(amount) < 1 THEN '<1 ETH'
Run a query to Download Data