Database

[{"_id":ObjectId("5f889026fa83f52985807c7a"),"Date":"2019-09-26","Time":"13:30:00","Stock":{"open":1733.256,"high":1743.9292,"low":1500.1847,"close":1740.0262,"volume":330114},"Company":"Amazon"},{"_id":ObjectId("5f889026fa83f52985807c8a"),"Date":"2019-09-26","Time":"13:30:00","Stock":{"open":1733.256,"high":1900.9292,"low":1733.1847,"close":1740.0262,"volume":330114},"Company":"Amazon"}]

Query

db.collection.aggregate([{$group:{_id:{"Company":"$Company","Date":"$Date"},"volumeSum":{$sum:"$Stock.volume"},"maxPrice":{$max:"$Stock.high"},"minPrice":{$min:"$Stock.low"},"Count":{"$sum":1}}}])

Result