kidaETH Withdraw Validator Stats
    Updated 2023-04-18
    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