mlhFlash Bounty: Merge Staking Providers2
    Updated 2022-09-04
    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