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)	SUNPHARMA	EQ	1699.1	1800	1835.05	1760	1835.05	1835.05	1825.9	3024	552152475000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNPHARMA	EQ	1835.05	1960	1960	1763	1811.5	1810.45	1805.97	5787	1045115490000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNPHARMA	EQ	1810.45	1845	1845	1740	1745	1746.9	1766.69	6105	1078563995000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNPHARMA	EQ	1746.9	1750	1795	1735	1748	1745.2	1749.32	3472	607363240000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNPHARMA	EQ	1745.2	1705	1705	1605.6	1605.6	1605.6	1621.51	4125	668874015000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNPHARMA	EQ	1605.6	1650	1697	1478	1545	1531.85	1581.78	4378	692504815000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNPHARMA	EQ	1531.85	1522	1580	1410.05	1422	1507.2	1519.06	27648	4199903715000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNPHARMA	EQ	1507.2	1471	1491	1386.65	1386.65	1417	1442.89	18892	2725912040000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNPHARMA	EQ	1417	1400	1513.5	1361	1480	1492.5	1440.53	15735	2266671610000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNPHARMA	EQ	1492.5	1475	1603	1470	1590	1578.35	1516.88	15237	2311275210000


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