Nifty 50 Stocks Price Dataset
Nifty 50 Stocks Prices
@kaggle.tadakasuryateja_nifty_50_stocks
Nifty 50 Stocks Prices
@kaggle.tadakasuryateja_nifty_50_stocks
CREATE TABLE itc (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE kotakbank (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE lt (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE lupin (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE mandm (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE maruti (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE mcdowell_n (
"date" VARCHAR,
"stock_name" VARCHAR,
"n_1_open" VARCHAR,
"n_2_high" VARCHAR,
"n_3_low" VARCHAR,
"n_4_close" VARCHAR,
"n_5_adjusted_close" VARCHAR,
"n_6_volume" VARCHAR,
"n_7_dividend_amount" VARCHAR,
"n_8_split_coefficient" VARCHAR
);
CREATE TABLE nestleind (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE ntpc (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE ongc (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE powergrid (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE reliance (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE sbin (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE sunpharma (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE tatamotors (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE tatasteel (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE tcs (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE techm (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE ultracemco (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE unionbank (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE vedl (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE wipro (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
CREATE TABLE zeel (
"date" TIMESTAMP,
"stock_name" VARCHAR,
"n_1_open" DOUBLE,
"n_2_high" DOUBLE,
"n_3_low" DOUBLE,
"n_4_close" DOUBLE,
"n_5_adjusted_close" DOUBLE,
"n_6_volume" BIGINT,
"n_7_dividend_amount" DOUBLE,
"n_8_split_coefficient" DOUBLE
);
Anyone who has the link will be able to view this.