pavlyshynTotal ETH deposits
    Updated 2023-04-21
    select sum(stake) as deposits from (
    select
    Date(block_timestamp) as Date,
    decoded_log:pubkey as pubkey,
    32 as stake,
    'Lido' as source,
    *
    from
    ethereum.core.fact_decoded_event_logs
    where
    CONTRACT_ADDRESS = lower('0x00000000219ab540356cBB839Cbe05303d7705Fa')
    and pubkey in (
    select distinct
    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(block_timestamp) as Date,
    decoded_log:pubkey as pubkey,
    32 as stake,
    'Evertake_pool' as source,
    *
    from
    ethereum.core.fact_decoded_event_logs
    where
    CONTRACT_ADDRESS = lower('0x00000000219ab540356cBB839Cbe05303d7705Fa')
    and pubkey in (
    select distinct
    Run a query to Download Data