Database
[{"_id":"Stock1","data":[{"value":10.0,"date":"2000-01-01T00:00:00.000Z"},{"value":12.0,"date":"2010-01-01T00:00:00.000Z"},{"value":14.0,"date":"2020-01-01T00:00:00.000Z"}]},{"_id":"Stock2","data":[{"value":10.0,"date":"2000-01-01T00:00:00.000Z"},{"value":8.0,"date":"2010-01-01T00:00:00.000Z"},{"value":6.0,"date":"2020-01-01T00:00:00.000Z"}]},{"_id":"Stock3","data":[{"value":10.0,"date":"2000-01-01T00:00:00.000Z"},{"value":10.0,"date":"2010-01-01T00:00:00.000Z"},{"value":10.0,"date":"2020-01-01T00:00:00.000Z"}]}]
Query
db.collection.aggregate([{"$match":{"_id":{"$in":["Stock1","Stock3"]}}},{"$project":{"data":{"$filter":{"input":"$data","as":"d","cond":{"$and":[{"$gte":[{"$toDate":"$$d.date"},ISODate("2010-01-01")]},{"$lte":[{"$toDate":"$$d.date"},ISODate("2020-01-01")]}]}}}}}])