SELECT n.symbol, n.company_name FROM stocks.nasdaq_listed n join stocks.s_and_p_500 sp ON n.symbol = sp.symbol;
Query Title

S&P 500 companies in Nasdaq

Description None
Last Execution Results

Dec 11, 22:38 (UTC)

Download
# symbol company_name
1AAL American Airlines Group, Inc.
2AAPL Apple Inc.
3ABMD ABIOMED, Inc.
4ADBE Adobe Systems Incorporated
5ADI Analog Devices, Inc.
6ADP Automatic Data Processing, Inc.
7ADSK Autodesk, Inc.
8AKAM Akamai Technologies, Inc.
9ALGN Align Technology, Inc.
10AMAT Applied Materials, Inc.
11AMD Advanced Micro Devices, Inc.
12AMGN Amgen Inc.
13AMZN Amazon.com, Inc.
14ANSS ANSYS, Inc.
15ATVI Activision Blizzard, Inc
16AVGO Broadcom Inc.
17BIIB Biogen Inc.
18BKNG Booking Holdings Inc.
19CBOE Cboe Global Markets, Inc.
20CDNS Cadence Design Systems, Inc.
21CDW CDW Corporation
22CERN Cerner Corporation
23CHRW C.H. Robinson Worldwide, Inc.
24CHTR Charter Communications, Inc.
25CINF Cincinnati Financial Corporation
26CMCSA Comcast Corporation
27CME CME Group Inc.
28COST Costco Wholesale Corporation
29CPRT Copart, Inc.
30CSCO Cisco Systems, Inc.
31CSX CSX Corporation
32CTAS Cintas Corporation
33CTSH Cognizant Technology Solutions Corporation
34CTXS Citrix Systems, Inc.
35CZR Caesars Entertainment Corporation
36DISCA Discovery, Inc.
37DISCK Discovery, Inc.
38DISH DISH Network Corporation
39DLTR Dollar Tree, Inc.
40DXCM DexCom, Inc.
41EA Electronic Arts Inc.
42EBAY eBay Inc.
43ENPH Enphase Energy, Inc.
44EQIX Equinix, Inc.
45ETSY Etsy, Inc.
46EXPD Expeditors International of Washington, Inc.
47EXPE Expedia Group, Inc.
48FANG Diamondback Energy, Inc.
49FAST Fastenal Company
50FB Facebook, Inc.
51FFIV F5 Networks, Inc.
52FISV Fiserv, Inc.
53FITB Fifth Third Bancorp
54FOX Twenty
55FOXA Twenty
56FTNT Fortinet, Inc.
57GILD Gilead Sciences, Inc.
58GOOG Alphabet Inc.
59GOOGL Alphabet Inc.
60GRMN Garmin Ltd.
61HAS Hasbro, Inc.
62HBAN Huntington Bancshares Incorporated
63HOLX Hologic, Inc.
64HSIC Henry Schein, Inc.
65IDXX IDEXX Laboratories, Inc.
66ILMN Illumina, Inc.
67INCY Incyte Corporation
68INFO IHS Markit Ltd.
69INTC Intel Corporation
70INTU Intuit Inc.
71IPGP IPG Photonics Corporation
72ISRG Intuitive Surgical, Inc.
73JBHT J.B. Hunt Transport Services, Inc.
74JKHY Jack Henry & Associates, Inc.
75KHC The Kraft Heinz Company
76KLAC KLA
77LKQ LKQ Corporation
78LRCX Lam Research Corporation
79MAR Marriott International
80MCHP Microchip Technology Incorporated
81MDLZ Mondelez International, Inc.
82MKTX MarketAxess Holdings, Inc.
83MNST Monster Beverage Corporation
84MPWR Monolithic Power Systems, Inc.
85MSFT Microsoft Corporation
86MTCH Match Group, Inc.
87MU Micron Technology, Inc.
88NDAQ Nasdaq, Inc.
89NFLX Netflix, Inc.
90NTAP NetApp, Inc.
91NTRS Northern Trust Corporation
92NVDA NVIDIA Corporation
93NWS News Corporation
94NWSA News Corporation
95NXPI NXP Semiconductors N.V.
96ODFL Old Dominion Freight Line, Inc.
97ORLY O'Reilly Automotive, Inc.
98PAYX Paychex, Inc.
99PBCT People's United Financial, Inc.
100PCAR PACCAR Inc.
101PENN Penn National Gaming, Inc.
102PEP PepsiCo, Inc.
103PFG Principal Financial Group Inc
104POOL Pool Corporation
105PTC PTC Inc.
106PYPL PayPal Holdings, Inc.
107QCOM QUALCOMM Incorporated
108QRVO Qorvo, Inc.
109REGN Regeneron Pharmaceuticals, Inc.
110ROST Ross Stores, Inc.
111SBAC SBA Communications Corporation
112SBUX Starbucks Corporation
113SIVB SVB Financial Group
114SNPS Synopsys, Inc.
115STX Seagate Technology PLC
116SWKS Skyworks Solutions, Inc.
117TECH Bio
118TMUS T
119TRMB Trimble Inc.
120TROW T. Rowe Price Group, Inc.
121TSCO Tractor Supply Company
122TSLA Tesla, Inc.
123TTWO Take
124TXN Texas Instruments Incorporated
125ULTA Ulta Beauty, Inc.
126VRSK Verisk Analytics, Inc.
127VRSN VeriSign, Inc.
128VRTX Vertex Pharmaceuticals Incorporated
129WBA Walgreens Boots Alliance, Inc.
130WDC Western Digital Corporation
131WLTW Willis Towers Watson Public Limited Company
132WYNN Wynn Resorts, Limited
133XEL Xcel Energy Inc.
134XLNX Xilinx, Inc.
135XRAY DENTSPLY SIRONA Inc.
136ZBRA Zebra Technologies Corporation
137ZION Zions Bancorporation
All Tables
Database

Table

 Metadata
commodities oil_brent_daily
commodities oil_wti_daily
crypto fact_coin_price_history
real_estate freddie_mac_house_price_index
stocks company
stocks nasdaq_listed
stocks s_and_p_500
stocks stock_price
stocks stock_price_history_daily