MySQL 8.0

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

select version();


version()


8.0.22


CREATE TABLE IT201120 (
  id int PRIMARY KEY AUTO_INCREMENT,
  gts timestamp,
  val int NOT NULL
)
SET @@cte_max_recursion_depth  = 100000;
SET @today = CURDATE() + interval 0 second;

-- 隨機產生10萬筆時間與數值資料
INSERT INTO IT201120 (gts, val)
WITH RECURSIVE GenerateRandomTime AS (
  SELECT @today AS DateTimeField, 1 AS RowNum
  UNION ALL
  SELECT @today + interval ceil(RAND() * 86400) second AS DateTimeField, RowNum + 1
  FROM GenerateRandomTime
  WHERE RowNum < 1e5
)
SELECT DateTimeField, (RAND() * 1e6)
FROM GenerateRandomTime;
-- 最大時間與最小時間
SELECT MIN(gts), 
       MAX(gts)
FROM IT201120


MIN(gts)
MAX(gts)


2020-11-22 00:00:00
2020-11-23 00:00:00


-- 依照資料筆數分成100組
-- 取當組別的開始與結束時間(gts)，以及該組別的最大與最小值(val)
SET @rowPerGroup = (SELECT COUNT(*) / 100 FROM IT201120);

SELECT groupIndex, MIN(gts), MAX(gts), MIN(val), MAX(val)
FROM (
      SELECT ceil(ROW_NUMBER() OVER (ORDER BY gts) / @rowPerGroup ) AS groupIndex, gts, val
      FROM IT201120
) AS GroupResult
GROUP BY groupIndex


groupIndex
MIN(gts)
MAX(gts)
MIN(val)
MAX(val)


1
2020-11-22 00:00:00
2020-11-22 00:14:14
283
998372

2
2020-11-22 00:14:14
2020-11-22 00:28:44
1987
996826

3
2020-11-22 00:28:44
2020-11-22 00:43:35
2051
999708

4
2020-11-22 00:43:37
2020-11-22 00:58:36
2671
999791

5
2020-11-22 00:58:37
2020-11-22 01:12:56
371
997875

6
2020-11-22 01:12:58
2020-11-22 01:27:52
464
999996

7
2020-11-22 01:27:52
2020-11-22 01:41:48
1005
999737

8
2020-11-22 01:41:50
2020-11-22 01:55:56
661
998556

9
2020-11-22 01:55:58
2020-11-22 02:10:15
2
999396

10
2020-11-22 02:10:15
2020-11-22 02:25:07
584
998470

11
2020-11-22 02:25:08
2020-11-22 02:38:53
204
999957

12
2020-11-22 02:38:53
2020-11-22 02:53:37
191
999375

13
2020-11-22 02:53:38
2020-11-22 03:07:18
422
999540

14
2020-11-22 03:07:19
2020-11-22 03:22:17
889
997725

15
2020-11-22 03:22:17
2020-11-22 03:36:27
79
998303

16
2020-11-22 03:36:27
2020-11-22 03:52:01
206
999857

17
2020-11-22 03:52:02
2020-11-22 04:06:55
34
998582

18
2020-11-22 04:06:56
2020-11-22 04:21:20
1208
999521

19
2020-11-22 04:21:20
2020-11-22 04:35:46
453
999485

20
2020-11-22 04:35:47
2020-11-22 04:50:13
97
999962

21
2020-11-22 04:50:13
2020-11-22 05:05:15
5624
999994

22
2020-11-22 05:05:16
2020-11-22 05:19:47
2520
999553

23
2020-11-22 05:19:47
2020-11-22 05:33:52
93
999404

24
2020-11-22 05:33:53
2020-11-22 05:48:06
929
999006

25
2020-11-22 05:48:06
2020-11-22 06:02:42
5365
999711

26
2020-11-22 06:02:42
2020-11-22 06:16:19
85
999959

27
2020-11-22 06:16:19
2020-11-22 06:30:23
468
998992

28
2020-11-22 06:30:24
2020-11-22 06:44:05
252
999327

29
2020-11-22 06:44:05
2020-11-22 06:59:40
2755
996335

30
2020-11-22 06:59:42
2020-11-22 07:13:16
2090
998396

31
2020-11-22 07:13:16
2020-11-22 07:27:58
919
999746

32
2020-11-22 07:27:58
2020-11-22 07:42:24
72
999771

33
2020-11-22 07:42:24
2020-11-22 07:56:39
2324
997784

34
2020-11-22 07:56:40
2020-11-22 08:10:38
348
999988

35
2020-11-22 08:10:38
2020-11-22 08:24:21
584
999222

36
2020-11-22 08:24:22
2020-11-22 08:38:53
679
998496

37
2020-11-22 08:38:53
2020-11-22 08:53:10
906
999544

38
2020-11-22 08:53:13
2020-11-22 09:07:23
1613
997472

39
2020-11-22 09:07:24
2020-11-22 09:22:32
850
999868

40
2020-11-22 09:22:34
2020-11-22 09:37:25
2319
996022

41
2020-11-22 09:37:26
2020-11-22 09:51:57
511
999511

42
2020-11-22 09:51:58
2020-11-22 10:06:45
177
999596

43
2020-11-22 10:06:45
2020-11-22 10:21:52
234
999036

44
2020-11-22 10:21:53
2020-11-22 10:36:56
1126
999627

45
2020-11-22 10:36:57
2020-11-22 10:51:27
78
998802

46
2020-11-22 10:51:30
2020-11-22 11:06:20
723
999156

47
2020-11-22 11:06:20
2020-11-22 11:21:10
154
998390

48
2020-11-22 11:21:11
2020-11-22 11:35:45
441
999555

49
2020-11-22 11:35:46
2020-11-22 11:50:09
207
999729

50
2020-11-22 11:50:09
2020-11-22 12:03:30
1314
998337

51
2020-11-22 12:03:30
2020-11-22 12:17:31
511
999349

52
2020-11-22 12:17:32
2020-11-22 12:32:00
761
999021

53
2020-11-22 12:32:01
2020-11-22 12:46:37
154
999894

54
2020-11-22 12:46:37
2020-11-22 13:00:58
854
997258

55
2020-11-22 13:00:58
2020-11-22 13:14:41
1246
998203

56
2020-11-22 13:14:41
2020-11-22 13:28:51
23
999143

57
2020-11-22 13:28:51
2020-11-22 13:43:45
3514
999393

58
2020-11-22 13:43:45
2020-11-22 13:57:43
421
998989

59
2020-11-22 13:57:43
2020-11-22 14:12:38
399
999506

60
2020-11-22 14:12:39
2020-11-22 14:27:02
210
997279

61
2020-11-22 14:27:03
2020-11-22 14:40:39
3488
999662

62
2020-11-22 14:40:40
2020-11-22 14:54:44
2137
999846

63
2020-11-22 14:54:45
2020-11-22 15:08:41
924
999801

64
2020-11-22 15:08:42
2020-11-22 15:22:59
526
999528

65
2020-11-22 15:23:01
2020-11-22 15:38:04
1252
999276

66
2020-11-22 15:38:05
2020-11-22 15:52:32
58
999785

67
2020-11-22 15:52:32
2020-11-22 16:07:21
5939
999623

68
2020-11-22 16:07:21
2020-11-22 16:21:43
691
999329

69
2020-11-22 16:21:45
2020-11-22 16:36:07
1723
999963

70
2020-11-22 16:36:07
2020-11-22 16:50:10
708
999557

71
2020-11-22 16:50:12
2020-11-22 17:05:22
924
998549

72
2020-11-22 17:05:22
2020-11-22 17:19:13
800
999161

73
2020-11-22 17:19:17
2020-11-22 17:32:37
1428
999168

74
2020-11-22 17:32:37
2020-11-22 17:46:52
732
998559

75
2020-11-22 17:46:53
2020-11-22 18:01:03
2170
998681

76
2020-11-22 18:01:04
2020-11-22 18:15:25
419
999816

77
2020-11-22 18:15:27
2020-11-22 18:29:56
959
998796

78
2020-11-22 18:29:57
2020-11-22 18:43:51
649
999813

79
2020-11-22 18:43:52
2020-11-22 18:58:20
1389
999516

80
2020-11-22 18:58:23
2020-11-22 19:13:22
758
999423

81
2020-11-22 19:13:24
2020-11-22 19:27:07
1899
999926

82
2020-11-22 19:27:07
2020-11-22 19:40:58
4327
997560

83
2020-11-22 19:41:02
2020-11-22 19:55:05
527
999539

84
2020-11-22 19:55:06
2020-11-22 20:09:23
242
999648

85
2020-11-22 20:09:23
2020-11-22 20:23:50
1486
999503

86
2020-11-22 20:23:50
2020-11-22 20:38:26
221
999463

87
2020-11-22 20:38:27
2020-11-22 20:52:38
562
999721

88
2020-11-22 20:52:39
2020-11-22 21:06:17
598
999459

89
2020-11-22 21:06:19
2020-11-22 21:20:56
1535
999795

90
2020-11-22 21:20:57
2020-11-22 21:35:02
631
999640

91
2020-11-22 21:35:03
2020-11-22 21:49:04
1357
998188

92
2020-11-22 21:49:04
2020-11-22 22:02:45
1311
999729

93
2020-11-22 22:02:46
2020-11-22 22:17:17
26
998170

94
2020-11-22 22:17:19
2020-11-22 22:32:10
2329
999896

95
2020-11-22 22:32:11
2020-11-22 22:46:46
1224
998903

96
2020-11-22 22:46:47
2020-11-22 23:01:00
2008
999468

97
2020-11-22 23:01:01
2020-11-22 23:15:32
2934
999798

98
2020-11-22 23:15:32
2020-11-22 23:30:20
3347
999681

99
2020-11-22 23:30:22
2020-11-22 23:45:28
1024
999977

100
2020-11-22 23:45:30
2020-11-23 00:00:00
516
999201


WITH groupResult AS(
  SELECT NTILE(100) OVER (ORDER BY gts) AS groupIndex, gts, val
  FROM IT201120
)

SELECT groupIndex, MIN(gts), MAX(gts), MIN(val), MAX(val)
FROM groupResult
GROUP BY groupIndex;


groupIndex
MIN(gts)
MAX(gts)
MIN(val)
MAX(val)


1
2020-11-22 00:00:00
2020-11-22 00:14:14
283
998372

2
2020-11-22 00:14:14
2020-11-22 00:28:44
1987
996826

3
2020-11-22 00:28:44
2020-11-22 00:43:35
2051
999708

4
2020-11-22 00:43:37
2020-11-22 00:58:36
2671
999791

5
2020-11-22 00:58:37
2020-11-22 01:12:56
371
997875

6
2020-11-22 01:12:58
2020-11-22 01:27:52
464
999996

7
2020-11-22 01:27:52
2020-11-22 01:41:48
1005
999737

8
2020-11-22 01:41:50
2020-11-22 01:55:56
661
998556

9
2020-11-22 01:55:58
2020-11-22 02:10:15
2
999396

10
2020-11-22 02:10:15
2020-11-22 02:25:07
584
998470

11
2020-11-22 02:25:08
2020-11-22 02:38:53
204
999957

12
2020-11-22 02:38:53
2020-11-22 02:53:37
191
999375

13
2020-11-22 02:53:38
2020-11-22 03:07:18
422
999540

14
2020-11-22 03:07:19
2020-11-22 03:22:17
889
997725

15
2020-11-22 03:22:17
2020-11-22 03:36:27
79
998303

16
2020-11-22 03:36:27
2020-11-22 03:52:01
206
999857

17
2020-11-22 03:52:02
2020-11-22 04:06:55
34
998582

18
2020-11-22 04:06:56
2020-11-22 04:21:20
1208
999521

19
2020-11-22 04:21:20
2020-11-22 04:35:46
453
999485

20
2020-11-22 04:35:47
2020-11-22 04:50:13
97
999962

21
2020-11-22 04:50:13
2020-11-22 05:05:15
5624
999994

22
2020-11-22 05:05:16
2020-11-22 05:19:47
2520
999553

23
2020-11-22 05:19:47
2020-11-22 05:33:52
93
999404

24
2020-11-22 05:33:53
2020-11-22 05:48:06
929
999006

25
2020-11-22 05:48:06
2020-11-22 06:02:42
5365
999711

26
2020-11-22 06:02:42
2020-11-22 06:16:19
85
999959

27
2020-11-22 06:16:19
2020-11-22 06:30:23
468
998992

28
2020-11-22 06:30:24
2020-11-22 06:44:05
252
999327

29
2020-11-22 06:44:05
2020-11-22 06:59:40
2755
996335

30
2020-11-22 06:59:42
2020-11-22 07:13:16
2090
998396

31
2020-11-22 07:13:16
2020-11-22 07:27:58
919
999746

32
2020-11-22 07:27:58
2020-11-22 07:42:24
72
999771

33
2020-11-22 07:42:24
2020-11-22 07:56:39
2324
997784

34
2020-11-22 07:56:40
2020-11-22 08:10:38
348
999988

35
2020-11-22 08:10:38
2020-11-22 08:24:21
584
999222

36
2020-11-22 08:24:22
2020-11-22 08:38:53
679
998496

37
2020-11-22 08:38:53
2020-11-22 08:53:10
906
999544

38
2020-11-22 08:53:13
2020-11-22 09:07:23
1613
997472

39
2020-11-22 09:07:24
2020-11-22 09:22:32
850
999868

40
2020-11-22 09:22:34
2020-11-22 09:37:25
2319
996022

41
2020-11-22 09:37:26
2020-11-22 09:51:57
511
999511

42
2020-11-22 09:51:58
2020-11-22 10:06:45
177
999596

43
2020-11-22 10:06:45
2020-11-22 10:21:52
234
999036

44
2020-11-22 10:21:53
2020-11-22 10:36:56
1126
999627

45
2020-11-22 10:36:57
2020-11-22 10:51:27
78
998802

46
2020-11-22 10:51:30
2020-11-22 11:06:20
723
999156

47
2020-11-22 11:06:20
2020-11-22 11:21:10
154
998390

48
2020-11-22 11:21:11
2020-11-22 11:35:45
441
999555

49
2020-11-22 11:35:46
2020-11-22 11:50:09
207
999729

50
2020-11-22 11:50:09
2020-11-22 12:03:30
1314
998337

51
2020-11-22 12:03:30
2020-11-22 12:17:31
511
999349

52
2020-11-22 12:17:32
2020-11-22 12:32:00
761
999021

53
2020-11-22 12:32:01
2020-11-22 12:46:37
154
999894

54
2020-11-22 12:46:37
2020-11-22 13:00:58
854
997258

55
2020-11-22 13:00:58
2020-11-22 13:14:41
1246
998203

56
2020-11-22 13:14:41
2020-11-22 13:28:51
23
999143

57
2020-11-22 13:28:51
2020-11-22 13:43:45
3514
999393

58
2020-11-22 13:43:45
2020-11-22 13:57:43
421
998989

59
2020-11-22 13:57:43
2020-11-22 14:12:38
399
999506

60
2020-11-22 14:12:39
2020-11-22 14:27:02
210
997279

61
2020-11-22 14:27:03
2020-11-22 14:40:39
3488
999662

62
2020-11-22 14:40:40
2020-11-22 14:54:44
2137
999846

63
2020-11-22 14:54:45
2020-11-22 15:08:41
924
999801

64
2020-11-22 15:08:42
2020-11-22 15:22:59
526
999528

65
2020-11-22 15:23:01
2020-11-22 15:38:04
1252
999276

66
2020-11-22 15:38:05
2020-11-22 15:52:32
58
999785

67
2020-11-22 15:52:32
2020-11-22 16:07:21
5939
999623

68
2020-11-22 16:07:21
2020-11-22 16:21:43
691
999329

69
2020-11-22 16:21:45
2020-11-22 16:36:07
1723
999963

70
2020-11-22 16:36:07
2020-11-22 16:50:10
708
999557

71
2020-11-22 16:50:12
2020-11-22 17:05:22
924
998549

72
2020-11-22 17:05:22
2020-11-22 17:19:13
800
999161

73
2020-11-22 17:19:17
2020-11-22 17:32:37
1428
999168

74
2020-11-22 17:32:37
2020-11-22 17:46:52
732
998559

75
2020-11-22 17:46:53
2020-11-22 18:01:03
2170
998681

76
2020-11-22 18:01:04
2020-11-22 18:15:25
419
999816

77
2020-11-22 18:15:27
2020-11-22 18:29:56
959
998796

78
2020-11-22 18:29:57
2020-11-22 18:43:51
649
999813

79
2020-11-22 18:43:52
2020-11-22 18:58:20
1389
999516

80
2020-11-22 18:58:23
2020-11-22 19:13:22
758
999423

81
2020-11-22 19:13:24
2020-11-22 19:27:07
1899
999926

82
2020-11-22 19:27:07
2020-11-22 19:40:58
4327
997560

83
2020-11-22 19:41:02
2020-11-22 19:55:05
527
999539

84
2020-11-22 19:55:06
2020-11-22 20:09:23
242
999648

85
2020-11-22 20:09:23
2020-11-22 20:23:50
1486
999503

86
2020-11-22 20:23:50
2020-11-22 20:38:26
221
999463

87
2020-11-22 20:38:27
2020-11-22 20:52:38
562
999721

88
2020-11-22 20:52:39
2020-11-22 21:06:17
598
999459

89
2020-11-22 21:06:19
2020-11-22 21:20:56
1535
999795

90
2020-11-22 21:20:57
2020-11-22 21:35:02
631
999640

91
2020-11-22 21:35:03
2020-11-22 21:49:04
1357
998188

92
2020-11-22 21:49:04
2020-11-22 22:02:45
1311
999729

93
2020-11-22 22:02:46
2020-11-22 22:17:17
26
998170

94
2020-11-22 22:17:19
2020-11-22 22:32:10
2329
999896

95
2020-11-22 22:32:11
2020-11-22 22:46:46
1224
998903

96
2020-11-22 22:46:47
2020-11-22 23:01:00
2008
999468

97
2020-11-22 23:01:01
2020-11-22 23:15:32
2934
999798

98
2020-11-22 23:15:32
2020-11-22 23:30:20
3347
999681

99
2020-11-22 23:30:22
2020-11-22 23:45:28
1024
999977

100
2020-11-22 23:45:30
2020-11-23 00:00:00
516
999201

groupIndex	MIN(gts)	MAX(gts)	MIN(val)	MAX(val)
1	2020-11-22 00:00:00	2020-11-22 00:14:14	283	998372
2	2020-11-22 00:14:14	2020-11-22 00:28:44	1987	996826
3	2020-11-22 00:28:44	2020-11-22 00:43:35	2051	999708
4	2020-11-22 00:43:37	2020-11-22 00:58:36	2671	999791
5	2020-11-22 00:58:37	2020-11-22 01:12:56	371	997875
6	2020-11-22 01:12:58	2020-11-22 01:27:52	464	999996
7	2020-11-22 01:27:52	2020-11-22 01:41:48	1005	999737
8	2020-11-22 01:41:50	2020-11-22 01:55:56	661	998556
9	2020-11-22 01:55:58	2020-11-22 02:10:15	2	999396
10	2020-11-22 02:10:15	2020-11-22 02:25:07	584	998470
11	2020-11-22 02:25:08	2020-11-22 02:38:53	204	999957
12	2020-11-22 02:38:53	2020-11-22 02:53:37	191	999375
13	2020-11-22 02:53:38	2020-11-22 03:07:18	422	999540
14	2020-11-22 03:07:19	2020-11-22 03:22:17	889	997725
15	2020-11-22 03:22:17	2020-11-22 03:36:27	79	998303
16	2020-11-22 03:36:27	2020-11-22 03:52:01	206	999857
17	2020-11-22 03:52:02	2020-11-22 04:06:55	34	998582
18	2020-11-22 04:06:56	2020-11-22 04:21:20	1208	999521
19	2020-11-22 04:21:20	2020-11-22 04:35:46	453	999485
20	2020-11-22 04:35:47	2020-11-22 04:50:13	97	999962
21	2020-11-22 04:50:13	2020-11-22 05:05:15	5624	999994
22	2020-11-22 05:05:16	2020-11-22 05:19:47	2520	999553
23	2020-11-22 05:19:47	2020-11-22 05:33:52	93	999404
24	2020-11-22 05:33:53	2020-11-22 05:48:06	929	999006
25	2020-11-22 05:48:06	2020-11-22 06:02:42	5365	999711
26	2020-11-22 06:02:42	2020-11-22 06:16:19	85	999959
27	2020-11-22 06:16:19	2020-11-22 06:30:23	468	998992
28	2020-11-22 06:30:24	2020-11-22 06:44:05	252	999327
29	2020-11-22 06:44:05	2020-11-22 06:59:40	2755	996335
30	2020-11-22 06:59:42	2020-11-22 07:13:16	2090	998396
31	2020-11-22 07:13:16	2020-11-22 07:27:58	919	999746
32	2020-11-22 07:27:58	2020-11-22 07:42:24	72	999771
33	2020-11-22 07:42:24	2020-11-22 07:56:39	2324	997784
34	2020-11-22 07:56:40	2020-11-22 08:10:38	348	999988
35	2020-11-22 08:10:38	2020-11-22 08:24:21	584	999222
36	2020-11-22 08:24:22	2020-11-22 08:38:53	679	998496
37	2020-11-22 08:38:53	2020-11-22 08:53:10	906	999544
38	2020-11-22 08:53:13	2020-11-22 09:07:23	1613	997472
39	2020-11-22 09:07:24	2020-11-22 09:22:32	850	999868
40	2020-11-22 09:22:34	2020-11-22 09:37:25	2319	996022
41	2020-11-22 09:37:26	2020-11-22 09:51:57	511	999511
42	2020-11-22 09:51:58	2020-11-22 10:06:45	177	999596
43	2020-11-22 10:06:45	2020-11-22 10:21:52	234	999036
44	2020-11-22 10:21:53	2020-11-22 10:36:56	1126	999627
45	2020-11-22 10:36:57	2020-11-22 10:51:27	78	998802
46	2020-11-22 10:51:30	2020-11-22 11:06:20	723	999156
47	2020-11-22 11:06:20	2020-11-22 11:21:10	154	998390
48	2020-11-22 11:21:11	2020-11-22 11:35:45	441	999555
49	2020-11-22 11:35:46	2020-11-22 11:50:09	207	999729
50	2020-11-22 11:50:09	2020-11-22 12:03:30	1314	998337
51	2020-11-22 12:03:30	2020-11-22 12:17:31	511	999349
52	2020-11-22 12:17:32	2020-11-22 12:32:00	761	999021
53	2020-11-22 12:32:01	2020-11-22 12:46:37	154	999894
54	2020-11-22 12:46:37	2020-11-22 13:00:58	854	997258
55	2020-11-22 13:00:58	2020-11-22 13:14:41	1246	998203
56	2020-11-22 13:14:41	2020-11-22 13:28:51	23	999143
57	2020-11-22 13:28:51	2020-11-22 13:43:45	3514	999393
58	2020-11-22 13:43:45	2020-11-22 13:57:43	421	998989
59	2020-11-22 13:57:43	2020-11-22 14:12:38	399	999506
60	2020-11-22 14:12:39	2020-11-22 14:27:02	210	997279
61	2020-11-22 14:27:03	2020-11-22 14:40:39	3488	999662
62	2020-11-22 14:40:40	2020-11-22 14:54:44	2137	999846
63	2020-11-22 14:54:45	2020-11-22 15:08:41	924	999801
64	2020-11-22 15:08:42	2020-11-22 15:22:59	526	999528
65	2020-11-22 15:23:01	2020-11-22 15:38:04	1252	999276
66	2020-11-22 15:38:05	2020-11-22 15:52:32	58	999785
67	2020-11-22 15:52:32	2020-11-22 16:07:21	5939	999623
68	2020-11-22 16:07:21	2020-11-22 16:21:43	691	999329
69	2020-11-22 16:21:45	2020-11-22 16:36:07	1723	999963
70	2020-11-22 16:36:07	2020-11-22 16:50:10	708	999557
71	2020-11-22 16:50:12	2020-11-22 17:05:22	924	998549
72	2020-11-22 17:05:22	2020-11-22 17:19:13	800	999161
73	2020-11-22 17:19:17	2020-11-22 17:32:37	1428	999168
74	2020-11-22 17:32:37	2020-11-22 17:46:52	732	998559
75	2020-11-22 17:46:53	2020-11-22 18:01:03	2170	998681
76	2020-11-22 18:01:04	2020-11-22 18:15:25	419	999816
77	2020-11-22 18:15:27	2020-11-22 18:29:56	959	998796
78	2020-11-22 18:29:57	2020-11-22 18:43:51	649	999813
79	2020-11-22 18:43:52	2020-11-22 18:58:20	1389	999516
80	2020-11-22 18:58:23	2020-11-22 19:13:22	758	999423
81	2020-11-22 19:13:24	2020-11-22 19:27:07	1899	999926
82	2020-11-22 19:27:07	2020-11-22 19:40:58	4327	997560
83	2020-11-22 19:41:02	2020-11-22 19:55:05	527	999539
84	2020-11-22 19:55:06	2020-11-22 20:09:23	242	999648
85	2020-11-22 20:09:23	2020-11-22 20:23:50	1486	999503
86	2020-11-22 20:23:50	2020-11-22 20:38:26	221	999463
87	2020-11-22 20:38:27	2020-11-22 20:52:38	562	999721
88	2020-11-22 20:52:39	2020-11-22 21:06:17	598	999459
89	2020-11-22 21:06:19	2020-11-22 21:20:56	1535	999795
90	2020-11-22 21:20:57	2020-11-22 21:35:02	631	999640
91	2020-11-22 21:35:03	2020-11-22 21:49:04	1357	998188
92	2020-11-22 21:49:04	2020-11-22 22:02:45	1311	999729
93	2020-11-22 22:02:46	2020-11-22 22:17:17	26	998170
94	2020-11-22 22:17:19	2020-11-22 22:32:10	2329	999896
95	2020-11-22 22:32:11	2020-11-22 22:46:46	1224	998903
96	2020-11-22 22:46:47	2020-11-22 23:01:00	2008	999468
97	2020-11-22 23:01:01	2020-11-22 23:15:32	2934	999798
98	2020-11-22 23:15:32	2020-11-22 23:30:20	3347	999681
99	2020-11-22 23:30:22	2020-11-22 23:45:28	1024	999977
100	2020-11-22 23:45:30	2020-11-23 00:00:00	516	999201