S&P 500 Stocks Info

Overview of the underlying stocks of S&P500

@kaggle.davidemattioli_sp_500_stocks_info

Table List

1 table(807.97 KB)

Sp500 Stocks Info

@kaggle.davidemattioli_sp_500_stocks_info.sp500_stocks_info

807.97 KB
505 rows
166 columns
Only the first 100 columns are shown

zip Zip	sector Sector	fulltimeemployees FullTimeEmployees	longbusinesssummary LongBusinessSummary	city City	phone Phone	state State	country Country	companyofficers CompanyOfficers	website Website	maxage MaxAge	address1 Address1	industry Industry	ebitdamargins EbitdaMargins	profitmargins ProfitMargins	grossmargins GrossMargins	operatingcashflow OperatingCashflow	revenuegrowth RevenueGrowth	operatingmargins OperatingMargins	ebitda Ebitda	targetlowprice TargetLowPrice	recommendationkey RecommendationKey	grossprofits GrossProfits	freecashflow FreeCashflow	targetmedianprice TargetMedianPrice	currentprice CurrentPrice	earningsgrowth EarningsGrowth	currentratio CurrentRatio	returnonassets ReturnOnAssets	numberofanalystopinions NumberOfAnalystOpinions	targetmeanprice TargetMeanPrice	debttoequity DebtToEquity	returnonequity ReturnOnEquity	targethighprice TargetHighPrice	totalcash TotalCash	totaldebt TotalDebt	totalrevenue TotalRevenue	totalcashpershare TotalCashPerShare	financialcurrency FinancialCurrency	revenuepershare RevenuePerShare	quickratio QuickRatio	recommendationmean RecommendationMean	exchange Exchange	shortname ShortName	longname LongName	exchangetimezonename ExchangeTimezoneName	exchangetimezoneshortname ExchangeTimezoneShortName	isesgpopulated IsEsgPopulated	gmtoffsetmilliseconds GmtOffSetMilliseconds	quotetype QuoteType	symbol Symbol	messageboardid MessageBoardId	uuid Uuid	market Market	enterprisetorevenue EnterpriseToRevenue	enterprisetoebitda EnterpriseToEbitda	forwardeps ForwardEps	sharesoutstanding SharesOutstanding	bookvalue BookValue	sharesshort SharesShort	sharespercentsharesout SharesPercentSharesOut	lastfiscalyearend LastFiscalYearEnd	heldpercentinstitutions HeldPercentInstitutions	netincometocommon NetIncomeToCommon	trailingeps TrailingEps	pricetobook PriceToBook	heldpercentinsiders HeldPercentInsiders	nextfiscalyearend NextFiscalYearEnd	mostrecentquarter MostRecentQuarter	shortratio ShortRatio	sharesshortpreviousmonthdate SharesShortPreviousMonthDate	floatshares FloatShares	beta Beta	enterprisevalue EnterpriseValue	pricehint PriceHint	lastsplitdate LastSplitDate	lastsplitfactor LastSplitFactor	earningsquarterlygrowth EarningsQuarterlyGrowth	pricetosalestrailing12months PriceToSalesTrailing12Months	dateshortinterest DateShortInterest	pegratio PegRatio
55144-1000	Industrials	95000	3M Company develops, manufactures, and markets various products worldwide. It operates through four business segments: Safety and Industrial, Transportation and Electronics, Health Care, and Consumer. The Safety and Industrial segment offers personal safety products, industrial adhesives and tapes, …	St. Paul	651-733-1110	MN	United States	[]	http://www.3m.com	1	3M Center	Specialty Industrial Machinery	0.29003	0.17038	0.48703998	8569999872	0.247	0.23501	10074000384	138	hold	15685000000	5909624832	206	182.39	0.151	1.731	0.10925999	16	200.26	131.71	0.46612	219	5503000064	19118999552	34733998080	9.51	USD	59.938	1.112	3.1	NYQ	3M Company	3M Company	America/New_York	EDT	true	-14400000	EQUITY	MMM	finmb_289194	375388b3-dab7-3763-90cd-457ad19388a2	us_market	3.468	11.959	10.59	579675008	23.737	10649972	0.0184	1609372800	0.68718004	5918000128	9.772	7.683785	0.00116	1672444800	1625011200	5.88	1627603200	577990178	0.953056	120471691264	2	1064880000	2:1	0.167	3.043903	1630368000	2.16
60064-6400	Healthcare	109000	Abbott Laboratories discovers, develops, manufactures, and sells health care products worldwide. It operates in four segments: Established Pharmaceutical Products, Diagnostic Products, Nutritional Products, and Medical Devices. The Established Pharmaceutical Products segment provides generic pharmac…	North Chicago	224 667 6100	IL	United States	[]	http://www.abbott.com	1	100 Abbott Park Road	Medical Devices	0.27738002	0.1533	0.56837004	9822999552	0.353	0.18544	10357000192	109	buy	19611000000	6360750080	134.5	127.4	2.213	1.751	0.06202	22	132.05	54.587	0.17815	158	8371999744	18443999232	37338001408	4.712	USD	21.036	1.161	1.9	NYQ	Abbott Laboratories	Abbott Laboratories	America/New_York	EDT	true	-14400000	EQUITY	ABT	finmb_247483	5f9c82b0-139d-3f8f-b30c-efd7ee9ccdcf	us_market	5.93	21.379	4.67	1776819968	18.889	14011039	0.007900001	1609372800	0.7571	5693000192	3.191	6.744666	0.00721	1672444800	1617148800	1.77	1620950400	1763476229	0.67519	221419765760	2	1357084800	10000:4798	2.179	6.06264	1623715200	2.31
60064-6400	Healthcare	48000	AbbVie Inc. discovers, develops, manufactures, and sells pharmaceuticals in the worldwide. The company offers HUMIRA, a therapy administered as an injection for autoimmune and intestinal BehÃ§et's diseases; SKYRIZI to treat moderate to severe plaque psoriasis in adults; RINVOQ, a JAK inhibitor for t…	North Chicago	847 932 7900	IL	United States	[]	http://www.abbvie.com	1	1 North Waukegan Road	Drug Manufacturers—General	0.51499003	0.12401	0.68121004	20451000320	0.339	0.35173	27669999616	105	buy	31747000000	18179999744	127.5	106.45		0.906	0.0794	22	125.96	652.342	0.48855	144	8600000512	82156003328	53729001472	4.867	USD	30.364	0.645	2	NYQ	AbbVie Inc.	AbbVie Inc.	America/New_York	EDT	true	-14400000	EQUITY	ABBV	finmb_141885706	73238d42-cdcc-3f92-8141-dd675addae10	us_market	5.134	9.969	13.92	1766220032	7.765	14655916	0.0083	1609372800	0.6899	6597000192	2.913	13.70895	0.00125	1672444800	1625011200	2.49	1623715200	1741728204	0.789133	275834241024	2		nan		3.499304	1626307200	1.9
01923	Healthcare	1725	Abiomed, Inc. engages in the research, development, and sale of medical devices to assist or replace the pumping function of the failing heart. It also provides a continuum of care to heart failure patients. The company offers Impella 2.5, a percutaneous micro heart pump with integrated motor and se…	Danvers	978 646 1400	MA	United States	[]	http://www.abiomed.com	1	22 Cherry Hill Drive	Medical Devices	0.30991	0.16510001	0.81704	298177984	0.532	0.28342	289846016	269	buy	685615000	180856000	415	354.45		6.452	0.12236	6	387.33	0.433	0.12818	425	523031008	5658000	935257024	11.526	USD	20.685	5.407	2.4	NMS	ABIOMED, Inc.	Abiomed, Inc.	America/New_York	EDT		-14400000	EQUITY	ABMD	finmb_247589	a393224e-40ae-3cd2-a2c8-12a0912a9351	us_market	16.799	54.206	5.23	45296000	29.371	777624	0.0171	1617148800	0.93431	154412000	4.94	12.068027	0.02049	1680220800	1625011200	4.27	1626307200	44453569	1.302313	15711506432	2	970444800	2:1		17.45954	1628812800	8.42
2	Technology	506000	Accenture plc, a professional services company, provides strategy and consulting, interactive, and technology and operations services worldwide. The company also provides outsourcing services. It serves communications, media, high tech, software, and platform companies; banking, capital market, and …	Dublin	353 1 646 2000	nan	Ireland	[]	http://www.accenture.com	1	1 Grand Canal Square	Information Technology Services	0.16749	0.12051	0.31989	9694850048	0.207	0.15032	8031220224	290	buy	13976158000	8071195136	330	342.15	0.262	1.416	0.116730005	23	328.71	17.331	0.32209998	365	10013812736	3447866112	47949377536	15.791	USD	75.472	1.305	2.1	NYQ	Accenture plc	Accenture plc	America/New_York	EDT	true	-14400000	EQUITY	ACN	finmb_972190	64bf532c-0542-3794-9f22-7d6062a2458b	us_market	4.326	25.825	9.38	635646976	28.802	4670270	0.0074	1598832000	0.72690004	5778489856	8.45	11.879383	0.00127	1661904000	1622419200	2.93	1626307200	633217136	1.107584	207410200576	2	1325203200	10:1	0.262	4.5357547	1628812800	3.28
90405	Communication Services	9500	Activision Blizzard, Inc., together with its subsidiaries, develops and publishes interactive entertainment content and services in the Americas, Europe, the Middle East, Africa, and the Asia Pacific. The company operates through three segments: Activision Publishing, Inc.; Blizzard Entertainment, I…	Santa Monica	310 255 2000	CA	United States	[]	http://www.activisionblizzard.com	1	3100 Ocean Park Boulevard	Electronic Gaming & Multimedia	0.37894002	0.2919	0.72924006	2568000000	0.188	0.36194	3387000064	100	buy	5826000000	2376375040	117	78.09	0.493	4.832	0.09234	30	115.95	22.142	0.17412001	154	9624999936	3606000128	8938000384	12.376	USD	11.548	4.575	1.8	NMS	Activision Blizzard, Inc	Activision Blizzard, Inc.	America/New_York	EDT	true	-14400000	EQUITY	ATVI	finmb_4222231	c564fea5-667a-32d7-929a-597b64dca83b	us_market	6.39	16.863	4.42	777017024	19.734	13972369	0.018	1609372800	0.89155	2608999936	2.96	3.9571297	0.00721	1672444800	1625011200	1.54	1626307200	771937848	0.589519	57115373568	2	1220832000	2:1	0.51	6.7886834	1628812800	1.53
95110-2704	Technology	22516	Adobe Inc. operates as a diversified software company worldwide. Its Digital Media segment provides tools and solutions that enable individuals, teams, and enterprises to create, publish, promote, and monetize their digital content. Its flagship product is Creative Cloud, a subscription service that…	San Jose	408 536 6000	CA	United States	[]	http://www.adobe.com	1	345 Park Avenue	Software—Infrastructure	0.39815	0.38794	0.87865996	6977999872	0.226	0.3575	5728999936	550	buy	11146000000	5496374784	640	646.56	0.022	1.315	0.13627	25	646.31	33.88	0.45138	750	5768000000	4693000192	14389000192	12.107	USD	30.027	1.179	1.7	NMS	Adobe Inc.	Adobe Inc.	America/New_York	EDT	true	-14400000	EQUITY	ADBE	finmb_24321	bccf427f-30a1-3360-9ce4-c77a8198c902	us_market	20.95	52.617	14.03	478000000	28.979	4778345	0.01	1606435200	0.85213995	5582000128	11.538	22.311329	0.0031	1669507200	1622764800	2.95	1625011200	474856464	0.964497	301443776512	2	1116892800	2:1	0.015	21.478607	1627603200	2.94
95054	Technology	12600	Advanced Micro Devices, Inc. operates as a semiconductor company worldwide. The company operates in two segments, Computing and Graphics; and Enterprise, Embedded and Semi-Custom. Its products include x86 microprocessors as an accelerated processing unit, chipsets, discrete and integrated graphics p…	Santa Clara	408 749 4000	CA	United States	[]	http://www.amd.com	1	2485 Augustine Drive	Semiconductors	0.19331	0.25241	0.44791	2034000000	0.929	0.16363001	2208000000	90	buy	4347000000	1334249984	110	106.18	2.318	2.513	0.14682999	35	117.25	8.507	0.60605	172	3116000000	551000000	11422000128	2.565	USD	9.56	1.851	2.3	NMS	Advanced Micro Devices, Inc.	Advanced Micro Devices, Inc.	America/New_York	EDT		-14400000	EQUITY	AMD	finmb_168864	48af4341-f745-363f-945f-a838eeabb062	us_market	8.692	44.963	2.7	1215020032	5.331	84744445	0.069699995	1608940800	0.748	2883000064	2.382	19.917465	0.00522	1672012800	1616803200	1.77	1619740800	1208326210	2.030978	99278061568	2	966902400	2:1	2.426	11.294942	1622160000	1.35
27604	Consumer Cyclical	40000	Advance Auto Parts, Inc. provides automotive replacement parts, accessories, batteries, and maintenance items for domestic and imported cars, vans, sport utility vehicles, and light and heavy duty trucks. The company offers battery accessories; belts and hoses; brakes and brake pads; chassis and cli…	Raleigh	540 362 4911	NC	United States	[]	http://www.advanceautoparts.com	1	2635 East Millbrook Road	Specialty Retail	0.11545999	0.059169997	0.44679	1288711936	0.234	0.09229	1239875968	138	buy	4484775000	974514368	243.5	199.465	3.46	1.317	0.05175	16	233.19	99.793	0.18054001	256	880233024	3494320128	10738808832	13.563	USD	158.215	0.352	2.2	NYQ	Advance Auto Parts Inc Advance	Advance Auto Parts, Inc.	America/New_York	EDT	true	-14400000	EQUITY	AAP	finmb_24333	e77e78f9-7896-3fa1-acee-885058f2c91a	us_market	1.499	12.984	12.17	65438900	53.954	3760667	0.0575	1609545600	0.99179	635363008	9.309	3.6969457	0.00421	1672617600	1619222400	7.31	1626307200	64648360	1.371705	16098774016	2	1127692800	3:2	3.266	1.2154765	1628812800	1.23
22203	Utilities	8162	The AES Corporation operates as a diversified power generation and utility company. It owns and/or operates power plants to generate and sell power to customers, such as utilities, industrial users, and other intermediaries. The company also owns and/or operates utilities to generate or purchase, di…	Arlington	703 522 1315	VA	United States	[]	http://www.aes.com	1	4300 Wilson Boulevard	Utilities—Diversified	0.35834	-0.02471	0.26795	2635000064	0.127	0.25038	3568000000	27.5	buy	2511000000	308249984	30	24.0371		1.242	0.04494	9	30.06	347.137	-0.020750001	32	2072999936	19883999232	9957000192	3.111	USD	14.962	0.68	1.7	NYQ	The AES Corporation	The AES Corporation	America/New_York	EDT	true	-14400000	EQUITY	AES	finmb_35312	76b75934-57e2-3b50-befe-2dcd63cf388f	us_market	3.874	10.811	1.68	668112000	3.959	6917028	0.0104	1609372800	0.9917	-249000000	0.064	6.071508	0.0031400002	1672444800	1617148800	1.38	1620950400	664025372	0.792391	38574329856	2	959904000	2:1		1.6128829	1623715200	1.95


CREATE TABLE sp500_stocks_info (
  "zip" VARCHAR,
  "sector" VARCHAR,
  "fulltimeemployees" DOUBLE,
  "longbusinesssummary" VARCHAR,
  "city" VARCHAR,
  "phone" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "companyofficers" VARCHAR,
  "website" VARCHAR,
  "maxage" BIGINT,
  "address1" VARCHAR,
  "industry" VARCHAR,
  "ebitdamargins" DOUBLE,
  "profitmargins" DOUBLE,
  "grossmargins" DOUBLE,
  "operatingcashflow" DOUBLE,
  "revenuegrowth" DOUBLE,
  "operatingmargins" DOUBLE,
  "ebitda" DOUBLE,
  "targetlowprice" DOUBLE,
  "recommendationkey" VARCHAR,
  "grossprofits" DOUBLE,
  "freecashflow" DOUBLE,
  "targetmedianprice" DOUBLE,
  "currentprice" DOUBLE,
  "earningsgrowth" DOUBLE,
  "currentratio" DOUBLE,
  "returnonassets" DOUBLE,
  "numberofanalystopinions" DOUBLE,
  "targetmeanprice" DOUBLE,
  "debttoequity" DOUBLE,
  "returnonequity" DOUBLE,
  "targethighprice" DOUBLE,
  "totalcash" DOUBLE,
  "totaldebt" DOUBLE,
  "totalrevenue" DOUBLE,
  "totalcashpershare" DOUBLE,
  "financialcurrency" VARCHAR,
  "revenuepershare" DOUBLE,
  "quickratio" DOUBLE,
  "recommendationmean" DOUBLE,
  "exchange" VARCHAR,
  "shortname" VARCHAR,
  "longname" VARCHAR,
  "exchangetimezonename" VARCHAR,
  "exchangetimezoneshortname" VARCHAR,
  "isesgpopulated" BOOLEAN,
  "gmtoffsetmilliseconds" DOUBLE,
  "underlyingsymbol" VARCHAR,
  "quotetype" VARCHAR,
  "symbol" VARCHAR,
  "underlyingexchangesymbol" VARCHAR,
  "headsymbol" VARCHAR,
  "messageboardid" VARCHAR,
  "uuid" VARCHAR,
  "market" VARCHAR,
  "annualholdingsturnover" VARCHAR,
  "enterprisetorevenue" DOUBLE,
  "beta3year" VARCHAR,
  "enterprisetoebitda" DOUBLE,
  "n_52weekchange" VARCHAR,
  "morningstarriskrating" VARCHAR,
  "forwardeps" DOUBLE,
  "revenuequarterlygrowth" VARCHAR,
  "sharesoutstanding" DOUBLE,
  "fundinceptiondate" VARCHAR,
  "annualreportexpenseratio" VARCHAR,
  "totalassets" VARCHAR,
  "bookvalue" DOUBLE,
  "sharesshort" DOUBLE,
  "sharespercentsharesout" DOUBLE,
  "fundfamily" VARCHAR,
  "lastfiscalyearend" DOUBLE,
  "heldpercentinstitutions" DOUBLE,
  "netincometocommon" DOUBLE,
  "trailingeps" DOUBLE,
  "lastdividendvalue" VARCHAR,
  "sandp52weekchange" VARCHAR,
  "pricetobook" DOUBLE,
  "heldpercentinsiders" DOUBLE,
  "nextfiscalyearend" DOUBLE,
  "yield" VARCHAR,
  "mostrecentquarter" DOUBLE,
  "shortratio" DOUBLE,
  "sharesshortpreviousmonthdate" DOUBLE,
  "floatshares" DOUBLE,
  "beta" DOUBLE,
  "enterprisevalue" DOUBLE,
  "pricehint" BIGINT,
  "threeyearaveragereturn" VARCHAR,
  "lastsplitdate" DOUBLE,
  "lastsplitfactor" VARCHAR,
  "legaltype" VARCHAR,
  "morningstaroverallrating" VARCHAR,
  "earningsquarterlygrowth" DOUBLE,
  "pricetosalestrailing12months" DOUBLE,
  "dateshortinterest" DOUBLE,
  "pegratio" DOUBLE,
  "ytdreturn" VARCHAR
);