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
Thu Nov 04 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	EQ	245	291	344.9	291	342	342.55	327.29	479716245	15700395821970002	187584905	0.391
Fri Nov 05 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	EQ	342.55	343	356.5	343	348.3	349.85	349.78	31927173	1116747196655000	10894509	0.3412
Mon Nov 08 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	EQ	349.85	351.8	355.9	329.5	331.4	330.75	335.19	46932779	1573117519380000	16651623	0.3547999999999999
Tue Nov 09 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	EQ	330.75	330.15	333.4	325	325.4	326.05	327.75	23741956	778138279065000	12977359	0.5466
Wed Nov 10 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	EQ	326.05	325.4	327.8	320.05	321.3	322.8	323.78	21057129	681798175450000	6280335	0.2983
Thu Nov 11 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	EQ	322.8	323	336.95	321.85	329.6	328.55	331.43	26548372	879901818535000	9365609	0.3528
Fri Nov 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	EQ	328.55	330	332.95	318	320.55	320.15	325.77	15004107	488787167610000.06	5797721	0.3864
Mon Nov 15 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	EQ	320.15	321.2	322.9	315.05	318.1	317.2	319.39	9917395	316754376770000	4812011	0.4852
Tue Nov 16 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	EQ	317.2	320	323.95	316.1	317.5	318.05	319.21	12100114	386246039530000	6620732	0.5472
Thu Nov 18 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	EQ	318.05	319.6	328.95	310	327.3	326.9	319.09	23983896	765294094650000	9152722	0.3816


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