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)	ONGC	EQ	207.7	205	214.4	205	214	213.45	209.91	9600	201509000000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ONGC	EQ	213.45	201.5	209.7	201	209	206.55	206.26	17900	369203000000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ONGC	EQ	206.55	201	223.1	200.5	223.1	223.1	215.46	27000	581749000000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ONGC	EQ	223.1	234	234.9	217.6	217.6	219.3	223.42	35600	795368000000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ONGC	EQ	219.3	223	223	213	215.7	215.75	215.19	11400	245314500000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ONGC	EQ	215.75	205	218	205	210	209.5	208.14	40000	832545000000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ONGC	EQ	209.5	210	210	194	200	195.1	203.75	29200	594945000000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ONGC	EQ	195.1	204.95	209.8	200	202.7	202.2	205.03	16700	342400500000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ONGC	EQ	202.2	202	202.95	198	200	198.85	200.19	45000	900860500000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ONGC	EQ	198.85	194.1	197	193.1	195	194.4	195.29	32600	636651000000


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