zakkisyedLSD stakers
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
›
⌄
SELECT
(CASE
WHEN eth_to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' THEN 'Lido Finance'
WHEN eth_to_address = '0x84db6ee82b7cf3b47e8f19270abde5718b936670' THEN 'Ankr'
WHEN eth_to_address = '0xe95a203b1a91a908f9b9ce46459d101078c2c3cb' THEN 'stkr'
WHEN eth_to_address = '0x5e8422345238f34275888049021821e8e08caa1f' THEN 'frax-eth'
WHEN eth_to_address = '0xae78736cd615f374d3085123a210448e74fc6393' THEN 'Rocket Pool'
WHEN eth_to_address = '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58' THEN 'Rocket Pool'
WHEN eth_to_address = '0xeee27662c2b8eba3cd936a23f039f3189633e4c8' THEN 'Celsius'
WHEN eth_to_address = '0xfa5f9eaa65ffb2a75de092eb7f3fc84fc86b5b18' THEN 'Abyss Finance'
WHEN eth_to_address = '0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd' THEN 'Cream.Finance'
WHEN eth_to_address = '0x430cf6dd3e289adae63b50ff661d6bba2dbb3f28' THEN 'StaFi'
WHEN eth_to_address = '0xd4039ecc40aeda0582036437cf3ec02845da4c13' THEN 'Kraken'
WHEN eth_to_address = '0xa40dfee99e1c85dc97fdc594b16a460717838703' THEN 'Kraken'
WHEN eth_to_address = '0xbe9895146f7af43049ca1c1ae358b0541ea49704' THEN 'Cbeth'
WHEN eth_to_address = '0xbdd75a97c29294ff805fb2fee65abd99492b32a8' THEN 'Binance'
WHEN eth_to_address = '0x50ff765a993400cd62b61cfa4bb33b1ddf694ec7' THEN 'Binance'
WHEN eth_to_address = '0x39dc6a99209b5e6b81dc8540c86ff10981ebda29' THEN 'Staked.us'
WHEN eth_to_address = '0xae78736cd615f374d3085123a210448e74fc6393' THEN 'Rocket Pool'
WHEN eth_to_address = '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58' THEN 'Rocket Pool'
WHEN eth_to_address = '0xeee27662c2b8eba3cd936a23f039f3189633e4c8' THEN 'Celsius'
ELSE 'Others'
END) AS protocol,
count(distinct ETH_FROM_ADDRESS) as depositors,
SUM(amount) AS total_staked_eth
FROM
ethereum.core.ez_eth_transfers
WHERE protocol = {{protocol_name}}
GROUP BY 1
ORDER BY 1
Run a query to Download Data