Database
[{"name":"#0","sales":[{"date":"2021-10-14","price":3.69,},{"date":"2021-10-15","price":2.79,}]},{"name":"#1","sales":[{"date":"2021-10-14","price":1.5,},{"date":"2021-10-14","price":2,}]}]
Query
db.collection.aggregate([{$match:{"sales.date":"2021-10-14"}},{$replaceWith:{$arrayElemAt:[{$filter:{input:"$sales",cond:{$eq:["$$this.date","2021-10-14"]}}},0]}}])