Jamie james4k
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" |
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: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 |
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: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: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: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: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:81e35a355fcd3eb21db5
Created
June 6, 2014 19:31
peak concurrent players of action 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 | peak | avgmonthlypeak | |
| --------+-------------------------------------------------------------+--------+---------------- | |
| 570 | Dota 2 | 843024 | 445037 | |
| 730 | Counter-Strike: Global Offensive | 170137 | 67985 | |
| 550 | Left 4 Dead 2 | 161590 | 26382 | |
| 49520 | Borderlands 2 | 123596 | 32038 | |
| 440 | Team Fortress 2 | 117917 | 80091 | |
| 105600 | Terraria | 97392 | 18524 | |
| 211820 | Starbound | 88355 | 26514 | |
| 236430 | DARK SOULS™ II | 79528 | 40627 |
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
| select left(g.name, 30) as name, (sum(sum) * 1.0 / sum(samples) * count(*) * 24.0)::bigint as hours | |
| from game_players_daily gpd, games g | |
| where gpd.appid = g.appid and date_part('year', time) = 2014 | |
| group by g.appid | |
| order by hours desc | |
| limit 100; |
OlderNewer