[{"_id":ObjectId("60a2c0621e5f043b735e36ef"),"car_id":78,"terminal":"JFK","timestamp":ISODate("2020-01-01T17:00:00.000Z"),},{"_id":ObjectId("60a2c0621e5f043b735e36f0"),"car_id":78,"terminal":"LAX","timestamp":ISODate("2020-02-08T17:00:00.000Z"),},{"_id":ObjectId("60a2c0621e5f043b735e36f1"),"car_id":78,"terminal":"ORD","timestamp":ISODate("2020-03-01T17:00:00.000Z"),},{"_id":ObjectId("60a2c0621e5f043b735e36f2"),"car_id":79,"terminal":"MIA","timestamp":ISODate("2020-02-11T17:00:00.000Z"),},{"_id":ObjectId("60a2c0621e5f043b735e36f3"),"car_id":79,"terminal":"ORD","timestamp":ISODate("2020-03-21T17:00:00.000Z"),},{"_id":ObjectId("60a2c0621e5f043b735e36f4"),"car_id":81,"terminal":"JFK","timestamp":ISODate("2020-08-01T17:00:00.000Z"),},]

db.collection.aggregate([{"$match":{"$or":[{"car_id":78,"timestamp":{"$lte":ISODate("2020-02-09T00:00:00.000Z")}},{"car_id":79,"timestamp":{"$lte":ISODate("2020-03-22T00:00:00.000Z")}}]}},{"$sort":{"timestamp":1}},{"$group":{"_id":"$car_id","last":{"$last":"$$ROOT"}}}])