Getting list of S&P 500 stocks from Wikipedia page is very straightforward using Python and Pandas. Of course getting the most up to date info would be much more reliable using Yahoo! Finance API or looking at the data provided directly by exchanges or Standard&Poor's (S&P).
Wikipedia is not official source but we will use this option since it is very easy to implement. Wiki page contains list of companies in html table and Pandas has the amazing option to convert html table from URL directly to dataframe.
import pandas as pd
# There are 2 tables on the Wikipedia page
# we want the first table
payload=pd.read_html('https://en.wikipedia.org/wiki/List_of_S%26P_500_companies')
first_table = payload[0]
second_table = payload[1]
df = first_table
df.head()
| Symbol | Security | SEC filings | GICS Sector | GICS Sub Industry | Headquarters Location | Date first added | CIK | Founded | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | MMM | 3M Company | reports | Industrials | Industrial Conglomerates | St. Paul, Minnesota | NaN | 66740 | 1902 |
| 1 | ABT | Abbott Laboratories | reports | Health Care | Health Care Equipment | North Chicago, Illinois | 1964-03-31 | 1800 | 1888 |
| 2 | ABBV | AbbVie Inc. | reports | Health Care | Pharmaceuticals | North Chicago, Illinois | 2012-12-31 | 1551152 | 2013 (1888) |
| 3 | ABMD | ABIOMED Inc | reports | Health Care | Health Care Equipment | Danvers, Massachusetts | 2018-05-31 | 815094 | 1981 |
| 4 | ACN | Accenture plc | reports | Information Technology | IT Consulting & Other Services | Dublin, Ireland | 2011-07-06 | 1467373 | 1989 |
That is it!
Once we have the whole dataframe we can extract the tickers and related company names. For further screening via scripts it will be useful to store all S&P 500 tickers in a list.
symbols = df['Symbol'].values.tolist()
print(symbols[:15])
['MMM', 'ABT', 'ABBV', 'ABMD', 'ACN', 'ATVI', 'ADBE', 'AMD', 'AAP', 'AES', 'AFL', 'A', 'APD', 'AKAM', 'ALK']
names = df['Security'].values.tolist()
print(names[:15])
['3M Company', 'Abbott Laboratories', 'AbbVie Inc.', 'ABIOMED Inc', 'Accenture plc', 'Activision Blizzard', 'Adobe Systems Inc', 'Advanced Micro Devices Inc', 'Advance Auto Parts', 'AES Corp', 'AFLAC Inc', 'Agilent Technologies Inc', 'Air Products & Chemicals Inc', 'Akamai Technologies Inc', 'Alaska Air Group Inc']
Extracting economy sectors from dataframe will be useful as well in case we want to screen for example only some specific types of stocks.
#show unique economy sectors
sectors = df['GICS Sector'].values.tolist()
sectors = set(sectors)
print(sectors)
{'Information Technology', 'Real Estate', 'Materials', 'Utilities', 'Health Care', 'Energy', 'Communication Services', 'Industrials', 'Consumer Staples', 'Consumer Discretionary', 'Financials'}
So let's say we would want to find all Real Estate stocks (REITs) in the S&P 500 index and save it to separate dataframe. We will just need to slice the dataframe in the sector column and filter it.
real_estate_df = df[df['GICS Sector'] == 'Real Estate']
real_estate_symbols = real_estate_df['Symbol'].values.tolist()
print(real_estate_symbols)
['ARE', 'AMT', 'AIV', 'AVB', 'BXP', 'CBRE', 'CCI', 'DLR', 'DRE', 'EQIX', 'EQR', 'ESS', 'EXR', 'FRT', 'PEAK', 'HST', 'IRM', 'KIM', 'MAA', 'PLD', 'PSA', 'O', 'REG', 'SBAC', 'SPG', 'SLG', 'UDR', 'VTR', 'VNO', 'WELL', 'WY']
real_estate_df
| Symbol | Security | SEC filings | GICS Sector | GICS Sub Industry | Headquarters Location | Date first added | CIK | Founded | |
|---|---|---|---|---|---|---|---|---|---|
| 16 | ARE | Alexandria Real Estate Equities | reports | Real Estate | Office REITs | Pasadena, California | 2017-03-20 | 1035443 | 1994 |
| 34 | AMT | American Tower Corp. | reports | Real Estate | Specialized REITs | Boston, Massachusetts | 2007-11-19 | 1053507 | 1995 |
| 47 | AIV | Apartment Investment & Management | reports | Real Estate | Residential REITs | Denver, Colorado | 2003-03-14 | 922864 | 1994 (1975) |
| 61 | AVB | AvalonBay Communities, Inc. | reports | Real Estate | Residential REITs | Arlington, Virginia[3] | 2007-01-10 | 915912 | NaN |
| 76 | BXP | Boston Properties | reports | Real Estate | Office REITs | Boston, Massachusetts | 2006-04-03 | 1037540 | NaN |
| 93 | CBRE | CBRE Group | reports | Real Estate | Real Estate Services | Los Angeles, California | 2006-11-10 | 1138118 | NaN |
| 134 | CCI | Crown Castle International Corp. | reports | Real Estate | Specialized REITs | Houston, Texas | 2012-03-14 | 1051470 | NaN |
| 147 | DLR | Digital Realty Trust Inc | reports | Real Estate | Specialized REITs | San Francisco, California | 2016-05-18 | 1297996 | NaN |
| 159 | DRE | Duke Realty Corp | reports | Real Estate | Industrial REITs | Indianapolis, Indiana | 2017-07-26 | 783280 | NaN |
| 174 | EQIX | Equinix | reports | Real Estate | Specialized REITs | Redwood City, California | 2015-03-20 | 1101239 | NaN |
| 175 | EQR | Equity Residential | reports | Real Estate | Residential REITs | Chicago, Illinois | 2001-12-03 | 906107 | NaN |
| 176 | ESS | Essex Property Trust, Inc. | reports | Real Estate | Residential REITs | Palo Alto, California | 2014-04-02 | 920522 | NaN |
| 184 | EXR | Extra Space Storage | reports | Real Estate | Specialized REITs | Salt Lake City, Utah | 2016-01-19 | 1289490 | NaN |
| 189 | FRT | Federal Realty Investment Trust | reports | Real Estate | Retail REITs | Rockville, Maryland | 2016-02-01 | 34903 | NaN |
| 228 | PEAK | Healthpeak Properties | reports | Real Estate | Health Care REITs | Long Beach, California | 2008-03-31 | 765880 | NaN |
| 240 | HST | Host Hotels & Resorts | reports | Real Estate | Hotel & Resort REITs | Bethesda, Maryland | 2007-03-20 | 1070750 | NaN |
| 263 | IRM | Iron Mountain Incorporated | reports | Real Estate | Specialized REITs | Boston, Massachusetts | 2009-01-06 | 1020569 | NaN |
| 277 | KIM | Kimco Realty | reports | Real Estate | Retail REITs | New Hyde Park, New York | 2006-04-04 | 879101 | NaN |
| 323 | MAA | Mid-America Apartments | reports | Real Estate | Residential REITs | Memphis, Tennessee | 2016-12-02 | 912595 | NaN |
| 384 | PLD | Prologis | reports | Real Estate | Industrial REITs | San Francisco, California | 2003-07-17 | 1045609 | NaN |
| 387 | PSA | Public Storage | reports | Real Estate | Specialized REITs | Glendale, California | 2005-08-19 | 1393311 | NaN |
| 397 | O | Realty Income Corporation | reports | Real Estate | Retail REITs | San Diego, California | 2015-04-07 | 726728 | NaN |
| 398 | REG | Regency Centers Corporation | reports | Real Estate | Retail REITs | Jacksonville, Florida | 2017-03-02 | 910606 | NaN |
| 411 | SBAC | SBA Communications | reports | Real Estate | Specialized REITs | Boca Raton, Florida | 2017-09-01 | 1034054 | NaN |
| 418 | SPG | Simon Property Group Inc | reports | Real Estate | Retail REITs | Indianapolis, Indiana | 2002-06-26 | 1063761 | 2003 |
| 420 | SLG | SL Green Realty | reports | Real Estate | Office REITs | New York, New York | 2015-03-20 | 1040971 | NaN |
| 452 | UDR | UDR, Inc. | reports | Real Estate | Residential REITs | Highlands Ranch, Colorado | 2016-03-07 | 74208 | NaN |
| 468 | VTR | Ventas Inc | reports | Real Estate | Health Care REITs | Chicago, Illinois | 2009-03-04 | 740260 | NaN |
| 475 | VNO | Vornado Realty Trust | reports | Real Estate | Office REITs | New York, New York | NaN | 899689 | NaN |
| 487 | WELL | Welltower Inc. | reports | Real Estate | Health Care REITs | Toledo, Ohio | 2009-01-30 | 766704 | NaN |
| 491 | WY | Weyerhaeuser | reports | Real Estate | Specialized REITs | Federal Way, Washington | NaN | 106535 | NaN |
All sector dataframes:
Below is a code that creates partial dataframes belonging to each sector, these can be eventually saved to a database or to csv file.
# increase jupyter notebook width
from IPython.core.display import display, HTML
display(HTML("<style>.container { width:100% !important; }</style>"))
# pretty printing of pandas dataframe
pd.set_option('expand_frame_repr', False)
for sector in sectors:
sector_df = df[df['GICS Sector'] == sector]
# delete unnecessary columns
del sector_df['SEC filings']
del sector_df['Headquarters Location']
del sector_df['Date first added']
del sector_df['CIK']
del sector_df['Founded']
#print(sector_df.head())
print(sector_df)
print('--------------------------------------')
Symbol Security GICS Sector GICS Sub Industry
4 ACN Accenture plc Information Technology IT Consulting & Other Services
6 ADBE Adobe Systems Inc Information Technology Application Software
7 AMD Advanced Micro Devices Inc Information Technology Semiconductors
13 AKAM Akamai Technologies Inc Information Technology Internet Services & Infrastructure
21 ADS Alliance Data Systems Information Technology Data Processing & Outsourced Services
40 APH Amphenol Corp Information Technology Electronic Components
41 ADI Analog Devices, Inc. Information Technology Semiconductors
42 ANSS ANSYS Information Technology Application Software
48 AAPL Apple Inc. Information Technology Technology Hardware, Storage & Peripherals
49 AMAT Applied Materials Inc. Information Technology Semiconductor Equipment
53 ANET Arista Networks Information Technology Communications Equipment
58 ADSK Autodesk Inc. Information Technology Application Software
59 ADP Automatic Data Processing Information Technology Internet Services & Infrastructure
79 AVGO Broadcom Inc. Information Technology Semiconductors
80 BR Broadridge Financial Solutions Information Technology Data Processing & Outsourced Services
84 CDNS Cadence Design Systems Information Technology Application Software
94 CDW CDW Information Technology Technology Distributors
111 CSCO Cisco Systems Information Technology Communications Equipment
114 CTXS Citrix Systems Information Technology Application Software
119 CTSH Cognizant Technology Solutions Information Technology IT Consulting & Other Services
130 GLW Corning Inc. Information Technology Electronic Components
161 DXC DXC Technology Information Technology IT Consulting & Other Services
186 FFIV F5 Networks Information Technology Communications Equipment
191 FIS Fidelity National Information Services Information Technology Data Processing & Outsourced Services
195 FISV Fiserv Inc Information Technology Data Processing & Outsourced Services
196 FLT FleetCor Technologies Inc Information Technology Data Processing & Outsourced Services
197 FLIR FLIR Systems Information Technology Electronic Equipment & Instruments
201 FTNT Fortinet Information Technology Systems Software
210 IT Gartner Inc Information Technology IT Consulting & Other Services
218 GPN Global Payments Inc. Information Technology Data Processing & Outsourced Services
.. ... ... ... ...
286 LRCX Lam Research Information Technology Semiconductor Equipment
290 LDOS Leidos Holdings Information Technology IT Consulting & Other Services
310 MA Mastercard Inc. Information Technology Data Processing & Outsourced Services
312 MXIM Maxim Integrated Products Inc Information Technology Semiconductors
320 MCHP Microchip Technology Information Technology Semiconductors
321 MU Micron Technology Information Technology Semiconductors
322 MSFT Microsoft Corp. Information Technology Systems Software
331 MSI Motorola Solutions Inc. Information Technology Communications Equipment
336 NTAP NetApp Information Technology Technology Hardware, Storage & Peripherals
351 NLOK NortonLifeLock Information Technology Application Software
355 NVDA Nvidia Corporation Information Technology Semiconductors
362 ORCL Oracle Corp. Information Technology Application Software
366 PAYX Paychex Inc. Information Technology Data Processing & Outsourced Services
367 PYPL PayPal Information Technology Data Processing & Outsourced Services
390 QRVO Qorvo Information Technology Semiconductors
392 QCOM QUALCOMM Inc. Information Technology Semiconductors
410 CRM Salesforce.com Information Technology Application Software
413 STX Seagate Technology Information Technology Technology Hardware, Storage & Peripherals
416 NOW ServiceNow Information Technology Systems Software
419 SWKS Skyworks Solutions Information Technology Semiconductors
431 SNPS Synopsys Inc. Information Technology Application Software
438 TEL TE Connectivity Ltd. Information Technology Electronic Manufacturing Services
441 TXN Texas Instruments Information Technology Semiconductors
469 VRSN Verisign Inc. Information Technology Internet Services & Infrastructure
474 V Visa Inc. Information Technology Data Processing & Outsourced Services
488 WDC Western Digital Information Technology Technology Hardware, Storage & Peripherals
489 WU Western Union Co Information Technology Data Processing & Outsourced Services
497 XRX Xerox Information Technology Technology Hardware, Storage & Peripherals
498 XLNX Xilinx Information Technology Semiconductors
501 ZBRA Zebra Technologies Information Technology Electronic Equipment & Instruments
[70 rows x 4 columns]
--------------------------------------
Symbol Security GICS Sector GICS Sub Industry
16 ARE Alexandria Real Estate Equities Real Estate Office REITs
34 AMT American Tower Corp. Real Estate Specialized REITs
47 AIV Apartment Investment & Management Real Estate Residential REITs
61 AVB AvalonBay Communities, Inc. Real Estate Residential REITs
76 BXP Boston Properties Real Estate Office REITs
93 CBRE CBRE Group Real Estate Real Estate Services
134 CCI Crown Castle International Corp. Real Estate Specialized REITs
147 DLR Digital Realty Trust Inc Real Estate Specialized REITs
159 DRE Duke Realty Corp Real Estate Industrial REITs
174 EQIX Equinix Real Estate Specialized REITs
175 EQR Equity Residential Real Estate Residential REITs
176 ESS Essex Property Trust, Inc. Real Estate Residential REITs
184 EXR Extra Space Storage Real Estate Specialized REITs
189 FRT Federal Realty Investment Trust Real Estate Retail REITs
228 PEAK Healthpeak Properties Real Estate Health Care REITs
240 HST Host Hotels & Resorts Real Estate Hotel & Resort REITs
263 IRM Iron Mountain Incorporated Real Estate Specialized REITs
277 KIM Kimco Realty Real Estate Retail REITs
323 MAA Mid-America Apartments Real Estate Residential REITs
384 PLD Prologis Real Estate Industrial REITs
387 PSA Public Storage Real Estate Specialized REITs
397 O Realty Income Corporation Real Estate Retail REITs
398 REG Regency Centers Corporation Real Estate Retail REITs
411 SBAC SBA Communications Real Estate Specialized REITs
418 SPG Simon Property Group Inc Real Estate Retail REITs
420 SLG SL Green Realty Real Estate Office REITs
452 UDR UDR, Inc. Real Estate Residential REITs
468 VTR Ventas Inc Real Estate Health Care REITs
475 VNO Vornado Realty Trust Real Estate Office REITs
487 WELL Welltower Inc. Real Estate Health Care REITs
491 WY Weyerhaeuser Real Estate Specialized REITs
--------------------------------------
Symbol Security GICS Sector GICS Sub Industry
12 APD Air Products & Chemicals Inc Materials Industrial Gases
15 ALB Albemarle Corp Materials Specialty Chemicals
28 AMCR Amcor plc Materials Paper Packaging
62 AVY Avery Dennison Corp Materials Paper Packaging
64 BLL Ball Corp Materials Metal & Glass Containers
95 CE Celanese Materials Specialty Chemicals
100 CF CF Industries Holdings Inc Materials Fertilizers & Agricultural Chemicals
131 CTVA Corteva Materials Fertilizers & Agricultural Chemicals
156 DOW Dow Inc. Materials Commodity Chemicals
160 DD DuPont de Nemours Inc Materials Specialty Chemicals
163 EMN Eastman Chemical Materials Diversified Chemicals
166 ECL Ecolab Inc. Materials Specialty Chemicals
199 FMC FMC Corporation Materials Fertilizers & Agricultural Chemicals
207 FCX Freeport-McMoRan Inc. Materials Copper
255 IP International Paper Materials Paper Packaging
257 IFF Intl Flavors & Fragrances Materials Specialty Chemicals
294 LIN Linde plc Materials Industrial Gases
300 LYB LyondellBasell Materials Specialty Chemicals
308 MLM Martin Marietta Materials Materials Construction Materials
330 MOS The Mosaic Company Materials Fertilizers & Agricultural Chemicals
339 NEM Newmont Corporation Materials Gold
354 NUE Nucor Corp. Materials Steel
364 PKG Packaging Corporation of America Materials Paper Packaging
379 PPG PPG Industries Materials Specialty Chemicals
414 SEE Sealed Air Materials Paper Packaging
417 SHW Sherwin-Williams Materials Specialty Chemicals
476 VMC Vulcan Materials Materials Construction Materials
490 WRK WestRock Materials Paper Packaging
--------------------------------------
Symbol Security GICS Sector GICS Sub Industry
9 AES AES Corp Utilities Independent Power Producers & Energy Traders
22 LNT Alliant Energy Corp Utilities Electric Utilities
29 AEE Ameren Corp Utilities Multi-Utilities
31 AEP American Electric Power Utilities Electric Utilities
35 AWK American Water Works Company Inc Utilities Water Utilities
56 ATO Atmos Energy Corp Utilities Gas Utilities
97 CNP CenterPoint Energy Utilities Multi-Utilities
117 CMS CMS Energy Utilities Multi-Utilities
126 ED Consolidated Edison Utilities Electric Utilities
154 D Dominion Energy Utilities Electric Utilities
157 DTE DTE Energy Co. Utilities Multi-Utilities
158 DUK Duke Energy Utilities Electric Utilities
167 EIX Edison Int'l Utilities Electric Utilities
171 ETR Entergy Corp. Utilities Electric Utilities
178 EVRG Evergy Utilities Electric Utilities
179 ES Eversource Energy Utilities Multi-Utilities
181 EXC Exelon Corp. Utilities Multi-Utilities
193 FE FirstEnergy Corp Utilities Electric Utilities
342 NEE NextEra Energy Utilities Multi-Utilities
345 NI NiSource Inc. Utilities Multi-Utilities
353 NRG NRG Energy Utilities Independent Power Producers & Energy Traders
376 PNW Pinnacle West Capital Utilities Multi-Utilities
380 PPL PPL Corp. Utilities Electric Utilities
386 PEG Public Serv. Enterprise Inc. Utilities Electric Utilities
415 SRE Sempra Energy Utilities Multi-Utilities
422 SO Southern Co. Utilities Electric Utilities
484 WEC Wec Energy Group Inc Utilities Electric Utilities
496 XEL Xcel Energy Inc Utilities Multi-Utilities
--------------------------------------
Symbol Security GICS Sector GICS Sub Industry
1 ABT Abbott Laboratories Health Care Health Care Equipment
2 ABBV AbbVie Inc. Health Care Pharmaceuticals
3 ABMD ABIOMED Inc Health Care Health Care Equipment
11 A Agilent Technologies Inc Health Care Health Care Equipment
17 ALXN Alexion Pharmaceuticals Health Care Biotechnology
18 ALGN Align Technology Health Care Health Care Supplies
20 AGN Allergan, plc Health Care Pharmaceuticals
37 ABC AmerisourceBergen Corp Health Care Health Care Distributors
39 AMGN Amgen Inc. Health Care Biotechnology
43 ANTM Anthem Health Care Managed Health Care
67 BAX Baxter International Inc. Health Care Health Care Equipment
68 BDX Becton Dickinson Health Care Health Care Equipment
71 BIIB Biogen Inc. Health Care Biotechnology
77 BSX Boston Scientific Health Care Health Care Equipment
78 BMY Bristol-Myers Squibb Health Care Health Care Distributors
88 CAH Cardinal Health Inc. Health Care Health Care Distributors
96 CNC Centene Corporation Health Care Managed Health Care
99 CERN Cerner Health Care Health Care Technology
107 CI CIGNA Corp. Health Care Managed Health Care
128 COO The Cooper Companies Health Care Health Care Supplies
137 CVS CVS Health Health Care Health Care Services
139 DHR Danaher Corp. Health Care Health Care Equipment
141 DVA DaVita Inc. Health Care Health Care Facilities
144 XRAY Dentsply Sirona Health Care Health Care Supplies
168 EW Edwards Lifesciences Health Care Health Care Equipment
216 GILD Gilead Sciences Health Care Biotechnology
227 HCA HCA Healthcare Health Care Health Care Facilities
230 HSIC Henry Schein Health Care Health Care Distributors
236 HOLX Hologic Health Care Health Care Equipment
242 HUM Humana Inc. Health Care Managed Health Care
.. ... ... ... ...
249 ILMN Illumina Inc Health Care Life Sciences Tools & Services
254 INCY Incyte Health Care Biotechnology
259 ISRG Intuitive Surgical Inc. Health Care Health Care Equipment
262 IQV IQVIA Holdings Inc. Health Care Life Sciences Tools & Services
268 JNJ Johnson & Johnson Health Care Pharmaceuticals
285 LH Laboratory Corp. of America Holding Health Care Health Care Services
292 LLY Lilly (Eli) & Co. Health Care Pharmaceuticals
314 MCK McKesson Corp. Health Care Health Care Distributors
315 MDT Medtronic plc Health Care Health Care Equipment
316 MRK Merck & Co. Health Care Pharmaceuticals
318 MTD Mettler Toledo Health Care Life Sciences Tools & Services
333 MYL Mylan N.V. Health Care Pharmaceuticals
371 PKI PerkinElmer Health Care Health Care Equipment
372 PRGO Perrigo Health Care Pharmaceuticals
373 PFE Pfizer Inc. Health Care Pharmaceuticals
393 DGX Quest Diagnostics Health Care Health Care Services
399 REGN Regeneron Pharmaceuticals Health Care Biotechnology
402 RMD ResMed Health Care Health Care Equipment
427 STE STERIS plc Health Care Health Care Equipment
428 SYK Stryker Corp. Health Care Health Care Equipment
440 TFX Teleflex Health Care Health Care Equipment
443 TMO Thermo Fisher Scientific Health Care Life Sciences Tools & Services
459 UNH United Health Group Inc. Health Care Managed Health Care
463 UHS Universal Health Services, Inc. Health Care Health Care Facilities
467 VAR Varian Medical Systems Health Care Health Care Equipment
472 VRTX Vertex Pharmaceuticals Inc Health Care Biotechnology
483 WAT Waters Corporation Health Care Health Care Distributors
485 WCG WellCare Health Care Managed Health Care
502 ZBH Zimmer Biomet Holdings Health Care Health Care Equipment
504 ZTS Zoetis Health Care Pharmaceuticals
[61 rows x 4 columns]
--------------------------------------
Symbol Security GICS Sector GICS Sub Industry
46 APA Apache Corporation Energy Oil & Gas Exploration & Production
63 BKR Baker Hughes Co Energy Oil & Gas Equipment & Services
83 COG Cabot Oil & Gas Energy Oil & Gas Exploration & Production
103 CVX Chevron Corp. Energy Integrated Oil & Gas
108 XEC Cimarex Energy Energy Oil & Gas Exploration & Production
124 CXO Concho Resources Energy Oil & Gas Exploration & Production
125 COP ConocoPhillips Energy Oil & Gas Exploration & Production
145 DVN Devon Energy Energy Oil & Gas Exploration & Production
146 FANG Diamondback Energy Energy Oil & Gas Exploration & Production
172 EOG EOG Resources Energy Oil & Gas Exploration & Production
185 XOM Exxon Mobil Corp. Energy Integrated Oil & Gas
222 HAL Halliburton Co. Energy Oil & Gas Equipment & Services
229 HP Helmerich & Payne Energy Oil & Gas Drilling
232 HES Hess Corporation Energy Integrated Oil & Gas
235 HFC HollyFrontier Corp Energy Oil & Gas Refining & Marketing
278 KMI Kinder Morgan Energy Oil & Gas Storage & Transportation
303 MRO Marathon Oil Corp. Energy Oil & Gas Exploration & Production
304 MPC Marathon Petroleum Energy Oil & Gas Refining & Marketing
335 NOV National Oilwell Varco Inc. Energy Oil & Gas Equipment & Services
346 NBL Noble Energy Inc Energy Oil & Gas Exploration & Production
358 OXY Occidental Petroleum Energy Oil & Gas Exploration & Production
361 OKE ONEOK Energy Oil & Gas Storage & Transportation
375 PSX Phillips 66 Energy Oil & Gas Refining & Marketing
377 PXD Pioneer Natural Resources Energy Oil & Gas Exploration & Production
412 SLB Schlumberger Ltd. Energy Oil & Gas Equipment & Services
439 FTI TechnipFMC Energy Oil & Gas Equipment & Services
466 VLO Valero Energy Energy Oil & Gas Refining & Marketing
493 WMB Williams Cos. Energy Oil & Gas Storage & Transportation
--------------------------------------
Symbol Security GICS Sector GICS Sub Industry
5 ATVI Activision Blizzard Communication Services Interactive Home Entertainment
24 GOOGL Alphabet Inc Class A Communication Services Interactive Media & Services
25 GOOG Alphabet Inc Class C Communication Services Interactive Media & Services
57 T AT&T Inc. Communication Services Integrated Telecommunication Services
98 CTL CenturyLink Inc Communication Services Alternative Carriers
102 CHTR Charter Communications Communication Services Cable & Satellite
121 CMCSA Comcast Corp. Communication Services Cable & Satellite
149 DISCA Discovery Inc. Class A Communication Services Broadcasting
150 DISCK Discovery Inc. Class C Communication Services Broadcasting
151 DISH Dish Network Communication Services Cable & Satellite
169 EA Electronic Arts Communication Services Interactive Home Entertainment
187 FB Facebook, Inc. Communication Services Interactive Media & Services
204 FOXA Fox Corporation Class A Communication Services Movies & Entertainment
205 FOX Fox Corporation Class B Communication Services Movies & Entertainment
256 IPG Interpublic Group Communication Services Advertising
295 LYV Live Nation Entertainment Communication Services Movies & Entertainment
337 NFLX Netflix Inc. Communication Services Movies & Entertainment
340 NWSA News Corp. Class A Communication Services Publishing
341 NWS News Corp. Class B Communication Services Publishing
360 OMC Omnicom Group Communication Services Advertising
433 TMUS T-Mobile US Communication Services Wireless Telecommunication Services
435 TTWO Take-Two Interactive Communication Services Interactive Home Entertainment
450 TWTR Twitter, Inc. Communication Services Interactive Media & Services
471 VZ Verizon Communications Communication Services Integrated Telecommunication Services
473 VIAC ViacomCBS Communication Services Movies & Entertainment
481 DIS The Walt Disney Company Communication Services Movies & Entertainment
--------------------------------------
Symbol Security GICS Sector GICS Sub Industry
0 MMM 3M Company Industrials Industrial Conglomerates
14 ALK Alaska Air Group Inc Industrials Airlines
19 ALLE Allegion Industrials Building Products
30 AAL American Airlines Group Industrials Airlines
38 AME AMETEK Inc. Industrials Electrical Components & Equipment
45 AOS A.O. Smith Corp Industrials Building Products
52 ARNC Arconic Inc. Industrials Aerospace & Defense
73 BA Boeing Company Industrials Aerospace & Defense
82 CHRW C. H. Robinson Worldwide Industrials Air Freight & Logistics
91 CAT Caterpillar Inc. Industrials Construction Machinery & Heavy Trucks
110 CTAS Cintas Corporation Industrials Diversified Support Services
129 CPRT Copart Inc Industrials Diversified Support Services
135 CSX CSX Corp. Industrials Railroads
136 CMI Cummins Inc. Industrials Industrial Machinery
142 DE Deere & Co. Industrials Agricultural & Farm Machinery
143 DAL Delta Air Lines Inc. Industrials Airlines
155 DOV Dover Corp. Industrials Industrial Machinery
164 ETN Eaton Corporation Industrials Electrical Components & Equipment
170 EMR Emerson Electric Company Industrials Electrical Components & Equipment
173 EFX Equifax Inc. Industrials Research & Consulting Services
183 EXPD Expeditors Industrials Air Freight & Logistics
188 FAST Fastenal Co Industrials Building Products
190 FDX FedEx Corporation Industrials Air Freight & Logistics
198 FLS Flowserve Corporation Industrials Industrial Machinery
202 FTV Fortive Corp Industrials Industrial Machinery
203 FBHS Fortune Brands Home & Security Industrials Building Products
211 GD General Dynamics Industrials Aerospace & Defense
212 GE General Electric Industrials Industrial Conglomerates
220 GWW Grainger (W.W.) Inc. Industrials Industrial Machinery
238 HON Honeywell Int'l Inc. Industrials Industrial Conglomerates
.. ... ... ... ...
297 LMT Lockheed Martin Corp. Industrials Aerospace & Defense
309 MAS Masco Corp. Industrials Building Products
343 NLSN Nielsen Holdings Industrials Research & Consulting Services
348 NSC Norfolk Southern Corp. Industrials Railroads
350 NOC Northrop Grumman Industrials Aerospace & Defense
359 ODFL Old Dominion Freight Line Industrials Trucking
363 PCAR PACCAR Inc. Industrials Construction Machinery & Heavy Trucks
365 PH Parker-Hannifin Industrials Industrial Machinery
368 PNR Pentair plc Industrials Industrial Machinery
391 PWR Quanta Services Inc. Industrials Construction & Engineering
396 RTN Raytheon Co. Industrials Aerospace & Defense
401 RSG Republic Services Inc Industrials Environmental & Facilities Services
403 RHI Robert Half International Industrials Human Resource & Employment Services
404 ROK Rockwell Automation Inc. Industrials Electrical Components & Equipment
405 ROL Rollins Inc. Industrials Environmental & Facilities Services
406 ROP Roper Technologies Industrials Industrial Conglomerates
421 SNA Snap-on Industrials Industrial Machinery
423 LUV Southwest Airlines Industrials Airlines
424 SWK Stanley Black & Decker Industrials Industrial Machinery
442 TXT Textron Inc. Industrials Aerospace & Defense
447 TDG TransDigm Group Industrials Aerospace & Defense
457 UNP Union Pacific Corp Industrials Railroads
458 UAL United Airlines Holdings Industrials Airlines
460 UPS United Parcel Service Industrials Air Freight & Logistics
461 URI United Rentals, Inc. Industrials Trading Companies & Distributors
462 UTX United Technologies Industrials Aerospace & Defense
470 VRSK Verisk Analytics Industrials Research & Consulting Services
478 WAB Wabtec Corporation Industrials Construction Machinery & Heavy Trucks
482 WM Waste Management Inc. Industrials Environmental & Facilities Services
499 XYL Xylem Inc. Industrials Industrial Machinery
[70 rows x 4 columns]
--------------------------------------
Symbol Security GICS Sector GICS Sub Industry
26 MO Altria Group Inc Consumer Staples Tobacco
51 ADM Archer-Daniels-Midland Co Consumer Staples Agricultural Products
81 BF.B Brown-Forman Corp. Consumer Staples Distillers & Vintners
85 CPB Campbell Soup Consumer Staples Packaged Foods & Meats
106 CHD Church & Dwight Consumer Staples Household Products
115 CLX The Clorox Company Consumer Staples Household Products
118 KO Coca-Cola Company Consumer Staples Soft Drinks
120 CL Colgate-Palmolive Consumer Staples Household Products
123 CAG Conagra Brands Consumer Staples Packaged Foods & Meats
127 STZ Constellation Brands Consumer Staples Distillers & Vintners
132 COST Costco Wholesale Corp. Consumer Staples Hypermarkets & Super Centers
133 COTY Coty, Inc Consumer Staples Personal Products
177 EL Estee Lauder Cos. Consumer Staples Personal Products
213 GIS General Mills Consumer Staples Packaged Foods & Meats
231 HSY The Hershey Company Consumer Staples Packaged Foods & Meats
239 HRL Hormel Foods Corp. Consumer Staples Packaged Foods & Meats
267 SJM JM Smucker Consumer Staples Packaged Foods & Meats
273 K Kellogg Co. Consumer Staples Packaged Foods & Meats
276 KMB Kimberly-Clark Consumer Staples Household Products
281 KHC Kraft Heinz Co Consumer Staples Packaged Foods & Meats
282 KR Kroger Co. Consumer Staples Food Retail
287 LW Lamb Weston Holdings Inc Consumer Staples Packaged Foods & Meats
311 MKC McCormick & Co. Consumer Staples Packaged Foods & Meats
325 TAP Molson Coors Brewing Company Consumer Staples Brewers
326 MDLZ Mondelez International Consumer Staples Packaged Foods & Meats
327 MNST Monster Beverage Consumer Staples Soft Drinks
370 PEP PepsiCo Inc. Consumer Staples Soft Drinks
374 PM Philip Morris International Consumer Staples Tobacco
382 PG Procter & Gamble Consumer Staples Personal Products
432 SYY Sysco Corp. Consumer Staples Food Distributors
451 TSN Tyson Foods Consumer Staples Packaged Foods & Meats
479 WMT Walmart Consumer Staples Hypermarkets & Super Centers
480 WBA Walgreens Boots Alliance Consumer Staples Drug Retail
--------------------------------------
Symbol Security GICS Sector GICS Sub Industry
8 AAP Advance Auto Parts Consumer Discretionary Automotive Retail
27 AMZN Amazon.com Inc. Consumer Discretionary Internet & Direct Marketing Retail
50 APTV Aptiv PLC Consumer Discretionary Auto Parts & Equipment
60 AZO AutoZone Inc Consumer Discretionary Specialty Stores
70 BBY Best Buy Co. Inc. Consumer Discretionary Computer & Electronics Retail
74 BKNG Booking Holdings Inc Consumer Discretionary Internet & Direct Marketing Retail
75 BWA BorgWarner Consumer Discretionary Auto Parts & Equipment
87 CPRI Capri Holdings Consumer Discretionary Apparel, Accessories & Luxury Goods
89 KMX Carmax Inc Consumer Discretionary Specialty Stores
90 CCL Carnival Corp. Consumer Discretionary Hotels, Resorts & Cruise Lines
104 CMG Chipotle Mexican Grill Consumer Discretionary Restaurants
138 DHI D. R. Horton Consumer Discretionary Homebuilding
140 DRI Darden Restaurants Consumer Discretionary Restaurants
152 DG Dollar General Consumer Discretionary General Merchandise Stores
153 DLTR Dollar Tree Consumer Discretionary General Merchandise Stores
165 EBAY eBay Inc. Consumer Discretionary Internet & Direct Marketing Retail
182 EXPE Expedia Group Consumer Discretionary Internet & Direct Marketing Retail
200 F Ford Motor Consumer Discretionary Automobile Manufacturers
208 GPS Gap Inc. Consumer Discretionary Apparel Retail
209 GRMN Garmin Ltd. Consumer Discretionary Consumer Electronics
214 GM General Motors Consumer Discretionary Automobile Manufacturers
215 GPC Genuine Parts Consumer Discretionary Specialty Stores
221 HRB H&R Block Consumer Discretionary Specialized Consumer Services
223 HBI Hanesbrands Inc Consumer Discretionary Apparel, Accessories & Luxury Goods
224 HOG Harley-Davidson Consumer Discretionary Motorcycle Manufacturers
226 HAS Hasbro Inc. Consumer Discretionary Leisure Products
234 HLT Hilton Worldwide Holdings Inc Consumer Discretionary Hotels, Resorts & Cruise Lines
237 HD Home Depot Consumer Discretionary Home Improvement Retail
280 KSS Kohl's Corp. Consumer Discretionary General Merchandise Stores
283 LB L Brands Inc. Consumer Discretionary Apparel Retail
.. ... ... ... ...
299 LOW Lowe's Cos. Consumer Discretionary Home Improvement Retail
302 M Macy's Inc. Consumer Discretionary Department Stores
306 MAR Marriott Int'l. Consumer Discretionary Hotels, Resorts & Cruise Lines
313 MCD McDonald's Corp. Consumer Discretionary Restaurants
319 MGM MGM Resorts International Consumer Discretionary Casinos & Gaming
324 MHK Mohawk Industries Consumer Discretionary Home Furnishings
338 NWL Newell Brands Consumer Discretionary Housewares & Specialties
344 NKE Nike Consumer Discretionary Apparel, Accessories & Luxury Goods
347 JWN Nordstrom Consumer Discretionary Department Stores
352 NCLH Norwegian Cruise Line Holdings Consumer Discretionary Hotels, Resorts & Cruise Lines
356 NVR NVR Inc Consumer Discretionary Homebuilding
357 ORLY O'Reilly Automotive Consumer Discretionary Specialty Stores
388 PHM Pulte Homes Inc. Consumer Discretionary Homebuilding
389 PVH PVH Corp. Consumer Discretionary Apparel, Accessories & Luxury Goods
394 RL Ralph Lauren Corporation Consumer Discretionary Apparel, Accessories & Luxury Goods
407 ROST Ross Stores Consumer Discretionary Apparel Retail
408 RCL Royal Caribbean Cruises Ltd Consumer Discretionary Hotels, Resorts & Cruise Lines
425 SBUX Starbucks Corp. Consumer Discretionary Restaurants
436 TPR Tapestry, Inc. Consumer Discretionary Apparel, Accessories & Luxury Goods
437 TGT Target Corp. Consumer Discretionary General Merchandise Stores
444 TIF Tiffany & Co. Consumer Discretionary Apparel, Accessories & Luxury Goods
445 TJX TJX Companies Inc. Consumer Discretionary Apparel Retail
446 TSCO Tractor Supply Company Consumer Discretionary Specialty Stores
453 ULTA Ulta Beauty Consumer Discretionary Specialty Stores
455 UAA Under Armour Class A Consumer Discretionary Apparel, Accessories & Luxury Goods
456 UA Under Armour Class C Consumer Discretionary Apparel, Accessories & Luxury Goods
465 VFC V.F. Corp. Consumer Discretionary Apparel, Accessories & Luxury Goods
492 WHR Whirlpool Corp. Consumer Discretionary Household Appliances
495 WYNN Wynn Resorts Ltd Consumer Discretionary Casinos & Gaming
500 YUM Yum! Brands Inc Consumer Discretionary Restaurants
[64 rows x 4 columns]
--------------------------------------
Symbol Security GICS Sector GICS Sub Industry
10 AFL AFLAC Inc Financials Life & Health Insurance
23 ALL Allstate Corp Financials Property & Casualty Insurance
32 AXP American Express Co Financials Consumer Finance
33 AIG American International Group Financials Property & Casualty Insurance
36 AMP Ameriprise Financial Financials Asset Management & Custody Banks
44 AON Aon plc Financials Insurance Brokers
54 AJG Arthur J. Gallagher & Co. Financials Insurance Brokers
55 AIZ Assurant Financials Multi-line Insurance
65 BAC Bank of America Corp Financials Diversified Banks
66 BK The Bank of New York Mellon Corp. Financials Asset Management & Custody Banks
69 BRK.B Berkshire Hathaway Financials Multi-Sector Holdings
72 BLK BlackRock Financials Asset Management & Custody Banks
86 COF Capital One Financial Financials Consumer Finance
92 CBOE Cboe Global Markets Financials Financial Exchanges & Data
101 SCHW Charles Schwab Corporation Financials Investment Banking & Brokerage
105 CB Chubb Limited Financials Property & Casualty Insurance
109 CINF Cincinnati Financial Financials Property & Casualty Insurance
112 C Citigroup Inc. Financials Diversified Banks
113 CFG Citizens Financial Group Financials Regional Banks
116 CME CME Group Inc. Financials Financial Exchanges & Data
122 CMA Comerica Inc. Financials Diversified Banks
148 DFS Discover Financial Services Financials Consumer Finance
162 ETFC E*Trade Financials Investment Banking & Brokerage
180 RE Everest Re Group Ltd. Financials Reinsurance
192 FITB Fifth Third Bancorp Financials Regional Banks
194 FRC First Republic Bank Financials Regional Banks
206 BEN Franklin Resources Financials Asset Management & Custody Banks
217 GL Globe Life Inc. Financials Life & Health Insurance
219 GS Goldman Sachs Group Financials Investment Banking & Brokerage
225 HIG Hartford Financial Svc.Gp. Financials Property & Casualty Insurance
.. ... ... ... ...
298 L Loews Corp. Financials Multi-line Insurance
301 MTB M&T Bank Corp. Financials Regional Banks
305 MKTX MarketAxess Financials Financial Exchanges & Data
307 MMC Marsh & McLennan Financials Insurance Brokers
317 MET MetLife Inc. Financials Life & Health Insurance
328 MCO Moody's Corp Financials Financial Exchanges & Data
329 MS Morgan Stanley Financials Investment Banking & Brokerage
332 MSCI MSCI Inc Financials Financial Exchanges & Data
334 NDAQ Nasdaq, Inc. Financials Financial Exchanges & Data
349 NTRS Northern Trust Corp. Financials Asset Management & Custody Banks
369 PBCT People's United Financial Financials Thrifts & Mortgage Finance
378 PNC PNC Financial Services Financials Regional Banks
381 PFG Principal Financial Group Financials Life & Health Insurance
383 PGR Progressive Corp. Financials Property & Casualty Insurance
385 PRU Prudential Financial Financials Life & Health Insurance
395 RJF Raymond James Financial Inc. Financials Investment Banking & Brokerage
400 RF Regions Financial Corp. Financials Regional Banks
409 SPGI S&P Global, Inc. Financials Financial Exchanges & Data
426 STT State Street Corp. Financials Asset Management & Custody Banks
429 SIVB SVB Financial Financials Regional Banks
430 SYF Synchrony Financial Financials Consumer Finance
434 TROW T. Rowe Price Group Financials Asset Management & Custody Banks
448 TRV The Travelers Companies Inc. Financials Property & Casualty Insurance
449 TFC Truist Financial Financials Regional Banks
454 USB U.S. Bancorp Financials Diversified Banks
464 UNM Unum Group Financials Life & Health Insurance
477 WRB W. R. Berkley Corporation Financials Property & Casualty Insurance
486 WFC Wells Fargo Financials Diversified Banks
494 WLTW Willis Towers Watson Financials Insurance Brokers
503 ZION Zions Bancorp Financials Regional Banks
[66 rows x 4 columns]
--------------------------------------