Contents

SELECT game_id,
       time_bucket(INTERVAL '1 hour', created_at) AS bucket,
       AVG(score),
       MAX(score),
       MIN(score)
FROM plays
GROUP BY game_id, bucket;

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
timescaledb-0.2.6	examples/ranking/db/views/score_per_hours_v01.sql
timescaledb-0.2.5	examples/ranking/db/views/score_per_hours_v01.sql
timescaledb-0.2.4	examples/ranking/db/views/score_per_hours_v01.sql
timescaledb-0.2.3	examples/ranking/db/views/score_per_hours_v01.sql
timescaledb-0.2.2	examples/ranking/db/views/score_per_hours_v01.sql
timescaledb-0.2.1	examples/ranking/db/views/score_per_hours_v01.sql
timescaledb-0.2.0	examples/ranking/db/views/score_per_hours_v01.sql