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

Adaniports

@kaggle.altruisticemphasis_sp_bse_sensex_50.adaniports

185.94 kB
2,585 rows
13 columns

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

Asianpaints

@kaggle.altruisticemphasis_sp_bse_sensex_50.asianpaints

200.26 kB
2,585 rows
13 columns

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

Axisbank

@kaggle.altruisticemphasis_sp_bse_sensex_50.axisbank

197.31 kB
2,585 rows
13 columns

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

Bajajauto

@kaggle.altruisticemphasis_sp_bse_sensex_50.bajajauto

198.23 kB
2,585 rows
13 columns

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

Bajajfinance

@kaggle.altruisticemphasis_sp_bse_sensex_50.bajajfinance

205.12 kB
2,585 rows
13 columns

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

Bajajfineserv

@kaggle.altruisticemphasis_sp_bse_sensex_50.bajajfineserv

203.46 kB
2,585 rows
13 columns

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

Bhartiairtel

@kaggle.altruisticemphasis_sp_bse_sensex_50.bhartiairtel

185.03 kB
2,585 rows
13 columns

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

Bpcl

@kaggle.altruisticemphasis_sp_bse_sensex_50.bpcl

190.35 kB
2,585 rows
13 columns

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

Britannia

@kaggle.altruisticemphasis_sp_bse_sensex_50.britannia

199.15 kB
2,585 rows
13 columns

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

Cipla

@kaggle.altruisticemphasis_sp_bse_sensex_50.cipla

188.53 kB
2,585 rows
13 columns

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

Coalindia

@kaggle.altruisticemphasis_sp_bse_sensex_50.coalindia

183.58 kB
2,585 rows
13 columns

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

Dabur

@kaggle.altruisticemphasis_sp_bse_sensex_50.dabur

182.61 kB
2,585 rows
13 columns

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

Divislab

@kaggle.altruisticemphasis_sp_bse_sensex_50.divislab

194.77 kB
2,585 rows
13 columns

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

Drreddys

@kaggle.altruisticemphasis_sp_bse_sensex_50.drreddys

200.12 kB
2,585 rows
13 columns

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

Eicher

@kaggle.altruisticemphasis_sp_bse_sensex_50.eicher

209.34 kB
2,585 rows
13 columns

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

Godrejconsum

@kaggle.altruisticemphasis_sp_bse_sensex_50.godrejconsum

188.97 kB
2,585 rows
13 columns

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

Grasimindus

@kaggle.altruisticemphasis_sp_bse_sensex_50.grasimindus

199.07 kB
2,585 rows
13 columns

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

Hcltechnologies

@kaggle.altruisticemphasis_sp_bse_sensex_50.hcltechnologies

193.4 kB
2,585 rows
13 columns

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

Hdcfbank

@kaggle.altruisticemphasis_sp_bse_sensex_50.hdcfbank

198.33 kB
2,585 rows
13 columns

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

Hdfc

@kaggle.altruisticemphasis_sp_bse_sensex_50.hdfc

200.06 kB
2,585 rows
13 columns

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

Hdfclifeinsurance

@kaggle.altruisticemphasis_sp_bse_sensex_50.hdfclifeinsurance

186.26 kB
2,585 rows
13 columns

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

Heromotocorp

@kaggle.altruisticemphasis_sp_bse_sensex_50.heromotocorp

199.46 kB
2,585 rows
13 columns

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

Hindalcoindus

@kaggle.altruisticemphasis_sp_bse_sensex_50.hindalcoindus

183.36 kB
2,585 rows
13 columns

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

Hindustanunilever

@kaggle.altruisticemphasis_sp_bse_sensex_50.hindustanunilever

196.59 kB
2,585 rows
13 columns

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

Icicibank

@kaggle.altruisticemphasis_sp_bse_sensex_50.icicibank

196.99 kB
2,585 rows
13 columns

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