PS0G1How much ETH was staked over time?
Updated 2022-09-05
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
›
⌄
-- inspired han.ghasemi
With txns As (
Select
CASE eth_to_address
When '0xc874b064f465bdd6411d45734b56fac750cda29a' Then 'Stakewise'
When '0x84db6ee82b7cf3b47e8f19270abde5718b936670' Then 'Stkr'
When '0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd' Then 'Cream'
When '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58' Then 'Rocket_pool'
When '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' Then 'Lido'
When '0x00000000219ab540356cbb839cbe05303d7705fa' Then 'Direct staking'
END As type,
*
From ethereum.core.ez_eth_transfers
Where 1=1
And block_timestamp >= '2022-01-01'
And eth_to_address In
(
'0xc874b064f465bdd6411d45734b56fac750cda29a',
'0x84db6ee82b7cf3b47e8f19270abde5718b936670',
'0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd',
'0x4d05e3d48a938db4b7a9a59a802d5b45011bde58',
'0xae7ab96520de3a18e5e111b5eaab095312d7fe84',
'0x00000000219ab540356cbb839cbe05303d7705fa'
)
And identifier = 'CALL_ORIGIN'
)
Select
block_timestamp::date As date,
type,
Count(Distinct eth_from_address) As New_wallets,
sum(amount) as Eth_deposited,
sum(amount_usd) as Eth_deposited_usd,
avg(amount) as Avg_Eth_deposited,
avg(amount_usd) as Avg_Eth_deposited_usd,
Run a query to Download Data