Name: NIFTY ALL STOCK Dataset
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

NIFTY ALL STOCK Dataset

Content

This dataset is a playground for technical analysis. It is said that 30% of traffic on stocks is already generated by machines, can trading be fully automated? If not, there is still a lot to learn from historical data. .

Context

https://www.kaggle.com/akshaypawar7/nifty-50-interactive-dashboard
Dataset consists of following files:

500 files of equity stock historical candle data
1_bhavcopy.csv =>
Daily prices of all NSE equity stocks . Most of data spans from 2020 to the end today, for companies new on stock market date range is shorter.
1_meta.csv =>
General description of each company with division on index and industry,
as shown in below chart.

Inspiration

Regardless of your investment strategy, fluctuations are expected in the financial market. Despite this variance, professional investors try to estimate their overall returns. Risks and returns differ based on investment types and other factors, which impact stability and volatility. To attempt to predict returns, there are many computer-based algorithms and models for financial market trading. Yet, with new techniques and approaches, data science could improve quantitative researchers' ability to forecast an investment's return.

Tables

Mazdock

@kaggle.akshaypawar7_nifty_dataset.mazdock

30.04 kB
333 rows
12 columns

CREATE TABLE mazdock (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Mcdowell N

@kaggle.akshaypawar7_nifty_dataset.mcdowell_n

42.95 kB
525 rows
12 columns

CREATE TABLE mcdowell_n (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Mcx

@kaggle.akshaypawar7_nifty_dataset.mcx

42.67 kB
525 rows
12 columns

CREATE TABLE mcx (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Metropolis

@kaggle.akshaypawar7_nifty_dataset.metropolis

43.62 kB
525 rows
12 columns

CREATE TABLE metropolis (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Mfsl

@kaggle.akshaypawar7_nifty_dataset.mfsl

43.47 kB
525 rows
12 columns

CREATE TABLE mfsl (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Mgl

@kaggle.akshaypawar7_nifty_dataset.mgl

42.66 kB
525 rows
12 columns

CREATE TABLE mgl (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Mhril

@kaggle.akshaypawar7_nifty_dataset.mhril

41.47 kB
525 rows
12 columns

CREATE TABLE mhril (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Midhani

@kaggle.akshaypawar7_nifty_dataset.midhani

40.23 kB
525 rows
12 columns

CREATE TABLE midhani (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Mindacorp

@kaggle.akshaypawar7_nifty_dataset.mindacorp

41.68 kB
525 rows
12 columns

CREATE TABLE mindacorp (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Mindaind

@kaggle.akshaypawar7_nifty_dataset.mindaind

42.95 kB
525 rows
12 columns

CREATE TABLE mindaind (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Mindtree

@kaggle.akshaypawar7_nifty_dataset.mindtree

44.45 kB
525 rows
12 columns

CREATE TABLE mindtree (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

M M

@kaggle.akshaypawar7_nifty_dataset.m_m

43.69 kB
525 rows
12 columns

CREATE TABLE m_m (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

M Mfin

@kaggle.akshaypawar7_nifty_dataset.m_mfin

42.68 kB
525 rows
12 columns

CREATE TABLE m_mfin (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Mmtc

@kaggle.akshaypawar7_nifty_dataset.mmtc

39.67 kB
525 rows
12 columns

CREATE TABLE mmtc (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Moil

@kaggle.akshaypawar7_nifty_dataset.moil

40.76 kB
525 rows
12 columns

CREATE TABLE moil (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Motilalofs

@kaggle.akshaypawar7_nifty_dataset.motilalofs

42.47 kB
525 rows
12 columns

CREATE TABLE motilalofs (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Mphasis

@kaggle.akshaypawar7_nifty_dataset.mphasis

43.97 kB
525 rows
12 columns

CREATE TABLE mphasis (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Mrf

@kaggle.akshaypawar7_nifty_dataset.mrf

44.29 kB
525 rows
12 columns

CREATE TABLE mrf (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Mrpl

@kaggle.akshaypawar7_nifty_dataset.mrpl

39.14 kB
525 rows
12 columns

CREATE TABLE mrpl (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Muthootfin

@kaggle.akshaypawar7_nifty_dataset.muthootfin

43.09 kB
525 rows
12 columns

CREATE TABLE muthootfin (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

N 1 Bhavcopy

@kaggle.akshaypawar7_nifty_dataset.n_1_bhavcopy

28.84 MB
894,615 rows
12 columns

CREATE TABLE n_1_bhavcopy (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

N 1 Meta

@kaggle.akshaypawar7_nifty_dataset.n_1_meta

30.54 kB
505 rows
22 columns

CREATE TABLE n_1_meta (
  "symbol" VARCHAR,
  "company_name" VARCHAR,
  "industry" VARCHAR,
  "nifty_500" BIGINT,
  "nifty_50" BIGINT,
  "nifty_next_50" BIGINT,
  "nifty_100" BIGINT,
  "nifty_200" BIGINT,
  "nifty_midcap_50" BIGINT,
  "nifty_midcap_100" BIGINT,
  "nifty_smallcap_100" BIGINT,
  "nifty_largemidcap_250" BIGINT,
  "nifty_auto" BIGINT,
  "nifty_bank" BIGINT,
  "nifty_energy" BIGINT,
  "nifty_fmcg" BIGINT,
  "nifty_it" BIGINT,
  "nifty_media" BIGINT,
  "nifty_metal" BIGINT,
  "nifty_pharma" BIGINT,
  "nifty_psu_bank" BIGINT,
  "nifty_realty" BIGINT
);

N 3mindia

@kaggle.akshaypawar7_nifty_dataset.n_3mindia

42.97 kB
525 rows
12 columns

CREATE TABLE n_3mindia (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Nam India

@kaggle.akshaypawar7_nifty_dataset.nam_india

41.39 kB
509 rows
12 columns

CREATE TABLE nam_india (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);

Natcopharm

@kaggle.akshaypawar7_nifty_dataset.natcopharm

42.5 kB
525 rows
12 columns

CREATE TABLE natcopharm (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE  -- Deliv %
);