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
Mon Aug 28 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	EQ	365	521	569	502	553	554.25	552	15166163	837176013020000	3777529	0.2491
Tue Aug 29 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	EQ	554.25	555	563.9	535.55	536.1	539.3	547.59	3929113	215153038915000	727534	0.1852
Wed Aug 30 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	EQ	539.3	537	542.9	521.5	529	528.1	529.55	2034983	107762957620000	345064	0.1696
Thu Aug 31 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	EQ	528.1	525	544	515	539.35	538.45	532.89	1670990	89044643830000	286440	0.1714
Fri Sep 01 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	EQ	538.45	539	549	535.1	541.35	541.85	542.46	1176195	63803856150000	213842	0.1818
Mon Sep 04 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	EQ	541.85	542	549	452.8	542	543.95	543.8	749788	40773713470000	213912	0.2853
Tue Sep 05 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	EQ	543.95	544	556	538.5	551.5	552.7	548.92	956133	52483829145000	258744	0.2706
Wed Sep 06 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	EQ	552.7	554.7	562.5	538	540	541.25	551.38	957611	52801098525000	202832	0.2118
Thu Sep 07 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	EQ	541.25	545	545	530	536.25	537.3	536.79	351161	18849974530000	140830	0.401
Fri Sep 08 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	TECHM	EQ	537.3	538.8	544.9	531.55	531.6	534.8	538.89	269659	14531639525000	59668	0.2213


CREATE TABLE techm (
  "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
);