SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

DROP TABLE IF EXISTS #Data

CREATE TABLE #Data
(
    ORDER_TIME			DATETIME 
	,ORDER_ID			NUMERIC(18,0)
	,PROD_ID			NUMERIC(18,0)
	,ACCOUNT_ID			NUMERIC(18,0)
	,ORDER_QUANTITY		INT
);
 
INSERT INTO #Data
SELECT '2018-06-22 11:00:00.000', 1981516061, 158666, 1601554883,5
UNION ALL SELECT '2018-07-09 10:15:00.000',2008873062,158666,1601554883,3
UNION ALL SELECT '2018-07-09 12:33:00.000',2009269223,158666,1601554883,2
UNION ALL SELECT '2018-07-10 08:29:00.000',2010735394,158666,1601554883,4
UNION ALL SELECT '2018-07-10 10:57:00.000',2010735584,158666,1601554883,7
UNION ALL SELECT '2018-06-27 23:53:00.000',1991467553,158666,2300231016,6
UNION ALL SELECT '2018-06-28 00:44:00.000',1991583913,158666,2300231016,6
UNION ALL SELECT '2018-07-04 04:15:00.000',2001154492,158666,2300231016,4
UNION ALL SELECT '2018-07-04 15:44:00.000',2001154814,158666,2300231016,5
UNION ALL SELECT '2018-07-04 21:30:00.000',2002057915,158666,2300231016,4
UNION ALL SELECT '2018-07-05 02:09:00.000',2002058086,158666,2300231016,4
UNION ALL SELECT '2018-07-05 04:15:00.000',2002058147,158666,2300231016,3
UNION ALL SELECT '2018-07-05 17:23:00.000',2003700706,158666,2300231016,2
UNION ALL SELECT '2018-07-05 18:07:00.000',2003700938,158666,2300231016,1
UNION ALL SELECT '2018-07-06 20:15:00.000',2005719626,158666,2300231016,7
UNION ALL SELECT '2018-07-07 07:45:00.000',2005719879,158666,2300231016,8
UNION ALL SELECT '2018-07-07 12:13:00.000',2005719931,158666,2300231016,9
UNION ALL SELECT '2018-07-09 18:29:00.000',2009395510,158666,2300231016,8
UNION ALL SELECT '2018-07-09 21:05:00.000',2009395523,158666,2300231016,6
UNION ALL SELECT '2018-07-11 21:31:00.000',2011107312,158666,2300231016,5
UNION ALL SELECT '2018-06-27 18:23:00.000',1991016381,258669,2300231016,4
UNION ALL SELECT '2018-06-27 19:07:00.000',1991181365,258669,2300231016,4
UNION ALL SELECT '2018-06-27 19:28:00.000',1991181376,258669,2300231016,3
UNION ALL SELECT '2018-06-28 01:44:00.000',1991583923,258669,2300231016,9
UNION ALL SELECT '2018-06-28 02:19:00.000',1991583943,258669,2300231016,2
UNION ALL SELECT '2018-07-03 10:15:00.000',1999231742,258669,2300231016,1
UNION ALL SELECT '2018-07-03 10:45:00.000',2000293679,258669,2300231016,1
UNION ALL SELECT '2018-07-03 14:22:00.000',2000293804,258669,2300231016,3
UNION ALL SELECT '2018-07-04 19:45:00.000',2002057785,258669,2300231016,2
UNION ALL SELECT '2018-07-04 21:00:00.000',2002057813,258669,2300231016,1
UNION ALL SELECT '2018-07-05 15:12:00.000',2002548332,258669,2300231016,7
UNION ALL SELECT '2018-07-05 17:52:00.000',2003700719,258669,2300231016,6
UNION ALL SELECT '2018-07-09 22:30:00.000',2009395530,258669,2300231016,5
UNION ALL SELECT '2018-07-09 23:23:00.000',2009395666,258669,2300231016,3
UNION ALL SELECT '2018-07-30 17:45:00.000',2043642075,158666,2300231016,2
UNION ALL SELECT '2018-07-30 23:30:00.000',2043642114,158666,2300231016,4

;WITH NextEventLag AS(
--Returns the next event information.
SELECT 
	ORDER_TIME	
	,ORDER_ID
	,PROD_ID	
	,ACCOUNT_ID	
	,RowNum						= ROW_NUMBER() OVER(PARTITION BY ACCOUNT_ID, PROD_ID ORDER BY ORDER_TIME)

--NEXT_ORDER_TIME_LAG: Returns the time difference between two consecutive order times.
	,NEXT_ORDER_TIME_LAG		= DATEDIFF(MINUTE, LAG(ORDER_TIME, 1, ORDER_TIME) OVER(PARTITION BY ACCOUNT_ID, PROD_ID ORDER BY ORDER_TIME), ORDER_TIME)

,ORDER_QUANTITY

FROM #Data
)

,RunningOrders AS(
SELECT 
	RowNum
	,ORDER_TIME
	,ACCOUNT_ID
	,PROD_ID
	,NEXT_ORDER_TIME_LAG
	,LAG_LESS_THAN_24h				= 0
	,ORDER_QUANTITY

FROM NextEventLag

WHERE RowNum = 1

UNION ALL
  
SELECT 
	NextEventLag.RowNum
	,NextEventLag.ORDER_TIME
	,NextEventLag.ACCOUNT_ID
	,NextEventLag.PROD_ID
	,NextEventLag.NEXT_ORDER_TIME_LAG
	
--If the time lag between consecutive events and the time running sum is over 1440 minutes then set the value to 0. 
--Change the NEXT_ORDER_TIME_LAG time interval to the desired interval value in minutes.
    ,LAG_LESS_THAN_24h				= CASE WHEN RunningOrders.LAG_LESS_THAN_24h + NextEventLag.NEXT_ORDER_TIME_LAG >= 1440 THEN 0 
									   ELSE RunningOrders.LAG_LESS_THAN_24h + NextEventLag.NEXT_ORDER_TIME_LAG
									  END
	,NextEventLag.ORDER_QUANTITY

FROM RunningOrders
	INNER JOIN NextEventLag 			ON RunningOrders.RowNum + 1 = NextEventLag.RowNum
										AND RunningOrders.ACCOUNT_ID = NextEventLag.ACCOUNT_ID
										AND RunningOrders.PROD_ID = NextEventLag.PROD_ID
)

,GroupedLags AS(
--This Groups together the LAG(s) less than 1440 minutes and is used by the outer query window functions
--to calculate the running aggregates. 
SELECT RunningOrders.* 
	,Running24h.*

FROM RunningOrders

CROSS APPLY(SELECT TOP 1
					Groups							= COUNT(*) OVER(ORDER BY GroupApply.LAG_LESS_THAN_24h)  --Count admin units within the time window in the WHERE clause

FROM RunningOrders	AS GroupApply

WHERE 
					GroupApply.ACCOUNT_ID = RunningOrders.ACCOUNT_ID
					AND GroupApply.PROD_ID = RunningOrders.PROD_ID
					AND GroupApply.ORDER_TIME <= RunningOrders.ORDER_TIME
							
				--ORDER BY StageBaseApply.ORDER_TIME
				) AS Running24h
)

select 
	GroupedLags.ACCOUNT_ID
	,GroupedLags.PROD_ID
	,GroupedLags.ORDER_TIME
	,GroupedLags.NEXT_ORDER_TIME_LAG
	,GroupedLags.LAG_LESS_THAN_24h
	,RUNNING_COUNT_24h								= ROW_NUMBER() OVER(PARTITION BY GroupedLags.ACCOUNT_ID, GroupedLags.PROD_ID, GroupedLags.Groups ORDER BY GroupedLags.ORDER_TIME)
	,RUNNING_SUM_24h								= SUM(ORDER_QUANTITY) OVER(PARTITION BY GroupedLags.ACCOUNT_ID, GroupedLags.PROD_ID, GroupedLags.Groups ORDER BY GroupedLags.ORDER_TIME) 
	
from GroupedLags

ORDER BY 
	GroupedLags.ACCOUNT_ID
	,GroupedLags.PROD_ID
	,GroupedLags.ORDER_TIME

ACCOUNT_ID	PROD_ID	ORDER_TIME	NEXT_ORDER_TIME_LAG	LAG_LESS_THAN_24h	RUNNING_COUNT_24h	RUNNING_SUM_24h
1601554883	158666	22/06/2018 11:00:00	0	0	1	5
1601554883	158666	09/07/2018 10:15:00	24435	0	1	3
1601554883	158666	09/07/2018 12:33:00	138	138	2	5
1601554883	158666	10/07/2018 08:29:00	1196	1334	3	9
1601554883	158666	10/07/2018 10:57:00	148	0	1	7
2300231016	158666	27/06/2018 23:53:00	0	0	1	6
2300231016	158666	28/06/2018 00:44:00	51	51	2	12
2300231016	158666	04/07/2018 04:15:00	8851	0	1	4
2300231016	158666	04/07/2018 15:44:00	689	689	2	9
2300231016	158666	04/07/2018 21:30:00	346	1035	3	13
2300231016	158666	05/07/2018 02:09:00	279	1314	4	17
2300231016	158666	05/07/2018 04:15:00	126	0	1	3
2300231016	158666	05/07/2018 17:23:00	788	788	2	5
2300231016	158666	05/07/2018 18:07:00	44	832	3	6
2300231016	158666	06/07/2018 20:15:00	1568	0	1	7
2300231016	158666	07/07/2018 07:45:00	690	690	2	15
2300231016	158666	07/07/2018 12:13:00	268	958	3	24
2300231016	158666	09/07/2018 18:29:00	3256	0	1	8
2300231016	158666	09/07/2018 21:05:00	156	156	2	14
2300231016	158666	11/07/2018 21:31:00	2906	0	1	5
2300231016	158666	30/07/2018 17:45:00	27134	0	1	2
2300231016	158666	30/07/2018 23:30:00	345	345	2	6
2300231016	258669	27/06/2018 18:23:00	0	0	1	4
2300231016	258669	27/06/2018 19:07:00	44	44	2	8
2300231016	258669	27/06/2018 19:28:00	21	65	3	11
2300231016	258669	28/06/2018 01:44:00	376	441	4	20
2300231016	258669	28/06/2018 02:19:00	35	476	5	22
2300231016	258669	03/07/2018 10:15:00	7676	0	1	1
2300231016	258669	03/07/2018 10:45:00	30	30	2	2
2300231016	258669	03/07/2018 14:22:00	217	247	3	5
2300231016	258669	04/07/2018 19:45:00	1763	0	1	2
2300231016	258669	04/07/2018 21:00:00	75	75	2	3
2300231016	258669	05/07/2018 15:12:00	1092	1167	3	10
2300231016	258669	05/07/2018 17:52:00	160	1327	4	16
2300231016	258669	09/07/2018 22:30:00	6038	0	1	5
2300231016	258669	09/07/2018 23:23:00	53	53	2	8