Query editor
WITH lock_events AS (SELECTblock_time AS time,(BYTEARRAY_TO_INT256(BYTEARRAY_SUBSTRING(data, 1, 32)) / 1e18) AS net_amount,0 AS withdraw_amountFROM base.logsWHEREcontract_address = 0xc9714f8f036087d801f38c4105194e150d3a1864-- Event Locked (index_topic_1 address user, uint256 amount, uint256 stakedBalance, index_topic_2 uint256 duration)AND topic0 = 0x44cebfefa4561bee5b61d675ccfd8dc9969fff9cc15e7a4eccccd62af94f9c11AND block_time >= CAST('2025-06-10' AS TIMESTAMP)),withdraw_events AS (SELECTblock_time AS time,(BYTEARRAY_TO_INT256(BYTEARRAY_SUBSTRING(data, 1, 32)) / 1e18) * -1 AS net_amount,(BYTEARRAY_TO_INT256(BYTEARRAY_SUBSTRING(data, 1, 32)) / 1e18) AS withdraw_amountFROM base.logsWHEREcontract_address = 0xc9714f8f036087d801f38c4105194e150d3a1864-- Withdrawn (index_topic_1 address user, uint256 amount, uint256 stakedBalance)AND topic0 = 0x92ccf450a286a957af52509bc1c9939d1a6a481783e142e41e2499f0bb66ebc6AND block_time >= CAST('2025-09-01' AS TIMESTAMP)),all_events AS (SELECT * FROM lock_eventsUNION ALLSELECT * FROM withdraw_events),cumulative AS (SELECTtime,net_amount,withdraw_amount,SUM(net_amount) OVER (ORDER BY time ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative,SUM(withdraw_amount) OVER (ORDER BY time ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_withdrawalsFROM all_events)SELECT *FROM cumulativeORDER BY time desc;