Database
[{"timestamp":ISODate("2024-01-01T00:00:00Z"),"schema":"1.0.0","value":3},{"timestamp":ISODate("2024-01-01T01:00:00Z"),"schema":"1.2.0","value":-10}]
Query
db.collection.aggregate([{"$group":{"_id":{"bucket":{$toDate:{$subtract:[{$toLong:"$timestamp"},{$mod:[{$toLong:"$timestamp"},86400000]}]}}},"maxValue":{"$max":"$value"},"minValue":{"$min":"$value"}}},{"$project":{"_id":0,"bucket":"$_id.bucket","maxValue":1,"minValue":1}}])