pavlyshynTotal_WITHDRAWAL
Updated 2023-04-21
99
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
›
⌄
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