Name: Nifty Indices Dataset
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

Nifty Indices Dataset

Context

The National Stock Exchange of India Limited (NSE) is the leading stock exchange of India, located in Mumbai. The NIFTY 50 index is National Stock Exchange of India's benchmark broad based stock market index for the Indian equity market.

Apart from NIFTY 50 index, there are also other indices like NIFTY Next 50, Nifty Midcap 150 etc. Exploring these indices may help in taking investment decisions.

Content

This dataset has day level information on major NIFTY indices starting from 01 January 2000.

Each file represents an index and has the following columns

Date - date of observation
Open - open value of the index on that day
High - highest value of the index on that day
Low - lowest value of the index on that day
Close - closing value of the index on that day
Volume - volume of transaction
Turnover - turn over
P/E - price to earnings ratio
P/B - price to book value
Div Yield - dividend yield

Acknowledgements

The data is obtained from NSE website with the help of nsepy python package.

Photo credits: Photo by M. B. M. on Unsplash

Inspiration

Who wants to predict the future of stock prices? ;)

Tables

Indiavix

@kaggle.sudalairajkumar_nifty_indices_dataset.indiavix

123.54 KB
3061 rows
8 columns


CREATE TABLE indiavix (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "previous" DOUBLE,
  "change" DOUBLE,
  "n__change" DOUBLE
);

Nifty 100

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_100

234.96 KB
4603 rows
10 columns


CREATE TABLE nifty_100 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "turnover" DOUBLE,
  "p_e" DOUBLE,
  "p_b" DOUBLE,
  "div_yield" DOUBLE
);

Nifty 50

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_50

232.88 KB
5970 rows
8 columns


CREATE TABLE nifty_50 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "p_e" DOUBLE,
  "p_b" DOUBLE,
  "div_yield" VARCHAR
);

Nifty 500

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_500

297.88 KB
5353 rows
10 columns


CREATE TABLE nifty_500 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "turnover" DOUBLE,
  "p_e" DOUBLE,
  "p_b" DOUBLE,
  "div_yield" DOUBLE
);

Nifty Auto

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_auto

181.4 KB
4350 rows
10 columns


CREATE TABLE nifty_auto (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "turnover" DOUBLE,
  "p_e" DOUBLE,
  "p_b" DOUBLE,
  "div_yield" DOUBLE
);

Nifty Bank

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_bank

263.67 KB
5354 rows
10 columns


CREATE TABLE nifty_bank (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "turnover" DOUBLE,
  "p_e" DOUBLE,
  "p_b" DOUBLE,
  "div_yield" DOUBLE
);

Nifty Fmcg

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_fmcg

210.83 KB
5353 rows
10 columns


CREATE TABLE nifty_fmcg (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "turnover" DOUBLE,
  "p_e" DOUBLE,
  "p_b" DOUBLE,
  "div_yield" DOUBLE
);

Nifty It

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_it

290.71 KB
5354 rows
10 columns


CREATE TABLE nifty_it (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "turnover" DOUBLE,
  "p_e" DOUBLE,
  "p_b" DOUBLE,
  "div_yield" DOUBLE
);

Nifty Metal

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_metal

138.37 KB
2474 rows
10 columns


CREATE TABLE nifty_metal (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "turnover" DOUBLE,
  "p_e" DOUBLE,
  "p_b" DOUBLE,
  "div_yield" DOUBLE
);

Nifty Microcap 250

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_microcap_250

117.04 KB
4653 rows
8 columns


CREATE TABLE nifty_microcap_250 (
  "date" TIMESTAMP,
  "open" VARCHAR,
  "high" VARCHAR,
  "low" VARCHAR,
  "close" DOUBLE,
  "p_e" VARCHAR,
  "p_b" VARCHAR,
  "div_yield" VARCHAR
);

Nifty Midcap 150

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_midcap_150

129.48 KB
4652 rows
8 columns


CREATE TABLE nifty_midcap_150 (
  "date" TIMESTAMP,
  "open" VARCHAR,
  "high" VARCHAR,
  "low" VARCHAR,
  "close" DOUBLE,
  "p_e" VARCHAR,
  "p_b" DOUBLE,
  "div_yield" DOUBLE
);

Nifty Next 50

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_next_50

246.07 KB
5970 rows
8 columns


CREATE TABLE nifty_next_50 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "p_e" DOUBLE,
  "p_b" DOUBLE,
  "div_yield" VARCHAR
);

Nifty Pharma

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_pharma

208.9 KB
5103 rows
10 columns


CREATE TABLE nifty_pharma (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "turnover" DOUBLE,
  "p_e" DOUBLE,
  "p_b" DOUBLE,
  "div_yield" DOUBLE
);

Nifty Smallcap 250

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_smallcap_250

169.14 KB
8040 rows
8 columns


CREATE TABLE nifty_smallcap_250 (
  "date" TIMESTAMP,
  "open" VARCHAR,
  "high" VARCHAR,
  "low" VARCHAR,
  "close" DOUBLE,
  "p_e" VARCHAR,
  "p_b" VARCHAR,
  "div_yield" VARCHAR
);