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)	IOC	EQ	254	260	273.25	250	267.35	270.85	258.55	23700	612764750000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	EQ	270.85	260	268	254.1	267	264.4	259.8	24400	633911250000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	EQ	264.4	264.9	265	257	261.35	261.3	260.66	18900	492638250000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	EQ	261.3	258	263	256.05	263	260.1	259.81	18150	471551500000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	EQ	260.1	259.9	267	253.25	267	264.45	260.11	17650	459090250000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	EQ	264.45	252.1	259.5	250.6	250.65	251.35	254	23550	598178500000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	EQ	251.35	250	256	235.05	237	239.75	245.63	39500	970247500000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	EQ	239.75	258.95	258.95	258.95	258.95	258.95	258.95	350	9063250000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	EQ	258.95	279.7	279.7	268	274	272.5	275.96	8490	234288020000.00003
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	IOC	EQ	272.5	277	281.9	260	277	277.05	274.03	8508	233142735000


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