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