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)	ASIANPAINT	EQ	361.2	370	390	370	385	381.65	380.54	3318	126261725000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	EQ	381.65	380	392	375	390	385.55	383.5	4818	184769865000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	EQ	385.55	371.5	390	371.5	383	383	379.81	2628	99813845000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	EQ	383	384.9	384.9	374.5	375.1	377.5	379.88	3354	127411439999.99998
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	EQ	377.5	376	390	370	389	385.7	383.38	9589	367627470000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	EQ	385.7	415	416.6	409	416.6	415	414.97	60313	2502823025000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	EQ	415	415	423	409	417	415.2	412.51	65570	2704802390000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	EQ	415.2	420	448.45	410.05	418.55	417.65	421.46	24854	1047500785000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	EQ	417.65	423	429.9	413.05	417.1	418.7	422.4	9169	387300640000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ASIANPAINT	EQ	418.7	410	414.9	408	410.6	410	410.05	64603	2649021300000


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