Database

[{"_id":"AQ106_2020-09-12T09","date":"2020-09-12T09:00:00.000Z","station":{"name":"AQ106","loc":{"type":"Point","coordinates":[14.339263,40.814224]},"properties":{}},"samples":[{"t":"2020-09-12T11:02:00.000+02:00","data":{"pm1_mg_m3":2.7,"pm2_5_mg_m3":4.6,"pm10_mg_m3":12,"P0":152,"P1":16,"P2":4.7,"P3":0.8,"P4":0.86,"P5":0.6,"P6":0.28,"P7":0.152,"P8":0.094,"P9":0.092,"P10":0.019,"P11":0,"P12":0,"P13":0.0188,"P14":0,"P15":0,"P16":0,"P17":0,"P18":0,"P19":0,"P20":0,"P21":0,"P22":0,"P23":0,"temp_celsius":32.59,"humRelPercent":34,"press_mBar":1010.79,"CO2mA":4,"NO2_WE_mV":226.419,"NO2_AE_mV":229.553,"OX_WE_mV":252.287,"OX_AE_mV":220.419,"CO_WE_mV":509.077,"AE_WE_mV":348.51,"batt_V":13.5,"source_V":17.6}},{"t":"2020-09-12T11:04:00.000+02:00","data":{"pm1_mg_m3":2.8,"pm2_5_mg_m3":5.6,"pm10_mg_m3":18,"P0":150,"P1":18,"P2":4.7,"P3":0.9,"P4":0.85,"P5":0.4,"P6":0.38,"P7":0.252,"P8":0.194,"P9":0.082,"P10":0.049,"P11":0.0568,"P12":0.0705,"P13":0.0488,"P14":0,"P15":0,"P16":0,"P17":0,"P18":0,"P19":0,"P20":0,"P21":0,"P22":0,"P23":0,"temp_celsius":30.04,"humRelPercent":38,"press_mBar":1010.79,"CO2mA":9,"NO2_WE_mV":230.419,"NO2_AE_mV":329.553,"OX_WE_mV":350.287,"OX_AE_mV":120.419,"CO_WE_mV":600.077,"AE_WE_mV":240.51,"batt_V":12.8,"source_V":17.7}}]},{"_id":"AQ100_2020-09-12T10","date":"2020-09-12T10:00:00.000Z","station":{"name":"AQ100","loc":{"type":"Point","coordinates":[14.339263,40.814224]},"properties":{}},"samples":[{"t":"2020-09-12T10:02:00.000+02:00","data":{"pm1_mg_m3":2.8,"pm2_5_mg_m3":6,"pm10_mg_m3":10,"AE_WE_mV":340.51,"batt_V":14.5,"source_V":15.6,"temp_celsius":30.21,"humRelPercent":24,"press_mBar":1013.61,}},{"t":"2020-09-12T10:04:00.000+02:00","data":{"pm1_mg_m3":5.6,"pm2_5_mg_m3":11,"pm10_mg_m3":20,"AE_WE_mV":348.51,"batt_V":13.5,"source_V":17.6,"temp_celsius":33.34,"humRelPercent":34,"press_mBar":1013.00,}}]}]

Query

db.collection.aggregate([{$match:{"station.name":"AQ106"}},{$unwind:{path:"$samples"}},{$group:{_id:"$date",P0:{$avg:"$samples.data.P0"},temp:{$avg:"$samples.data.temp_celsius"}}}])

Result