Database

[{"_meta":{"information":"some info","symbol":"someSymbol",},"array":[{"date":"2021-01-29","value":"719.4600"},{"date":"2019-09-30","value":"224.0800"},{"date":"2017-09-29","value":"356.1200",},],},{"_meta":{"information":"some info","symbol":"someSymbol",},"array":{"date":"2019-09-30","value":"224.0800"},}]

Query

db.collection.aggregate([{"$project":{"array":{"$filter":{"input":{"$cond":{"if":{"$eq":[{"$type":"$array"},"array"]},"then":"$array","else":["$array"],}},"as":"a","cond":{"$and":[{"$lte":["$$a.date","2020"]},{"$gte":["$$a.date","2016"]}]}}}}}])

Result