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

Pel

@kaggle.akshaypawar7_nifty_dataset.pel

43.84 kB
525 rows
12 columns

CREATE TABLE pel (
  "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 %
);

Persistent

@kaggle.akshaypawar7_nifty_dataset.persistent

44.12 kB
525 rows
12 columns

CREATE TABLE persistent (
  "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 %
);

Petronet

@kaggle.akshaypawar7_nifty_dataset.petronet

41.39 kB
525 rows
12 columns

CREATE TABLE petronet (
  "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 %
);

Pfc

@kaggle.akshaypawar7_nifty_dataset.pfc

41.43 kB
525 rows
12 columns

CREATE TABLE pfc (
  "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 %
);

Pfizer

@kaggle.akshaypawar7_nifty_dataset.pfizer

43.45 kB
525 rows
12 columns

CREATE TABLE pfizer (
  "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 %
);

Pghh

@kaggle.akshaypawar7_nifty_dataset.pghh

43.28 kB
525 rows
12 columns

CREATE TABLE pghh (
  "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 %
);

Pghl

@kaggle.akshaypawar7_nifty_dataset.pghl

42.82 kB
525 rows
12 columns

CREATE TABLE pghl (
  "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 %
);

Phoenixltd

@kaggle.akshaypawar7_nifty_dataset.phoenixltd

42.66 kB
525 rows
12 columns

CREATE TABLE phoenixltd (
  "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 %
);

Pidilitind

@kaggle.akshaypawar7_nifty_dataset.pidilitind

43.65 kB
525 rows
12 columns

CREATE TABLE pidilitind (
  "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 %
);

Piind

@kaggle.akshaypawar7_nifty_dataset.piind

44.13 kB
525 rows
12 columns

CREATE TABLE piind (
  "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 %
);

Pnb

@kaggle.akshaypawar7_nifty_dataset.pnb

39.85 kB
525 rows
12 columns

CREATE TABLE pnb (
  "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 %
);

Pnbhousing

@kaggle.akshaypawar7_nifty_dataset.pnbhousing

42.06 kB
525 rows
12 columns

CREATE TABLE pnbhousing (
  "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 %
);

Pncinfra

@kaggle.akshaypawar7_nifty_dataset.pncinfra

42.61 kB
525 rows
12 columns

CREATE TABLE pncinfra (
  "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 %
);

Polycab

@kaggle.akshaypawar7_nifty_dataset.polycab

43.6 kB
525 rows
12 columns

CREATE TABLE polycab (
  "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 %
);

Polymed

@kaggle.akshaypawar7_nifty_dataset.polymed

42.71 kB
525 rows
12 columns

CREATE TABLE polymed (
  "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 %
);

Polyplex

@kaggle.akshaypawar7_nifty_dataset.polyplex

43.18 kB
525 rows
12 columns

CREATE TABLE polyplex (
  "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 %
);

Poonawalla

@kaggle.akshaypawar7_nifty_dataset.poonawalla

17.16 kB
130 rows
12 columns

CREATE TABLE poonawalla (
  "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 %
);

Powergrid

@kaggle.akshaypawar7_nifty_dataset.powergrid

42.57 kB
525 rows
12 columns

CREATE TABLE powergrid (
  "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 %
);

Powerindia

@kaggle.akshaypawar7_nifty_dataset.powerindia

38.42 kB
464 rows
12 columns

CREATE TABLE powerindia (
  "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 %
);

Prajind

@kaggle.akshaypawar7_nifty_dataset.prajind

40.96 kB
525 rows
12 columns

CREATE TABLE prajind (
  "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 %
);

Prestige

@kaggle.akshaypawar7_nifty_dataset.prestige

42.9 kB
525 rows
12 columns

CREATE TABLE prestige (
  "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 %
);

Princepipe

@kaggle.akshaypawar7_nifty_dataset.princepipe

42.91 kB
525 rows
12 columns

CREATE TABLE princepipe (
  "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 %
);

Prsmjohnsn

@kaggle.akshaypawar7_nifty_dataset.prsmjohnsn

41.44 kB
525 rows
12 columns

CREATE TABLE prsmjohnsn (
  "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 %
);

Pvr

@kaggle.akshaypawar7_nifty_dataset.pvr

43.3 kB
525 rows
12 columns

CREATE TABLE pvr (
  "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 %
);

Quess

@kaggle.akshaypawar7_nifty_dataset.quess

42.94 kB
525 rows
12 columns

CREATE TABLE quess (
  "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 %
);