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 nymx (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE oas (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE obas (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE obci (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE obln (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE obnk (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE obsv (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ocaxu (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE occ (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE occi (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE occip (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ocfc (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ocfcp (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ocg (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ocgn (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ocsi (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" VARCHAR
);CREATE TABLE ocsl (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ocul (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ocup (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE odfl (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE odp (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE odt (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE oeg (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE oepwu (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE oesx (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ofed (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ofix (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE oflx (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ofs (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ofssg (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ofssi (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE ofssl (
"datetime" VARCHAR,
"open" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close" VARCHAR,
"adj_close" VARCHAR,
"volume" VARCHAR
);CREATE TABLE ofssz (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" VARCHAR
);CREATE TABLE ogi (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE oiim (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE okta (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE olb (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE oled (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE olli (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE olma (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE om (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE omab (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE omcl (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE omeg (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE omer (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE omex (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE omp (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE on (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE onb (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE oncr (
"datetime" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);Anyone who has the link will be able to view this.