By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| timestamp | val | typerow |
|---|---|---|
| 2018-06-03 13:30:00.000 | 6 | out |
| 2018-06-03 14:10:00.000 | 8 | out |
| 2018-06-03 14:30:00.000 | 17 | in |
| 2018-06-03 15:00:00.000 | 9 | out |
| 2018-06-03 15:30:00.000 | 4 | out |
| 2018-06-03 16:00:00.000 | 2 | out |
| 2018-06-03 17:05:00.000 | 23 | in |
| 2018-06-03 17:30:00.000 | 0 | out |
| 2018-06-03 18:15:00.000 | 7 | out |
| 2018-06-03 18:30:00.000 | 8 | in |
| 2018-06-03 19:00:00.000 | 5 | out |