Skip to content

Instantly share code, notes, and snippets.

@Naesstrom

Naesstrom/Luftdaten average per hour

Created March 2, 2018 16:47
Show Gist options
  • Save Naesstrom/afcc3c89050938301ed85845ca6b123a to your computer and use it in GitHub Desktop.
Save Naesstrom/afcc3c89050938301ed85845ca6b123a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Luftdaten average per hour
### PM10
SELECT mean("SDS_P1") FROM "feinstaub" WHERE ("node" = 'esp8266-3402380') AND $timeFilter GROUP BY time(1h)
### PM2.5
SELECT mean("SDS_P2") FROM "feinstaub" WHERE ("node" = 'esp8266-3402380') AND $timeFilter GROUP BY time(1h)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment