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 bpopm (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bpopn (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bprn (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bpth (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bpy (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bpypn (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bpypo (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bpypp (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bpyu (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bpyup (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE brez (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE brezr (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE brezw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE brid (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE brkl (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE brkr (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE brks (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE brli (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE brlir (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE brliu (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" VARCHAR
);CREATE TABLE brliw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE brog (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE brogw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE brp (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE brpa (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE brpar (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE brpau (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" VARCHAR
);CREATE TABLE brpaw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE brqs (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bry (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bsbk (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bset (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bsgm (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bsqr (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bsrr (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bsvn (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE bsy (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE btai (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE btaq (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE btaqu (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE btaqw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE btbt (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE btnb (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE btnbu (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE btnbw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE btrs (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE btrsw (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE btwn (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE btwnu (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE btwnw (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);Anyone who has the link will be able to view this.