If you’re a current Enterprise customer or interested in getting a preview of our schema for Enterprise access, here is a list of our tables:
Streams - Every Twitch stream with > 10 viewers going back to May 2020.
Stream Snaps - Ongoing pulls of every stream with 10-minute frequency, providing snapshots of real-time viewers, games played, and other information.
Channels - Information on every channel with at least one stream recorded with > 10 viewers.
Channel Snaps - Daily follower count snapshots of every Twitch channel.
Games - Detailed information on every game and category detected for streams going back to 2016.
Game Snaps - 10-minute snapshot rollups of aggregated game viewership and channel activity across all Twitch streams we've recorded.
Videos - Information on every video associated with a stream we have records for. This is a newer feature, starting in May 2022.
Video Snaps - Trailing 7-day viewership snapshots of every video we've recorded.