Query editor
-- h/t https://dune.com/eliasimos-- Original Query: https://dune.com/queries/46128/90778-- Added Liquid Collective, Harbour, pstake, Swell, Frax, Tranchess, Etherfi / Rocketpool section fixed-- Added 7 and 30-day changeswith lido as (select week, 'Lido' as pool, sum (ETH_staked) over (order by week) as ETH_stakedfrom (select date_trunc('week', evt_block_time) as week, sum(value/1e18) as ETH_stakedfrom erc20."ERC20_evt_Transfer"where contract_address = '\xae7ab96520DE3A18E5e111B5EaAb095312D7fE84'and "from" = '\x0000000000000000000000000000000000000000'group by 1union allselect date_trunc('week', evt_block_time) as week, -sum(value/1e18) as ETH_stakedfrom erc20."ERC20_evt_Transfer"where contract_address = '\xae7ab96520DE3A18E5e111B5EaAb095312D7fE84'and "to" = '\x0000000000000000000000000000000000000000'group by 1order by 1) z),frax as (select week, 'Frax' as pool, sum (ETH_staked) over (order by week) as ETH_stakedfrom (select date_trunc('week', evt_block_time) as week, sum(value/1e18) as ETH_stakedfrom erc20."ERC20_evt_Transfer"where contract_address = '\x5E8422345238F34275888049021821E8E08CAa1f'and "from" = '\x0000000000000000000000000000000000000000'group by 1union allselect date_trunc('week', evt_block_time) as week, -sum(value/1e18) as ETH_stakedfrom erc20."ERC20_evt_Transfer"where contract_address = '\x5E8422345238F34275888049021821E8E08CAa1f'and "to" = '\x0000000000000000000000000000000000000000'group by 1order by 1) z),etherfi as (select week, 'EtherFi' as pool, sum (ETH_staked) over (order by week) as ETH_stakedfrom (select date_trunc('week', block_time) as week, sum(value)/1e18 as ETH_stakedfrom ethereum."traces" ewhere e.to = '\x7623e9DC0DA6FF821ddb9EbABA794054E078f8c4'group by 1order by 1) z),ankr as (select week, 'Ankr' as pool, sum (ETH_staked) over (order by week) as ETH_stakedfrom (select date_trunc('week', evt_block_time) as week, sum(value/1e18) as ETH_stakedfrom erc20."ERC20_evt_Transfer"where contract_address = '\xE95A203B1a91a908F9B9CE46459d101078c2c3cb'and "from" = '\x0000000000000000000000000000000000000000'group by 1