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 Jul 09 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	EQ	125	164.9	170.4	155	164	164.3	165.95	35164283	583552816185000	8537695	0.2428
Thu Jul 10 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	EQ	164.3	167	168.7	164.5	167	167	166.74	10464179	174481962120000	4363947	0.417
Fri Jul 11 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	EQ	167	167.75	174.85	166.25	173.6	173.35	172.45	11740117	202462154745000	3014852	0.2568
Mon Jul 14 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	EQ	173.35	174.25	179.25	174.25	178.6	177.95	177.91	5982324	106431310030000	1949217	0.3258
Tue Jul 15 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	EQ	177.95	200	200	173	176.3	176.2	176.88	6173689	109200079040000.02	1307694	0.2118
Wed Jul 16 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	EQ	176.2	176.45	179.1	175.35	176.9	177.1	177.59	3759085	66756950310000	1155442	0.3074
Thu Jul 17 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	EQ	177.1	177.5	178	170.65	170.7	172.2	175.48	3814181	66930296870000.01	1064071	0.2789999999999999
Fri Jul 18 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	EQ	172.2	165	171.9	160	167.4	167.4	167.66	5375212	90119032225000	1427995	0.2657
Mon Jul 21 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	EQ	167.4	169	169.4	163.05	164	164.9	166.67	3315845	55266461654999.99	980379	0.2957
Tue Jul 22 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	EQ	164.9	164	169.15	162.1	168.6	167.25	165.06	4627992	76391242225000	1257167	0.2716


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