OpenSpartan Wait Times Datasets

An open-source dataset of Halo Infinite wait times powered by OpenSpartan tooling.

Overview

This repository contains historical data sets for Halo Infinite match times, as captured from the United States west coast.

While the data is not necessarily capturing the global wait times, it can be used as a reasonable reference point for wait times for various playlists available through each of the Halo Infinite operations since the start of tracking on the OpenSpartan side.

Datasets

🎖️ Event/Operation	📆 Timeframe	📦 Dataset	📝 Notes
Banished Honor	April 30, 2024 - June 4, 2024	banished-honor-wait-times.db	✅ Data has a few gaps as data collection tool issues were addressed.
Tenrai IV	June 4, 2024 - July 2, 2024	tenrai-iv-wait-times.db	✅ Data has a few gaps as data collection tool issues were addressed.
Anvil	July 2, 2024 - July 30, 2024	anvil-wait-times.db	✅ Data collection complete. Minimal gaps.
Fleetcom	July 30, 2024 - September 3, 2024	fleetcom-wait-times.db	✅ Data collection complete. Minimal gaps.
Champions	September 3, 2024 - October 8, 2024	champions-wait-times.db	✅ Data collection complete. Minimal gaps.
Haloween	October 8, 2024 - November 5, 2024	haloween-wait-times.db	✅ Data collection complete. Minimal gaps.
Great Journey	November 5, 2024 - December 2, 2024	great-journey-wait-times.db	✅ Data collection complete. Some gaps.
Snowbound	December 2, 2024 - January 7, 2025	📈 Data collection in progress.	📈 Data collection in progress.

Analyzing the data

Every single dataset available in this repository is a SQLite database. You can query it from any language or framework that supports SQLite, and even make pretty graphs with Jupyter notebooks and Python.

There are two tables in each datasets:

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.

You can also analyze the data with the help of a tool like DB Browser for SQLite.

FAQ

I see that some data is missing in the Banished Honor and Tenrai IV datasets. What's up with that?

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.

Can you share the tool that captured this data?

Planning on doing this in the future. For the time being, you can familiarize yourself with the process on my blog.

Can I use this data to render wait time graphs?

Yes. What I have here is the raw data - you can use it to slice and dice the metrics as you see fit.

Data is captured for the US west coast. Do you have plans for capturing metrics for other time zones or regions?

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.

Other tools

• OpenSpartan Workshop
• OpenSpartan XUID Resolver
• OpenSpartan Career Rank Extractor

To see the latest on supported tools and data, refer to the official OpenSpartan site and my blog.