Open1
timestreamのクエリサンプル

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