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 crl (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crm (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crmt (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crnt (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crnx (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cron (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crox (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crsp (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crto (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crus (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crusc (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE crvl (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crvs (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crws (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crzo (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE csa (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csb (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csbr (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csco (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csf (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csfl (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE csgp (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csgs (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csii (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csiq (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csml (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csod (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE cspi (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csq (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csse (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cssep (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cste (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cstr (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cswc (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cswcl (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE cswi (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csx (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctas (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctbi (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctg (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cthr (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctib (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctic (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctlt (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctmx (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctra (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctre (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctrl (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE ctrn (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctrp (
"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.