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 svbi (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE svra (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE svvc (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE swin (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE swir (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE swk (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE swks (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE sybt (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE sybx (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE syf (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE syk (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE syke (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE symc (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE syna (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE sync (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE synh (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE synl (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE synt (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE sypr (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE syrs (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE syy (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE t (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ta (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE taco (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE tacow (
"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.