NIFTY-50 Stock Market Data (2000 - 2021)

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	deliverable_volume Deliverable Volume	n__deliverble %Deliverble
Wed Jun 23 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	EQ	2	500	745	150	638	635.95	627.71	2699293	169437184605000	395612	0.1466
Thu Jun 24 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	EQ	635.95	630	630	608.4	612	616	618.21	913575	56478019835000	305751	0.3347
Fri Jun 25 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	EQ	616	619	679	616.1	665	668.3	658.45	1637383	107813620084999.98	217950	0.1331
Mon Jun 28 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	EQ	668.3	660	671.9	640.2	653	656.4	657.39	913349	60042707740000	194984	0.2135
Tue Jun 29 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	EQ	656.4	656	683.4	653	666.85	671.7	675.11	743063	50164878630000	101786	0.1369999999999999
Wed Jun 30 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	EQ	671.7	672	700	670	697.85	695.15	690.66	722230	49881792325000	149425	0.2069
Thu Jul 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	EQ	695.15	702	765	690.1	764	745.2	726.59	1582574	114988349505000	185737	0.1174
Fri Jul 02 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	EQ	745.2	745	780	724.65	727	730.5	753.03	2988945	225076076215000	268657	0.0899
Mon Jul 05 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	EQ	730.5	728.2	743.5	711.1	714	719.05	726	1272188	92361014640000	130172	0.1023
Tue Jul 06 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	LT	EQ	719.05	721.8	738	715.3	727.9	729.6	726.59	1081518	78582238420000	238350	0.2203999999999999


CREATE TABLE lt (
  "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" DOUBLE,
  "deliverable_volume" BIGINT,
  "n__deliverble" DOUBLE
);