Jamie james4k
james4k
/ gist:5493407fb2bb48d92eff
Created
June 6, 2014 19:28
peak concurrent players of action category, 2014
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| appid | name | peak | avgmonthlypeak | |
| --------+-------------------------------------------------------------+--------+---------------- | |
| 570 | Dota 2 | 843024 | 753590 | |
| 730 | Counter-Strike: Global Offensive | 170137 | 139730 | |
| 440 | Team Fortress 2 | 83502 | 80079 | |
| 236430 | DARK SOULS™ II | 79528 | 40627 | |
| 63380 | Sniper Elite V2 | 70123 | 12747 | |
| 550 | Left 4 Dead 2 | 61325 | 25272 | |
| 218620 | PAYDAY 2 | 55122 | 29751 | |
| 49520 | Borderlands 2 | 47105 | 21735 |
james4k
/ gist:0a187e714d0bfa1e87b1
Created
June 6, 2014 19:26
peak concurrent players of free to play category, 2014 only
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| appid | name | peak | avgmonthlypeak | |
| --------+--------------------------------------------+--------+---------------- | |
| 570 | Dota 2 | 843024 | 753590 | |
| 440 | Team Fortress 2 | 83502 | 80079 | |
| 245550 | Free to Play | 37675 | 9645 | |
| 208090 | Loadout | 29424 | 10696 | |
| 230410 | Warframe | 26848 | 20720 | |
| 236390 | War Thunder | 26228 | 16367 | |
| 243870 | Tom Clancy's Ghost Recon Phantoms - NA | 21679 | 7252 | |
| 238960 | Path of Exile | 19489 | 12019 |
james4k
/ gist:4dcb8341de0965c42664
Created
June 6, 2014 19:09
linear regression on early access category
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| appid | name | slope | r2 | avg | |
| --------+---------------------------+-----------------------+----------------------+------- | |
| 221100 | DayZ | 0.0234480534248668 | 0.592159361502954 | 23093 | |
| 222900 | Dead Island: Epidemic | 0.00668958698072217 | 0.932481282896558 | 1319 | |
| 202090 | Magicka: Wizard Wars | 0.00312326077259766 | 0.399801533074936 | 1861 | |
| 220200 | Kerbal Space Program | 0.00203382991389009 | 0.278723065688733 | 4107 | |
| 251570 | 7 Days to Die | 0.00144547042729681 | 0.179946968554476 | 2365 | |
| 233450 | Prison Architect | 0.00126280749260566 | 0.438898324878937 | 1913 | |
| 244210 | Assetto Corsa | 0.00105558890829412 | 0.624335595876603 | 599 | |
| 232450 | SolForge | 0.000713353800480538 | 0.286761710492122 | 985 |
james4k
/ gist:d3cb47ebb351eedd9559
Created
June 6, 2014 19:09
linear regression on free to play category
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| appid | name | slope | r2 | avg | |
| --------+--------------------------------------------+-----------------------+----------------------+-------- | |
| 570 | Dota 2 | 0.46417252751648 | 0.980674018724042 | 519212 | |
| 243870 | Tom Clancy's Ghost Recon Phantoms - NA | 0.0361542504321968 | 0.584950355888128 | 8628 | |
| 236390 | War Thunder | 0.015647118837447 | 0.762477082379145 | 10863 | |
| 230410 | Warframe | 0.0133635748592547 | 0.5327343725272 | 14372 | |
| 208090 | Loadout | 0.00699989612393898 | 0.126726817543656 | 13612 | |
| 222900 | Dead Island: Epidemic | 0.00668958698072217 | 0.932481282896558 | 1319 | |
| 226320 | Marvel Heroes 2015 | 0.00319402248165466 | 0.400751298686258 | 4987 | |
| 202090 | Magicka: Wizard Wars |
james4k
/ gist:ecab13c32dee8149e567
Created
June 6, 2014 18:51
linear regression on indie category w/o r2 constraint
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| appid | name | slope | r2 | avg | |
| --------+-------------------------------------------------------------+-----------------------+----------------------+------- | |
| 221100 | DayZ | 0.0234480534248668 | 0.592159361502954 | 23093 | |
| 4000 | Garry's Mod | 0.0215832431644035 | 0.883818454084834 | 28318 | |
| 244850 | Space Engineers | 0.0102031501830021 | 0.646860944517838 | 4660 | |
| 105600 | Terraria | 0.0083959098260543 | 0.114798916115606 | 41057 | |
| 242920 | Banished | 0.00784941120625064 | 0.182961120318323 | 5875 | |
| 208090 | Loadout | 0.00699533711903867 | 0.12655549373197 | 13612 | |
| 227300 | Euro Truck S |
james4k
/ gist:0ca3cc71be86e09d799d
Last active
August 29, 2015 14:02
peak concurrent players of free to play games
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| appid | name | peak | avgmonthlypeak | |
| --------+-------------------------------------------------------------+--------+---------------- | |
| 570 | Dota 2 | 843024 | 445037 | |
| 440 | Team Fortress 2 | 117917 | 80091 | |
| 238960 | Path of Exile | 34371 | 17599 | |
| 218230 | PlanetSide 2 | 29449 | 10819 | |
| 208090 | Loadout | 29424 | 4794 | |
| 230410 | Warframe | 26848 | 16999 | |
| 236390 | War Thunder | 26228 | 11848 | |
| 243870 | Tom Clancy's Ghost Recon Phantoms - NA | 21679 | 7252 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| appid | name | slope | r2 | avg | |
| --------+--------------------------------------------+-----------------------+-------------------+------- | |
| 221100 | DayZ | 0.0235230851097337 | 0.594449210235611 | 23093 | |
| 4000 | Garry's Mod | 0.0216288958385452 | 0.8851965472592 | 28318 | |
| 244850 | Space Engineers | 0.0102046830613906 | 0.646990825365276 | 4660 | |
| 227300 | Euro Truck Simulator 2 | 0.00281036914838749 | 0.640144683695447 | 3391 | |
| 244210 | Assetto Corsa | 0.00107091769217915 | 0.636646652098627 | 599 | |
| 222880 | Insurgency | 0.000865743829271579 | 0.504934577687369 | 1184 | |
| 223390 | Forge | 0.000842197454027153 | 0.587123225005886 | 927 | |
| 230230 | Divinity Original Sin | 0.000284991370317435 |
james4k
/ gist:9612324
Created
March 18, 2014 02:09
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ go test -race | |
| # testmain | |
| /var/folders/zw/9s6rndqs0qlc14d2kc_7tzdr0000gn/T/go-build602341821/j4k.co/exp/ui/scene/_test/_testmain.go:5: can't find import: "regexp" |
james4k
/ gist:7800626
Created
December 5, 2013 05:39
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| steamcharts=# \d game_players | |
| Table "public.game_players" | |
| Column | Type | Modifiers | |
| --------+--------------------------+--------------- | |
| appid | integer | | |
| time | timestamp with time zone | default now() | |
| count | integer | | |
| Indexes: | |
| "game_players_appid_idx" btree (appid) | |
| "game_players_time_idx" btree ("time") |
james4k
/ test.go
Created
October 23, 2013 17:36
— forked from tobstarr/test.go
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "log" | |
| "net/http" | |
| "os" | |
| "os/exec" | |
| ) | |
| func main() { |