/*
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! */