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

126.51 kB
3,061 rows
8 columns

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

Nifty 100

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_100

240.59 kB
4,603 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

238.47 kB
5,970 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  -- Div Yield %
);

Nifty 500

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_500

305.03 kB
5,353 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

185.75 kB
4,350 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

269.99 kB
5,354 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

215.89 kB
5,353 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

297.69 kB
5,354 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

141.69 kB
2,474 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

119.85 kB
4,653 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  -- Div Yield %
);

Nifty Midcap 150

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_midcap_150

132.59 kB
4,652 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  -- Div Yield %
);

Nifty Next 50

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_next_50

251.97 kB
5,970 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  -- Div Yield %
);

Nifty Pharma

@kaggle.sudalairajkumar_nifty_indices_dataset.nifty_pharma

213.91 kB
5,103 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

173.2 kB
8,040 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  -- Div Yield %
);