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)	CIPLA	EQ	1349.4	1410	1457.35	1380.05	1457.35	1457.35	1441.36	21060	3035495710000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	EQ	1457.35	1537	1537	1430	1466.05	1465.25	1460.43	30215	4412697995000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	EQ	1465.25	1474	1474	1365	1441	1435.05	1428.11	33799	4826872355000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	EQ	1435.05	1434	1435	1349	1365	1355.85	1390.55	33083	4600355805000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	EQ	1355.85	1370	1389.9	1247.4	1247.4	1247.55	1267.49	66536	8433350509999.999
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	EQ	1247.55	1288	1299	1191	1197.15	1205.9	1222.23	105912	12944849340000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	EQ	1205.9	1225	1225	1109.45	1125	1114.25	1156.31	186975	21620034285000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	EQ	1114.25	1185	1203.4	1185	1203.4	1203.4	1202.76	7416	891969640000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	EQ	1203.4	1299.7	1299.7	1281.2	1299.7	1297.05	1298.53	90379	11736022640000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	EQ	1297.05	1299	1304.55	1220	1275	1280.7	1275.38	70729	9020601715000


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