Open1

timestreamのクエリサンプル

shunshun

1日ごとのデータ数をカウント

SELECT
  bin(time, 1d) AS day,
  COUNT(*) AS count_per_day
FROM "db"."table"
WHERE time BETWEEN from_iso8601_timestamp('2025-03-24T00:00:00Z')
              AND from_iso8601_timestamp('2025-04-01T00:00:00Z')
GROUP BY bin(time, 1d)
ORDER BY day ASC