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)	ICICIBANK	EQ	69.2	74.35	74.75	71.4	74.75	74.75	73.2	286260	2095439040000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	EQ	74.75	73.05	78.5	71	73.25	73.05	73.38	296264	2173892790000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	EQ	73.05	70	73.5	67.5	70	69.5	70.85	227624	1612793995000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	EQ	69.5	71	74	69.55	69.75	70.05	72.04	275149	1982120640000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	EQ	70.05	69	72.5	66	67	67.4	68.72	138809	953888205000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	EQ	67.4	67	71	67	70	69.9	69.78	249656	1742092355000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	EQ	69.9	69.15	70.45	66.1	69	69.35	68.89	307601	2119124005000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	EQ	69.35	69	74.9	69	74.9	74.9	74.35	88395	657222050000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	EQ	74.9	80	80.9	78	79	79.35	80.43	494679	3978944790000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIBANK	EQ	79.35	78	80.8	75	80.05	79	78.15	703072	5494427335000


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