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 08 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	EQ	2512.95	2555	2575	2475.2	2476	2494.65	2529.81	648	163931630000	438	0.6759000000000001
Mon Jan 11 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	EQ	2494.65	2401	2515	2400	2500	2498.95	2494.44	825	205790905000	638	0.7733
Tue Jan 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	EQ	2498.95	2540	2540	2471.35	2505	2502.85	2485.22	68346	16985494094999.998	67695	0.9905
Wed Jan 13 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	EQ	2502.85	2502.85	2540	2480	2489.8	2489.35	2491.94	1032	257168240000	718	0.6957
Thu Jan 14 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	EQ	2489.35	2535	2595	2470	2560	2568.2	2510.27	330361	82929564305000	329193	0.9965
Fri Jan 15 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	EQ	2568.2	2580	2580	2500.05	2524.8	2513.5	2548.35	8229	2097037285000	7303	0.8875000000000001
Mon Jan 18 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	EQ	2513.5	2574	2574	2514	2542.05	2536.15	2534.76	883	223818890000	689	0.7803
Tue Jan 19 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	EQ	2536.15	2567	2570	2531	2550	2556.1	2558.84	688	176048160000	432	0.6279
Wed Jan 20 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	EQ	2556.1	2550	2575	2540	2541	2542.5	2552.32	641	163603850000	549	0.8565
Thu Jan 21 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	EQ	2542.5	2539.9	2569	2499.9	2512.05	2526.2	2538.36	831	210938015000	623	0.7497


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