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

Tcs Stock

@kaggle.atulanandjha_national_stock_exchange_time_series.tcs_stock

29.79 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)	TCS	EQ	2558.25	2567	2567	2541	2550	2545.55	2548.51	183415	46743445615000	8002	52870	0.2883
Fri Jan 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	2545.55	2551	2590.95	2550.6	2588.4	2579.45	2568.19	462870	118874010950000	27585	309350	0.6683
Mon Jan 05 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	2579.45	2581	2599.9	2524.65	2538.1	2540.25	2563.94	877121	224888554095000	43234	456728	0.5207
Tue Jan 06 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	2540.25	2529.1	2529.1	2440	2450.05	2446.6	2466.9	1211892	298961535645000	84503	714306	0.5894
Wed Jan 07 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	2446.6	2470	2479.15	2407.45	2426.9	2417.7	2433.96	1318166	320836246205000	101741	886368	0.6724
Thu Jan 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	2417.7	2442.4	2449	2420.55	2446	2443.8	2434.81	782704	190573934495000	47699	450768	0.5759000000000001
Fri Jan 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	2443.8	2455	2519.9	2450	2510	2512.3	2490.01	1598821	398108220610000	81743	865777	0.5415
Mon Jan 12 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	2512.3	2517	2528	2480.25	2527.95	2509.7	2497.82	798003	199326599700000	58810	451228	0.5654
Tue Jan 13 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	2509.7	2520	2530.4	2480.1	2498	2497.9	2509.4	734216	184244037280000	49993	386133	0.5259
Wed Jan 14 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	2497.9	2516	2531.8	2500.5	2525.05	2521.95	2517.54	893548	224954619585000	69237	498193	0.5575


CREATE TABLE tcs_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
);