Hot-13.Lido Rocket Pool Comparison

    -- Q13. Use the ethereum_core tables to compare deposits to Lido and Rocket Pool -- Hint: -- rETH contract: https://etherscan.io/token/0xae78736cd615f374d3085123a210448e74fc6393 -- Lido sETH contract: https://etherscan.io/txs?a=0xae7ab96520de3a18e5e111b5eaab095312d7fe84

    Methodology

    • Find all deposits to Lido and Rocketpool in the past 60Days
      where contract_address IN (
        LOWER('0xae78736cd615f374d3085123a210448e74fc6393') -- Rocket Pool
        ,LOWER('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84') -- Lido
      )
      and (event_name = 'TokensMinted' or event_name = 'Submitted')
    
    • Parse out the ETH Amount of the deposits.
    • Plot daily total and average deposits

    Daily Total Deposits

    • Lido clearly shadows RocketPool in terms of daily total deposits
    • Highest is 192K ETH for Lido vs 4.6K ETH for RocketPool
    • Till date Lido has had 1.5M ETH deposits vs 42.37K ETH for RocketPool.
    Loading...

    Daily Average Deposits

    • Lido clearly shadows RocketPool in terms of daily average deposits as well.
    • Highest is 530 ETH for Lido vs 44 ETH for RocketPool
    • Till date Lido has a running average of 76 ETH vs 18 ETH for RocketPool.
    Loading...
    Loading...
    Loading...