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
Mon Jan 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDLEVER	EQ	2136.6	2300	2307.55	2300	2307.55	2307.55	2307.08	24903	5745329890000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDLEVER	EQ	2307.55	2381	2381	2250	2270	2281.05	2298.15	58514	13447400525000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDLEVER	EQ	2281.05	2200	2250	2105	2183.5	2199.9	2211.17	80296	17754819445000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDLEVER	EQ	2199.9	2224.9	2360	2210	2300	2288.2	2301.8	190032	43741570135000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDLEVER	EQ	2288.2	2300	2452	2282.25	2395	2412.95	2380.24	192582	45839194485000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDLEVER	EQ	2412.95	2445	2499	2410	2440	2431.25	2464.07	86591	21336585280000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDLEVER	EQ	2431.25	2450	2529	2390	2450	2485.8	2460.27	134411	33068757725000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDLEVER	EQ	2485.8	2500	2684.7	2490	2684.7	2647.8	2579.17	177057	45666011260000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDLEVER	EQ	2647.8	2699	2859.65	2650	2783	2786.65	2804.4	254508	71374323065000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDLEVER	EQ	2786.65	2750	2777	2650	2697.05	2702.1	2706.88	120240	32547513205000


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