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
Fri Oct 05 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	EQ	52	89.8	109.5	83.15	100.2	100.6	102.49	481058927	4930560669525000	181390171	0.3771
Mon Oct 08 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	EQ	100.6	104	104	94.85	95.3	95.45	98.12	71252858	699161551045000	22115293	0.3104
Tue Oct 09 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	EQ	95.45	95.5	102.85	90.35	102.1	101.95	98.57	65658228	647178408115000	16991920	0.2588
Wed Oct 10 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	EQ	101.95	104.6	105	102	102.65	102.9	103.66	38211410	396088698370000	16409289	0.4294
Thu Oct 11 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	EQ	102.9	120	120	102	114.85	114.4	110.78	59805552	662523526215000	17530826	0.2930999999999999
Fri Oct 12 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	EQ	114.4	112	117.9	111	114.25	113.65	115.56	55918584	646171378605000	15832822	0.2831
Mon Oct 15 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	EQ	113.65	116	116.7	114.15	115.4	115.15	115.71	23520928	272164614990000	9028767	0.3839
Tue Oct 16 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	EQ	115.15	115.3	128.9	114.5	128.3	126.9	121.83	77970674	949884184830000	17581372	0.2255
Wed Oct 17 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	EQ	126.9	114	140	106.1	135.35	136.8	127.86	115242925	1473492842190000	18324073	0.159
Thu Oct 18 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERGRID	EQ	136.8	139	149.45	126.35	128.2	132	142.53	82472533	1175485545025000	22803867	0.2764999999999999


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