[{"_id":{"$oid":"6334cefd0048787d5535ff16"},"type":"CASH_OUT","postBalance":{"$numberDecimal":"23287.625"},"createdAt":{"$date":{"$numberLong":"1664405245000"}},},{"_id":{"$oid":"6334d438c1ab8a577677cbf3"},"userID":{"$oid":"62f27bc29f51747015fdb941"},"aggregatorID":"0000116","transactionFee":{"$numberDecimal":"0.0"},"createdAt":{"$date":{"$numberLong":"1664405245000"}},"type":"AIRTIME_VTU","postBalance":{"$numberDecimal":"2114.675"},"walletHistoryID":613266,"walletID":1720,"walletActionAt":{"$date":{"$numberLong":"1664406584000"}},},{"type":"FUNDS_TRANSFER","postBalance":{"$numberDecimal":"36566.39"},"createdAt":{"$date":{"$numberLong":"1664407090000"}}}]

db.collection.aggregate([{$match:{createdAt:{$gte:ISODate("2022-09-15T00:00:00.000Z"),$lt:ISODate("2022-09-30T00:00:00.000Z")}}},{$group:{_id:"$type",createdAt:{$first:"$createdAt"},totalAmount:{$sum:"$postBalance"}}},{$group:{_id:0,createdAt:{$first:"$createdAt"},data:{$push:{k:"$_id",v:"$totalAmount"}}}},{$project:{data:{$arrayToObject:"$data"},createdAt:1,_id:0}},{$set:{"data.date":"$createdAt"}},{$replaceRoot:{newRoot:"$data"}}])