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 Jan 23 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIPHOS	EQ	10	100	560	100	555.1	553.8	483.69	73629	3561361450000	52799	0.7171
Tue Jan 27 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIPHOS	EQ	553.8	570	570	525	530.1	540.35	540.77	26737	1445850850000	17314	0.6476000000000001
Wed Jan 28 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIPHOS	EQ	540.35	530	565	511	542	538.85	542.24	32155	1743569020000	23285	0.7241
Thu Jan 29 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIPHOS	EQ	538.85	530	543.5	504	517	515.1	529.23	19074	1009447220000	12935	0.6781
Fri Jan 30 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIPHOS	EQ	515.1	519	519	471.4	485	482.95	485.85	23807	1156659385000	12750	0.5356000000000001
Tue Feb 03 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIPHOS	EQ	482.95	472	475	450	465	461.45	466.1	25068	1168431745000	17793	0.7098000000000001
Wed Feb 04 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIPHOS	EQ	461.45	442	479	442	475	475.15	470.81	21392	1007167445000	18545	0.8669
Thu Feb 05 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIPHOS	EQ	475.15	475	489	470.5	475.05	480.15	477.59	19618	936930590000	16395	0.8357
Fri Feb 06 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIPHOS	EQ	480.15	461.1	486	461	485.9	480.75	477.32	11997	572643405000	10892	0.9079
Mon Feb 09 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIPHOS	EQ	480.75	475	483	462.05	474.8	471.95	471.87	19547	922368255000	14957	0.7652


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