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
Mon May 26 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	EQ	2101.05	898	898	551.35	600.25	604.75	624.61	3972485	248124475790000	1202933	0.3028
Tue May 27 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	EQ	604.75	624.7	639	580.3	595.5	593.15	606.43	1751063	106190068700000	369389	0.211
Wed May 28 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	EQ	593.15	561.65	621.9	561.65	605.1	608.15	608.75	1652355	100587748930000	898602	0.5438000000000001
Thu May 29 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	EQ	608.15	619.4	619.4	576	600	599.45	600.98	669269	40221651265000	449951	0.6723
Fri May 30 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	EQ	599.45	605.4	607	538	576.25	571.7	565.55	1262117	71379372060000	936432	0.742
Mon Jun 02 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	EQ	571.7	605.5	615	570.7	573	580.8	598.3	206640	12363260330000	69415	0.3359
Tue Jun 03 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	EQ	580.8	596	602	555.15	577	579.7	575.83	157283	9056802440000	106984	0.6802
Wed Jun 04 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	EQ	579.7	597.85	597.85	547.5	550	552.1	563.64	326450	18399934815000	238952	0.7320000000000001
Thu Jun 05 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	EQ	552.1	553	588.8	532.4	548	562.4	560.7	238915	13396034935000	140638	0.5887
Fri Jun 06 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJ-AUTO	EQ	562.4	567	574.7	544.4	572	568.8	564.38	73920	4171902765000	35676	0.4826


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