[{_id:ObjectId("63a318c36ccc42d2330fae5c"),code:19,timestamp:ISODate("2022-12-21T14:30:31.172Z"),value:3.8},{_id:ObjectId("63a318c46ccc42d2330fae8d"),code:19,timestamp:ISODate("2022-12-21T14:30:32.189Z"),value:4.0},{_id:ObjectId("63a318c46ccc42d2330fae8a"),code:19,timestamp:ISODate("2022-12-21T14:35:32.189Z"),value:54.0},{_id:ObjectId("63a318c36ccc42d2330fae5e"),code:19,timestamp:ISODate("2022-12-21T15:30:14.025Z"),value:5.0},{_id:ObjectId("63a318c36ccc42d2330fae5f"),code:19,timestamp:ISODate("2022-12-21T15:30:18.025Z"),value:5.5},{_id:ObjectId("63a318c46ccc42d2330fae8e"),code:37,timestamp:ISODate("2022-12-21T14:30:32.189Z"),value:24.0},]

db.collection.aggregate([{$set:{cleanTimeStamp:{$dateTrunc:{date:"$timestamp",unit:"minute",}}}},{$setWindowFields:{partitionBy:"$code",sortBy:{cleanTimeStamp:1},output:{valueLast:{$avg:"$value",window:{range:[59,60],unit:"minute"}}}}},{$set:{gainPct:{$round:[{$divide:[{$subtract:["$valueLast","$value"]},"$value"]},3]},cleanTimeStamp:"$$REMOVE"}}])