Запрос на выборку данных с группировкой по суткам

SELECT date_trunc('hour',id.datetime) AS Дата,
MIN(channel35.val) AS ГЛ_V,
MIN(channel36.val) AS ГП_V
FROM
((SELECT datetime FROM cnldata) id LEFT JOIN
(SELECT datetime, val FROM cnldata WHERE cnlnum=35) channel35 ON channel35.datetime=id.datetime LEFT JOIN
(SELECT datetime, val FROM cnldata WHERE cnlnum=36) channel36 ON channel36.datetime=id.datetime)
WHERE
id.datetime BETWEEN '2017-01-01 09:00:00' AND '2018-01-03 09:10:00'
GROUP BY date_trunc('hour',id.datetime)
ORDER BY date_trunc('hour',id.datetime) ASC

SELECT * FROM action_log.actions WHERE response_time > '2018-10-10 13:32:52'::TIMESTAMP AND response_time < '2018-10-13 13:32:52'::TIMESTAMP;

SELECT dt + '9 hours'::INTERVAL AS dt, COALESCE(ch35, 0), COALESCE(ch36, 0)
FROM
(SELECT date_trunc('hour', d.datetime - '9 hours'::INTERVAL) AS dt, 
MIN(CASE d.cnlnum WHEN 35 THEN d.val ELSE NULL END) AS ch35,
MIN(CASE d.cnlnum WHEN 36 THEN d.val ELSE NULL END) AS ch36
FROM cnldata AS d WHERE d.cnlnum IN (35,36)
GROUP BY date_trunc('hour', d.datetime - '9 hours'::INTERVAL)) AS X
ORDER BY dt;

AND datetime BETWEEN 'XXX' AND 'YYY'

SELECT dt + '9 hours'::INTERVAL AS Дата, COALESCE(ch35, 0) AS ГЛ_V , COALESCE(ch36, 0) AS ГП_V
FROM
(SELECT date_trunc('day', d.datetime - '9 hours'::INTERVAL) AS dt, 
MIN(CASE d.cnlnum WHEN 35 THEN d.val ELSE NULL END) AS ch35,
MIN(CASE d.cnlnum WHEN 36 THEN d.val ELSE NULL END) AS ch36
FROM cnldata AS d WHERE d.cnlnum IN (35,36) AND 
datetime BETWEEN '2017-01-01 09:00:00' AND '2017-01-05 09:10:00'
GROUP BY date_trunc('day', d.datetime - '9 hours'::INTERVAL)) AS X
ORDER BY dt;