Stock Price Data

Top 10 IT stock price data from NSE India

@kaggle.sunnykusawa_stock_price_data

Table List

1 table(354.61 KB)

Stock Price Data

@kaggle.sunnykusawa_stock_price_data.stock_price_data

354.61 KB
4963 rows
15 columns

symbol Symbol	series Series	date Date	prev_close Prev Close	open_price Open Price	high_price High Price	low_price Low Price	last_price Last Price	close_price Close Price	average_price Average Price	total_traded_quantity Total Traded Quantity	turnover Turnover	no_of_trades No. Of Trades	deliverable_qty Deliverable Qty	n__dly_qt_to_traded_qty % Dly Qt To Traded Qty
TCS	EQ	5-Mar-19	1995.4	2005	2007	1976.6	1985.05	1988.1	1987.11	2449622	4867670462	151723	1394714	56.94
TCS	EQ	6-Mar-19	1988.1	1989.3	2015	1985.05	2005	1999.6	2001.3	2635047	5273530564	179625	1257394	47.72
TCS	EQ	7-Mar-19	1999.6	2005	2024.05	2000.2	2015	2013.3	2014.4	2539884	5116330320	126121	1392383	54.82
TCS	EQ	8-Mar-19	2013.3	2025	2033	2010.05	2022.75	2022.7	2023.03	2031071	4108921516	116872	971744	47.84
TCS	EQ	11-Mar-19	2022.7	2028.9	2033	2003.65	2016.15	2014.8	2017.1	3111689	6276593842	104833	2195339	70.55
TCS	EQ	12-Mar-19	2014.8	2014.05	2024.8	2003	2009.1	2012.45	2015.6	2658550	5358583633	132223	1716971	64.58
TCS	EQ	13-Mar-19	2012.45	2013	2015.9	1978.6	1995	2000.5	2001.12	1833163	3668374640	112785	821473	44.81
TCS	EQ	14-Mar-19	2000.5	2004.95	2007.8	1981	1990.4	1987.4	1991.28	1905495	3794368664	124863	1000627	52.51
TCS	EQ	15-Mar-19	1987.4	1998.9	2068.95	1991	2036	2039.95	2040.01	5184318	10576085296	164284	2256287	43.52
TCS	EQ	18-Mar-19	2039.95	2043	2064.6	2011	2023.85	2022.8	2033.02	2349915	4777435477	116385	867727	36.93


CREATE TABLE stock_price_data (
  "symbol" VARCHAR,
  "series" VARCHAR,
  "date" VARCHAR,
  "prev_close" DOUBLE,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "last_price" DOUBLE,
  "close_price" DOUBLE,
  "average_price" DOUBLE,
  "total_traded_quantity" BIGINT,
  "turnover" DOUBLE,
  "no_of_trades" BIGINT,
  "deliverable_qty" BIGINT,
  "n__dly_qt_to_traded_qty" DOUBLE
);