July 8, 2024 in Data by Den Delimarsky3 minutes
Get a glimpse into the aggregated playlist wait times for Halo Infinite.
Starting today, you can access OpenSpartan Wait Time Datasets - an open-source effort to aggregate and track playlist wait times for Halo Infinite.
Explore the currently captured wait times.
Starting with Banished Honor and Tenrai IV, and continuing with future operations, this collection will contain snapshots of playlist wait times in 10 minute increments, allowing anyone to easily see the changes in wait times over the span of an operation.
The GitHub repository contains data in the datasets
folder, where you can find SQLite databases for each operation for which wait time data was captured. Because the data is captured in an open format, you can use a myriad of tools to query and render it, such as Jupyter notebooks with Python and even dedicated tools like DB Browser for SQLite.
Every SQLite database is small enough that it can be queried on even the most low-spec PCs or cloud workloads.
There are two key tables that are of interest:
Table | Description |
---|---|
PlaylistMetadata | Outlines all playlist-related metadata, including playlist asset ID, version ID, name, description, and more. |
WaitTimeSnapshots | Captures playlist wait times, in 10 minute intervals. Data includes snapshot timestamp (PT time zone), asset ID, version ID, and wait time in seconds. |
While for now the data is captured only for the US west coast, I am looking at expanding that in the future to other time zones and regions.
During the data capture I was still stabilizing the tool against issues that resulted in data misses. That resulted in some gaps. Moving forward (starting with the Anvil operation), those gaps should be minimal (if any) and contain the full spectrum of data in 10 minute intervals.
Planning on doing this in the future. For the time being, you can familiarize yourself with the process on my blog.
Yes. What I have here is the raw data - you can use it to slice and dice the metrics as you see fit.
I am currently looking at the best ways to capture this data for other regions, but if the changes are going to be happening, it will be after Anvil. The Anvil data set will contain only PT data captures.
To see the latest on supported tools and data, refer to the official OpenSpartan site and my blog.