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)	DRREDDY	EQ	1396.5	1505	1508.25	1505	1508.25	1508.25	1508.21	13280	2002904375000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	EQ	1508.25	1590	1628.95	1510	1628.95	1628.95	1579.29	57142	9024404910000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	EQ	1628.95	1549	1650	1499	1566	1568.05	1594.99	119697	19091553600000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	EQ	1568.05	1599	1693.5	1571	1693.5	1661.55	1632.11	121966	19906246590000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	EQ	1661.55	1685	1685	1528.65	1528.65	1529.1	1585.24	79641	12624973610000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	EQ	1529.1	1560	1560	1407.5	1502	1503.9	1503.84	62612	9415849660000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	EQ	1503.9	1512	1529	1384	1436	1446.6	1449.71	89184	12929137705000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	EQ	1446.6	1460	1540	1460	1486.05	1490.9	1496.5	31611	4730600895000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	EQ	1490.9	1485	1545	1461	1470.05	1477.45	1511.43	39753	6008397020000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	EQ	1477.45	1470.05	1510	1412	1486.45	1473.5	1458.08	46272	6746848115000.001


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