amirrzDistribution of liquid staked Eth2 by provider
Updated 2022-09-17
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
›
⌄
select block_timestamp::date as block_date,
sum(amount) as sum_eth,
-- sum(amount_usd) as sum_usd,
-- count(distinct eth_from_address) as unique_depositors,
case
when eth_to_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84') then 'Lido (stETH)'
when eth_to_address = lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58') then 'Rocket Pool (rETH)'
when eth_to_address = lower('0xC874b064f465bdD6411D45734b56fac750Cda29A') then 'StakeWise (sETH2)'
when eth_to_address = lower('0xDFe66B14D37C77F4E9b180cEb433d1b164f0281D') then 'StakeHound (stakedETH)'
when eth_to_address = lower('0x84db6ee82b7cf3b47e8f19270abde5718b936670') then 'Ankr (aETHc)'
when eth_to_address = lower('0x18691f528659D0Abd08f79498dCc7B6fBdc1e91d') then 'SharedStake (vETH2)'
when eth_to_address = lower('0xB9599ecb958623614F94BcD9b03f9Ab161Eb05D0') then 'pStake (stkETH)'
end as provider,
sum(sum_eth) over(partition by provider order by block_date) as cumul_sum_eth
from
ethereum.core.ez_eth_transfers
where
-- block_timestamp::date >= current_date - 31
-- and
eth_to_address in (
lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84'), -- Lido (stETH)
lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58'), -- Rocket Pool Mainnet Deposit
-- lower('0x178e141a0e3b34152f73ff610437a7bf9b83267a'), -- Rocket Pool (rETH)
lower('0xC874b064f465bdD6411D45734b56fac750Cda29A'), -- StakeWise (Deployer)
-- lower('0xFe2e637202056d30016725477c5da089Ab0A043A'), -- StakeWise (sETH2)
lower('0xDFe66B14D37C77F4E9b180cEb433d1b164f0281D'), -- StakeHound (stakedETH)
lower('0x84db6ee82b7cf3b47e8f19270abde5718b936670'), -- Ankr (Deployer)
-- lower('0xE95A203B1a91a908F9B9CE46459d101078c2c3cb'), -- Ankr (aETHc)
lower('0x18691f528659D0Abd08f79498dCc7B6fBdc1e91d'), -- SharedStake (Deployer)
-- lower('0x898BAD2774EB97cF6b94605677F43b41871410B1'), -- SharedStake (vETH2)
lower('0xB9599ecb958623614F94BcD9b03f9Ab161Eb05D0') -- pStake (stkETH) issuer contract
)
group by block_date,
provider
order by provider, block_date;
Run a query to Download Data