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 crto (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crtx (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crus (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crvl (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crvs (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crwd (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE crws (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csbr (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csco (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cscw (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csgp (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csgs (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csii (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csiq (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csod (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cspi (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csq (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csse (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cssen (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cssep (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cste (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cstl (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cstr (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cswc (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cswi (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE csx (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctaqu (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctas (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctbi (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctg (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cthr (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctib (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctic (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctmx (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctre (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctrm (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctrn (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctsh (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctso (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctxr (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ctxrw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE ctxs (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cuba (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cue (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE curi (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE curiw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE cutr (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cvac (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cvbf (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cvco (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);Anyone who has the link will be able to view this.