Baselight
Sign In

S&P BSE SENSEX 50

Group of 50 Stocks since 2011 listed under the BSE SENSEX 50 Index.

@kaggle.altruisticemphasis_sp_bse_sensex_50

Loading...
Loading...

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

  1. Date : Provides the date of market opening
  2. Open Price : The price at which the stock opens for the day
  3. High Price : The price at which the stock opens for the day
  4. Low Price : The lowest price the stock fetched during that trading day
  5. Closing Price : The price at which the stock closed after the trading day
  6. WAP : Weighted Average Price for the day
  7. No of Shares : No. of shares traded throughout the day
  8. No. of traders : The number of buy and sell trades happened throughout the day
  9. Total Turnovers : The total turnover based on the no of shares traded in that day
  10. 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.
  11. % Deli. Qty to Traded Qty : The ratio between column 7 and 10.
  12. Spread High-Low : The ratio between the high and low spread
  13. 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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
);

Indusindbank

@kaggle.altruisticemphasis_sp_bse_sensex_50.indusindbank
  • 198.31 kB
  • 2,585 rows
  • 13 columns
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
Loading... 
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
);

Share link

Anyone who has the link will be able to view this.