• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 23:17
CEST 05:17
KST 12:17
  • Home
  • Forum
  • Calendar
  • Streams
  • Liquipedia
  • Features
  • Store
  • EPT
  • TL+
  • StarCraft 2
  • Brood War
  • Smash
  • Heroes
  • Counter-Strike
  • Overwatch
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • StarCraft 2
  • Brood War
  • Blogs
Forum Sidebar
Events/Features
News
Featured News
RSL Season 1 - Final Week4[ASL19] Finals Recap: Standing Tall10HomeStory Cup 27 - Info & Preview18Classic wins Code S Season 2 (2025)16Code S RO4 & Finals Preview: herO, Rogue, Classic, GuMiho0
Community News
Firefly given lifetime ban by ESIC following match-fixing investigation17$25,000 Streamerzone StarCraft Pro Series announced6Weekly Cups (June 30 - July 6): Classic Doubles6[BSL20] Non-Korean Championship 4x BSL + 4x China10Flash Announces Hiatus From ASL70
StarCraft 2
General
RSL Revival patreon money discussion thread The GOAT ranking of GOAT rankings We need to be discussing a new patch right now! Firefly given lifetime ban by ESIC following match-fixing investigation RSL Season 1 - Final Week
Tourneys
RSL: Revival, a new crowdfunded tournament series FEL Cracov 2025 (July 27) - $8000 live event Sparkling Tuna Cup - Weekly Open Tournament $25,000 Streamerzone StarCraft Pro Series announced WardiTV Mondays
Strategy
How did i lose this ZvP, whats the proper response Simple Questions Simple Answers
Custom Maps
[UMS] Zillion Zerglings
External Content
Mutation # 481 Fear and Lava Mutation # 480 Moths to the Flame Mutation # 479 Worn Out Welcome Mutation # 478 Instant Karma
Brood War
General
BW General Discussion A cwal.gg Extension - Easily keep track of anyone ASL20 Preliminary Maps BGH Auto Balance -> http://bghmmr.eu/ Script to open stream directly using middle click
Tourneys
Small VOD Thread 2.0 [Megathread] Daily Proleagues Last Minute Live-Report Thread Resource! [BSL20] Non-Korean Championship 4x BSL + 4x China
Strategy
Simple Questions, Simple Answers I am doing this better than progamers do.
Other Games
General Games
Path of Exile CCLP - Command & Conquer League Project Stormgate/Frost Giant Megathread The PlayStation 5 Nintendo Switch Thread
Dota 2
Official 'what is Dota anymore' discussion
League of Legends
Heroes of the Storm
Simple Questions, Simple Answers Heroes of the Storm 2.0
Hearthstone
Heroes of StarCraft mini-set
TL Mafia
TL Mafia Community Thread Vanilla Mini Mafia
Community
General
US Politics Mega-thread Things Aren’t Peaceful in Palestine Russo-Ukrainian War Thread The Accidental Video Game Porn Archive Stop Killing Games - European Citizens Initiative
Fan Clubs
SKT1 Classic Fan Club! Maru Fan Club
Media & Entertainment
Movie Discussion! [Manga] One Piece Anime Discussion Thread [\m/] Heavy Metal Thread
Sports
2024 - 2025 Football Thread Formula 1 Discussion NBA General Discussion TeamLiquid Health and Fitness Initiative For 2023 NHL Playoffs 2024
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List
Blogs
Men Take Risks, Women Win Ga…
TrAiDoS
momentary artworks from des…
tankgirl
from making sc maps to makin…
Husyelt
StarCraft improvement
iopq
Trip to the Zoo
micronesia
Customize Sidebar...

Website Feedback

Closed Threads



Active: 569 users

Detailed graphs of stream viewer numbers

Forum Index > SC2 General
Post a Reply
Normal
soiii
Profile Joined July 2011
Germany266 Posts
Last Edited: 2012-07-23 21:35:19
July 23 2012 19:46 GMT
#1
Hi everybody,

I spend the last couple of weeks when I had some free time from my studies to build a website I always wanted to have. Its about stream viewer numbers with detailed graphs showing them. The address is sc2streamnumbers.com and here is how it looks:

[image loading]

What you are seeing now is the change in the viewer number over the last hour. The viewer number gets saved every 5 minutes. You can change that to the view of the last 24 hours, the last week or month. As a graph with a point for every 5 minutes in the last month would be quite crowded (8640 points) the site creates average values for the different time resolutions.

You can also go back and forth in time or switch on the auto update to automaticly retrieve updated graphs. Also there is a search function and a list with the current online streams which contains roughly the same streams as the famous tl list available here.

How its done
For the fellow programmers browsing this forum here is how its done from the technical point of view. The page queries the xml view of the tl stream list every 5 minutes and saves all the relevant data in a postgresql database. It also creates all the average values if needed. This is done by a python script.

The website itself is made with Django, a beautiful python web framework. Also I used Jquery for the ajax calls and elycharts for the graphs. I feel like this is a very powerful software stack.

If you are interested in the server side code just write me a pm and I can give you access to my repository.

Advertising
I am aware that this thread might fall under the advertising rule as I am not a very active tl member and it somewhat promotes a website. But please keep in mind that there are no ads on the site and this serves a very niche interest. I dont even own a company or something similiar and never put advertising on the sites I made.

Have a nice day,
soiii
HaXXspetten
Profile Blog Joined October 2009
Sweden15718 Posts
July 23 2012 19:48 GMT
#2
Heh, that's pretty neat actually ^^

gj
nath
Profile Blog Joined May 2010
United States1788 Posts
July 23 2012 19:49 GMT
#3
i wouldnt say that you used a "very powerful software stack", more like one that is easy to use, but not that powerful.

nevertheless, i really like what you've done here
Founder of Flow Enterprises, LLC http://flow-enterprises.com/
soiii
Profile Joined July 2011
Germany266 Posts
July 23 2012 20:44 GMT
#4
Thanks for the positive feedback so far ^.^ If you found bugs or have ideas what could be changed feel free to post it.
dani`
Profile Joined January 2011
Netherlands2402 Posts
July 23 2012 20:51 GMT
#5
Looks quite nice. I'd recommend changing 'hour/day/week/month Before' to 'Previous hour/day/week/month'. Having a capital letter for the second word is weird, and it makes more sense to have previous <=> next as opposed to before <=> next in my opinion
soiii
Profile Joined July 2011
Germany266 Posts
July 23 2012 21:08 GMT
#6
On July 24 2012 05:51 dani` wrote:
Looks quite nice. I'd recommend changing 'hour/day/week/month Before' to 'Previous hour/day/week/month'. Having a capital letter for the second word is weird, and it makes more sense to have previous <=> next as opposed to before <=> next in my opinion

Sounds reasonable and got changed.
skatblast
Profile Joined September 2011
United States784 Posts
July 23 2012 21:11 GMT
#7
looks like a awesome site
Xanatoss
Profile Joined May 2010
Germany539 Posts
July 23 2012 21:20 GMT
#8
As if you read my Mind O.O
I just looked at the upper right corner of TL.net and thought to myself "I wonder how Stream-Viewer numbers are distributed over time."
Would be awesome if you could implement an overall monitor.

Great work! Always jelly about people with these kind of skills.
The chair slowly turns around. You see his face, but it can't be. He's not supposed to be here. Not him. Not a Protoss. Not THAT Protoss. MC says, "Hi Greg, long time no see." You back slowly out of the booth. But you can't. It's already forcefielded.
babybell
Profile Joined June 2011
776 Posts
July 23 2012 21:26 GMT
#9
woowowow well done dude.
very nice visually too.
SoniC_eu
Profile Joined April 2011
Denmark1008 Posts
July 23 2012 21:28 GMT
#10
nice work dood :D
In order to succeed, your desire for success should be greater than your fear of failure. http://da.twitch.tv/sonic_eu
Anta
Profile Joined April 2012
Germany434 Posts
July 23 2012 21:30 GMT
#11
this is amazing!

sc2 community we are the internet has!
"In short: stop bitching, change your tampons and up your game." mad respect to CloudNineLabs.com http://i.imgur.com/g5KGz.jpg ! I love Dreamhack!
ridethecatbus
Profile Joined February 2012
United States64 Posts
Last Edited: 2012-07-23 21:37:35
July 23 2012 21:37 GMT
#12
soiii, that's awesome man! What do you think of adding a Year-to-date button or letting the user set the time parameters?
nakam
Profile Joined April 2010
Sweden245 Posts
July 23 2012 21:43 GMT
#13
I like it! Would be neat with an option to trim times when the person is not streaming and have like a marker in the graph when the person started streaming.
TL Local Timezone Script - http://www.teamliquid.net/forum/viewmessage.php?topic_id=277156
soiii
Profile Joined July 2011
Germany266 Posts
July 23 2012 21:46 GMT
#14
On July 24 2012 06:37 ridethecatbus wrote:
What do you think of adding a Year-to-date button or letting the user set the time parameters?

Making the time parameters more flexible sounds like a good idea. What exactly do you mean with a Year-to-date button?
soiii
Profile Joined July 2011
Germany266 Posts
July 23 2012 21:52 GMT
#15
On July 24 2012 06:43 nakam wrote:
I like it! Would be neat with an option to trim times when the person is not streaming and have like a marker in the graph when the person started streaming.

Changing the time interval by cutting off empty time might be rather complicated but I will look into a feature were you can jump to the times when the stream was active.
Snackysnacks
Profile Joined December 2010
United States411 Posts
July 23 2012 21:55 GMT
#16
I noticed under Weekly/Monthly doesn't have the current day/Up to day stream numbers
I understand if this is intentional but it would be nicer to see the whole month with the last data value being the latest queried entry.
(╯°□°)╯︵ ┻━┻
archonOOid
Profile Blog Joined March 2011
1983 Posts
Last Edited: 2012-07-23 22:18:19
July 23 2012 22:00 GMT
#17
My personal suggestions that you could add: multiple graphs overlapping each other so that you could compare two streamers, customization (favorites, etc) share of the total number of sc2 (individuals not tournament organizers) streamers and finally an option to display the history of popular offline streamers.
I'm Quotable (IQ)
ridethecatbus
Profile Joined February 2012
United States64 Posts
July 23 2012 22:01 GMT
#18
On July 24 2012 06:46 soiii wrote:
Show nested quote +
On July 24 2012 06:37 ridethecatbus wrote:
What do you think of adding a Year-to-date button or letting the user set the time parameters?

Making the time parameters more flexible sounds like a good idea. What exactly do you mean with a Year-to-date button?


Year-to-date as in 01/01/2012 to today. That or simply a button that shows all of 2012 or 2011.
soiii
Profile Joined July 2011
Germany266 Posts
July 23 2012 22:07 GMT
#19
On July 24 2012 06:55 Snackysnacks wrote:
I noticed under Weekly/Monthly doesn't have the current day/Up to day stream numbers
I understand if this is intentional but it would be nicer to see the whole month with the last data value being the latest queried entry.

Sounds like a good idea.
On July 24 2012 07:00 archonOOid wrote:
My personal suggestions that you could add: multiple graphs overlapping each other so that you could compare two streamers, share of the sc2 individual streamers and display history of popular offline streamers.

Nice idea but quite complicated to do. Will look into that for the 2.0 version of the site
soiii
Profile Joined July 2011
Germany266 Posts
Last Edited: 2012-07-23 22:12:35
July 23 2012 22:12 GMT
#20
On July 24 2012 07:01 ridethecatbus wrote:
Show nested quote +
On July 24 2012 06:46 soiii wrote:
On July 24 2012 06:37 ridethecatbus wrote:
What do you think of adding a Year-to-date button or letting the user set the time parameters?

Making the time parameters more flexible sounds like a good idea. What exactly do you mean with a Year-to-date button?


Year-to-date as in 01/01/2012 to today. That or simply a button that shows all of 2012 or 2011.

Good idea. That might come in handy when the database grows over time. At the moment it only reaches back for about a month.
ItchyLegs
Profile Joined November 2010
Canada369 Posts
July 23 2012 22:16 GMT
#21
this site is really cool.
roachra
Profile Joined June 2012
14 Posts
August 20 2012 09:33 GMT
#22
hey,

love your site.

is there anyway that you can provide aggregate numbers by game too? i've been wondering for some time whether the "starcraft stream numbers are down" fact is really true or it's just the fact that a larger amount of total viewers are just distributed over more available streams..

keep up the great work,
XXX
MasterReY
Profile Blog Joined August 2007
Germany2708 Posts
August 20 2012 09:49 GMT
#23
I dont know if its a bug or im doing something wrong but when i check GOMTV numbers ( http://sc2streamnumbers.com/7217/ ), it tells me the stream was offline all the time until today.

When did you start recording the numbers? Because im pretty sure it was online last friday.
https://www.twitch.tv/MasterReY/ ~ Biggest Reach fan on TL.net (Don't even dare to mention LR now) ~ R.I.P Violet ~ Developer of SCRChart
TL+ Member
Gamegene
Profile Blog Joined June 2011
United States8308 Posts
March 31 2013 22:21 GMT
#24
http://www.downforeveryoneorjustme.com/http://sc2streamnumbers.com/

;; what happened to the site? does anyone know if there are any other services that provide the same information?
Throw on your favorite jacket and you're good to roll. Stroll through the trees and let your miseries go.
DJFaqU
Profile Joined May 2011
466 Posts
March 31 2013 22:28 GMT
#25
It's working for me.
Eiskaffee
Profile Joined March 2013
Germany31 Posts
Last Edited: 2013-03-31 22:38:27
March 31 2013 22:36 GMT
#26
Site is down right now?


EDIT: no its working now just loaded really slow
alvadr
Profile Joined May 2012
135 Posts
March 31 2013 22:41 GMT
#27
It's working for me, seems like an awesome site, and a well deserved bump.
Canucklehead
Profile Joined March 2011
Canada5074 Posts
Last Edited: 2013-04-02 19:23:15
April 02 2013 19:13 GMT
#28
Is there something wrong with the monthly graph or am I reading it wrong? The monthly graph's peak values do not align with the daily peak values. For example, if you look at dragon's monthly graph, it shows he had a peak of 4800 viewers for March, however if you look at the daily graph, he has multiple days of over 5-6k viewers.

If the monthly graph is just showing the average viewer per day and not peak per day, then it still doesn't add up. If you look at march 28th for dragon, in the monthly graph it shows a value of 3020. If you look at the daily graph for march 28th, he only had less than 3k viewers during the first hour of an about 6 hour stream, so the average for that day was a lot more than 3020.
Top 10 favourite pros: MKP, MVP, MC, Nestea, DRG, Jaedong, Flash, Life, Creator, Leenock
mechengineer123
Profile Joined March 2013
Ukraine711 Posts
April 02 2013 19:26 GMT
#29
On April 03 2013 04:13 Canucklehead wrote:
Is there something wrong with the monthly graph or am I reading it wrong? The monthly graph's peak values do not align with the daily peak values. For example, if you look at dragon's monthly graph, it shows he had a peak of 4800 viewers for March, however if you look at the daily graph, he has multiple days of over 5-6k viewers.

If the monthly graph is just showing the average viewer per day and not peak per day, then it still doesn't add up. If you look at march 28th for dragon, in the monthly graph it shows a value of 3020. If you look at the daily graph for march 28th, he only had less than 3k viewers during the first hour of an about 5 hour stream, so the average for that day was a lot more than 3020.

My guess is that it divides the data in batches of x time units and then averages that or whatever, so it loses the "real" peaks.
fezvez
Profile Blog Joined January 2011
France3021 Posts
Last Edited: 2013-04-02 19:56:33
April 02 2013 19:55 GMT
#30
First of all, great job! I liked the nice graphs and the super smooth transitions.

However, if I may :
- Some players appear several times. If you look up "Stephano", there are 3 results
- Going back to the home page is very slow
- Perhaps it is just a UI thing, but I feel that my mouse "slides", because the box that indicates the number of streamer is really slow. Could you augment its speed?

Request :
A yearly, or quarterly (or 6-month-ly) button would be nice =)
soiii
Profile Joined July 2011
Germany266 Posts
Last Edited: 2013-07-04 17:12:14
July 04 2013 17:11 GMT
#31
Sorry for the long downtime on the site. I had some server issues and no time for fixing it. The site will hopefully be back up in the next days but I can not guarantee that all the old data will be included as the database died and my backups are not the best.

Also I might do some redesigning.
soiii
Profile Joined July 2011
Germany266 Posts
July 20 2013 13:52 GMT
#32
Hi there for everybody still interested in the site I have some bad news. I just got a job offer I can not turn down so there will be probably no time in the near future to set up the site again. Never say never but for now I can not keep monitoring and developing the site properly.
cocosoft
Profile Joined May 2010
Sweden1068 Posts
July 20 2013 15:01 GMT
#33
It works! Guys!
¯\_(ツ)_/¯
Steglich
Profile Joined September 2011
Denmark282 Posts
February 07 2014 03:02 GMT
#34
I really miss your site!
Was great to be able to see peak numbers and so on.
HelloSon
Profile Joined April 2010
United States456 Posts
February 07 2014 03:03 GMT
#35
why the fuck did you bump this?
yo
Normal
Please log in or register to reply.
Live Events Refresh
The PiG Daily
22:50
Best Games of SC
Clem vs ByuN
SHIN vs GuMiho
PiGStarcraft693
LiquipediaDiscussion
SC Evo Complete
22:00
Enki Epic Ser. Taeja vs soO EN
davetesta47
Liquipedia
OSC
20:00
Mid Season Playoffs
Spirit vs GeraldLIVE!
Solar vs ShoWTimE
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
PiGStarcraft693
Nina 175
RuFF_SC2 144
StarCraft: Brood War
Sea 4465
Larva 318
Aegong 83
NaDa 42
Icarus 8
LuMiX 2
Dota 2
monkeys_forever696
NeuroSwarm118
League of Legends
JimRising 942
febbydoto11
Counter-Strike
Stewie2K294
Heroes of the Storm
Khaldor119
Other Games
summit1g9809
shahzam835
ViBE208
C9.Mang0190
Trikslyr68
Organizations
Other Games
gamesdonequick36731
BasetradeTV40
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 15 non-featured ]
StarCraft 2
• Berry_CruncH243
• Hupsaiya 61
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• Azhi_Dahaki7
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
League of Legends
• Jankos1900
Other Games
• Scarra1067
Upcoming Events
RSL Revival
6h 43m
SHIN vs Clem
Cure vs TBD
FEL
8h 43m
FEL
12h 43m
Gerald vs PAPI
Spirit vs ArT
CSO Cup
12h 43m
BSL20 Non-Korean Champi…
14h 43m
Bonyth vs QiaoGege
Dewalt vs Fengzi
Hawk vs Zhanhun
Sziky vs Mihu
Mihu vs QiaoGege
Zhanhun vs Sziky
Fengzi vs Hawk
DaveTesta Events
14h 43m
Sparkling Tuna Cup
1d 6h
RSL Revival
1d 6h
Classic vs TBD
FEL
1d 11h
BSL20 Non-Korean Champi…
1d 14h
Bonyth vs Dewalt
QiaoGege vs Dewalt
Hawk vs Bonyth
Sziky vs Fengzi
Mihu vs Zhanhun
QiaoGege vs Zhanhun
Fengzi vs Mihu
[ Show More ]
Wardi Open
2 days
Replay Cast
3 days
WardiTV European League
3 days
PiGosaur Monday
3 days
uThermal 2v2 Circuit
4 days
Replay Cast
4 days
The PondCast
5 days
Replay Cast
5 days
Epic.LAN
6 days
Liquipedia Results

Completed

KCM Race Survival 2025 Season 2
HSC XXVII
NC Random Cup

Ongoing

JPL Season 2
BSL 2v2 Season 3
Acropolis #3
CSL 17: 2025 SUMMER
Copa Latinoamericana 4
Jiahua Invitational
2025 ACS Season 2: Qualifier
CSLPRO Last Chance 2025
Championship of Russia 2025
RSL Revival: Season 1
Murky Cup #2
BLAST.tv Austin Major 2025
ESL Impact League Season 7
IEM Dallas 2025
PGL Astana 2025
Asian Champions League '25
BLAST Rivals Spring 2025
MESA Nomadic Masters

Upcoming

CSL Xiamen Invitational
CSL Xiamen Invitational: ShowMatche
2025 ACS Season 2
CSLPRO Chat StarLAN 3
K-Championship
uThermal 2v2 Main Event
SEL Season 2 Championship
FEL Cracov 2025
Esports World Cup 2025
Underdog Cup #2
StarSeries Fall 2025
FISSURE Playground #2
BLAST Open Fall 2025
BLAST Open Fall Qual
Esports World Cup 2025
BLAST Bounty Fall 2025
BLAST Bounty Fall Qual
IEM Cologne 2025
FISSURE Playground #1
TLPD

1. ByuN
2. TY
3. Dark
4. Solar
5. Stats
6. Nerchio
7. sOs
8. soO
9. INnoVation
10. Elazer
1. Rain
2. Flash
3. EffOrt
4. Last
5. Bisu
6. Soulkey
7. Mini
8. Sharp
Sidebar Settings...

Advertising | Privacy Policy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren
The contents of this webpage are copyright © 2025 TLnet. All Rights Reserved.