[{"_id":{"$oid":"5f5ea17e103de234587abed9"},"totalPrice":1,"createdAt":{"$date":"2020-09-15T11:00:00.048Z"}},{"_id":{"$oid":"5f5ea186103de234587abedc"},"totalPrice":1,"createdAt":{"$date":"2020-09-15T11:30:00.554Z"}},{"_id":{"$oid":"5f5ea19f103de234587abedf"},"totalPrice":1,"createdAt":{"$date":"2020-09-15T15:00:00.403Z"}},{"_id":{"$oid":"5f5ea1a9103de234587abee4"},"totalPrice":1,"createdAt":{"$date":"2020-09-15T19:48:09.881Z"}},{"_id":{"$oid":"5f5ea403e91ed91a44b62c92"},"totalPrice":1,"createdAt":{"$date":"2020-09-15T19:58:11.035Z"}},{"_id":{"$oid":"5f5ea6276ba53b06944de28c"},"totalPrice":1,"createdAt":{"$date":"2020-09-16T20:07:19.37Z"}},{"_id":{"$oid":"5f5ea7306ba53b06944de28f"},"totalPrice":1,"createdAt":{"$date":"2020-09-16T20:30:00.19Z"}},{"_id":{"$oid":"5f5ea8256ba53b06944de292"},"totalPrice":1,"createdAt":{"$date":"2020-09-14T21:30:00.841Z"}}]

db.collection.aggregate([{$sort:{createdAt:1},},{$group:{_id:null,docs:{$push:{createdAt:"$createdAt",totalPrice:"$totalPrice",missing:false,},},start:{$first:{$toInt:{$divide:[{$subtract:[{$toLong:"$$NOW"},{$multiply:[24,60,60,1000]},],},1000,],},},},end:{$last:{$toInt:{$divide:[{$toLong:"$$NOW"},1000]}},},},},{$addFields:{docs:{$map:{input:{$range:[{$toInt:"$start"},{$add:[{$toInt:"$end"},7200]},/** 2 hours range*/7200,],},as:"ts",in:{ts_exists:{$filter:{input:"$docs",as:"d",cond:{$and:[{$gte:[{$toInt:{$divide:[{$toLong:"$$d.createdAt"},1000],},},{$subtract:["$$ts",7200]},],},{$lt:[{$toInt:{$divide:[{$toLong:"$$d.createdAt"},1000],},},"$$ts",],},],},},},ts:"$$ts",},},},},},{$unwind:"$docs",},{$project:{_id:0,y:{$reduce:{input:"$docs.ts_exists",initialValue:0,in:{$add:["$$value","$$this.totalPrice"]},},},x:{$dateToString:{format:"%Y-%m-%d %H:%M",date:{$toDate:{$multiply:["$docs.ts",1000]}},},},},},])