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 itc (
"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 kotakbank (
"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 lt (
"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 lupin (
"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 mandm (
"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 maruti (
"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 mcdowell_n (
"date" VARCHAR,
"stock_name" VARCHAR,
"n_1_open" VARCHAR -- 1. Open,
"n_2_high" VARCHAR -- 2. High,
"n_3_low" VARCHAR -- 3. Low,
"n_4_close" VARCHAR -- 4. Close,
"n_5_adjusted_close" VARCHAR -- 5. Adjusted Close,
"n_6_volume" VARCHAR -- 6. Volume,
"n_7_dividend_amount" VARCHAR -- 7. Dividend Amount,
"n_8_split_coefficient" VARCHAR -- 8. Split Coefficient
);CREATE TABLE nestleind (
"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 ntpc (
"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 ongc (
"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 powergrid (
"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 reliance (
"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 sbin (
"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 sunpharma (
"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 tatamotors (
"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 tatasteel (
"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 tcs (
"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 techm (
"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 ultracemco (
"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 unionbank (
"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 vedl (
"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 wipro (
"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 zeel (
"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.