pavlyshynTotal_WITHDRAWAL
    Updated 2023-04-21
    select sum(WITHDRAWAL_AMOUNT) as Total_WITHDRAWAL from (

    select
    Date(SLOT_TIMESTAMP) as Date,
    'Lido' as source,
    *
    from
    ethereum.beacon_chain.fact_withdrawals
    where
    validator_index in (
    select distinct
    index
    from
    ethereum.beacon_chain.fact_validators
    where
    pubkey in (
    select
    decoded_log:pubkey as pubkey
    from
    ethereum.core.ez_decoded_event_logs
    where
    origin_to_address = lower('0x55032650b14df07b85bf18a3a3ec8e0af2e028d5')
    and origin_from_address = lower('0x3d5a107f7a5bcec8734c49ed54d41bc6f93eb97f')
    and event_name = 'SigningKeyAdded'
    )
    )


    Union all

    select
    Date(SLOT_TIMESTAMP) as Date,
    'Everstake_pool' as source,
    *
    from
    ethereum.beacon_chain.fact_withdrawals
    Run a query to Download Data