Query editor
WITH extracted_data AS (SELECTblock_time,BYTEARRAY_TO_INT256(BYTEARRAY_SUBSTRING(topic2, 1, 32)) AS duration,BYTEARRAY_TO_INT256(BYTEARRAY_SUBSTRING(data, 1, 32)) / POWER(10, 18) AS amountFROM base.logsWHEREcontract_address = 0xc9714f8f036087d801f38c4105194e150d3a1864AND topic0 = 0x44cebfefa4561bee5b61d675ccfd8dc9969fff9cc15e7a4eccccd62af94f9c11 /* Locked */AND block_time >= CURRENT_TIMESTAMP - INTERVAL '30' DAY), aggregated_data AS (SELECTblock_time AS time,SUM(amount) AS locked_amount,duration,CASEWHEN duration = 7776000THEN '3_months'WHEN duration = 15552000THEN '6_months'WHEN duration = 23328000THEN '9_months'WHEN duration = 31104000THEN '12_months'ELSE 'unknown_duration'END AS duration_typeFROM extracted_dataGROUP BY1,duration), cumulative_data AS (SELECTtime,duration_type,locked_amount,SUM(locked_amount) OVER (ORDER BY time ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_stakedFROM aggregated_data)SELECT*FROM cumulative_dataORDER BYtime,duration_type