Query editor
-- h/t https://dune.com/LidoAnalytical-- Original query: https://dune.com/queries/96263-- added Tranchess, Liquid Collective, EtherFiselect time,sum(lido) over (order by time asc rows between unbounded preceding and current row) as "Lido",sum(ankr) over (order by time asc rows between unbounded preceding and current row) as "Ankr",sum(sharedstake) over (order by time asc rows between unbounded preceding and current row) as "SharedStake",sum(creth2) over (order by time asc rows between unbounded preceding and current row) as "Creth2",sum(stakehound) over (order by time asc rows between unbounded preceding and current row) as "StakeHound",sum(stakewise) over (order by time asc rows between unbounded preceding and current row) as "Stakewise",sum(stafi) over (order by time asc rows between unbounded preceding and current row) as "StaFi",sum(rocketpool) over (order by time asc rows between unbounded preceding and current row) as "Rocketpool",sum(pstake) over (order by time asc rows between unbounded preceding and current row) as "pStake",sum(harbour) over (order by time asc rows between unbounded preceding and current row) as "Harbour",sum(coinbase) over (order by time asc rows between unbounded preceding and current row) as "Coinbase",sum(swell) over (order by time asc rows between unbounded preceding and current row) as "Swell",sum(frax) over (order by time asc rows between unbounded preceding and current row) as "Frax",sum(tranchess) over (order by time asc rows between unbounded preceding and current row) as "Tranchess",sum(liquidcollective) over (order by time asc rows between unbounded preceding and current row) as "Liquid Collective",sum(etherfi) over (order by time asc rows between unbounded preceding and current row) as "EtherFi"from (selectCOALESCE(lido_amounts.time, ankr_amounts.time, sharedstake_amounts.time, creth2_amounts.time, stakehound_amounts.time, stafi_amounts.time, rocketpool_amounts.time, tranchess_amounts.time, liquidcollective_amounts.time, etherfi_amounts.time) as time,COALESCE(lido_deposited, 0) as lido,COALESCE(ankr_deposited, 0) as ankr,COALESCE(sharedstake_deposited, 0) as sharedstake,COALESCE(creth2_deposited, 0) as creth2,COALESCE(stakehound_deposited, 0) as stakehound,COALESCE(stakewise_deposited, 0) as stakewise,COALESCE(stafi_deposited, 0) as stafi,COALESCE(rocketpool_deposited, 0) as rocketpool,COALESCE(pstake_deposited, 0) as pstake,COALESCE(harbour_deposited, 0) as harbour,COALESCE(coinbase_deposited, 0) as coinbase,COALESCE(swell_deposited, 0) as swell,COALESCE(frax_deposited, 0) as frax,COALESCE(tranchess_deposited, 0) as tranchess,COALESCE(liquidcollective_deposited, 0) as liquidcollective,COALESCE(etherfi_deposited, 0) as etherfifrom(SELECTdate_trunc('day', evt_block_time) as time,SUM(amount)/1e18 as lido_depositedFROM lido."steth_evt_Submitted"GROUP BY 1) lido_amountsFULL JOIN(SELECTtime,sum(value)/1e18 as ankr_depositedFROM(selectdate_trunc('day', evt_block_time) as time,(value) as valuefrom erc20."ERC20_evt_Transfer"where contract_address = '\xE95A203B1a91a908F9B9CE46459d101078c2c3cb'and "from" = '\x0000000000000000000000000000000000000000'UNION ALLselect