Dataset: S&P 500 + Popular Stocks: Daily Trends & % Change

About this Dataset

S&P 500 + Popular Stocks: Daily Trends & % Change

S&P 500 daily increase trend and amount change in %. There also other stocks with increase trend and change % to provide a comparison.

This dataset encompasses daily data from 2012 to 2021, with some missing days. However, there is no null data present. The dataset includes stock data for companies such as ADBE, INTC, MSFT, AMD, NVDA, DIS, NFLX, TSLA, META, and KFC.

Column Descriptions:

Date: Dates are in year-month-day format, covering the period from 2012 to 2021. While the data is daily, there are notable gaps (several missing days).
sp500_increase: Indicates whether the S&P 500 increased on a given day, with a value of 1 denoting an increase and 0 denoting a decrease.
sp500_changep: Represents the percentage change in the S&P 500 on that specific day.
Other stocks follow a similar structure with columns such as "_increase", indicating if the stock increased, and "_changep", indicating the percentage change, analogous to the sp500_increase and sp500_changep columns.
This dataset is compiled to analyze the impact of fluctuations in the S&P 500 on other stocks.

Tables

Sp500 Trends

@kaggle.atacs26_s_and_p_500_popular_stocks_daily_trends_and_change.sp500_trends

263.07 KB
2128 rows
24 columns


CREATE TABLE sp500_trends (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "sp500_increase" BIGINT,
  "sp500_changep" DOUBLE,
  "adbe_increase" BIGINT,
  "adbe_changep" DOUBLE,
  "intc_increase" BIGINT,
  "intc_changep" DOUBLE,
  "msft_increase" BIGINT,
  "msft_changep" DOUBLE,
  "amd_increase" BIGINT,
  "amd_changep" DOUBLE,
  "nvda_increase" BIGINT,
  "nvda_changep" DOUBLE,
  "dis_increase" BIGINT,
  "dis_changep" DOUBLE,
  "nflx_increase" BIGINT,
  "nflx_changep" DOUBLE,
  "tsla_increase" BIGINT,
  "tsla_changep" DOUBLE,
  "meta_increase" BIGINT,
  "meta_changep" DOUBLE,
  "kfc_increase" BIGINT,
  "kfc_changep" DOUBLE
);