Nifty 50 Stocks Price Dataset
Nifty 50 Stocks Prices
@kaggle.tadakasuryateja_nifty_50_stocks
Nifty 50 Stocks Prices
@kaggle.tadakasuryateja_nifty_50_stocks
A dataset containing prices of Nifty 50 Stocks. Contains open, high, low, close prices, volume of the stock.
This dataset is meant to use for predicting the stock prices in future.
You may use linear regression or neural networks.****
CREATE TABLE adaniports (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE adanipower (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE asianpaint (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE axisbank (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE bajaj_auto (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE bajfinance (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE bharatras (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE bhartiartl (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE birlacorpn (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE bpcl (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE cipla (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE coalindia (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE drreddy (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE eichermot (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE gail (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE grasim (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE hcltech (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE hdfc (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE hdfcbank (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE heromotoco (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE ibulhsgfin (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE icicibank (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE indusindbk (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE infy (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);CREATE TABLE ioc (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE -- 1. Open,
"n_2_high" DOUBLE -- 2. High,
"n_3_low" DOUBLE -- 3. Low,
"n_4_close" DOUBLE -- 4. Close,
"n_5_adjusted_close" DOUBLE -- 5. Adjusted Close,
"n_6_volume" BIGINT -- 6. Volume,
"n_7_dividend_amount" DOUBLE -- 7. Dividend Amount,
"n_8_split_coefficient" DOUBLE -- 8. Split Coefficient
);Anyone who has the link will be able to view this.