Skip to content

Latest commit

 

History

History
73 lines (49 loc) · 4.85 KB

README.md

File metadata and controls

73 lines (49 loc) · 4.85 KB


OpenSpartan Wait Times Dataset Logo

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 N/A 🔄 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.

DB Browser for SQLite used to parse the OpenSpartan Wait Times Datasets

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

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