2000+ Assets (Stock & FX) Historical Price
frequency update, 2000+ assets, since IPO, included S&P500, NASDAQ and FX
@kaggle.benjaminpo_sp500_spx_components_stock_price
frequency update, 2000+ assets, since IPO, included S&P500, NASDAQ and FX
@kaggle.benjaminpo_sp500_spx_components_stock_price
These dataset included 2000+ assets, since IPO, included S&P500, NASDAQ and FX. These data files are generated by my python script.
The data is collected from Yahoo Finance.
CREATE TABLE tcco (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tcda (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tcfc (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tcgp (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE tcmd (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tcon (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tcpc (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tcrd (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE tcx (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tdac (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE tdacu (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE tdacw (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE tdg (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tdiv (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tdy (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE team (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tecd (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE tech (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tedu (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tel (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tell (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tenb (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tenx (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ter (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE terp (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE tess (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tfc (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tfsl (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tfx (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tga (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tgen (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tgls (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tgt (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tgtx (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE thb_x (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE thff (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE thrm (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE thst (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tibr (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE tibru (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE tibrw (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE tile (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tipt (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tisa (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE titn (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tivo (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE tjx (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tkksu (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE tlf (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE tlgt (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);Anyone who has the link will be able to view this.