Average hourly value from time series data

[grant1]

Maybe start here and build your query in InfluxQL or Flux and see what it looks like. Am sure others can help once you post your results (and if you still need help).