mlhFlash Bounty: Merge Staking Providers2
Updated 2022-09-04
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select 'Rocket Pool' as platform,
sum(eth_value) as total_ETH_staked,
count(distinct from_address) as total_unique_depositors,
avg(eth_value) as avg_distribution_of_ETH_deposits,
median(eth_value) as median_of_ETH_deposits,
max(eth_value) as max_of_ETH_deposits,
min(eth_value) as min_of_ETH_deposits
from ethereum.core.fact_transactions
inner join ethereum_core.fact_event_logs on ethereum.core.fact_transactions.tx_hash=ethereum_core.fact_event_logs.tx_hash
where contract_address in (lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58'))
and eth_value>0
group by 1
Run a query to Download Data