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 fdusl (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE fdx (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fe (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE feim (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fele (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fem (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE femb (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fems (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fenc (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fep (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE feuz (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fex (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE feye (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE ffbc (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ffbcw (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE ffbw (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ffhl (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ffic (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ffin (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ffiv (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ffnw (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ffwm (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fgbi (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fgen (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fgm (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fhb (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fhk (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE fibk (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE finx (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fis (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fisi (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fisv (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fitb (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fitbi (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE five (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fivn (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fixd (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fixx (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fizz (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fjp (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fko (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE fku (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE flat (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE fldm (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE flex (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE flgt (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE flic (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);CREATE TABLE flir (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE flks (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"adj_close" VARCHAR,
"close" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"open" VARCHAR,
"volume" VARCHAR
);CREATE TABLE fll (
"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.