Stock Market Dataset

Historical daily prices of Nasdaq-traded stocks and ETFs

@kaggle.jacksoncrow_stock_market_dataset

Table List

1 table(316.93 KB)

Symbols Valid Meta

@kaggle.jacksoncrow_stock_market_dataset.symbols_valid_meta

316.93 KB
8049 rows
12 columns

nasdaq_traded Nasdaq Traded	symbol Symbol	security_name Security Name	listing_exchange Listing Exchange	market_category Market Category	etf ETF	round_lot_size Round Lot Size	test_issue Test Issue	financial_status Financial Status	cqs_symbol CQS Symbol	nasdaq_symbol NASDAQ Symbol	nextshares NextShares
Y	A	Agilent Technologies, Inc. Common Stock	N		N	100	N	nan	A	A	N
Y	AA	Alcoa Corporation Common Stock	N		N	100	N	nan	AA	AA	N
Y	AAAU	Perth Mint Physical Gold ETF	P		Y	100	N	nan	AAAU	AAAU	N
Y	AACG	ATA Creativity Global - American Depositary Shares, each representing two common shares	Q	G	N	100	N	N	nan	AACG	N
Y	AADR	AdvisorShares Dorsey Wright ADR ETF	P		Y	100	N	nan	AADR	AADR	N
Y	AAL	American Airlines Group, Inc. - Common Stock	Q	Q	N	100	N	N	nan	AAL	N
Y	AAMC	Altisource Asset Management Corp Com	A		N	100	N	nan	AAMC	AAMC	N
Y	AAME	Atlantic American Corporation - Common Stock	Q	G	N	100	N	N	nan	AAME	N
Y	AAN	Aaron's, Inc. Common Stock	N		N	100	N	nan	AAN	AAN	N
Y	AAOI	Applied Optoelectronics, Inc. - Common Stock	Q	G	N	100	N	N	nan	AAOI	N


CREATE TABLE symbols_valid_meta (
  "nasdaq_traded" VARCHAR,
  "symbol" VARCHAR,
  "security_name" VARCHAR,
  "listing_exchange" VARCHAR,
  "market_category" VARCHAR,
  "etf" VARCHAR,
  "round_lot_size" DOUBLE,
  "test_issue" VARCHAR,
  "financial_status" VARCHAR,
  "cqs_symbol" VARCHAR,
  "nasdaq_symbol" VARCHAR,
  "nextshares" VARCHAR
);