tongzzezDistribution Stakewise
Updated 2022-09-04
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
›
⌄
select
round(amount,7) as ETH_deposited_per_Tx,
count(tx_hash) as tx_cnt,
sum(tx_cnt) over() as max_tx,
sum(tx_cnt) over(order by ETH_deposited_per_Tx)/max_tx*100 as Cumulative_Tx_Count,
sum(ETH_deposited_per_Tx) as sum,
sum(sum) over() as max_sum,
sum(sum) over(order by ETH_deposited_per_Tx)/max_sum*100 as Cumulative_ETH
from
ethereum.core.ez_eth_transfers
where
eth_to_address = '0xc874b064f465bdd6411d45734b56fac750cda29a' --Stakewise
-- eth_to_address = '0x84db6ee82b7cf3b47e8f19270abde5718b936670' --stkr
-- eth_to_address = '0x00000000219ab540356cbb839cbe05303d7705fa' --Cream
-- eth_to_address = '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58' --Rocket_pool
-- eth_to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' --Lido
-- eth_to_address = '0x00000000219ab540356cbb839cbe05303d7705fa' --Direct staking
-- and not eth_from_address in ('0xc874b064f465bdd6411d45734b56fac750cda29a', '0x84db6ee82b7cf3b47e8f19270abde5718b936670', '0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd', '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58', '0xae7ab96520de3a18e5e111b5eaab095312d7fe84', '0x00000000219ab540356cbb839cbe05303d7705fa')
and ETH_deposited_per_Tx >= pow(10,-2)
group by ETH_deposited_per_Tx
order by ETH_deposited_per_Tx
Run a query to Download Data