farid-c9j0VMstaking platform 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
›
⌄
select date_trunc('week', block_timestamp) as week,
CASE WHEN contract_address = lower('0xae78736Cd615f374D3085123A210448E74Fc6393') THEN 'Rocket Pool'
WHEN contract_address = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84') THEN 'Lido'
WHEN contract_address = lower('0xFe2e637202056d30016725477c5da089Ab0A043A') THEN 'Stakewise'
WHEN contract_address = lower('0xE95A203B1a91a908F9B9CE46459d101078c2c3cb') THEN 'Ankr'
end as platform,
COUNT (DISTINCT to_address) as "Total Number of Unique Staker",
sum(raw_amount)/pow(10,18) as "Total Amount of ETH Staked",
("Total Amount of ETH Staked"/"Total Number of Unique Staker") as "Average Amount of ETH Staked per Staker",
avg((raw_amount)/pow(10,18)) as "Avg ETH stake volume",
min((raw_amount)/pow(10,18)) as "Min ETH stake volume",
max((raw_amount)/pow(10,18)) as "Max ETH stake volume",
median((raw_amount)/pow(10,18)) as "Median ETH stake volume"
from ethereum_core.fact_token_transfers
where from_address = '0x0000000000000000000000000000000000000000'
and raw_amount > 0
and platform is not null
and block_timestamp >= '2022-01-01'
group by week,platform
Run a query to Download Data