Full Nasdaq Stocks Data

Two datasets containing detailed information about 4400+ stocks traded in Nasdaq

@kaggle.gonzalezfrancisco_full_nasdaq_stocks_data

Table List

2 tables(1.06 MB)

Full Financial Stocks Raw

@kaggle.gonzalezfrancisco_full_nasdaq_stocks_data.full_financial_stocks_raw

694.22 KB
4447 rows
40 columns

symbol Symbol	security_name Security Name	listing_exchange Listing Exchange	etf Etf	financial_status Financial Status	zip Zip	sector Sector	fulltimeemployees FullTimeEmployees	city City	state State	country Country	industry Industry	twohundreddayaverage TwoHundredDayAverage	trailingannualdividendyield TrailingAnnualDividendYield	averagedailyvolume10day AverageDailyVolume10Day	regularmarketpreviousclose RegularMarketPreviousClose	open Open	averagevolume10days AverageVolume10days	dividendrate DividendRate	regularmarketvolume RegularMarketVolume	marketcap MarketCap	averagevolume AverageVolume	daylow DayLow	ask Ask	fiftytwoweekhigh FiftyTwoWeekHigh	forwardpe ForwardPE	fiveyearavgdividendyield FiveYearAvgDividendYield	dividendyield DividendYield	bidsize BidSize	dayhigh DayHigh	enterprisetorevenue EnterpriseToRevenue	forwardeps ForwardEps	bookvalue BookValue	sharesshort SharesShort	shortratio ShortRatio	floatshares FloatShares	enterprisevalue EnterpriseValue	regularmarketprice RegularMarketPrice	latest_dividend Latest Dividend
A	Agilent Technologies, Inc. Common Stock	N	N	nan	95051	Healthcare	16300	Santa Clara	CA	United States	Diagnostics & Research	79.98419	0.0078021595	2807514	86.13	86.3	2807514	0.72	1847602	26543439872	2616254	84.37	87.2	90.64	24.140057	0.92	0.0084	1400	86.48	4.987	3.57	15.636	5258241	2.55	308518035	26110310400	86.3	0.18
AA	Alcoa Corporation Common Stock	N	N	nan	15212	Basic Materials	13800	Pittsburgh	PA	United States	Aluminum	13.778677	0.04109589	9643371	8.76	9.12	9643371		11237725	1814569600	9784741	8.925	9.9	24.63	-40.666668			1800	9.79	0.417	-0.24	22.994	11633009	1.1	185121237	4210364928	9.12	0.09
AADR	AdvisorShares Dorsey Wright ADR ETF	P	Y	nan	nan	nan		nan	nan	nan	nan	49.253677		3914	48.275	47.59	3914		3019		18675	47.3664		57.51				800	48.221								47.59	0.008
AAL	American Airlines Group, Inc. - Common Stock	Q	N	N	76155	Industrials	131500	Fort Worth	TX	United States	Airlines	20.70919	0.035906643	66709542	11.14	12.43	66709542	0.4	99314752	5066270208	69955775	11.07	11.94	34.99	-299.5	1.14	0.0359	4000	12.55	0.796	-0.04	-6.233	119303588	1.49	416754073	34785148928	12.43	0.1
AAME	Atlantic American Corporation - Common Stock	Q	N	N	30319	Financial Services	151	Atlanta	GA	United States	Insurance—Life	2.0177207	0.01025641	1185	1.95	1.95	1185		453	38322000	2308	1.83		2.95		0.65		800	1.95	0.371		4.964	1620	0.46	4879047	67789672	1.95	0.02
AAP	Advance Auto Parts Inc Advance Auto Parts Inc W/I	N	N	nan	27604	Consumer Cyclical	39000	Raleigh	NC	United States	Specialty Retail	133.3967	0.0017701725	1514942	135.58	137.5	1514942	1	798726	9792331776	1208891	136.31	141.63	171.43	16.593678	0.18	0.0070999996	1300	141.78	1.175	8.54	51.606	1691705	1.57	68575245	11410747392	137.5	0.25
AAPL	Apple Inc. - Common Stock	Q	N	N	95014	Technology	137000	Cupertino	CA	United States	Consumer Electronics	286.9998	0.00972437	27552328	316.73	316.14	27552328	3.28	26969168	1378793553920	50365603	313.09	316.98	327.85	21.596062	1.59	0.010299999	800	318.71	5.108	14.73	18.137	33592445	0.89	4329827292	1368917278720	316.14	0.82
AAT	American Assets Trust, Inc. Common Stock	N	N	nan	92130	Real Estate	205	San Diego	CA	United States	REIT—Diversified	37.83544	0.04296296	349871	27	28.01	349871	0.8	330037	1687307264	454533	27.21	31.42	49.26	20.807407	2.59	0.0296	800	28.52	7.849	1.35	21.713	706006	1.7	53088019	2936203264	28.01	0.3
AAXJ	iShares MSCI All Country Asia ex Japan Index Fund	Q	Y	N	nan	nan		nan	nan	nan	nan	67.59066		957814	63.9	63.96	957814		870264		1704800	63.18	64.21	76.44				1800	64.01								63.96	0.933
ABB	ABB Ltd Common Stock	N	N	nan	8050	Industrials	144000	Zurich	nan	Switzerland	Electrical Equipment & Parts	20.96228	0.04253347	2318342	19.42	19.66	2318342	0.83	1714743	41781137408	2738256	19.345	19.75	25.3	20.589474	3.04	0.0422	2200	19.69	1.71	0.95	5.423	2148715	1.04	1744091278	46751436800	19.66	0.774


CREATE TABLE full_financial_stocks_raw (
  "symbol" VARCHAR,
  "security_name" VARCHAR,
  "listing_exchange" VARCHAR,
  "etf" VARCHAR,
  "financial_status" VARCHAR,
  "zip" VARCHAR,
  "sector" VARCHAR,
  "fulltimeemployees" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "industry" VARCHAR,
  "twohundreddayaverage" DOUBLE,
  "trailingannualdividendyield" DOUBLE,
  "averagedailyvolume10day" BIGINT,
  "regularmarketpreviousclose" DOUBLE,
  "open" DOUBLE,
  "averagevolume10days" BIGINT,
  "dividendrate" DOUBLE,
  "regularmarketvolume" BIGINT,
  "marketcap" DOUBLE,
  "averagevolume" BIGINT,
  "daylow" DOUBLE,
  "ask" DOUBLE,
  "fiftytwoweekhigh" DOUBLE,
  "forwardpe" DOUBLE,
  "fiveyearavgdividendyield" DOUBLE,
  "dividendyield" DOUBLE,
  "bidsize" DOUBLE,
  "dayhigh" DOUBLE,
  "enterprisetorevenue" DOUBLE,
  "forwardeps" DOUBLE,
  "revenuequarterlygrowth" VARCHAR,
  "bookvalue" DOUBLE,
  "sharesshort" DOUBLE,
  "shortratio" DOUBLE,
  "floatshares" DOUBLE,
  "enterprisevalue" DOUBLE,
  "regularmarketprice" DOUBLE,
  "latest_dividend" DOUBLE
);