Spreadsheet: 780505d1652499383-how-to-count-rows-by-the-hour-by-the-day-table
Sheet: Sheet1

Date | Number | Number | DeviceId | [NAME] | LaneType | Date
2019-05-01 05:22:50.490000 | HPC508 | 2125551212 | 101 | 1 | Entry | 2019-05-01 05:22:50.490000 | 2019-05-01 00:00:00
2019-05-01 05:29:10.027000 | 24C220 | 4565554545 | 101 | 1 | Entry | 2019-05-01 05:29:10.027000 | 2019-05-02 00:00:00
2019-05-01 05:52:39.790000 | 4WEJ498 | 7878945445 | 102 | 2 | Entry | 2019-05-01 05:52:39.790000 | 2019-05-03 00:00:00
2019-05-01 05:53:58.627000 | HPC509 | 4654678979 | 101 | 1 | Entry | 2019-05-01 05:53:58.627000 | 2019-05-04 00:00:00
2019-05-01 06:10:31.940000 | 24C221 | 9889545644 | 101 | 1 | Entry | 2019-05-01 06:10:31.940000 | 2019-05-05 00:00:00
2019-05-01 06:29:04.657000 | 4WEJ499 | 10507989154.4 | 102 | 2 | Entry | 2019-05-01 06:29:04.657000 | 2019-05-06 00:00:00
2019-05-01 06:45:04.393000 | HPC510 | 12069700484.2 | 101 | 1 | Entry | 2019-05-01 06:45:04.393000 | 2019-05-07 00:00:00
2019-05-01 06:45:41.140000 | 24C222 | 13631411814 | 101 | 1 | Entry | 2019-05-01 06:45:41.140000 | 2019-05-08 00:00:00
2019-05-01 06:52:02.403000 | 4WEJ500 | 15193123143.8 | 102 | 2 | Entry | 2019-05-01 06:52:02.403000 | 2019-05-09 00:00:00
2019-05-01 06:53:49.927000 | HPC511 | 16754834473.6 | 102 | 2 | Entry | 2019-05-01 06:53:49.927000 | 2019-05-10 00:00:00
2019-05-01 06:58:56.077000 | 24C223 | 18316545803.4 | 102 | 2 | Entry | 2019-05-01 06:58:56.077000 | 2019-05-11 00:00:00
2019-05-01 07:00:50.883000 | 4WEJ501 | 19878257133.2 | 102 | 2 | Entry | 2019-05-01 07:00:50.883000 | 2019-05-12 00:00:00
2019-05-01 07:11:45.033000 | HPC512 | 21439968463 | 101 | 1 | Entry | 2019-05-01 07:11:45.033000 | 2019-05-13 00:00:00
2019-05-01 07:24:29.887000 | 24C224 | 23001679792.8 | 101 | 1 | Entry | 2019-05-01 07:24:29.887000 | 2019-05-14 00:00:00
2019-05-02 07:37:40 | 4WEJ502 | 24563391122.6 | 102 | 2 | Entry | 2019-05-02 07:37:40 | 2019-05-15 00:00:00
2019-05-02 07:38:13 | HPC513 | 26125102452.4 | 102 | 2 | Entry | 2019-05-02 07:38:13 | 2019-05-16 00:00:00
2019-05-02 07:40:03 | 24C225 | 27686813782.2 | 102 | 2 | Entry | 2019-05-02 07:40:03 | 2019-05-17 00:00:00
2019-05-03 07:51:56 | 4WEJ503 | 29248525112 | 102 | 2 | Entry | 2019-05-03 07:51:56 | 2019-05-18 00:00:00
2019-05-03 07:51:58 | HPC514 | 30810236441.8 | 101 | 1 | Entry | 2019-05-03 07:51:58 | 2019-05-19 00:00:00
2019-05-03 07:53:59 | 24C226 | 32371947771.6 | 102 | 2 | Entry | 2019-05-03 07:53:59 | 2019-05-20 00:00:00
2019-05-03 07:54:15 | 4WEJ504 | 33933659101.4 | 101 | 1 | Entry | 2019-05-03 07:54:15 | 2019-05-21 00:00:00
2019-05-04 08:01:13 | HPC515 | 35495370431.2 | 102 | 2 | Entry | 2019-05-04 08:01:13 | 2019-05-22 00:00:00
2019-05-04 08:04:34 | 24C227 | 37057081761 | 102 | 2 | Entry | 2019-05-04 08:04:34 | 2019-05-23 00:00:00
2019-05-04 08:04:49 | 4WEJ505 | 38618793090.8 | 101 | 1 | Entry | 2019-05-04 08:04:49 | 2019-05-24 00:00:00
2019-05-05 08:09:41 | HPC516 | 40180504420.6 | 101 | 1 | Entry | 2019-05-05 08:09:41 | 2019-05-25 00:00:00
2019-05-05 08:10:41 | 24C228 | 41742215750.4 | 101 | 1 | Entry | 2019-05-05 08:10:41 | 2019-05-26 00:00:00
2019-05-05 08:17:28 | 4WEJ506 | 43303927080.2 | 101 | 1 | Entry | 2019-05-05 08:17:28 | 2019-05-27 00:00:00