Name: S&P BSE SENSEX 50
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

S&P BSE SENSEX 50

This dataset is a curated list of one of the favourite Indices, the S&P BSE SENSEX 50.

It contains the stocks of 50 major companies listed under this index and contains data from the past 10 years.

Each stock contains 13 columns

Date : Provides the date of market opening
Open Price : The price at which the stock opens for the day
High Price : The price at which the stock opens for the day
Low Price : The lowest price the stock fetched during that trading day
Closing Price : The price at which the stock closed after the trading day
WAP : Weighted Average Price for the day
No of Shares : No. of shares traded throughout the day
No. of traders : The number of buy and sell trades happened throughout the day
Total Turnovers : The total turnover based on the no of shares traded in that day
Deliverable Quantities : Deliverable quantity of shares is which actually move from one set of people (who had those shares in their demat account before today and are selling today) to another set of people (who have purchased those shares and will get those shares by T+2 days in their demat account.
% Deli. Qty to Traded Qty : The ratio between column 7 and 10.
Spread High-Low : The ratio between the high and low spread
Spread Close-Open : The ratio between the Close and opening price of the stock for that day

So this dataset is all for you to use and play around. Maybe make out a portfolio or create a mutual fund out of these companies and predict its future prices.

Tables

Indusindbank

@kaggle.altruisticemphasis_sp_bse_sensex_50.indusindbank

198.31 kB
2,585 rows
13 columns

CREATE TABLE indusindbank (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Infosys

@kaggle.altruisticemphasis_sp_bse_sensex_50.infosys

198.31 kB
2,585 rows
13 columns

CREATE TABLE infosys (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Itc

@kaggle.altruisticemphasis_sp_bse_sensex_50.itc

182.43 kB
2,585 rows
13 columns

CREATE TABLE itc (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Jswsteel

@kaggle.altruisticemphasis_sp_bse_sensex_50.jswsteel

194.88 kB
2,585 rows
13 columns

CREATE TABLE jswsteel (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Kotakmahindra

@kaggle.altruisticemphasis_sp_bse_sensex_50.kotakmahindra

196.31 kB
2,585 rows
13 columns

CREATE TABLE kotakmahindra (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Larsenandtoubro

@kaggle.altruisticemphasis_sp_bse_sensex_50.larsenandtoubro

195.58 kB
2,585 rows
13 columns

CREATE TABLE larsenandtoubro (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Mahindramahindra

@kaggle.altruisticemphasis_sp_bse_sensex_50.mahindramahindra

193.62 kB
2,585 rows
13 columns

CREATE TABLE mahindramahindra (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Marutisuzuki

@kaggle.altruisticemphasis_sp_bse_sensex_50.marutisuzuki

208.77 kB
2,585 rows
13 columns

CREATE TABLE marutisuzuki (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Nestleindia

@kaggle.altruisticemphasis_sp_bse_sensex_50.nestleindia

202 kB
2,585 rows
13 columns

CREATE TABLE nestleindia (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Ntpc

@kaggle.altruisticemphasis_sp_bse_sensex_50.ntpc

173.18 kB
2,585 rows
13 columns

CREATE TABLE ntpc (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Ongc

@kaggle.altruisticemphasis_sp_bse_sensex_50.ongc

186.12 kB
2,585 rows
13 columns

CREATE TABLE ongc (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Powergrid

@kaggle.altruisticemphasis_sp_bse_sensex_50.powergrid

174.69 kB
2,585 rows
13 columns

CREATE TABLE powergrid (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Relianceindus

@kaggle.altruisticemphasis_sp_bse_sensex_50.relianceindus

198.37 kB
2,585 rows
13 columns

CREATE TABLE relianceindus (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Sbilife

@kaggle.altruisticemphasis_sp_bse_sensex_50.sbilife

198.37 kB
2,585 rows
13 columns

CREATE TABLE sbilife (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Statebankofindia

@kaggle.altruisticemphasis_sp_bse_sensex_50.statebankofindia

199.39 kB
2,585 rows
13 columns

CREATE TABLE statebankofindia (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Sunpharma

@kaggle.altruisticemphasis_sp_bse_sensex_50.sunpharma

191.83 kB
2,585 rows
13 columns

CREATE TABLE sunpharma (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Tataconsumer

@kaggle.altruisticemphasis_sp_bse_sensex_50.tataconsumer

182.02 kB
2,585 rows
13 columns

CREATE TABLE tataconsumer (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Tatamotors

@kaggle.altruisticemphasis_sp_bse_sensex_50.tatamotors

194.06 kB
2,585 rows
13 columns

CREATE TABLE tatamotors (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Tatasteel

@kaggle.altruisticemphasis_sp_bse_sensex_50.tatasteel

192.58 kB
2,585 rows
13 columns

CREATE TABLE tatasteel (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Tcs

@kaggle.altruisticemphasis_sp_bse_sensex_50.tcs

201.29 kB
2,585 rows
13 columns

CREATE TABLE tcs (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Techmahindra

@kaggle.altruisticemphasis_sp_bse_sensex_50.techmahindra

194.47 kB
2,585 rows
13 columns

CREATE TABLE techmahindra (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Titancompany

@kaggle.altruisticemphasis_sp_bse_sensex_50.titancompany

193.98 kB
2,585 rows
13 columns

CREATE TABLE titancompany (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Ultratechcement

@kaggle.altruisticemphasis_sp_bse_sensex_50.ultratechcement

200.84 kB
2,585 rows
13 columns

CREATE TABLE ultratechcement (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Upllimited

@kaggle.altruisticemphasis_sp_bse_sensex_50.upllimited

191.69 kB
2,585 rows
13 columns

CREATE TABLE upllimited (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);

Wipro

@kaggle.altruisticemphasis_sp_bse_sensex_50.wipro

186.26 kB
2,585 rows
13 columns

CREATE TABLE wipro (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT  -- No. Of Trades,
  "total_turnover_rs" DOUBLE  -- Total Turnover (Rs.),
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE  -- % Deli. Qty To Traded Qty,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);