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)	BPCL	EQ	381.2	405	407	393.05	397.75	399.25	399.32	8720	348202920000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	EQ	399.25	397.75	397.75	367.4	377.45	370.5	375.71	22820	857369935000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	EQ	370.5	350	385	350	360.1	359.95	359.96	152538	5490785425000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	EQ	359.95	362	384	362	381.65	380.3	380.1	59554	2263622690000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	EQ	380.3	369	390	366	381.5	379.85	378.33	43187	1633889860000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	EQ	379.85	380	394.5	380	383.2	384.95	387.76	52234	2025402100000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	EQ	384.95	385	385	366	370.25	372.8	371.95	17112	636485110000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	EQ	372.8	380	382	375	378	378	376.3	5783	217614045000.00003
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	EQ	378	380	380	373	378	376	375.05	2297	86148750000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	EQ	376	378	382	373	373	374.4	379.33	18856	715265880000


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