SELECT eTime AS 'time', col1, col2 FROM ( SELECT from_unixtime(((floor(UNIX_TIMESTAMP(renTime) / 60)) * 60)) AS eTime, AVG(o2permeg) AS col1, 'null' AS 'col2' , ((floor(UNIX_TIMESTAMP(renTime) / 60)) * 60) as Epoch FROM ren_data WHERE renTime BETWEEN '2017-05-26 00:00:00' AND '2017-05-27 20:29:00' GROUP BY Epoch UNION SELECT from_unixtime(((floor(UNIX_TIMESTAMP(renTime) / 60)) * 60)) AS eTime, 'null' AS 'col1' , AVG(co2ppmv) AS col2, ((floor(UNIX_TIMESTAMP(renTime) / 60)) * 60) as Epoch FROM ren_data WHERE renTime BETwEEN '2017-05-26 00:00:00' AND '2017-05-27 20:29:00' GROUP BY Epoch) AS alias1 ORDER BY alias1.eTime Weybourne Atmospheric Observatory - O<sub>2</sub> and CO<sub>2</sub>

O2 and CO2


(All data displayed are preliminary and have not been subject to quality control)
Resolution = 1 min (subject to source data resolution)