Solved:
The order in which points are connected by lines depends on the ordering of the points in the table returned by the query. Adding an “ORDER BY time” to my query solved this.
Thank you to agnestoulet1 from this thread
1 Like