[{"_id":ObjectId("5dd271d30c90441941eb92b1"),"h_id":NumberInt(1),"ota":NumberInt(1),"search_date":ISODate("2019-09-09"),"data":[{"price":NumberInt(12500),"code":"02246933",},{"price":NumberInt(11500),"code":"02246934",},{"price":NumberInt(13500),"code":"02246935",},{"price":NumberInt(14500),"code":"02246936",}]},{"_id":ObjectId("5dd271d30c90441941eb92b2"),"h_id":NumberInt(1),"ota":NumberInt(1),"search_date":ISODate("2019-09-10"),"data":[{"price":NumberInt(2500),"code":"102246933",},{"price":NumberInt(1500),"code":"102246934",},{"price":NumberInt(3500),"code":"102246935",},{"price":NumberInt(4500),"code":"102246936",}]},{"_id":ObjectId("5dd271d30c90441941eb92b3"),"h_id":NumberInt(1),"ota":NumberInt(2),"search_date":ISODate("2019-09-09"),"data":[{"price":NumberInt(12500),"code":"02246933",},{"price":NumberInt(11500),"code":"02246934",},{"price":NumberInt(13500),"code":"02246935",},{"price":NumberInt(14500),"code":"02246936",}]},{"_id":ObjectId("5dd271d30c90441941eb92b4"),"h_id":NumberInt(1),"ota":NumberInt(2),"search_date":ISODate("2019-09-10"),"data":[{"price":NumberInt(2500),"code":"102246933",},{"price":NumberInt(1500),"code":"102246934",},{"price":NumberInt(3500),"code":"102246935",},{"price":NumberInt(4500),"code":"102246936",}]},{"_id":ObjectId("5dd271d30c90441941eb92b5"),"h_id":NumberInt(2),"ota":NumberInt(1),"search_date":ISODate("2019-09-09"),"data":[{"price":NumberInt(18500),"code":"02246933",},{"price":NumberInt(11500),"code":"02246934",},{"price":NumberInt(10500),"code":"02246935",},{"price":NumberInt(14500),"code":"02246936",}]},{"_id":ObjectId("5dd271d30c90441941eb92b6"),"h_id":NumberInt(2),"ota":NumberInt(1),"search_date":ISODate("2019-09-10"),"data":[{"price":NumberInt(2500),"code":"102246933",},{"price":NumberInt(8500),"code":"102246934",},{"price":NumberInt(3200),"code":"102246935",},{"price":NumberInt(4500),"code":"102246936",}]},{"_id":ObjectId("5dd271d30c90441941eb92b7"),"h_id":NumberInt(2),"ota":NumberInt(2),"search_date":ISODate("2019-09-09"),"data":[{"price":NumberInt(10500),"code":"02246933",},{"price":NumberInt(18500),"code":"02246934",},{"price":NumberInt(17500),"code":"02246935",},{"price":NumberInt(11500),"code":"02246936",}]},{"_id":ObjectId("5dd271d30c90441941eb92b8"),"h_id":NumberInt(2),"ota":NumberInt(2),"search_date":ISODate("2019-09-10"),"data":[{"price":NumberInt(5500),"code":"102246933",},{"price":NumberInt(1500),"code":"102246934",},{"price":NumberInt(800),"code":"102246935",},{"price":NumberInt(2500),"code":"102246936",}]}]

db.collection.aggregate([{$unwind:"$data"},{$sort:{"data.price":1}},{$group:{_id:{h_id:"$h_id",ota:"$ota",search_date:"$search_date"},"min_price":{$first:"$data.price"},"min_code":{$first:"$data.code"},"max_price":{$last:"$data.price"},"max_code":{$last:"$data.code"},}},{$group:{_id:{h_id:"$_id.h_id",ota:"$_id.ota",},search_date_group:{$push:{"search_date":"$_id.search_date","max_code":"$max_code","max_price":"$max_price","min_code":"$min_code","min_price":"$min_price",}}}},{$group:{_id:{h_id:"$_id.h_id",},"ota_group":{$push:{ota:"$_id.ota",search_date_group:"$search_date_group"}}}}])