pavlyshynTotal ETH deposits
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(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