National Stock Exchange : Time Series

national stock exchange dataset of indian IT companies for time series analysis

@kaggle.atulanandjha_national_stock_exchange_time_series

Table List

3 tables(76.31 KB)

Infy Stock

Nifty It Index

Tcs Stock

Infy Stock

@kaggle.atulanandjha_national_stock_exchange_time_series.infy_stock

29.97 KB
248 rows
15 columns

date Date	symbol Symbol	series Series	prev_close Prev Close	open Open	high High	low Low	last Last	close Close	vwap VWAP	volume Volume	turnover Turnover	trades Trades	deliverable_volume Deliverable Volume	n__deliverble %Deliverble
Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	EQ	1972.55	1968.95	1982	1956.9	1971	1974.4	1971.34	500691	98703055635000	14908	258080	0.5154
Fri Jan 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	EQ	1974.4	1972	2019.05	1972	2017.95	2013.2	2003.25	1694580	339466852425000	54166	1249104	0.7371
Mon Jan 05 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	EQ	2013.2	2009.9	2030	1977.5	1996	1995.9	2004.59	2484256	497991093805000	82694	1830962	0.737
Tue Jan 06 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	EQ	1995.9	1980	1985	1934.1	1965.1	1954.2	1954.82	2416829	472445845370000	108209	1772070	0.7332
Wed Jan 07 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	EQ	1954.2	1965	1974.75	1950	1966.05	1963.55	1962.59	1812479	355716183735000	62463	1317720	0.7270000000000001
Thu Jan 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	EQ	1963.55	1985.6	1997	1950	1979.25	1973.45	1972.78	3391230	669016029085000	92752	2686012	0.792
Fri Jan 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	EQ	1973.45	1980.1	2109	1913.05	2075.3	2074.45	2037.69	11215832	2285438887015000	359214	3369489	0.3004
Mon Jan 12 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	EQ	2074.45	2092	2119.2	2075	2112.95	2115.95	2099.4	3189722	669651595110000	107209	1818800	0.5702
Tue Jan 13 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	EQ	2115.95	2107.8	2107.8	2075	2092	2088.9	2089.42	2200309	459737380695000	66676	1385009	0.6295000000000001
Wed Jan 14 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	EQ	2088.9	2098.5	2133	2092.6	2129	2128.65	2110.88	2480315	523563759320000	53263	1832958	0.7390000000000001


CREATE TABLE infy_stock (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "series" VARCHAR,
  "prev_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "last" DOUBLE,
  "close" DOUBLE,
  "vwap" DOUBLE,
  "volume" BIGINT,
  "turnover" DOUBLE,
  "trades" BIGINT,
  "deliverable_volume" BIGINT,
  "n__deliverble" DOUBLE
);