Extract data from a table corresponding to specific time

5 views (last 30 days)
Astitva
Astitva on 21 Apr 2022
Answered: Campion Loong on 18 May 2022
<dateandtime> A B C
'01-Sep-2021 00:00:00' 0 0 0
'01-Sep-2021 00:04:59' 0 0 0
'01-Sep-2021 00:09:59' 0 0 0
'01-Sep-2021 00:15:00' 0 0 0
'01-Sep-2021 00:20:00' 0 0 0
'01-Sep-2021 00:24:59' 0 0 0
'01-Sep-2021 00:29:59' 0 0 0
'01-Sep-2021 00:35:00' 0 0 0
'01-Sep-2021 00:40:00' 0 0 0
'01-Sep-2021 00:45:00' 0 0 0
'01-Sep-2021 00:49:59' 0 0 0
'01-Sep-2021 00:54:59' 0 0 0
'01-Sep-2021 01:00:00' 0 0 0
'01-Sep-2021 01:05:00' 0 0 0
'01-Sep-2021 01:09:59' 0 0 0
'01-Sep-2021 01:14:59' 0 0 0
'01-Sep-2021 01:20:00' 0 0 0
'01-Sep-2021 01:25:00' 0 0 0
'01-Sep-2021 01:30:00' 0 0 0
'01-Sep-2021 01:34:59' 0 0 0
'01-Sep-2021 01:39:59' 0 0 0
'01-Sep-2021 01:45:00' 0 0 0
'01-Sep-2021 01:50:00' 0 0 0
'01-Sep-2021 01:54:59' 0 0 0
'01-Sep-2021 01:59:59' 0 0 0
'01-Sep-2021 02:05:00' 0 0 0
'01-Sep-2021 02:10:00' 0 0 0
'01-Sep-2021 02:15:00' 0 0 0
'01-Sep-2021 02:19:59' 0 0 0
'01-Sep-2021 02:24:59' 0 0 0
'01-Sep-2021 02:30:00' 0 0 0
'01-Sep-2021 02:35:00' 0 0 0
'01-Sep-2021 02:39:59' 0 0 0
'01-Sep-2021 02:44:59' 0 0 0
'01-Sep-2021 02:50:00' 0 0 0
'01-Sep-2021 02:55:00' 0 0 0
'01-Sep-2021 03:00:00' 0 0 0
'01-Sep-2021 03:04:59' 0 0 0
'01-Sep-2021 03:09:59' 0 0 0
'01-Sep-2021 03:15:00' 0 0 0
'01-Sep-2021 03:20:00' 0 0 0
'01-Sep-2021 03:24:59' 0 0 0
'01-Sep-2021 03:29:59' 0 0 0
'01-Sep-2021 03:35:00' 0 0 0
'01-Sep-2021 03:40:00' 0 0 0
'01-Sep-2021 03:45:00' 0 0 0
'01-Sep-2021 03:49:59' 0 0 0
'01-Sep-2021 03:54:59' 0 0 0
'01-Sep-2021 04:00:00' 0 0 0
'01-Sep-2021 04:05:00' 0 0 0
'01-Sep-2021 04:09:59' 0 0 0
'01-Sep-2021 04:14:59' 0 0 0
'01-Sep-2021 04:20:00' 0 0 0
'01-Sep-2021 04:25:00' 0 0 0
'01-Sep-2021 04:30:00' 0 0 0
'01-Sep-2021 04:34:59' 0 0 0
'01-Sep-2021 04:39:59' 0 0 0
'01-Sep-2021 04:45:00' 0 0 0
'01-Sep-2021 04:50:00' 0 0 0
'01-Sep-2021 04:54:59' 0 0 0
'01-Sep-2021 04:59:59' 0 0 0
'01-Sep-2021 05:05:00' 0 0 0
'01-Sep-2021 05:10:00' 0 0 0
'01-Sep-2021 05:15:00' 0 0 0
'01-Sep-2021 05:19:59' 0 0 0
'01-Sep-2021 05:24:59' 0 0 0
'01-Sep-2021 05:30:00' 31 0 0
'01-Sep-2021 05:35:00' 32 0 0
'01-Sep-2021 05:39:59' 32 0 0
'01-Sep-2021 05:44:59' 32 0 0
'01-Sep-2021 05:50:00' 31.9900000000000 0 4.06000000000000
'01-Sep-2021 05:55:00' 31 0 10
'01-Sep-2021 06:00:00' 31 0 17
'01-Sep-2021 06:04:59' 30 142 23.0700000000000
'01-Sep-2021 06:09:59' 30 13 30
'01-Sep-2021 06:15:00' 29 3 41.1000000000000
'01-Sep-2021 06:20:00' 29 0 51
'01-Sep-2021 06:24:59' 29 6 63
'01-Sep-2021 06:29:59' 30 2 75.1400000000000
'01-Sep-2021 06:35:00' 30 0 89
'01-Sep-2021 06:40:00' 30 0 103.150000000000
'01-Sep-2021 06:45:00' 30 23 118
'01-Sep-2021 06:49:59' 30 88 135
'01-Sep-2021 06:54:59' 31 0 152.180000000000
'01-Sep-2021 07:00:00' 31 0 170
'01-Sep-2021 07:05:00' 31 0 189.200000000000
'01-Sep-2021 07:09:59' 31 1 209
'01-Sep-2021 07:14:59' 31 0 230
'01-Sep-2021 07:20:00' 31.0100000000000 0 249.210000000000
'01-Sep-2021 07:25:00' 32 0 270
'01-Sep-2021 07:30:00' 33 0 292.190000000000
'01-Sep-2021 07:34:59' 33 14 311
'01-Sep-2021 07:39:59' 33 0 335.230000000000
'01-Sep-2021 07:45:00' 33 0 358
'01-Sep-2021 07:50:00' 33 0 378
'01-Sep-2021 07:54:59' 34.0100000000000 0 400.250000000000
'01-Sep-2021 07:59:59' 35 14 425
'01-Sep-2021 08:05:00' 35 0 441.170000000000
'01-Sep-2021 08:10:00' 35 1 458
'01-Sep-2021 08:15:00' 35 7 479
'01-Sep-2021 08:19:59' 35 0 505.250000000000
'01-Sep-2021 08:24:59' 35 100 530
'01-Sep-2021 08:30:00' 35.0100000000000 11 549.220000000000
'01-Sep-2021 08:35:00' 36 1 571
'01-Sep-2021 08:39:59' 35 0 590
'01-Sep-2021 08:44:59' 36.0100000000000 0 609.160000000000
'01-Sep-2021 08:50:00' 37 0 625
'01-Sep-2021 08:55:00' 36 6 646.200000000000
'01-Sep-2021 09:00:00' 36 14 666
'01-Sep-2021 09:04:59' 37 11 683.210000000000
'01-Sep-2021 09:09:59' 37 39 704
'01-Sep-2021 09:15:00' 38 0 722
'01-Sep-2021 09:20:00' 38 23 738.150000000000
'01-Sep-2021 09:24:59' 38 11 753
'01-Sep-2021 09:29:59' 38 8 770.140000000000
'01-Sep-2021 09:35:00' 38 6 784
'01-Sep-2021 09:40:00' 39 22 798
'01-Sep-2021 09:45:00' 39 22 813.120000000000
'01-Sep-2021 09:49:59' 39 34 825
'01-Sep-2021 09:54:59' 39.0100000000000 6 839.140000000000
'01-Sep-2021 10:00:00' 40 9 853
'01-Sep-2021 10:05:00' 40 0 867.080000000000
'01-Sep-2021 10:09:59' 40 0 875
'01-Sep-2021 10:14:59' 41 0 885
'01-Sep-2021 10:20:00' 41 73 901.060000000000
'01-Sep-2021 10:25:00' 41 22 907
'01-Sep-2021 10:30:00' 41.0100000000000 29 915.130000000000
'01-Sep-2021 10:34:59' 42 24 928
'01-Sep-2021 10:39:59' 42 27 937
'01-Sep-2021 10:45:00' 42.0100000000000 38 942.050000000000
'01-Sep-2021 10:50:00' 43 12 947
'01-Sep-2021 10:54:59' 43.9900000000000 11 957.100000000000
'01-Sep-2021 10:59:59' 43 130 967
'01-Sep-2021 11:05:00' 43.0100000000000 149 973.080000000000
'01-Sep-2021 11:10:00' 44 67 981
'01-Sep-2021 11:15:00' 44 53 983
'01-Sep-2021 11:19:59' 44 154 986.050000000000
'01-Sep-2021 11:24:59' 44 74 991
'01-Sep-2021 11:30:00' 44 70 996.990000000000
'01-Sep-2021 11:35:00' 44 88 996
'01-Sep-2021 11:39:59' 44.0100000000000 59 995.020000000000
'01-Sep-2021 11:44:59' 45 62 997
'01-Sep-2021 11:50:00' 44 102 1002
'01-Sep-2021 11:55:00' 44.0100000000000 32 1002.99000000000
'01-Sep-2021 12:00:00' 45 16 1002
'01-Sep-2021 12:04:59' 44 111 999.990000000000
'01-Sep-2021 12:09:59' 44 111 999
'01-Sep-2021 12:15:00' 45 2 994
'01-Sep-2021 12:20:00' 44.9900000000000 42 986.960000000000
'01-Sep-2021 12:24:59' 44 47 983
'01-Sep-2021 12:29:59' 44.0100000000000 121 981.930000000000
'01-Sep-2021 12:35:00' 45 67 975
'01-Sep-2021 12:40:00' 45 35 969
'01-Sep-2021 12:45:00' 45 274 952.020000000000
'01-Sep-2021 12:49:59' 45 218 954
'01-Sep-2021 12:54:59' 45 250 948.920000000000
'01-Sep-2021 13:00:00' 45 190 941
'01-Sep-2021 13:05:00' 45 115 931.750000000000
'01-Sep-2021 13:09:59' 45 251 907
'01-Sep-2021 13:14:59' 45 145 917
'01-Sep-2021 13:20:00' 45.0100000000000 99 909.920000000000
'01-Sep-2021 13:25:00' 46 60 902
'01-Sep-2021 13:30:00' 45 85 889.860000000000
'01-Sep-2021 13:34:59' 45 180 876
'01-Sep-2021 13:39:59' 45 232 861
'01-Sep-2021 13:45:00' 45 157 849.840000000000
'01-Sep-2021 13:50:00' 45.0100000000000 80 833.920000000000
'01-Sep-2021 13:54:59' 46 200 826
'01-Sep-2021 13:59:59' 45 271 813
'01-Sep-2021 14:05:00' 45 198 798.820000000000
'01-Sep-2021 14:10:00' 45 395 781
'01-Sep-2021 14:15:00' 45 397 773.890000000000
'01-Sep-2021 14:19:59' 45 345 763
'01-Sep-2021 14:24:59' 45 174 749.800000000000
'01-Sep-2021 14:30:00' 45 95 730
'01-Sep-2021 14:35:00' 45 196 717
'01-Sep-2021 14:39:59' 45 115 701.820000000000
'01-Sep-2021 14:44:59' 45 40 684
'01-Sep-2021 14:50:00' 45 161 664.810000000000
'01-Sep-2021 14:55:00' 45 263 646
'01-Sep-2021 15:00:00' 45 248 628
'01-Sep-2021 15:04:59' 45 140 608.820000000000
'01-Sep-2021 15:09:59' 45 147 591
'01-Sep-2021 15:15:00' 44.9900000000000 373 575.720000000000
'01-Sep-2021 15:20:00' 44 190 548
'01-Sep-2021 15:24:59' 45 104 529.840000000000
'01-Sep-2021 15:29:59' 45 216 514
'01-Sep-2021 15:35:00' 45 61 494
'01-Sep-2021 15:40:00' 45 169 472.810000000000
'01-Sep-2021 15:45:00' 45 146 454
'01-Sep-2021 15:49:59' 44 63 432.780000000000
'01-Sep-2021 15:54:59' 44 414 411
'01-Sep-2021 16:00:00' 45 130 390
'01-Sep-2021 16:05:00' 44.0100000000000 110 369.850000000000
'01-Sep-2021 16:09:59' 45 22 348
'01-Sep-2021 16:14:59' 44.9900000000000 31 327.760000000000
'01-Sep-2021 16:20:00' 44 154 310
'01-Sep-2021 16:25:00' 44 83 286
'01-Sep-2021 16:30:00' 44 162 262.820000000000
'01-Sep-2021 16:34:59' 44 106 245
'01-Sep-2021 16:39:59' 44 125 225.830000000000
'01-Sep-2021 16:45:00' 44 94 209
'01-Sep-2021 16:50:00' 44 101 189.800000000000
'01-Sep-2021 16:54:59' 44 100 170
'01-Sep-2021 16:59:59' 44 79 153
'01-Sep-2021 17:05:00' 44 26 138.850000000000
'01-Sep-2021 17:10:00' 44 27 124
'01-Sep-2021 17:15:00' 43.0100000000000 8 108.860000000000
'01-Sep-2021 17:19:59' 44 2 95
'01-Sep-2021 17:24:59' 44 1 84
'01-Sep-2021 17:30:00' 44 15 73.8900000000000
'01-Sep-2021 17:35:00' 44 28 63
'01-Sep-2021 17:39:59' 43.9900000000000 5 54.9100000000000
'01-Sep-2021 17:43:30' 0 0 0
'01-Sep-2021 17:44:59' 43 2 46
'01-Sep-2021 17:50:00' 42 0 38.9300000000000
'01-Sep-2021 17:55:00' 42 1 32
'01-Sep-2021 18:00:00' 42 0 26
'01-Sep-2021 18:04:59' 42 0 19.9400000000000
'01-Sep-2021 18:09:59' 42 0 14
'01-Sep-2021 18:15:00' 41.9900000000000 0 7.93000000000000
'01-Sep-2021 18:20:00' 41 0 3
'01-Sep-2021 18:24:59' 41 0 0
'01-Sep-2021 18:29:59' 41 0 0
'01-Sep-2021 18:35:00' 41 48 0
'01-Sep-2021 18:40:00' 41 37 0
'01-Sep-2021 18:45:00' 41 71 0
'01-Sep-2021 18:49:59' 41 6 0
'01-Sep-2021 18:54:59' 40 13 0
'01-Sep-2021 19:00:00' 40 0 0
'01-Sep-2021 19:05:00' 0 0 0
'01-Sep-2021 19:09:59' 0 0 0
'01-Sep-2021 19:14:59' 0 0 0
'01-Sep-2021 19:20:00' 0 0 0
'01-Sep-2021 19:25:00' 0 0 0
'01-Sep-2021 19:30:00' 0 0 0
'01-Sep-2021 19:34:59' 0 0 0
'01-Sep-2021 19:39:59' 0 0 0
'01-Sep-2021 19:45:00' 0 0 0
'01-Sep-2021 19:50:00' 0 0 0
'01-Sep-2021 19:54:59' 0 0 0
'01-Sep-2021 19:59:59' 0 0 0
'01-Sep-2021 20:05:00' 0 0 0
'01-Sep-2021 20:10:00' 0 0 0
'01-Sep-2021 20:15:00' 0 0 0
'01-Sep-2021 20:19:59' 0 0 0
'01-Sep-2021 20:24:59' 0 0 0
'01-Sep-2021 20:30:00' 0 0 0
'01-Sep-2021 20:35:00' 0 0 0
'01-Sep-2021 20:39:59' 0 0 0
'01-Sep-2021 20:44:59' 0 0 0
'01-Sep-2021 20:50:00' 0 0 0
'01-Sep-2021 20:55:00' 0 0 0
'01-Sep-2021 21:00:00' 0 0 0
'01-Sep-2021 21:04:59' 0 0 0
'01-Sep-2021 21:09:59' 0 0 0
'01-Sep-2021 21:15:00' 0 0 0
'01-Sep-2021 21:20:00' 0 0 0
'01-Sep-2021 21:24:59' 0 0 0
'01-Sep-2021 21:29:59' 0 0 0
'01-Sep-2021 21:35:00' 0 0 0
'01-Sep-2021 21:40:00' 0 0 0
'01-Sep-2021 21:45:00' 0 0 0
'01-Sep-2021 21:49:59' 0 0 0
'01-Sep-2021 21:54:59' 0 0 0
'01-Sep-2021 22:00:00' 0 0 0
'01-Sep-2021 22:05:00' 0 0 0
'01-Sep-2021 22:09:59' 0 0 0
'01-Sep-2021 22:14:59' 0 0 0
'01-Sep-2021 22:20:00' 0 0 0
'01-Sep-2021 22:25:00' 0 0 0
'01-Sep-2021 22:30:00' 0 0 0
'01-Sep-2021 22:34:59' 0 0 0
'01-Sep-2021 22:39:59' 0 0 0
'01-Sep-2021 22:45:00' 0 0 0
'01-Sep-2021 22:50:00' 0 0 0
'01-Sep-2021 22:54:59' 0 0 0
'01-Sep-2021 22:59:59' 0 0 0
'01-Sep-2021 23:05:00' 0 0 0
'01-Sep-2021 23:10:00' 0 0 0
'01-Sep-2021 23:15:00' 0 0 0
'01-Sep-2021 23:19:59' 0 0 0
'01-Sep-2021 23:24:59' 0 0 0
'01-Sep-2021 23:30:00' 0 0 0
'01-Sep-2021 23:35:00' 0 0 0
'01-Sep-2021 23:39:59' 0 0 0
'01-Sep-2021 23:44:59' 0 0 0
'01-Sep-2021 23:50:00' 0 0 0
'01-Sep-2021 23:55:00' 0 0 0
'02-Sep-2021 00:00:00' 0 0 0
'02-Sep-2021 00:04:59' 0 0 0
'02-Sep-2021 00:09:59' 0 0 0
'02-Sep-2021 00:15:00' 0 0 0
'02-Sep-2021 00:20:00' 0 0 0
'02-Sep-2021 00:24:59' 0 0 0
'02-Sep-2021 00:29:59' 0 0 0
'02-Sep-2021 00:35:00' 0 0 0
'02-Sep-2021 00:40:00' 0 0 0
'02-Sep-2021 00:45:00' 0 0 0
'02-Sep-2021 00:49:59' 0 0 0
'02-Sep-2021 00:54:59' 0 0 0
'02-Sep-2021 01:00:00' 0 0 0
'02-Sep-2021 01:05:00' 0 0 0
'02-Sep-2021 01:09:59' 0 0 0
'02-Sep-2021 01:14:59' 0 0 0
'02-Sep-2021 01:20:00' 0 0 0
'02-Sep-2021 01:25:00' 0 0 0
'02-Sep-2021 01:30:00' 0 0 0
'02-Sep-2021 01:34:59' 0 0 0
'02-Sep-2021 01:39:59' 0 0 0
'02-Sep-2021 01:45:00' 0 0 0
'02-Sep-2021 01:50:00' 0 0 0
'02-Sep-2021 01:54:59' 0 0 0
'02-Sep-2021 01:59:59' 0 0 0
'02-Sep-2021 02:05:00' 0 0 0
'02-Sep-2021 02:10:00' 0 0 0
'02-Sep-2021 02:15:00' 0 0 0
'02-Sep-2021 02:19:59' 0 0 0
'02-Sep-2021 02:24:59' 0 0 0
'02-Sep-2021 02:30:00' 0 0 0
'02-Sep-2021 02:35:00' 0 0 0
'02-Sep-2021 02:39:59' 0 0 0
'02-Sep-2021 02:44:59' 0 0 0
'02-Sep-2021 02:50:00' 0 0 0
'02-Sep-2021 02:55:00' 0 0 0
'02-Sep-2021 03:00:00' 0 0 0
'02-Sep-2021 03:04:59' 0 0 0
'02-Sep-2021 03:09:59' 0 0 0
'02-Sep-2021 03:15:00' 0 0 0
'02-Sep-2021 03:20:00' 0 0 0
'02-Sep-2021 03:24:59' 0 0 0
'02-Sep-2021 03:29:59' 0 0 0
'02-Sep-2021 03:35:00' 0 0 0
'02-Sep-2021 03:40:00' 0 0 0
'02-Sep-2021 03:45:00' 0 0 0
'02-Sep-2021 03:49:59' 0 0 0
'02-Sep-2021 03:54:59' 0 0 0
'02-Sep-2021 04:00:00' 0 0 0
'02-Sep-2021 04:05:00' 0 0 0
'02-Sep-2021 04:09:59' 0 0 0
'02-Sep-2021 04:14:59' 0 0 0
'02-Sep-2021 04:20:00' 0 0 0
'02-Sep-2021 04:25:00' 0 0 0
'02-Sep-2021 04:30:00' 0 0 0
'02-Sep-2021 04:34:59' 0 0 0
'02-Sep-2021 04:39:59' 0 0 0
'02-Sep-2021 04:45:00' 0 0 0
'02-Sep-2021 04:50:00' 0 0 0
'02-Sep-2021 04:54:59' 0 0 0
'02-Sep-2021 04:59:59' 0 0 0
'02-Sep-2021 05:05:00' 0 0 0
'02-Sep-2021 05:10:00' 0 0 0
'02-Sep-2021 05:15:00' 0 0 0
'02-Sep-2021 05:19:59' 0 0 0
'02-Sep-2021 05:24:59' 0 0 0
'02-Sep-2021 05:30:00' 31 0 0
'02-Sep-2021 05:35:00' 31 0 0
'02-Sep-2021 05:39:59' 31 0 0
'02-Sep-2021 05:44:59' 32.0100000000000 0 0.0400000000000000
'02-Sep-2021 05:50:00' 33 0 4
'02-Sep-2021 05:55:00' 32 0 8
'02-Sep-2021 06:00:00' 31 0 13.0600000000000
'02-Sep-2021 06:04:59' 31 0 19
'02-Sep-2021 06:09:59' 32 0 26.1100000000000
'02-Sep-2021 06:15:00' 32 0 37
'02-Sep-2021 06:20:00' 32 0 47
'02-Sep-2021 06:24:59' 32 0 60.1300000000000
'02-Sep-2021 06:29:59' 32 0 73
'02-Sep-2021 06:35:00' 32 5 87.1500000000000
'02-Sep-2021 06:40:00' 32 17 102
'02-Sep-2021 06:45:00' 32 6 118
'02-Sep-2021 06:49:59' 33.0100000000000 0 135.180000000000
'02-Sep-2021 06:54:59' 34 0 153
'02-Sep-2021 07:00:00' 33.9900000000000 34 171.190000000000
'02-Sep-2021 07:05:00' 33 50 190
'02-Sep-2021 07:09:59' 32 70 209.200000000000
'02-Sep-2021 07:14:59' 32 39 229
'02-Sep-2021 07:20:00' 32 67 250
'02-Sep-2021 07:25:00' 33.0100000000000 0 272.220000000000
'02-Sep-2021 07:30:00' 34 1 294
'02-Sep-2021 07:34:59' 34 0 316.210000000000
'02-Sep-2021 07:39:59' 34 0 337
'02-Sep-2021 07:45:00' 35 0 359
'02-Sep-2021 07:50:00' 35 0 379.230000000000
'02-Sep-2021 07:54:59' 35 0 402
'02-Sep-2021 07:59:59' 35 0 424.210000000000
'02-Sep-2021 08:05:00' 35 0 445
'02-Sep-2021 08:10:00' 36 0 467
'02-Sep-2021 08:15:00' 37 0 489.210000000000
'02-Sep-2021 08:19:59' 37 0 510
'02-Sep-2021 08:24:59' 38 0 533.250000000000
'02-Sep-2021 08:30:00' 38 0 552
'02-Sep-2021 08:35:00' 38 0 572
'02-Sep-2021 08:39:59' 38 0 592.200000000000
'02-Sep-2021 08:44:59' 38 0 612
'02-Sep-2021 08:50:00' 39 0 631.110000000000
'02-Sep-2021 08:55:00' 39 0 648
'02-Sep-2021 09:00:00' 40 0 666.190000000000
'02-Sep-2021 09:04:59' 40 0 685
'02-Sep-2021 09:09:59' 39 16 703
'02-Sep-2021 09:15:00' 39.0100000000000 17 719.160000000000
'02-Sep-2021 09:20:00' 40 1 735
'02-Sep-2021 09:24:59' 41 0 752.140000000000
'02-Sep-2021 09:29:59' 41 0 766
'02-Sep-2021 09:35:00' 41 0 783
'02-Sep-2021 09:40:00' 42 0 797.180000000000
'02-Sep-2021 09:45:00' 42 3 815
'02-Sep-2021 09:49:59' 42 4 832.170000000000
'02-Sep-2021 09:54:59' 42 0 845
'02-Sep-2021 10:00:00' 42 0 855
'02-Sep-2021 10:05:00' 42.0100000000000 3 867.100000000000
'02-Sep-2021 10:09:59' 43 0 877
'02-Sep-2021 10:14:59' 43 8 886.060000000000
'02-Sep-2021 10:20:00' 43 24 892
'02-Sep-2021 10:25:00' 43 4 900.170000000000
'02-Sep-2021 10:30:00' 43 12 917
'02-Sep-2021 10:34:59' 43 78 931
'02-Sep-2021 10:39:59' 43 19 939.110000000000
'02-Sep-2021 10:45:00' 43 135 950
'02-Sep-2021 10:50:00' 43.0100000000000 98 961.060000000000
'02-Sep-2021 10:54:59' 44 176 967
'02-Sep-2021 10:59:59' 43 186 977
'02-Sep-2021 11:05:00' 43.0100000000000 261 983.050000000000
'02-Sep-2021 11:10:00' 44 111 988
'02-Sep-2021 11:15:00' 44 157 993.070000000000
'02-Sep-2021 11:19:59' 44 241 998
'02-Sep-2021 11:24:59' 44 149 995.030000000000
'02-Sep-2021 11:30:00' 44 168 998
'02-Sep-2021 11:35:00' 45 67 1002
'02-Sep-2021 11:39:59' 44 164 1004.99000000000
'02-Sep-2021 11:44:59' 44 43 1004
'02-Sep-2021 11:50:00' 44.9900000000000 112 1003.97000000000
'02-Sep-2021 11:55:00' 44 125 1001
'02-Sep-2021 12:00:00' 45 71 999
'02-Sep-2021 12:04:59' 45 65 999
'02-Sep-2021 12:09:59' 45 128 998
'02-Sep-2021 12:15:00' 44.0100000000000 21 999.950000000000
'02-Sep-2021 12:20:00' 45 218 995
'02-Sep-2021 12:24:59' 44.9900000000000 201 998.970000000000
'02-Sep-2021 12:29:59' 44 117 996
'02-Sep-2021 12:35:00' 45 5 986
'02-Sep-2021 12:40:00' 45.9900000000000 23 973.910000000000
'02-Sep-2021 12:45:00' 45 219 965
'02-Sep-2021 12:49:59' 44.9900000000000 169 970.990000000000
'02-Sep-2021 12:54:59' 44 44 970
'02-Sep-2021 13:00:00' 45 10 958
'02-Sep-2021 13:05:00' 45.9900000000000 104 944.030000000000
'02-Sep-2021 13:09:59' 45 10 947
'02-Sep-2021 13:14:59' 45.9900000000000 90 931.920000000000
'02-Sep-2021 13:20:00' 45 170 924
'02-Sep-2021 13:25:00' 46 24 911
'02-Sep-2021 13:30:00' 45.0100000000000 99 896.850000000000
'02-Sep-2021 13:34:59' 46 55 882
'02-Sep-2021 13:39:59' 46.9700000000000 37 864.910000000000
'02-Sep-2021 13:45:00' 45 321 858
'02-Sep-2021 13:50:00' 45.9900000000000 124 849.830000000000
'02-Sep-2021 13:54:59' 45 137 833
'02-Sep-2021 13:59:59' 45.9900000000000 78 822.830000000000
'02-Sep-2021 14:05:00' 45 241 810
'02-Sep-2021 14:10:00' 45 124 798.840000000000
'02-Sep-2021 14:15:00' 45 108 783
'02-Sep-2021 14:19:59' 45 13 766
'02-Sep-2021 14:24:59' 44 126 746.790000000000
'02-Sep-2021 14:30:00' 44 166 731
'02-Sep-2021 14:35:00' 45 34 718.840000000000
'02-Sep-2021 14:39:59' 45 82 703
'02-Sep-2021 14:44:59' 45 246 682
'02-Sep-2021 14:50:00' 45 106 663.870000000000
'02-Sep-2021 14:55:00' 45 54 651
'02-Sep-2021 15:00:00' 45.9900000000000 27 629.780000000000
'02-Sep-2021 15:04:59' 45 107 608
'02-Sep-2021 15:09:59' 45.0100000000000 6 585.790000000000
'02-Sep-2021 15:15:00' 46 36 565
'02-Sep-2021 15:20:00' 46 0 542
'02-Sep-2021 15:24:59' 45 44 523.810000000000
'02-Sep-2021 15:29:59' 45 1 505
'02-Sep-2021 15:35:00' 44.9900000000000 56 485.830000000000
'02-Sep-2021 15:40:00' 44 63 469
'02-Sep-2021 15:45:00' 45 0 446.800000000000
'02-Sep-2021 15:49:59' 45 0 427
'02-Sep-2021 15:54:59' 45 24 403
'02-Sep-2021 16:00:00' 45 88 383.800000000000
'02-Sep-2021 16:05:00' 45 70 364
'02-Sep-2021 16:09:59' 44 32 340.790000000000
'02-Sep-2021 16:14:59' 44 5 320
'02-Sep-2021 16:20:00' 44 49 300
'02-Sep-2021 16:25:00' 44.0100000000000 10 279.810000000000
'02-Sep-2021 16:30:00' 45 19 261
'02-Sep-2021 16:34:59' 44 40 241.800000000000
'02-Sep-2021 16:39:59' 44 4 222
'02-Sep-2021 16:45:00' 44 0 201
'02-Sep-2021 16:50:00' 44 15 181.840000000000
'02-Sep-2021 16:54:59' 44 25 166
'02-Sep-2021 16:59:59' 43 144 148.860000000000
'02-Sep-2021 17:05:00' 43 33 135
'02-Sep-2021 17:10:00' 43 6 119.860000000000
'02-Sep-2021 17:15:00' 43 0 106
'02-Sep-2021 17:19:59' 43 2 93
'02-Sep-2021 17:24:59' 44 0 81.9000000000000
'02-Sep-2021 17:30:00' 44 5 72
'02-Sep-2021 17:35:00' 43 29 60.9100000000000
'02-Sep-2021 17:39:59' 43 0 52
'02-Sep-2021 17:44:17' 0 0 0
'02-Sep-2021 17:44:59' 42 9 43
'02-Sep-2021 17:50:00' 42 4 35.9400000000000
'02-Sep-2021 17:55:00' 42 18 30
'02-Sep-2021 18:00:00' 41.9900000000000 0 23.9400000000000
'02-Sep-2021 18:04:59' 41 0 18
'02-Sep-2021 18:09:59' 41 0 12
'02-Sep-2021 18:15:00' 41 0 6.95000000000000
'02-Sep-2021 18:20:00' 41 0 2
'02-Sep-2021 18:24:59' 41 0 0
'02-Sep-2021 18:29:59' 41 0 0
'02-Sep-2021 18:35:00' 40 0 0
'02-Sep-2021 18:40:00' 41 0 0
'02-Sep-2021 18:45:00' 41 0 0
'02-Sep-2021 18:49:59' 40 0 0
'02-Sep-2021 18:54:59' 40 0 0
'02-Sep-2021 19:00:00' 40 0 0
'02-Sep-2021 19:05:00' 0 0 0
'02-Sep-2021 19:09:59' 0 0 0
'02-Sep-2021 19:14:59' 0 0 0
'02-Sep-2021 19:20:00' 0 0 0
'02-Sep-2021 19:25:00' 0 0 0
'02-Sep-2021 19:30:00' 0 0 0
'02-Sep-2021 19:34:59' 0 0 0
'02-Sep-2021 19:39:59' 0 0 0
'02-Sep-2021 19:45:00' 0 0 0
'02-Sep-2021 19:50:00' 0 0 0
'02-Sep-2021 19:54:59' 0 0 0
'02-Sep-2021 19:59:59' 0 0 0
'02-Sep-2021 20:05:00' 0 0 0
'02-Sep-2021 20:10:00' 0 0 0
'02-Sep-2021 20:15:00' 0 0 0
'02-Sep-2021 20:19:59' 0 0 0
'02-Sep-2021 20:24:59' 0 0 0
'02-Sep-2021 20:30:00' 0 0 0
'02-Sep-2021 20:35:00' 0 0 0
'02-Sep-2021 20:39:59' 0 0 0
'02-Sep-2021 20:44:59' 0 0 0
'02-Sep-2021 20:50:00' 0 0 0
'02-Sep-2021 20:55:00' 0 0 0
'02-Sep-2021 21:00:00' 0 0 0
'02-Sep-2021 21:04:59' 0 0 0
'02-Sep-2021 21:09:59' 0 0 0
'02-Sep-2021 21:15:00' 0 0 0
'02-Sep-2021 21:20:00' 0 0 0
'02-Sep-2021 21:24:59' 0 0 0
'02-Sep-2021 21:29:59' 0 0 0
'02-Sep-2021 21:35:00' 0 0 0
'02-Sep-2021 21:40:00' 0 0 0
'02-Sep-2021 21:45:00' 0 0 0
'02-Sep-2021 21:49:59' 0 0 0
'02-Sep-2021 21:54:59' 0 0 0
'02-Sep-2021 22:00:00' 0 0 0
'02-Sep-2021 22:05:00' 0 0 0
'02-Sep-2021 22:09:59' 0 0 0
'02-Sep-2021 22:14:59' 0 0 0
'02-Sep-2021 22:20:00' 0 0 0
'02-Sep-2021 22:25:00' 0 0 0
'02-Sep-2021 22:30:00' 0 0 0
'02-Sep-2021 22:34:59' 0 0 0
'02-Sep-2021 22:39:59' 0 0 0
'02-Sep-2021 22:45:00' 0 0 0
'02-Sep-2021 22:50:00' 0 0 0
'02-Sep-2021 22:54:59' 0 0 0
'02-Sep-2021 22:59:59' 0 0 0
'02-Sep-2021 23:05:00' 0 0 0
'02-Sep-2021 23:10:00' 0 0 0
'02-Sep-2021 23:15:00' 0 0 0
'02-Sep-2021 23:19:59' 0 0 0
'02-Sep-2021 23:24:59' 0 0 0
'02-Sep-2021 23:30:00' 0 0 0
'02-Sep-2021 23:35:00' 0 0 0
'02-Sep-2021 23:39:59' 0 0 0
'02-Sep-2021 23:44:59' 0 0 0
'02-Sep-2021 23:50:00' 0 0 0
'02-Sep-2021 23:55:00' 0 0 0
'03-Sep-2021 00:00:00' 0 0 0
'03-Sep-2021 00:04:59' 0 0 0
'03-Sep-2021 00:09:59' 0 0 0
'03-Sep-2021 00:15:00' 0 0 0
'03-Sep-2021 00:20:00' 0 0 0
'03-Sep-2021 00:24:59' 0 0 0
'03-Sep-2021 00:29:59' 0 0 0
'03-Sep-2021 00:35:00' 0 0 0
'03-Sep-2021 00:40:00' 0 0 0
'03-Sep-2021 00:45:00' 0 0 0
'03-Sep-2021 00:49:59' 0 0 0
'03-Sep-2021 00:54:59' 0 0 0
'03-Sep-2021 01:00:00' 0 0 0
'03-Sep-2021 01:05:00' 0 0 0
'03-Sep-2021 01:09:59' 0 0 0
'03-Sep-2021 01:14:59' 0 0 0
'03-Sep-2021 01:20:00' 0 0 0
'03-Sep-2021 01:25:00' 0 0 0
'03-Sep-2021 01:30:00' 0 0 0
'03-Sep-2021 01:34:59' 0 0 0
'03-Sep-2021 01:39:59' 0 0 0
'03-Sep-2021 01:45:00' 0 0 0
'03-Sep-2021 01:50:00' 0 0 0
'03-Sep-2021 01:54:59' 0 0 0
'03-Sep-2021 01:59:59' 0 0 0
'03-Sep-2021 02:05:00' 0 0 0
'03-Sep-2021 02:10:00' 0 0 0
'03-Sep-2021 02:15:00' 0 0 0
'03-Sep-2021 02:19:59' 0 0 0
'03-Sep-2021 02:24:59' 0 0 0
'03-Sep-2021 02:30:00' 0 0 0
'03-Sep-2021 02:35:00' 0 0 0
'03-Sep-2021 02:39:59' 0 0 0
'03-Sep-2021 02:44:59' 0 0 0
'03-Sep-2021 02:50:00' 0 0 0
'03-Sep-2021 02:55:00' 0 0 0
'03-Sep-2021 03:00:00' 0 0 0
'03-Sep-2021 03:04:59' 0 0 0
'03-Sep-2021 03:09:59' 0 0 0
'03-Sep-2021 03:15:00' 0 0 0
'03-Sep-2021 03:20:00' 0 0 0
'03-Sep-2021 03:24:59' 0 0 0
'03-Sep-2021 03:29:59' 0 0 0
'03-Sep-2021 03:35:00' 0 0 0
'03-Sep-2021 03:40:00' 0 0 0
'03-Sep-2021 03:45:00' 0 0 0
'03-Sep-2021 03:49:59' 0 0 0
'03-Sep-2021 03:54:59' 0 0 0
'03-Sep-2021 04:00:00' 0 0 0
'03-Sep-2021 04:05:00' 0 0 0
'03-Sep-2021 04:09:59' 0 0 0
'03-Sep-2021 04:14:59' 0 0 0
'03-Sep-2021 04:20:00' 0 0 0
'03-Sep-2021 04:25:00' 0 0 0
'03-Sep-2021 04:30:00' 0 0 0
'03-Sep-2021 04:34:59' 0 0 0
'03-Sep-2021 04:39:59' 0 0 0
'03-Sep-2021 04:45:00' 0 0 0
'03-Sep-2021 04:50:00' 0 0 0
'03-Sep-2021 04:54:59' 0 0 0
'03-Sep-2021 04:59:59' 0 0 0
'03-Sep-2021 05:05:00' 0 0 0
'03-Sep-2021 05:10:00' 0 0 0
'03-Sep-2021 05:15:00' 0 0 0
'03-Sep-2021 05:19:59' 0 0 0
'03-Sep-2021 05:24:59' 0 0 0
'03-Sep-2021 05:30:00' 32 0 0
'03-Sep-2021 05:35:00' 31.9900000000000 0 0
'03-Sep-2021 05:39:59' 31 0 0
'03-Sep-2021 05:44:59' 31 0 0.0400000000000000
'03-Sep-2021 05:50:00' 31 0 4
'03-Sep-2021 05:55:00' 31 0 9
'03-Sep-2021 06:00:00' 31 0 14.0700000000000
'03-Sep-2021 06:04:59' 31 0 21
'03-Sep-2021 06:09:59' 29.9900000000000 2 28.1100000000000
'03-Sep-2021 06:15:00' 29 1 39
'03-Sep-2021 06:20:00' 30.0100000000000 0 52.1300000000000
'03-Sep-2021 06:24:59' 31 13 65
'03-Sep-2021 06:29:59' 31 0 78
'03-Sep-2021 06:35:00' 31.0100000000000 0 93.1600000000000
'03-Sep-2021 06:40:00' 32 2 109
'03-Sep-2021 06:45:00' 32 2 125.180000000000
'03-Sep-2021 06:49:59' 32 0 143
'03-Sep-2021 06:54:59' 32 0 160
'03-Sep-2021 07:00:00' 31.0100000000000 0 179.210000000000
'03-Sep-2021 07:05:00' 32 0 200
'03-Sep-2021 07:09:59' 31.0100000000000 22 220.210000000000
'03-Sep-2021 07:14:59' 32 0 241
'03-Sep-2021 07:20:00' 32 0 262.230000000000
'03-Sep-2021 07:25:00' 32 0 285
'03-Sep-2021 07:30:00' 32 0 305
'03-Sep-2021 07:34:59' 33 0 326.220000000000
'03-Sep-2021 07:39:59' 33 0 348
'03-Sep-2021 07:45:00' 33 1 369.210000000000
'03-Sep-2021 07:50:00' 33 7 390
'03-Sep-2021 07:54:59' 33 1 412
'03-Sep-2021 07:59:59' 34 0 433.220000000000
'03-Sep-2021 08:05:00' 34 9 455
'03-Sep-2021 08:10:00' 34.0100000000000 10 477.210000000000
'03-Sep-2021 08:15:00' 35 0 498
'03-Sep-2021 08:19:59' 35 0 521
'03-Sep-2021 08:24:59' 35.0100000000000 9 541.220000000000
'03-Sep-2021 08:30:00' 36 2 563
'03-Sep-2021 08:35:00' 37 0 584.210000000000
'03-Sep-2021 08:39:59' 37 0 605
'03-Sep-2021 08:44:59' 38 0 625.190000000000
'03-Sep-2021 08:50:00' 38 0 644
'03-Sep-2021 08:55:00' 38 0 662
'03-Sep-2021 09:00:00' 39 0 680.190000000000
'03-Sep-2021 09:04:59' 39 0 699
'03-Sep-2021 09:09:59' 39.0100000000000 0 716.170000000000
'03-Sep-2021 09:15:00' 40 0 733
'03-Sep-2021 09:20:00' 40 0 748
'03-Sep-2021 09:24:59' 40 0 766.180000000000
'03-Sep-2021 09:29:59' 40 0 784
'03-Sep-2021 09:35:00' 41 14 799.150000000000
'03-Sep-2021 09:40:00' 41 6 814
'03-Sep-2021 09:45:00' 42 33 830
'03-Sep-2021 09:49:59' 42 9 844.140000000000
'03-Sep-2021 09:54:59' 42 58 858
'03-Sep-2021 10:00:00' 43 61 869.150000000000
'03-Sep-2021 10:05:00' 43 98 880
'03-Sep-2021 10:09:59' 43 88 895
'03-Sep-2021 10:14:59' 43.0100000000000 25 907.090000000000
'03-Sep-2021 10:20:00' 44 50 916
'03-Sep-2021 10:25:00' 44 19 931.050000000000
'03-Sep-2021 10:30:00' 44 18 936
'03-Sep-2021 10:34:59' 44.9900000000000 12 943.080000000000
'03-Sep-2021 10:39:59' 44 0 951
'03-Sep-2021 10:45:00' 45 12 957
'03-Sep-2021 10:50:00' 44.9900000000000 13 962.090000000000
'03-Sep-2021 10:54:59' 44 36 971
'03-Sep-2021 10:59:59' 45 28 978.040000000000
'03-Sep-2021 11:05:00' 45 35 982
'03-Sep-2021 11:10:00' 45 0 988
'03-Sep-2021 11:15:00' 44.0100000000000 4 992.050000000000
'03-Sep-2021 11:19:59' 45 99 997
'03-Sep-2021 11:24:59' 44.9900000000000 57 1001.03000000000
'03-Sep-2021 11:30:00' 44 150 1004
'03-Sep-2021 11:35:00' 44.0100000000000 183 1005
'03-Sep-2021 11:39:59' 45 229 1005
'03-Sep-2021 11:44:59' 45 133 1012
'03-Sep-2021 11:50:00' 45 259 1006.99000000000
'03-Sep-2021 11:55:00' 45 281 1006
'03-Sep-2021 12:00:00' 45 191 1007.93000000000
'03-Sep-2021 12:04:59' 45 433 1001
'03-Sep-2021 12:09:59' 44 268 998
'03-Sep-2021 12:15:00' 45 233 998.960000000000
'03-Sep-2021 12:20:00' 45 167 995
'03-Sep-2021 12:24:59' 45.9900000000000 125 987.950000000000
'03-Sep-2021 12:29:59' 45 390 983
'03-Sep-2021 12:35:00' 44 208 977
'03-Sep-2021 12:40:00' 45 185 971.980000000000
'03-Sep-2021 12:45:00' 45 303 970
'03-Sep-2021 12:49:59' 46 125 960.010000000000
'03-Sep-2021 12:54:59' 46 410 961
'03-Sep-2021 13:00:00' 46 119 949.920000000000
'03-Sep-2021 13:05:00' 46 389 942
'03-Sep-2021 13:09:59' 45 338 933
'03-Sep-2021 13:14:59' 45.0100000000000 525 930.860000000000
'03-Sep-2021 13:20:00' 46 192 917
'03-Sep-2021 13:25:00' 45.9900000000000 310 915.850000000000
'03-Sep-2021 13:30:00' 45 292 901
'03-Sep-2021 13:34:59' 45 278 889.900000000000
'03-Sep-2021 13:39:59' 45 330 880
'03-Sep-2021 13:45:00' 45 122 868
'03-Sep-2021 13:50:00' 45.9900000000000 270 849.770000000000
'03-Sep-2021 13:54:59' 45 498 826.830000000000
'03-Sep-2021 13:59:59' 45 307 810
'03-Sep-2021 14:05:00' 45.0100000000000 284 805.900000000000
'03-Sep-2021 14:10:00' 46 296 796
'03-Sep-2021 14:15:00' 45 172 778
'03-Sep-2021 14:19:59' 45 255 767.830000000000
'03-Sep-2021 14:24:59' 45 251 751
'03-Sep-2021 14:30:00' 45 172 731.870000000000
'03-Sep-2021 14:35:00' 45 341 719
'03-Sep-2021 14:39:59' 45 360 703.810000000000
'03-Sep-2021 14:44:59' 45 205 685
'03-Sep-2021 14:50:00' 45 535 658
'03-Sep-2021 14:55:00' 44.9900000000000 334 647.820000000000
'03-Sep-2021 15:00:00' 44 270 630
'03-Sep-2021 15:04:59' 45 58 606.760000000000
'03-Sep-2021 15:09:59' 45 304 583
'03-Sep-2021 15:15:00' 45 377 562
'03-Sep-2021 15:20:00' 45 450 537.670000000000
'03-Sep-2021 15:24:59' 45 478 505
'03-Sep-2021 15:29:59' 45 307 497.820000000000
'03-Sep-2021 15:35:00' 45 293 480
'03-Sep-2021 15:40:00' 45 132 461.780000000000
'03-Sep-2021 15:45:00' 45 239 440
'03-Sep-2021 15:49:59' 45 414 418
'03-Sep-2021 15:54:59' 44.9900000000000 276 396.820000000000
'03-Sep-2021 16:00:00' 44 250 379
'03-Sep-2021 16:05:00' 44 221 359.800000000000
'03-Sep-2021 16:09:59' 44 180 340
'03-Sep-2021 16:14:59' 44 291 316
'03-Sep-2021 16:20:00' 44 201 296.740000000000
'03-Sep-2021 16:25:00' 44 180 277
'03-Sep-2021 16:30:00' 44 126 257.850000000000
'03-Sep-2021 16:34:59' 44 255 236
'03-Sep-2021 16:39:59' 44 198 219.810000000000
'03-Sep-2021 16:45:00' 44 332 201
'03-Sep-2021 16:50:00' 44 151 182
'03-Sep-2021 16:54:59' 44 72 163.850000000000
'03-Sep-2021 16:59:59' 44 117 149
'03-Sep-2021 17:05:00' 43 208 133.850000000000
'03-Sep-2021 17:10:00' 43 257 119
'03-Sep-2021 17:15:00' 43 280 106
'03-Sep-2021 17:19:59' 43 85 91.8800000000000
'03-Sep-2021 17:24:59' 43 145 80
'03-Sep-2021 17:30:00' 43 131 68.9000000000000
'03-Sep-2021 17:35:00' 43 63 59
'03-Sep-2021 17:39:59' 43 59 49.9200000000000
'03-Sep-2021 17:44:21' 0 0 0
'03-Sep-2021 17:44:59' 43 141 42
'03-Sep-2021 17:50:00' 42 271 35
'03-Sep-2021 17:55:00' 42 202 27.9400000000000
'03-Sep-2021 18:00:00' 42 133 22
'03-Sep-2021 18:04:59' 41 203 15.9500000000000
'03-Sep-2021 18:09:59' 41 88 11
'03-Sep-2021 18:15:00' 41 191 6
'03-Sep-2021 18:20:00' 41 187 0.990000000000000
'03-Sep-2021 18:24:59' 41 66 0
'03-Sep-2021 18:29:59' 41 73 0
'03-Sep-2021 18:35:00' 40.9900000000000 189 0
'03-Sep-2021 18:40:00' 40 95 0
'03-Sep-2021 18:45:00' 40 72 0
'03-Sep-2021 18:49:59' 40 59 0
'03-Sep-2021 18:54:59' 40 67 0
'03-Sep-2021 19:00:00' 0 0 0
'03-Sep-2021 19:05:00' 0 0 0
'03-Sep-2021 19:09:59' 0 0 0
'03-Sep-2021 19:14:59' 0 0 0
'03-Sep-2021 19:20:00' 0 0 0
'03-Sep-2021 19:25:00' 0 0 0
'03-Sep-2021 19:30:00' 0 0 0
'03-Sep-2021 19:34:59' 0 0 0
'03-Sep-2021 19:39:59' 0 0 0
'03-Sep-2021 19:45:00' 0 0 0
'03-Sep-2021 19:50:00' 0 0 0
'03-Sep-2021 19:54:59' 0 0 0
'03-Sep-2021 19:59:59' 0 0 0
'03-Sep-2021 20:05:00' 0 0 0
'03-Sep-2021 20:10:00' 0 0 0
'03-Sep-2021 20:15:00' 0 0 0
'03-Sep-2021 20:19:59' 0 0 0
'03-Sep-2021 20:24:59' 0 0 0
'03-Sep-2021 20:30:00' 0 0 0
'03-Sep-2021 20:35:00' 0 0 0
'03-Sep-2021 20:39:59' 0 0 0
'03-Sep-2021 20:44:59' 0 0 0
'03-Sep-2021 20:50:00' 0 0 0
'03-Sep-2021 20:55:00' 0 0 0
'03-Sep-2021 21:00:00' 0 0 0
'03-Sep-2021 21:04:59' 0 0 0
'03-Sep-2021 21:09:59' 0 0 0
'03-Sep-2021 21:15:00' 0 0 0
'03-Sep-2021 21:20:00' 0 0 0
'03-Sep-2021 21:24:59' 0 0 0
'03-Sep-2021 21:29:59' 0 0 0
'03-Sep-2021 21:35:00' 0 0 0
'03-Sep-2021 21:40:00' 0 0 0
'03-Sep-2021 21:45:00' 0 0 0
'03-Sep-2021 21:49:59' 0 0 0
'03-Sep-2021 21:54:59' 0 0 0
'03-Sep-2021 22:00:00' 0 0 0
'03-Sep-2021 22:05:00' 0 0 0
'03-Sep-2021 22:09:59' 0 0 0
'03-Sep-2021 22:14:59' 0 0 0
'03-Sep-2021 22:20:00' 0 0 0
'03-Sep-2021 22:25:00' 0 0 0
'03-Sep-2021 22:30:00' 0 0 0
'03-Sep-2021 22:34:59' 0 0 0
'03-Sep-2021 22:39:59' 0 0 0
I have similar data to this for 6 months with time interval of 5 minutes. I want to extract data corresponding to time 6:00 hrs to 18:00 hrs for each day and perform certain calculations.

Sign in to answer this question.

Answers (2)

Chunru
Chunru on 21 Apr 2022
Ran in:
Save your data into a text file: data.txt
x = readtable("data.txt");
a= strrep(string(x.Var1) + " " + string(x.Var2), "'", "" );
dt = datetime(a);
idx= (hour(dt)>=6) & (hour(dt)<=18);
y=x(idx, :)
y = 471×5 table
Var1 Var2 Var3 Var4 Var5 ________________ _____________ ____ ____ ______ {''01-Sep-2021'} {'06:00:00''} 31 0 17 {''01-Sep-2021'} {'06:04:59''} 30 142 23.07 {''01-Sep-2021'} {'06:09:59''} 30 13 30 {''01-Sep-2021'} {'06:15:00''} 29 3 41.1 {''01-Sep-2021'} {'06:20:00''} 29 0 51 {''01-Sep-2021'} {'06:24:59''} 29 6 63 {''01-Sep-2021'} {'06:29:59''} 30 2 75.14 {''01-Sep-2021'} {'06:35:00''} 30 0 89 {''01-Sep-2021'} {'06:40:00''} 30 0 103.15 {''01-Sep-2021'} {'06:45:00''} 30 23 118 {''01-Sep-2021'} {'06:49:59''} 30 88 135 {''01-Sep-2021'} {'06:54:59''} 31 0 152.18 {''01-Sep-2021'} {'07:00:00''} 31 0 170 {''01-Sep-2021'} {'07:05:00''} 31 0 189.2 {''01-Sep-2021'} {'07:09:59''} 31 1 209 {''01-Sep-2021'} {'07:14:59''} 31 0 230
Campion Loong
Campion Loong on 18 May 2022
Ran in:
Use timetable's logical or time-based subscripting to address your data with time expressively
% Some clean up at import since this reuses @Chunru's data.txt example file
opts = detectImportOptions("data.txt",'Delimiter',"\t"); % Use only 'tab' to delimit import
opts = setvaropts(opts,'Var1', 'Type','datetime', 'Prefixes',"'", 'Suffixes',"'"); % Remove the quotes around the date/timestamp
opts.VariableNames = ["Time" "Var1" "Var2" "Var3"]; % my personal naming preference
tt = readtimetable("data.txt",opts) % Read into MATLAB as timetable
tt = 852×3 timetable
Time Var1 Var2 Var3 ____________________ ____ ____ ____ 01-Sep-2021 00:00:00 0 0 0 01-Sep-2021 00:04:59 0 0 0 01-Sep-2021 00:09:59 0 0 0 01-Sep-2021 00:15:00 0 0 0 01-Sep-2021 00:20:00 0 0 0 01-Sep-2021 00:24:59 0 0 0 01-Sep-2021 00:29:59 0 0 0 01-Sep-2021 00:35:00 0 0 0 01-Sep-2021 00:40:00 0 0 0 01-Sep-2021 00:45:00 0 0 0 01-Sep-2021 00:49:59 0 0 0 01-Sep-2021 00:54:59 0 0 0 01-Sep-2021 01:00:00 0 0 0 01-Sep-2021 01:05:00 0 0 0 01-Sep-2021 01:09:59 0 0 0 01-Sep-2021 01:14:59 0 0 0
% Pull data from all dates when Time-of-Day is between 6th and 18th hour
tt(timeofday(tt.Time)>hours(6) & timeofday(tt.Time)<hours(18),:)
ans = 432×3 timetable
Time Var1 Var2 Var3 ____________________ _____ ____ ______ 01-Sep-2021 06:04:59 30 142 23.07 01-Sep-2021 06:09:59 30 13 30 01-Sep-2021 06:15:00 29 3 41.1 01-Sep-2021 06:20:00 29 0 51 01-Sep-2021 06:24:59 29 6 63 01-Sep-2021 06:29:59 30 2 75.14 01-Sep-2021 06:35:00 30 0 89 01-Sep-2021 06:40:00 30 0 103.15 01-Sep-2021 06:45:00 30 23 118 01-Sep-2021 06:49:59 30 88 135 01-Sep-2021 06:54:59 31 0 152.18 01-Sep-2021 07:00:00 31 0 170 01-Sep-2021 07:05:00 31 0 189.2 01-Sep-2021 07:09:59 31 1 209 01-Sep-2021 07:14:59 31 0 230 01-Sep-2021 07:20:00 31.01 0 249.21
Check out timerange & withtol as well for other rich time-based subscripting

Categories

Find more on Axes Appearance in Help Center and File Exchange

Tags

Products


Release

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!