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 cers (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cert (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cetx (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cetxp (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cetxw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE ceva (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cfac (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cfacu (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cfacw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE cfb (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cfbk (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cffi (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cffn (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cffvu (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cffvw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE cfii (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" VARCHAR
);CREATE TABLE cfiiu (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" VARCHAR
);CREATE TABLE cfiiw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE cfivu (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cfms (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cfrx (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cfv (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE cg (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cgbd (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cgc (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cgem (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cgen (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cgix (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cgntv (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE cgnx (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cgo (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cgro (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cgrou (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cgrow (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chci (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chco (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chdn (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chef (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chek (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chekz (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE chfs (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chi (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chkp (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chma (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chmg (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chng (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chngu (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chnr (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chpm (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE chpmu (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" VARCHAR
);Anyone who has the link will be able to view this.