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 opht (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE opk (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE opnt (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE opof (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE opra (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE oprx (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE optn (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE optt (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE orbc (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE orbk (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE orcl (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE org (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE orgs (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE orig (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE orit (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE orly (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ormp (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE orpn (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE orrf (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE osbc (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE osbcp (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE osir (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE osis (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE osn (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE ospn (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);Anyone who has the link will be able to view this.