[{"_id":"ObjectId(\"5fec31b6b9022035abbbf7cc\")","message":{"date":"2020-12-30 13:20:26","time":"2020-12-30T07:50:26.000Z","ID":"005","P":1.36}},{"_id":"ObjectId(\"5fec31b5b9022035abbbf7c2\")","message":{"date":"2020-12-30 13:20:24","time":"2020-12-30T07:50:24.000Z","ID":"005","P":1.5}},{"_id":"ObjectId(\"5fec31b0b9022035abbbf7b3\")","message":{"date":"2020-12-30 13:20:19","time":"2020-12-30T07:35:19.000Z","ID":"005","P":1.63}}]

db.collection.aggregate([{$addFields:{"message.time":{$toDate:"$message.time"}}},{"$group":{"_id":{"year":{"$year":"$message.time"},"dayOfYear":{"$dayOfYear":"$message.time"},"hour":{"$hour":"$message.time"},"interval":{"$subtract":[{"$minute":"$message.time"},{"$mod":[{"$minute":"$message.time"},15]}]}},"count":{"$sum":1},"average":{"$avg":"$message.P"}}}])