Database
[{"_id":"1","instance":"172.00.00.01","client":"A","date":ISODate("2020-12-06T22:47:00.163Z"),"app":0.0133317},{"_id":"2","instance":"172.00.00.01","client":"A","date":ISODate("2020-12-06T22:47:03.163Z"),"app":0.0400000},{"_id":"3","instance":"172.00.00.02","client":"B","date":ISODate("2020-12-06T22:47:00.163Z"),"app":0.0800000}]
Query
db.collection.aggregate([{"$group":{"_id":{"minute":{"$minute":{"date":"$date","timezone":"America/Chicago"}},"hour":{"$hour":{"date":"$date","timezone":"America/Chicago"}},"day":{"$dayOfMonth":{"date":"$date","timezone":"America/Chicago"}},"month":{"$month":{"date":"$date","timezone":"America/Chicago"}},"year":{"$year":{"date":"$date","timezone":"America/Chicago"}},instance:"$instance",client:"$client"},app:{$max:"$app"}}},{$group:{_id:{day:"$_id.day",hour:"$_id.hour",minute:"$_id.minute",month:"$_id.month","year":"$_id.year"},data:{$push:{k:"$_id.instance",v:"$app"}}}},{$addFields:{data:{"$arrayToObject":"$data"}}},{"$replaceRoot":{"newRoot":{"$mergeObjects":["$data","$$ROOT"]}}},{$project:{data:0}}])