SELECT time, value
FROM telemetry
WHERE device.id = 'DEVICE_ID'
  AND datastream.key = 'temperature'
  AND time > now() - 7d
ORDER BY time DESC
LIMIT 100

TIMEZONE 'Asia/Tehran'
SELECT
  bucket(time, 1h) AS hour,
  avg(value) AS average_temperature
FROM telemetry
WHERE datastream.key = 'temperature'
  AND time > now() - 7d
GROUP BY hour
ORDER BY hour

TIMEZONE 'UTC'
SELECT
  bucket(time, 1d) AS day,
  count(value) AS samples
FROM telemetry
WHERE datastream.key = 'temperature'
  AND time > now() - 30d
GROUP BY day