piperLido - ETH Staked: Lido staked ETH - All Time / Cumulative - Last 3 Month
    Updated 2022-06-13
    /*
    Twitter: @der_piper
    Discrod: piper#6707

    Lido - ETH Staked

    Q9. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
    */

    SELECT
    block_timestamp::date as date,
    SUM(amount) AS total_eth_staked,
    SUM(total_eth_staked) OVER (ORDER BY date) as cumulative_staked_eth
    FROM
    ethereum.core.ez_eth_transfers
    WHERE
    --origin_to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    eth_to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    AND
    block_timestamp BETWEEN '2022-04-12' AND '2022-06-13'
    GROUP BY date
    ORDER BY date

    /* The End! */
    Run a query to Download Data