Query editor
WITH delegates AS (SELECTdate_trunc('day', evt_block_time) as day,newBalance / 1e18 AS newBalance,previousBalance / 1e18 AS previousBalanceFROM cryptex_ethereum.CTX_evt_DelegateVotesChangedWHERE delegate <> 0xa70b638b70154edfcbb8dbbbd04900f328f32c35),aggregated AS (SELECTday,sum(newBalance - previousBalance) as net_delegatedFROM delegatesGROUP BY 1)SELECTday,net_delegated,sum(net_delegated) over (ORDER BY day) as total_delegatedFROM aggregatedORDER BY day DESC