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
The Standard and Poor's 500 or S&P 500 is the most famous financial benchmark in the world.
This stock market index tracks the performance of 500 large companies listed on stock exchanges in the United States. As of December 31, 2020, more than $5.4 trillion was invested in assets tied to the performance of this index.
Because the index includes multiple classes of stock of some constituent companies—for example, Alphabet's Class A (GOOGL) and Class C (GOOG)—there are actually 505 stocks in the gauge.
- Create a time series regression model to predict S&P value and/or stock prices.
- Your kernel can be featured here!
License
CC0: Public Domain
Splash banner
Stonks by unknown memer.
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 -- S\u0026P500
);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.