Database
[{"_id":ObjectId("62175a6dd2b42d83134288f0"),"result":[{"name":"Bitcoin","symbol":"BTC","price":45488.969940933,"date":"2022-4-1","time":"16:25:22","active":1},{"name":"Ethereum","symbol":"ETH","price":3328.61487109438,"date":"2022-4-1","time":"16:25:22","active":1}]}]
Query
db.collection.find({result:{$elemMatch:{name:"Bitcoin",date:{$gte:"2022-4-1",$lte:"2022-4-6"}}}},{"result.$":1})