Query editor
WITH lock_event_logs AS (SELECTblock_time,'lock_event' as event_type,BYTEARRAY_TO_INT256(BYTEARRAY_SUBSTRING(data, 1, 32)) / 1e18 AS locked_amount,BYTEARRAY_TO_INT256(BYTEARRAY_SUBSTRING(topic2, 1, 32)) AS durationFROM base.logsWHEREcontract_address = 0xc9714f8f036087d801f38c4105194e150d3a1864AND topic0 = 0x44cebfefa4561bee5b61d675ccfd8dc9969fff9cc15e7a4eccccd62af94f9c11AND block_time >= CAST('2025-06-10' AS TIMESTAMP))SELECT(le.block_time + le.duration * INTERVAL '1' second) AS unlock_time,le.locked_amount AS unlock_amount,SUM(le.locked_amount) OVER (ORDER BY (le.block_time + le.duration * INTERVAL '1' second)ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS potential_unlock_cumulativeFROM lock_event_logs AS leORDER BYunlock_time