Data explorer

SELECT
  time_bucket('1h', ts) AS hour,
  AVG(value) AS avg_flow
FROM tag_history
WHERE tag = 'line2.filler.flowrate'
  AND ts > NOW() - INTERVAL '24 hours'
GROUP BY hour
ORDER BY hour;