Name: Stocks: Tech, AI & Magnificent Seven
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Stocks: Tech, AI & Magnificent Seven

Seven companies that are pushing the Tech and AI space. This Dataset was created off of recent news of Apple wanting Google's Gemini to handle all its AI features. You can read it here: https://www.forbes.com/sites/siladityaray/2024/03/18/apple-reportedly-in-talks-with-google-to-integrate-geminis-ai-service-into-the-iphone/

As well as the Recent news of NVDA and its new chip! Read here: https://www.ft.com/content/ac1fae16-59d7-44ac-b196-635400d2c727

Tables

Aapl1424

@kaggle.princeiornongu_stocks_tech_ai_and_magnificent_seven.aapl1424

421.07 kB
2,570 rows
19 columns

CREATE TABLE aapl1424 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT,
  "atr_7_days" DOUBLE  -- ATR (7 Days),
  "rsi_7_days" DOUBLE  -- RSI (7 Days),
  "rsi_14_days" DOUBLE  -- RSI (14 Days),
  "ema_50_days" DOUBLE  -- EMA (50 Days),
  "ema_100_days" DOUBLE  -- EMA (100 Days),
  "sma_50_days" DOUBLE  -- SMA (50 Days),
  "sma_100_days" DOUBLE  -- SMA (100 Days),
  "log_return" DOUBLE,
  "percent_return" DOUBLE,
  "cumulative_log_return" DOUBLE,
  "cumulative_percent_return" DOUBLE
);

Amzn1424

@kaggle.princeiornongu_stocks_tech_ai_and_magnificent_seven.amzn1424

408.75 kB
2,570 rows
18 columns

CREATE TABLE amzn1424 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT,
  "atr_7_days" DOUBLE  -- ATR (7 Days),
  "rsi_7_days" DOUBLE  -- RSI (7 Days),
  "rsi_14_days" DOUBLE  -- RSI (14 Days),
  "ema_50_days" DOUBLE  -- EMA (50 Days),
  "ema_100_days" DOUBLE  -- EMA (100 Days),
  "sma_50_days" DOUBLE  -- SMA (50 Days),
  "sma_100_days" DOUBLE  -- SMA (100 Days),
  "log_return" DOUBLE,
  "percent_return" DOUBLE,
  "cumulative_log_return" DOUBLE,
  "cumulative_percent_return" DOUBLE
);

Googl1424

@kaggle.princeiornongu_stocks_tech_ai_and_magnificent_seven.googl1424

422.67 kB
2,570 rows
19 columns

CREATE TABLE googl1424 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT,
  "atr_7_days" DOUBLE  -- ATR (7 Days),
  "rsi_7_days" DOUBLE  -- RSI (7 Days),
  "rsi_14_days" DOUBLE  -- RSI (14 Days),
  "ema_50_days" DOUBLE  -- EMA (50 Days),
  "ema_100_days" DOUBLE  -- EMA (100 Days),
  "sma_50_days" DOUBLE  -- SMA (50 Days),
  "sma_100_days" DOUBLE  -- SMA (100 Days),
  "log_return" DOUBLE,
  "percent_return" DOUBLE,
  "cumulative_log_return" DOUBLE,
  "cumulative_percent_return" DOUBLE
);

Meta1424

@kaggle.princeiornongu_stocks_tech_ai_and_magnificent_seven.meta1424

420.37 kB
2,570 rows
19 columns

CREATE TABLE meta1424 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT,
  "atr_7_days" DOUBLE  -- ATR (7 Days),
  "rsi_7_days" DOUBLE  -- RSI (7 Days),
  "rsi_14_days" DOUBLE  -- RSI (14 Days),
  "ema_50_days" DOUBLE  -- EMA (50 Days),
  "ema_100_days" DOUBLE  -- EMA (100 Days),
  "sma_50_days" DOUBLE  -- SMA (50 Days),
  "sma_100_days" DOUBLE  -- SMA (100 Days),
  "log_return" DOUBLE,
  "percent_return" DOUBLE,
  "cumulative_log_return" DOUBLE,
  "cumulative_percent_return" DOUBLE
);

Msft1424

@kaggle.princeiornongu_stocks_tech_ai_and_magnificent_seven.msft1424

418.23 kB
2,570 rows
19 columns

CREATE TABLE msft1424 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT,
  "atr_7_days" DOUBLE  -- ATR (7 Days),
  "rsi_7_days" DOUBLE  -- RSI (7 Days),
  "rsi_14_days" DOUBLE  -- RSI (14 Days),
  "ema_50_days" DOUBLE  -- EMA (50 Days),
  "ema_100_days" DOUBLE  -- EMA (100 Days),
  "sma_50_days" DOUBLE  -- SMA (50 Days),
  "sma_100_days" DOUBLE  -- SMA (100 Days),
  "log_return" DOUBLE,
  "percent_return" DOUBLE,
  "cumulative_log_return" DOUBLE,
  "cumulative_percent_return" DOUBLE
);

Nvda1424

@kaggle.princeiornongu_stocks_tech_ai_and_magnificent_seven.nvda1424

423.15 kB
2,570 rows
19 columns

CREATE TABLE nvda1424 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT,
  "atr_7_days" DOUBLE  -- ATR (7 Days),
  "rsi_7_days" DOUBLE  -- RSI (7 Days),
  "rsi_14_days" DOUBLE  -- RSI (14 Days),
  "ema_50_days" DOUBLE  -- EMA (50 Days),
  "ema_100_days" DOUBLE  -- EMA (100 Days),
  "sma_50_days" DOUBLE  -- SMA (50 Days),
  "sma_100_days" DOUBLE  -- SMA (100 Days),
  "log_return" DOUBLE,
  "percent_return" DOUBLE,
  "cumulative_log_return" DOUBLE,
  "cumulative_percent_return" DOUBLE
);

Tsla1424

@kaggle.princeiornongu_stocks_tech_ai_and_magnificent_seven.tsla1424

424.02 kB
2,570 rows
19 columns

CREATE TABLE tsla1424 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT,
  "atr_7_days" DOUBLE  -- ATR (7 Days),
  "rsi_7_days" DOUBLE  -- RSI (7 Days),
  "rsi_14_days" DOUBLE  -- RSI (14 Days),
  "ema_50_days" DOUBLE  -- EMA (50 Days),
  "ema_100_days" DOUBLE  -- EMA (100 Days),
  "sma_50_days" DOUBLE  -- SMA (50 Days),
  "sma_100_days" DOUBLE  -- SMA (100 Days),
  "log_return" DOUBLE,
  "percent_return" DOUBLE,
  "cumulative_log_return" DOUBLE,
  "cumulative_percent_return" DOUBLE
);