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 adaniports (
"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 adanipower (
"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 asianpaint (
"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 axisbank (
"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 bajaj_auto (
"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 bajfinance (
"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 bharatras (
"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 bhartiartl (
"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 birlacorpn (
"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 bpcl (
"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 cipla (
"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 coalindia (
"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 drreddy (
"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 eichermot (
"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 gail (
"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 grasim (
"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 hcltech (
"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 hdfc (
"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 hdfcbank (
"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 heromotoco (
"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 ibulhsgfin (
"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 icicibank (
"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 indusindbk (
"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 infy (
"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 ioc (
"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.