S&P 500 Stocks (daily Updated)
Stock and company data on all members of the popular financial index.
@kaggle.andrewmvd_sp_500_stocks
Stock and company data on all members of the popular financial index.
@kaggle.andrewmvd_sp_500_stocks
CREATE TABLE sp500_companies (
"exchange" VARCHAR,
"symbol" VARCHAR,
"shortname" VARCHAR,
"longname" VARCHAR,
"sector" VARCHAR,
"industry" VARCHAR,
"currentprice" DOUBLE,
"marketcap" BIGINT,
"ebitda" DOUBLE,
"revenuegrowth" DOUBLE,
"city" VARCHAR,
"state" VARCHAR,
"country" VARCHAR,
"fulltimeemployees" DOUBLE,
"longbusinesssummary" VARCHAR,
"weight" DOUBLE
);
CREATE TABLE sp500_index (
"date" TIMESTAMP,
"s_p500" DOUBLE
);
CREATE TABLE sp500_stocks (
"date" TIMESTAMP,
"symbol" VARCHAR,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);
Anyone who has the link will be able to view this.