Big Stock Data
Thousands of stocks from the us market with a 1min resolution.
@kaggle.lszltakcs_big_stock_data
Thousands of stocks from the us market with a 1min resolution.
@kaggle.lszltakcs_big_stock_data
The data was scraped from yahoo finance so there is a lot of missing data. Also it is adjusted for splits and dividends.
Aftermarket hours are not included.
CREATE TABLE imnm (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE imos (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE imra (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE imrn (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE imrnw (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" VARCHAR,
"volume" DOUBLE
);CREATE TABLE imte (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE imtx (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE imtxw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE imux (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE imv (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE imvt (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE imxi (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inaq (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE inaqu (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE inaqw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE inbk (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inbkl (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inbkz (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inbx (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE incy (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE indb (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE indt (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE infi (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE infn (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ingn (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inkau (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inm (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inmb (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inmd (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ino (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inod (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inov (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inpx (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inse (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE insg (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE insm (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE intc (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE intg (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE intu (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE intz (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inva (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inve (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE invo (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE inzy (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ions (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE iosp (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE iova (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ipa (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ipar (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ipdn (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);Anyone who has the link will be able to view this.