Query editor
select 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 harbourfrom (selectCOALESCE(lido_amounts.time, ankr_amounts.time, sharedstake_amounts.time, creth2_amounts.time, stakehound_amounts.time, stafi_amounts.time, rocketpool_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 harbourfrom(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 ALLselectdate_trunc('day', evt_block_time) as time,-(value) as valuefrom erc20."ERC20_evt_Transfer"where contract_address = '\xE95A203B1a91a908F9B9CE46459d101078c2c3cb'and "to" = '\x0000000000000000000000000000000000000000') ank_transGROUP BY 1) ankr_amountson lido_amounts.time = ankr_amounts.timeFULL JOIN(SELECTtime,sum(amount/1e18) as sharedstake_depositedFROM(SELECTdate_trunc('day', evt_block_time) as time,