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)	SESAGOA	EQ	107.7	111	116.35	108	116.35	116.35	114.8	20371	233859660000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SESAGOA	EQ	116.35	113.75	116	108	116	114.7	113.34	22366	253499440000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SESAGOA	EQ	114.7	107.55	115.85	107.55	114.5	114	112.78	18305	206436075000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SESAGOA	EQ	114	112	123.1	112	118.8	119.3	119.89	25800	309313325000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SESAGOA	EQ	119.3	119.85	120	114.05	116.5	116.5	116.84	17361	202840260000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SESAGOA	EQ	116.5	120.5	120.85	116	119	119	118.69	20707	245767815000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SESAGOA	EQ	119	118	118.2	113.35	113.35	114.55	116.3	20648	240140035000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SESAGOA	EQ	114.55	115.5	117.4	114.65	115.65	115.45	115.73	4995	57804725000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SESAGOA	EQ	115.45	112.25	115.9	112.1	115	115.1	114.9	15911	182823965000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SESAGOA	EQ	115.1	113.55	114	111.35	114	113.9	112.94	3722	42034650000


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