Last active
August 29, 2015 14:16
-
-
Save james4k/8e2b1a68c10c69e1a009 to your computer and use it in GitHub Desktop.
2014 player hours, rough data
This file contains 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; |
This file contains 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
| name | hours | |
| --------------------------------+------------- | |
| Dota 2 | 4161405988 | |
| Counter-Strike: Global Offensi | 928554513 | |
| Team Fortress 2 | 470861829 | |
| Sid Meier's Civilization V | 302348646 | |
| Football Manager 2014 | 262508814 | |
| The Elder Scrolls V: Skyrim | 253019271 | |
| Garry's Mod | 248234389 | |
| Counter-Strike | 164419232 | |
| DayZ | 141014480 | |
| Warframe | 128024873 | |
| Rust | 123299653 | |
| PAYDAY 2 | 118226273 | |
| Counter-Strike: Source | 113427984 | |
| Arma 3 | 111370193 | |
| Total War: ROME II - Emperor E | 101627765 | |
| Borderlands 2 | 95315706 | |
| Left 4 Dead 2 | 92215997 | |
| Terraria | 89623337 | |
| Unturned | 72461095 | |
| War Thunder | 68890231 | |
| DARK SOULS™ II | 60737308 | |
| Path of Exile | 54788201 | |
| Arma 2: Operation Arrowhead | 53895841 | |
| Football Manager 2015 | 51023684 | |
| Europa Universalis IV | 48048095 | |
| Football Manager 2013 | 46005167 | |
| Mount & Blade: Warband | 45701265 | |
| Call of Duty: Black Ops II - M | 44109354 | |
| Robocraft | 40324819 | |
| Fallout: New Vegas | 39563231 | |
| Starbound | 38332564 | |
| XCOM: Enemy Unknown | 37572498 | |
| Company of Heroes 2 | 35633267 | |
| Neverwinter | 35285400 | |
| Tom Clancy's Ghost Recon Phant | 35100584 | |
| Euro Truck Simulator 2 | 34949792 | |
| PlanetSide 2 | 33798000 | |
| Call of Duty: Modern Warfare 3 | 31305355 | |
| Space Engineers | 31042780 | |
| Crusader Kings II | 30195321 | |
| Empire: Total War | 29651125 | |
| Kerbal Space Program | 28928196 | |
| Heroes & Generals | 28678847 | |
| Age of Empires II: HD Edition | 28408850 | |
| Far Cry® 3 | 27511272 | |
| Call of Duty: Ghosts - Multipl | 27346642 | |
| 7 Days to Die | 27066430 | |
| Tom Clancy's Ghost Recon Phant | 25855783 | |
| Dark Souls: Prepare to Die Edi | 25817526 | |
| Total War: SHOGUN 2 | 24929821 | |
| The Binding of Isaac | 23496372 | |
| Marvel Heroes 2015 | 22746231 | |
| The Binding of Isaac: Rebirth | 22441655 | |
| Call of Duty: Modern Warfare 2 | 21767016 | |
| Divinity: Original Sin | 20868196 | |
| FINAL FANTASY XIV: A Realm Reb | 20338489 | |
| Football Manager 2012 | 20135021 | |
| Banished | 20002773 | |
| Sid Meier's Civilization: Beyo | 19577230 | |
| Borderlands: The Pre-Sequel | 19564360 | |
| Loadout | 19309003 | |
| FTL: Faster Than Light | 19112734 | |
| APB Reloaded | 19066710 | |
| Killing Floor | 18567514 | |
| Don't Starve | 17722337 | |
| Saints Row IV | 17599932 | |
| Stronghold Kingdoms | 17526668 | |
| RIFT™ | 17335505 | |
| Assassin's Creed IV Black Flag | 17198808 | |
| Middle-earth: Shadow of Mordor | 17195006 | |
| Portal 2 | 17011836 | |
| Infestation: Survivor Stories | 16959214 | |
| Star Trek Online | 16890518 | |
| Chivalry: Medieval Warfare | 16439121 | |
| Grand Theft Auto IV | 16074797 | |
| Tomb Raider | 15599008 | |
| Company of Heroes (New Steam V | 14874921 | |
| BioShock Infinite | 14502954 | |
| Torchlight II | 14177968 | |
| Farming Simulator 2013 | 14125085 | |
| The Sims(TM) 3 | 13986349 | |
| Call of Duty: Advanced Warfare | 13458939 | |
| South Park™: The Stick of Trut | 13097072 | |
| Dragon Age: Origins - Ultimate | 12586109 | |
| Watch_Dogs | 12555993 | |
| Rising Storm/Red Orchestra 2 M | 12314137 | |
| No More Room in Hell | 12257834 | |
| EVE Online | 12201157 | |
| Napoleon: Total War | 12187997 | |
| Spacewar | 11715498 | |
| Insurgency | 11553935 | |
| Saints Row: The Third | 11310407 | |
| Prison Architect | 11039579 | |
| Batman™: Arkham Origins | 10993920 | |
| Firefall | 10858931 | |
| Farming Simulator 15 | 10637299 | |
| The Witcher 2: Assassins of Ki | 10576124 | |
| Sniper Elite V2 | 10343425 | |
| Train Simulator 2015 | 10282167 | |
| (100 rows) | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment