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
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	EQ	580	1550	1725	1492	1560	1554.45	1582.72	1192200	188691461000000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	EQ	1554.45	1560	1678.85	1560	1678.85	1678.85	1657.05	344850	57143494500000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	EQ	1678.85	1790	1813.2	1781	1813.2	1813.2	1804.69	53000	9564879750000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	EQ	1813.2	1958.3	1958.3	1835	1958.3	1958.3	1939.9	270950	52561693250000
Mon Jan 17 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	EQ	1958.3	2115	2115	1801.65	1801.65	1801.65	1990.55	428800	85354733750000
Tue Jan 18 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	EQ	1801.65	1730.55	1815	1657.55	1775	1774.5	1716.39	359900	61772802000000
Wed Jan 19 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	EQ	1774.5	1815	1889	1760	1842.8	1851.15	1842.81	316050	58242040000000
Thu Jan 20 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	EQ	1851.15	1865	1865	1750	1753.5	1757.85	1801.37	204700	36874092500000
Fri Jan 21 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	EQ	1757.85	1761	1815	1705	1786	1781.35	1774.01	282150	50053604000000
Mon Jan 24 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	EQ	1781.35	1834.9	1923.9	1795	1923.9	1923.9	1875.34	328650	61633171750000


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