In [1]:
import os
import sys
import random
import time
from random import seed, randint
import argparse
import platform
from datetime import datetime
import imp
import numpy as np
import fileinput
from itertools import product
import pandas as pd
from scipy.interpolate import griddata
from scipy.interpolate import interp2d
import seaborn as sns
from os import listdir
import matplotlib.pyplot as plt
import seaborn as sns
from scipy.interpolate import griddata
import matplotlib as mpl
%matplotlib inline
In [12]:
plt.rcParams['figure.figsize'] = [16.18033, 10] #golden ratio
plt.rcParams['figure.facecolor'] = 'w'
plt.rcParams['figure.dpi'] = 100
plt.rcParams.update({'font.size': 22})
In [4]:
data = pd.read_csv("/Users/weilu/Dropbox/WorldBankData/fortune1000-final.csv", engine='python')
In [25]:
data.columns
Out[25]:
Index(['rank', 'title', 'Previous Rank', 'Revenues ($M)', 'Revenue Change',
'Profits ($M)', 'Profit Change', 'Assets ($M)',
'Mkt Value as of 3/29/18 ($M)', 'Employees', 'CEO', 'CEO Title',
'Sector', 'Industry', 'Years on Fortune 500 List', 'City', 'State',
'Latitude', 'Longitude'],
dtype='object')
In [26]:
data
Out[26]:
rank
title
Previous Rank
Revenues ($M)
Revenue Change
Profits ($M)
Profit Change
Assets ($M)
Mkt Value as of 3/29/18 ($M)
Employees
CEO
CEO Title
Sector
Industry
Years on Fortune 500 List
City
State
Latitude
Longitude
0
1
Walmart
1
$500,343
3.00%
$9,862.00
-27.70%
$204,522
$263,563
2,300,000
C. Douglas McMillon
President, Chief Executive Officer & Director
Retailing
General Merchandisers
24
Bentonville
AR
36.372854
-94.208817
1
2
Exxon Mobil
4
$244,363
17.40%
$19,710.00
151.40%
$348,691
$316,157
71,200
Darren W. Woods
Chairman & Chief Executive Officer
Energy
Petroleum Refining
24
Irving
TX
32.814018
-96.948894
2
3
Berkshire Hathaway
2
$242,137
8.30%
$44,940.00
86.70%
$702,095
$492,008
377,000
Warren E. Buffett
Chairman, President & Chief Executive Officer
Financials
Insurance: Property and Casualty (Stock)
24
Omaha
NE
41.256537
-95.934503
3
4
Apple
3
$229,234
6.30%
$48,351.00
5.80%
$375,319
$851,318
123,000
Timothy D. Cook
Chairman & Chief Executive Officer
Technology
Computers, Office Equipment
24
Cupertino
CA
37.322998
-122.032182
4
5
UnitedHealth Group
6
$201,159
8.80%
$10,558.00
50.50%
$139,058
$207,080
260,000
David S. Wichmann
Chairman & Chief Executive Officer
Health Care
Health Care: Insurance and Managed Care
24
Minnetonka
MN
44.921184
-93.468749
5
6
McKesson
5
$198,533
3.10%
$5,070.00
124.50%
$60,969
$29,067
64,500
John H. Hammergren
Chairman, President & Chief Executive Officer
Wholesalers
Wholesalers: Health Care
24
SF
CA
37.774929
-122.419415
6
7
CVS Health
7
$184,765
4.10%
$6,622.00
24.50%
$95,131
$63,114
203,000
Larry J. Merlo
President, Chief Executive Officer & Director
Health Care
Health Care: Pharmacy and Other Services
24
Woonsocket
RI
42.002876
-71.514784
7
8
Amazon.com
12
$177,866
30.80%
$3,033.00
27.90%
$131,310
$700,668
566,000
Jeffrey P. Bezos
Chairman, President & Chief Executive Officer
Retailing
Internet Services and Retailing
17
Seattle
WA
47.606209
-122.332071
8
9
AT&T
9
$160,546
-2.00%
$29,450.00
127.00%
$444,097
$218,946
254,000
Randall L. Stephenson
Chairman, President & Chief Executive Officer
Telecommunications
Telecommunications
24
Dallas
TX
32.776664
-96.796988
9
10
General Motors
8
$157,311
-5.50%
($3,864.00)
-141.00%
$212,482
$50,972
180,000
Mary T. Barra
Chairman & Chief Executive Officer
Motor Vehicles & Parts
Motor Vehicles and Parts
24
Detroit
MI
42.331427
-83.045754
10
11
Ford Motor
10
$156,776
3.30%
$7,602.00
65.40%
$257,808
$44,244
202,000
James P. Hackett
President, Chief Executive Officer & Director
Motor Vehicles & Parts
Motor Vehicles and Parts
24
Dearborn
MI
42.322260
-83.176315
11
12
AmerisourceBergen
11
$153,144
4.30%
$364.50
-74.50%
$35,317
$18,938
19,500
Steven H. Collis
Chairman, President & Chief Executive Officer
Wholesalers
Wholesalers: Health Care
24
Chesterbrook
PA
40.075663
-75.459082
12
13
Chevron
19
$134,533
25.10%
$9,195.00
-
$253,806
$217,845
51,900
Michael K. Wirth
Chairman & Chief Executive Officer
Energy
Petroleum Refining
24
San Ramon
CA
37.779927
-121.978015
13
14
Cardinal Health
15
$129,976
6.90%
$1,288.00
-9.70%
$40,112
$19,726
40,400
Michael C. Kaufmann
Chairman & Chief Executive Officer
Wholesalers
Wholesalers: Health Care
24
Dublin
OH
40.099229
-83.114077
14
15
Costco
16
$129,025
8.70%
$2,679.00
14.00%
$36,347
$82,687
182,000
W. Craig Jelinek
President, Chief Executive Officer & Director
Retailing
General Merchandisers
24
Issaquah
WA
47.530101
-122.032619
15
16
Verizon
14
$126,034
0.00%
$30,101.00
129.30%
$257,143
$197,497
155,400
Lowell C. McAdam
Chairman & Chief Executive Officer
Telecommunications
Telecommunications
24
New York
NY
40.712775
-74.005973
16
17
Kroger
18
$122,662
6.40%
$1,907.00
-3.40%
$37,197
$20,828
449,000
W. Rodney McMullen
Chairman & Chief Executive Officer
Food & Drug Stores
Food and Drug Stores
24
Cincinnati
OH
39.103118
-84.512020
17
18
General Electric
13
$122,274
-3.50%
($5,786.00)
-165.50%
$377,945
$117,054
313,000
John L. Flannery Jr.
Chairman & Chief Executive Officer
Industrials
Industrial Machinery
24
Boston
MA
42.360083
-71.058880
18
19
Walgreens Boots Alliance
17
$118,214
0.70%
$4,078.00
-2.30%
$66,009
$64,924
290,000
Stefano Pessina
Vice Chairman & Chief Executive Officer
Food & Drug Stores
Food and Drug Stores
24
Deerfield
IL
42.171136
-87.844512
19
20
JPMorgan Chase
21
$113,899
8.00%
$24,441.00
-1.20%
$2,533,600
$375,043
252,539
James Dimon
Chairman & Chief Executive Officer
Financials
Commercial Banks
24
New York
NY
40.712775
-74.005973
20
21
Fannie Mae
20
$112,394
4.90%
$2,463.00
-80.00%
$3,345,529
$1,633
7,200
Timothy J. Mayopoulos
President, Chief Executive Officer & Director
Financials
Diversified Financials
21
Leavenworth
WA
47.751074
-120.740139
21
22
Alphabet
27
$110,855
22.80%
$12,662.00
-35.00%
$197,295
$719,124
80,110
Larry Page
Chief Executive Officer & Director
Technology
Internet Services and Retailing
13
Mountain View
CA
37.386052
-122.083851
22
23
Home Depot
23
$100,904
6.70%
$8,630.00
8.50%
$44,529
$206,272
413,000
Craig A. Menear
Chairman, President & Chief Executive Officer
Retailing
Specialty Retailers: Other
24
Atlanta
GA
33.748995
-84.387982
23
24
Bank of America Corp.
26
$100,264
7.00%
$18,232.00
1.80%
$2,281,234
$306,618
209,376
Brian T. Moynihan
Chairman, President & Chief Executive Officer
Financials
Commercial Banks
24
Charlotte
NC
35.227087
-80.843127
24
25
Express Scripts Holding
22
$100,065
-0.20%
$4,517.40
32.70%
$54,256
$38,791
26,600
Timothy C. Wentworth
President, Chief Executive Officer & Director
Health Care
Health Care: Pharmacy and Other Services
19
St. Louis
MO
38.627003
-90.199404
25
26
Wells Fargo
25
$97,741
3.80%
$22,183.00
1.10%
$1,951,757
$255,556
262,700
Timothy J. Sloan
President, Chief Executive Officer & Director
Financials
Commercial Banks
24
SF
CA
37.774929
-122.419415
26
27
Boeing
24
$93,392
-1.20%
$8,197.00
67.50%
$92,333
$192,539
140,800
Dennis A. Muilenburg
Chairman, President & Chief Executive Officer
Aerospace & Defense
Aerospace and Defense
24
Chicago
IL
41.878114
-87.629798
27
28
Phillips 66
34
$91,568
26.50%
$5,106.00
228.40%
$54,371
$44,730
14,600
Greg C. Garland
Chairman & Chief Executive Officer
Energy
Petroleum Refining
6
Houston
TX
29.760427
-95.369803
28
29
Anthem
29
$90,040
6.10%
$3,842.80
55.60%
$70,540
$56,182
56,000
Gail K. Boudreaux
President, Chief Executive Officer & Director
Health Care
Health Care: Insurance and Managed Care
24
Indianapolis
IN
39.768403
-86.158068
29
30
Microsoft
28
$89,950
5.40%
$21,204.00
26.20%
$241,086
$702,760
124,000
Satya Nadella
Chief Executive Officer & Director
Technology
Computer Software
24
Redmond
WA
47.673988
-122.121512
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
970
971
Nuance Communications
953
$1,939
-0.50%
($151.00)
-
$5,932
$4,626
11,600
Mark D. Benjamin
Chairman & Chief Executive Officer
Technology
Computer Software
-
Burlington
MA
42.504716
-71.195620
971
972
Finish Line
968
$1,934
2.40%
($18.20)
-183.20%
$747
$559
8,200
Samuel M. Sato
Chairman & Chief Executive Officer
Retailing
Specialty Retailers: Apparel
-
Indianapolis
IN
39.768403
-86.158068
972
973
TransUnion
NaN
$1,934
13.40%
$441.20
265.80%
$5,119
$10,441
5,100
James M. Peck
President, Chief Executive Officer & Director
Business Services
Financial Data Services
-
Chicago
IL
41.878114
-87.629798
973
974
ServiceNow
NaN
$1,933
39.00%
($149.10)
-
$3,398
$28,904
6,222
John J. Donahoe
President, Chief Executive Officer & Director
Technology
Computer Software
-
Santa Clara
CA
37.354108
-121.955236
974
975
Summit Materials
NaN
$1,933
18.80%
$121.80
231.20%
$3,787
$3,342
6,000
Thomas W. Hill
President, Chief Executive Officer & Director
Materials
Building Materials, Glass
-
Denver
CO
39.739236
-104.990251
975
976
Engility Holdings
915
$1,932
-7.00%
($35.20)
-
$2,026
$899
8,700
Lynn A. Dugle
Chairman, President & Chief Executive Officer
Aerospace & Defense
Aerospace and Defense
-
Chantilly
VA
38.894279
-77.431099
976
977
Ferrellgas Partners
926
$1,930
-5.30%
($54.20)
-
$1,610
$303
3,891
James E. Ferrell
Chairman & Interim Chief Executive Officer
Energy
Energy
-
Overland Park
KS
38.982228
-94.670792
977
978
Interactive Brokers Group
NaN
$1,927
30.60%
$76.00
-9.50%
$61,162
$4,806
1,228
Thomas P. Peterffy
Chairman & Chief Executive Officer
Financials
Securities
-
Greenwich
CT
41.026242
-73.628196
978
979
Stepan
NaN
$1,925
9.00%
$91.60
6.30%
$1,471
$1,875
2,096
F. Quinn Stepan Jr.
Chairman, President & Chief Executive Officer
Chemicals
Chemicals
-
Northfield
IL
42.099750
-87.780897
979
980
Oceaneering International
871
$1,922
-15.40%
$166.40
576.80%
$3,024
$1,827
8,200
Roderick A. Larson
President, Chief Executive Officer & Director
Energy
Oil and Gas Equipment, Services
-
Houston
TX
29.760427
-95.369803
980
981
Cimarex Energy
NaN
$1,918
52.60%
$494.30
-
$5,043
$8,924
910
Thomas E. Jorden
Chairman, President & Chief Executive Officer
Energy
Mining, Crude-Oil Production
-
Denver
CO
39.739236
-104.990251
981
982
Rexnord
958
$1,918
-0.30%
$74.10
9.10%
$3,539
$3,086
8,000
Todd A. Adams
President, Chief Executive Officer & Director
Industrials
Industrial Machinery
-
Milwaukee
WI
43.038902
-87.906474
982
983
Beazer Homes USA
990
$1,916
5.20%
$31.80
577.90%
$2,221
$536
1,100
Allan P. Merrill
President, Chief Executive Officer & Director
Engineering & Construction
Homebuilders
-
Atlanta
GA
33.748995
-84.387982
983
984
MKS Instruments
NaN
$1,916
47.90%
$339.10
223.60%
$2,414
$6,307
4,923
Gerald G. Colella
President, Chief Executive Officer & Director
Technology
Semiconductors and Other Electronic Components
-
Andover
MA
42.658336
-71.136795
984
985
Vail Resorts
NaN
$1,907
19.10%
$210.60
40.60%
$4,111
$8,962
20,150
Robert A. Katz
Chairman & Chief Executive Officer
Hotels, Restaurants & Leisure
Hotels, Casinos, Resorts
-
Broomfield
CO
39.920541
-105.086650
985
986
Ohio National Mutual
NaN
$1,907
8.20%
$25.90
-91.10%
$41,843
-
1,300
Gary T. Huffman
Chairman, President & Chief Executive Officer
Financials
Insurance: Life, Health (stock)
-
Cincinnati
OH
39.103118
-84.512020
986
987
TopBuild
NaN
$1,906
9.40%
$158.10
117.80%
$1,750
$2,725
8,400
Gerald Volas
Chairman & Chief Executive Officer
Engineering & Construction
Engineering, Construction
-
Daytona Beach
FL
29.210815
-81.022833
987
988
Brown & Brown
NaN
$1,881
6.50%
$399.60
55.20%
$5,748
$7,025
8,491
J. Powell Brown
President, Chief Executive Officer & Director
Financials
Insurance: Property and Casualty (Stock)
-
Daytona Beach
FL
29.210815
-81.022833
988
989
Aerojet Rocketdyne Holdings
NaN
$1,877
6.60%
($9.20)
-151.10%
$2,259
$2,113
5,157
Eileen P. Drake
President, Chief Executive Officer & Director
Aerospace & Defense
Aerospace and Defense
-
El Segundo
CA
33.919180
-118.416465
989
990
Barnes & Noble Education
NaN
$1,874
-
$5.40
-
$1,300
$323
13,375
Michael P. Huseby
Chairman & Chief Executive Officer
Retailing
Specialty Retailers: Other
-
Bernards
NJ
40.706617
-74.549328
990
991
Superior Energy Services
NaN
$1,874
29.20%
($205.90)
-
$3,110
$1,300
6,400
David D. Dunlap
President, Chief Executive Officer & Director
Energy
Oil and Gas Equipment, Services
-
Houston
TX
29.760427
-95.369803
991
992
VeriFone Systems
941
$1,871
-6.10%
($173.80)
-
$2,322
$1,698
5,600
Paul S. Galant
Chairman & Chief Executive Officer
Technology
Financial Data Services
-
San Jose
CA
37.338208
-121.886329
992
993
Childrens Place
NaN
$1,870
4.80%
$84.70
-17.20%
$940
$2,330
9,800
Jane T. Elfers
President, Chief Executive Officer & Director
Retailing
Specialty Retailers: Apparel
-
Secaucus
NJ
40.789545
-74.056530
993
994
Tribune Media
896
$1,867
-14.10%
$194.10
1262.60%
$8,169
$3,544
6,000
Peter M. Kern
Interim Chief Executive Officer & Director
Media
Entertainment
-
Chicago
IL
41.878114
-87.629798
994
995
Healthcare Services Group
NaN
$1,866
19.40%
$88.20
14.00%
$676
$3,204
55,000
Theodore Wahl
President, Chief Executive Officer & Director
Health Care
Health Care: Pharmacy and Other Services
-
Bensalem
PA
40.099443
-74.932568
995
996
SiteOne Landscape Supply
NaN
$1,862
13.00%
$54.60
78.40%
$911
$3,084
3,664
Doug Black
Chairman & Chief Executive Officer
Wholesalers
Wholesalers: Diversified
-
Roswell
GA
34.023243
-84.361556
996
997
Charles River Laboratories Intl
NaN
$1,858
10.50%
$123.40
-20.30%
$2,930
$5,118
11,800
James C. Foster
Chairman & Chief Executive Officer
Health Care
Health Care: Pharmacy and Other Services
-
Wilmington
MA
42.548171
-71.172447
997
998
CoreLogic
952
$1,851
-5.20%
$152.20
42.80%
$4,077
$3,694
5,900
Frank D. Martell
President, Chief Executive Officer & Director
Business Services
Financial Data Services
-
Irvine
CA
33.684567
-117.826505
998
999
Ensign Group
NaN
$1,849
11.80%
$40.50
-19.00%
$1,102
$1,354
21,301
Christopher R. Christensen
President, Chief Executive Officer & Director
Health Care
Health Care: Medical Facilities
-
Mission Viejo
CA
33.596891
-117.658156
999
1000
HCP
798
$1,848
-27.20%
$414.20
-34.00%
$14,089
$10,910
190
Thomas M. Herzog
President, Chief Executive Officer & Director
Financials
Real estate
-
Irvine
CA
33.684567
-117.826505
1000 rows × 19 columns
In [23]:
count = data.groupby("Sector")["title"].count().reset_index().sort_values("title")
# plt.legend(loc='center left', bbox_to_anchor=(1.0, 0.5))
In [24]:
sns.barplot(y="Sector", x="title", data=count,
label="Alcohol-involved", color="b")
Out[24]:
<matplotlib.axes._subplots.AxesSubplot at 0x1a1b4c0e48>
In [58]:
def p2f(x):
try:
a = float(x.strip('%'))/100
except:
print(x)
a = None
return a
In [59]:
data["Revenue Change_p2f"] = data["Revenue Change"].apply(p2f)
-
-
-
-
-
In [57]:
sns.swarmplot(x="Revenue Change_p2f", y="Sector", data=data)
Out[57]:
<matplotlib.axes._subplots.AxesSubplot at 0x1a1e2088d0>
In [60]:
data.sort_values(["Revenue Change_p2f"])
Out[60]:
rank
title
Previous Rank
Revenues ($M)
Revenue Change
Profits ($M)
Profit Change
Assets ($M)
Mkt Value as of 3/29/18 ($M)
Employees
CEO
CEO Title
Sector
Industry
Years on Fortune 500 List
City
State
Latitude
Longitude
Revenue Change_p2f
106
107
Hewlett Packard Enterprise
59
$28,871
-42.40%
$344.00
-89.10%
$61,406
$27,243
66,000
Antonio Neri
President, Chief Executive Officer & Director
Technology
Computers, Office Equipment
2
Palo Alto
CA
37.441883
-122.143020
-0.424
290
291
Xerox
162
$10,265
-40.10%
$195.00
-
$15,946
$7,330
36,100
John Visentin
Chairman & Chief Executive Officer
Technology
Computers, Office Equipment
24
Norwalk
CT
41.117744
-73.408158
-0.401
320
321
Conagra Brands
197
$9,235
-34.70%
$639.30
-
$10,096
$14,776
12,600
Sean M. Connolly
President, Chief Executive Officer & Director
Food, Beverages & Tobacco
Food Consumer Products
24
Chicago
IL
41.878114
-87.629798
-0.347
704
705
Ashland Global Holdings
516
$3,260
-34.10%
$1.00
-
$8,618
$4,343
6,500
William A. Wulfsohn
Chairman & Chief Executive Officer
Chemicals
Chemicals
-
Covington
KY
39.083671
-84.508554
-0.341
948
949
EchoStar
719
$2,039
-33.30%
$392.60
118.20%
$8,750
$5,061
2,100
Michael T. Dugan
President, Chief Executive Officer & Director
Technology
Network and Other Communications Equipment
-
Englewood
CO
39.647765
-104.987760
-0.333
999
1000
HCP
798
$1,848
-27.20%
$414.20
-34.00%
$14,089
$10,910
190
Thomas M. Herzog
President, Chief Executive Officer & Director
Financials
Real estate
-
Irvine
CA
33.684567
-117.826505
-0.272
571
572
Terex
445
$4,363
-25.30%
$128.70
-
$3,463
$3,030
10,700
John L. Garrison Jr.
President, Chief Executive Officer & Director
Industrials
Construction and Farm Machinery
-
Westport
CT
41.141472
-73.357905
-0.253
707
708
USG
566
$3,204
-24.90%
$88.00
-82.70%
$3,851
$5,664
6,800
Jennifer F. Scanlon
President, Chief Executive Officer & Director
Materials
Building Materials, Glass
-
Chicago
IL
41.878114
-87.629798
-0.249
585
586
Symantec
465
$4,191
-24.70%
($106.00)
-104.30%
$18,174
$16,067
13,000
Gregory S. Clark
Chairman & Chief Executive Officer
Technology
Computer Software
-
Mountain View
CA
37.386052
-122.083851
-0.247
171
172
Sears Holdings
127
$16,702
-24.60%
($383.00)
-
$7,262
$288
89,000
Edward S. Lampert
Chairman & Chief Executive Officer
Retailing
General Merchandisers
24
Hoffman Estates
IL
42.062991
-88.122720
-0.246
819
820
TEGNA
671
$2,550
-23.70%
$273.70
-37.30%
$4,962
$2,456
5,283
David T. Lougee
President, Chief Executive Officer & Director
Media
Entertainment
-
McLean
VA
38.933868
-77.177260
-0.237
323
324
Hilton Worldwide Holdings
241
$9,140
-21.60%
$1,259.00
261.80%
$14,308
$24,957
163,000
Christopher J. Nassetta
President, Chief Executive Officer & Director
Hotels, Restaurants & Leisure
Hotels, Casinos, Resorts
15
McLean
VA
38.933868
-77.177260
-0.216
280
281
Office Depot
203
$10,752
-20.90%
$181.00
-65.80%
$6,323
$1,195
45,000
Gerry P. Smith
Chairman & Chief Executive Officer
Retailing
Specialty Retailers: Other
24
Boca Raton
FL
26.368306
-80.128932
-0.209
657
658
CIT Group
550
$3,545
-20.40%
$468.20
-
$49,279
$6,649
4,167
Ellen R. Alemany
Chairwoman & CEO
Financials
Commercial Banks
-
New York
NY
40.712775
-74.005973
-0.204
632
633
Trinity Industries
539
$3,663
-20.20%
$702.50
104.50%
$9,543
$4,921
15,605
Timothy R. Wallace
Chairman, President & Chief Executive Officer
Transportation
Transportation Equipment
-
Dallas
TX
32.776664
-96.796988
-0.202
177
178
Emerson Electric
139
$16,301
-19.60%
$1,518.00
-7.20%
$19,589
$43,359
76,500
David N. Farr
Chairman & Chief Executive Officer
Industrials
Industrial Machinery
24
St. Louis
MO
38.627003
-90.199404
-0.196
914
915
Greenbrier Cos.
777
$2,169
-19.00%
$116.10
-36.60%
$2,398
$1,442
11,917
William A. Furman
Chairman, President & Chief Executive Officer
Transportation
Transportation Equipment
-
Lake Oswego
OR
45.415682
-122.715973
-0.190
752
753
Citrix Systems
661
$2,883
-15.70%
($20.70)
-103.90%
$5,820
$12,635
7,500
David J. Henshall
President, Chief Executive Officer & Director
Technology
Computer Software
-
Fort Lauderdale
FL
26.122439
-80.137317
-0.157
86
87
Coca-Cola
64
$35,410
-15.40%
$1,248.00
-80.90%
$87,896
$185,207
61,800
James R. Quincey
President, Chief Executive Officer & Director
Food, Beverages & Tobacco
Beverages
24
Atlanta
GA
33.748995
-84.387982
-0.154
979
980
Oceaneering International
871
$1,922
-15.40%
$166.40
576.80%
$3,024
$1,827
8,200
Roderick A. Larson
President, Chief Executive Officer & Director
Energy
Oil and Gas Equipment, Services
-
Houston
TX
29.760427
-95.369803
-0.154
439
440
Assurant
361
$6,415
-14.80%
$519.60
-8.10%
$31,843
$4,803
14,175
Alan B. Colberg
President, Chief Executive Officer & Director
Financials
Insurance: Property and Casualty (Stock)
14
New York
NY
40.712775
-74.005973
-0.148
115
116
Gilead Sciences
92
$26,107
-14.10%
$4,628.00
-65.70%
$70,283
$98,298
10,000
John F. Milligan IV
President, Chief Executive Officer & Director
Health Care
Pharmaceuticals
10
San Mateo
CA
37.558547
-122.271079
-0.141
993
994
Tribune Media
896
$1,867
-14.10%
$194.10
1262.60%
$8,169
$3,544
6,000
Peter M. Kern
Interim Chief Executive Officer & Director
Media
Entertainment
-
Chicago
IL
41.878114
-87.629798
-0.141
159
160
Community Health Systems
130
$18,477
-13.60%
($2,459.00)
-
$17,450
$454
86,000
Wayne T. Smith
Chairman & Chief Executive Officer
Health Care
Health Care: Medical Facilities
12
Franklin
TN
35.925064
-86.868890
-0.136
429
430
HD Supply Holdings
364
$6,534
-13.20%
$970.00
394.90%
$4,318
$7,040
11,000
Joseph J. DeAngelo
Chairman, President & Chief Executive Officer
Wholesalers
Wholesalers: Diversified
6
Atlanta
GA
33.748995
-84.387982
-0.132
127
128
Avnet
108
$22,872
-12.80%
$525.30
3.70%
$9,700
$5,009
15,700
William J. Amelio
Chief Executive Officer & Director
Wholesalers
Wholesalers: Electronics and Office Equipment
24
Phoenix
AZ
33.448377
-112.074037
-0.128
384
385
Newmont Mining
328
$7,348
-12.30%
($98.00)
-
$20,563
$20,853
12,569
Gary J. Goldberg
President, Chief Executive Officer & Director
Energy
Mining, Crude-Oil Production
15
Greenwood Village
CO
39.617210
-104.950814
-0.123
778
779
Tempur Sealy International
709
$2,754
-12.00%
$151.40
-20.60%
$2,694
$2,461
7,000
Scott L. Thompson
Chairman, President & Chief Executive Officer
Household Products
Home Equipment, Furnishings
-
Lexington
KY
38.040584
-84.503716
-0.120
722
723
Albemarle
654
$3,072
-12.00%
$54.90
-91.50%
$7,751
$10,269
5,400
Luther C. Kissam IV
Chairman, President & Chief Executive Officer
Chemicals
Chemicals
-
Charlotte
NC
35.227087
-80.843127
-0.120
703
704
Avaya Holdings
621
$3,272
-11.60%
-
-
$5,898
$2,459
8,700
James M. Chirico Jr.
President, Chief Executive Officer & Director
Technology
Information Technology Services
-
Santa Clara
CA
37.354108
-121.955236
-0.116
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
391
392
Thor Industries
540
$7,247
58.20%
$374.30
45.90%
$2,558
$6,069
17,800
Robert W. Martin
President, Chief Executive Officer & Director
Motor Vehicles & Parts
Motor Vehicles and Parts
1
Elkhart
IN
41.681993
-85.976667
0.582
812
813
Concho Resources
NaN
$2,586
58.20%
$956.00
-
$13,732
$22,409
1,203
Timothy A. Leach
Chairman & Chief Executive Officer
Energy
Mining, Crude-Oil Production
-
Midland
TX
31.997346
-102.077915
0.582
351
352
Westlake Chemical
507
$8,041
58.40%
$1,304.00
226.90%
$12,076
$14,385
8,799
Albert Yuan Chao
President, Chief Executive Officer & Director
Chemicals
Chemicals
1
Houston
TX
29.760427
-95.369803
0.584
448
449
American Axle & Manufacturing
593
$6,266
58.70%
$337.10
40.00%
$7,883
$1,699
25,000
David C. Dauch
Chairman & Chief Executive Officer
Motor Vehicles & Parts
Motor Vehicles and Parts
4
Detroit
MI
42.331427
-83.045754
0.587
630
631
Carlyle Group
869
$3,676
61.60%
$244.10
3714.10%
$12,281
$2,145
1,600
Kewsong Lee/Glenn A. Youngkin
Co-Chief Executive Officer & Director
Financials
Securities
-
Leavenworth
WA
47.751074
-120.740139
0.616
149
150
Micron Technology
226
$20,322
63.90%
$5,089.00
-
$35,336
$60,470
34,100
Sanjay Mehrotra
President, Chief Executive Officer & Director
Technology
Semiconductors and Other Electronic Components
21
Boise
ID
43.615019
-116.202314
0.639
795
796
Syneos Health
NaN
$2,672
65.90%
($138.50)
-222.90%
$7,286
$3,713
21,000
Alistair MacDonald
Chairman & Chief Executive Officer
Health Care
Health Care: Pharmacy and Other Services
-
Raleigh
NC
35.779590
-78.638179
0.659
259
260
Tesla
383
$11,759
68.00%
($1,961.40)
-
$28,655
$44,955
37,543
Elon Musk
Chairman & Chief Executive Officer
Motor Vehicles & Parts
Motor Vehicles and Parts
2
Palo Alto
CA
37.441883
-122.143020
0.680
469
470
KKR
656
$5,930
71.40%
$1,018.30
229.20%
$45,835
$9,882
1,184
Henry R. Kravis/George R. Roberts
Co-Chairman & Co-Chief Executive Officer
Financials
Securities
6
New York
NY
40.712775
-74.005973
0.714
613
614
American Equity Investment Life
883
$3,892
75.30%
$174.60
109.80%
$62,031
$2,639
515
John M. Matovina
Chairman, President & Chief Executive Officer
Financials
Insurance: Life, Health (stock)
-
West Des Moines
IA
41.577211
-93.711332
0.753
370
371
Coty
558
$7,650
75.90%
($422.20)
-369.10%
$22,548
$13,723
22,000
Camillo Pane
Chairman & Chief Executive Officer
Household Products
Household and Personal Products
1
New York
NY
40.712775
-74.005973
0.759
102
103
INTL FCStone
189
$29,424
99.40%
$6.40
-88.30%
$6,243
$804
1,607
Sean M. O'Connor
President, Chief Executive Officer & Director
Financials
Diversified Financials
10
New York
NY
40.712775
-74.005973
0.994
635
636
Antero Resources
NaN
$3,656
109.50%
$615.10
-
$15,262
$6,283
593
Paul M. Rady
Chairman & Chief Executive Officer
Energy
Mining, Crude-Oil Production
-
Denver
CO
39.739236
-104.990251
1.095
682
683
EQT
NaN
$3,378
110.00%
$1,508.50
-
$29,523
$12,565
2,067
David L. Porges
Chairman, President & Chief Executive Officer
Energy
Energy
-
Pittsburgh
PA
40.440625
-79.995886
1.100
848
849
Knight-Swift Transportation Holdings
586
$2,426
116.90%
$484.30
416.00%
$7,683
$8,199
25,300
David A. Jackson
President, Chief Executive Officer & Director
Transportation
Trucking, Truck Leasing
-
Phoenix
AZ
33.448377
-112.074037
1.169
847
848
Nexstar Media Group
NaN
$2,432
120.40%
$475.00
418.90%
$7,482
$3,066
8,737
Perry A. Sook
Chairman, President & Chief Executive Officer
Media
Entertainment
-
Irving
TX
32.814018
-96.948894
1.204
274
275
Molson Coors Brewing
522
$11,003
125.20%
$1,414.20
-28.40%
$30,247
$16,238
17,200
Mark R. Hunter
President, Chief Executive Officer & Director
Food, Beverages & Tobacco
Beverages
8
Denver
CO
39.739236
-104.990251
1.252
805
806
Range Resources
NaN
$2,611
137.40%
$333.10
-
$11,729
$3,614
773
Jeffrey L. Ventura
Chairman, President & Chief Executive Officer
Energy
Mining, Crude-Oil Production
-
Fort Worth
TX
32.755488
-97.330766
1.374
859
860
Patterson-UTI Energy
NaN
$2,357
157.30%
$5.90
-
$5,759
$3,892
8,000
William A. Hendricks Jr.
President, Chief Executive Officer & Director
Energy
Oil and Gas Equipment, Services
-
Houston
TX
29.760427
-95.369803
1.573
899
900
Cboe Global Markets
NaN
$2,229
217.00%
$401.70
115.00%
$5,266
$12,860
889
Edward T. Tilly
Chairman & Chief Executive Officer
Financials
Securities
-
Chicago
IL
41.878114
-87.629798
2.170
197
198
Envision Healthcare
538
$14,701
220.40%
($228.00)
-
$16,573
$4,647
57,750
Christopher A. Holden
President, Chief Executive Officer & Director
Health Care
Health Care: Pharmacy and Other Services
1
Nashville
TN
36.162664
-86.781602
2.204
642
643
Nexeo Solutions
NaN
$3,637
241.30%
$14.40
-
$2,254
$960
2,640
David A. Bradley
President, Chief Executive Officer & Director
Wholesalers
Wholesalers: Diversified
-
The Woodlands
TX
30.165821
-95.461263
2.413
488
489
Cheniere Energy
NaN
$5,601
336.50%
($393.00)
-
$27,906
$12,703
1,230
Jack A. Fusco
President, Chief Executive Officer & Director
Energy
Energy
1
Houston
TX
29.760427
-95.369803
3.365
343
344
DCP Midstream
NaN
$8,462
465.30%
$229.00
-26.60%
$13,878
$5,033
2,650
Wouter T. van Kempen
Chairman, President & Chief Executive Officer
Energy
Pipelines
1
Denver
CO
39.739236
-104.990251
4.653
761
762
Colony NorthStar
NaN
$2,842
613.20%
($197.90)
-568.00%
$24,786
$3,038
544
Richard B. Saltzman
President, Chief Executive Officer & Director
Financials
Real estate
-
Los Angeles
CA
34.052234
-118.243685
6.132
419
420
Fortive
NaN
$6,656
-
$1,044.50
-
$10,501
$26,979
26,000
James A. Lico
President, Chief Executive Officer & Director
Industrials
Industrial Machinery
1
Everett
WA
47.978985
-122.202079
NaN
465
466
Conduent
NaN
$6,022
-
$181.00
-
$7,548
$3,923
90,000
Ashok Vemuri
Chairman & Chief Executive Officer
Business Services
Diversified Outsourcing Services
1
Florham Park
NJ
40.787878
-74.388207
NaN
772
773
Park Hotels & Resorts
NaN
$2,791
-
$2,625.00
-
$9,714
$5,435
520
Thomas J. Baltimore Jr.
Chairman, President & Chief Executive Officer
Financials
Real estate
-
McLean
VA
38.933868
-77.177260
NaN
936
937
Quorum Health
NaN
$2,072
-
($114.20)
-
$1,829
$247
11,250
Robert H. Fish
President, Chief Executive Officer & Director
Health Care
Health Care: Medical Facilities
-
Brentwood
TN
36.033116
-86.782777
NaN
989
990
Barnes & Noble Education
NaN
$1,874
-
$5.40
-
$1,300
$323
13,375
Michael P. Huseby
Chairman & Chief Executive Officer
Retailing
Specialty Retailers: Other
-
Bernards
NJ
40.706617
-74.549328
NaN
1000 rows × 20 columns
In [ ]:
Content source: luwei0917/awsemmd_script
Similar notebooks: