RayyykETH staking on Liquid Platforms 1
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
28
29
30
31
32
33
34
35
36
›
⌄
with table_1 as (select 'Direct Staking',
count(distinct(origin_from_address)) as wallet_count,
count(distinct(tx_hash)) as tx_count,
sum(amount) as eth_staked,
avg(amount) as avg_eth_stake,
min(amount) as min_eth_stake,
max(amount) as max_eth_stake,
median(amount) as median_eth_stake
from ethereum.core.ez_eth_transfers
where eth_to_address ilike '0x00000000219ab540356cBB839Cbe05303d7705Fa' --Direct staking
union
select 'Lido',
count(distinct(origin_from_address)),
count(distinct(tx_hash)),
sum(amount),
avg(amount),
min(amount),
max(amount),
median(amount)
from ethereum.core.ez_eth_transfers
where eth_to_address ilike '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' --lido
union
select 'Rocket Pool',
count(distinct(origin_from_address)),
count(distinct(tx_hash)),
sum(amount),
avg(amount),
min(amount),
max(amount),
median(amount)
from ethereum.core.ez_eth_transfers
where eth_to_address ilike '0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58' --Rocket_pool
union
select 'Cream',
count(distinct(origin_from_address)),
count(distinct(tx_hash)),
Run a query to Download Data