[{"_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"},"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([{$project:{type:1,createdAt:1}},{$match:{$and:[{createdAt:{$gte:ISODate("2022-09-15T00:00:00.000Z"),$lt:ISODate("2022-09-16T00:00:00.000Z")}},{type:"CASH_OUT"}]}},{$group:{_id:{createdAt:{$last:"$createdAt"}},totalAmount:{$sum:"$postBalance"},}}])