2014 player hours, rough data

2014_playerhours.sql

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;

output.txt

              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)