kidaETH Withdraw Validator Stats
Updated 2023-04-18
999
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
validators as (
select distinct
index,
-- withdrawal_credentials,
pubkey
from ethereum.beacon_chain.fact_validators
),
withdrawals as (
select
-- withdrawal_address as address,
-- withdrawal_credentials as withdrawal_credentials,
pubkey,
sum(withdrawal_amount) as total_withdrawn
from ethereum.beacon_chain.fact_withdrawals w
left join validators v
on w.validator_index = v.index
group by 1
),
deposits as (
select
-- origin_from_address as address,
-- event_inputs:withdrawal_credentials as withdrawal_credentials,
event_inputs:pubkey as pubkey,
sum(
case event_inputs:amount
when '0x005ed0b200000000' then 3
when '0x007841cb02000000' then 24
when '0x0018ee8406000000' then 28
when '0x00286bee00000000' then 4
when '0x006a47f503000000' then 17
when '0x00a0acb903000000' then 16
when '0x00e40b5402000000' then 10
when '0x0040597307000000' then 32
Run a query to Download Data