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)

Dividend Stocks Only

@kaggle.gonzalezfrancisco_full_nasdaq_stocks_data.dividend_stocks_only

391 KB
1939 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
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
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
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
ABBV	AbbVie Inc. Common Stock	N	N	nan	60064	Healthcare	30000	North Chicago	IL	United States	Drug Manufacturers—General	85.55353	0.049608644	11022200	90.71	90.54	11022200	4.72	9896993	158576246784	13578856	88.56	91.99	97.86	8.727449	3.89	0.0525	800	91	4.402	10.31	-5.021	24803626	2	1474586171	149935276032	90.54	1.18
ABEV	Ambev S.A. American Depositary Shares (Each representing 1 Common Share)	N	N	nan	04530-001	Consumer Defensive	50000	Sao Paulo	SP	Brazil	Beverages—Brewers	3.4084558	0.060425535	35990728	2.35	2.5	35990728	0.12	49901167	39764787200	35349982	2.42	2.64	5.45	17.266665	2.32	0.0514	38500	2.59		0.15	0.987	60265627	3.15	4393778927	33826134016	2.5	0.120835
ABM	ABM Industries Incorporated Common Stock	N	N	nan	10006	Industrials	140000	New York	NY	United States	Specialty Business Services	34.402206	0.021223655	319742	34.16	34.33	319742	0.74	473730	2232131840	578687	32.73	36.83	42.67	17.179487	1.93	0.0217	800	34.44	0.496	1.95	23.365	2805854	4.63	60704669	3227732224	34.33	0.185
ABR	Arbor Realty Trust Common Stock	N	N	nan	11553	Real Estate	532	Uniondale	NY	United States	REIT—Mortgage	11.24978	0.14217444	2182914	8.37	8.69	2182914	1.2	2242564	938236032	3095254	8.1458	8.7	15.77	6.9186993	8.71	0.1434	1100	8.95	20.189	1.23	8.92	4021472	1.35	99797358	6361600512	8.69	0.3


CREATE TABLE dividend_stocks_only (
  "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
);