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)	UTIBANK	EQ	24.7	26.7	26.7	26.7	26.7	26.7	26.7	112100	299307000000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIBANK	EQ	26.7	27	28.7	26.5	27	26.85	27.24	234500	638727500000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIBANK	EQ	26.85	26	27.75	25.5	26.4	26.3	26.24	170100	446298000000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIBANK	EQ	26.3	25.8	27	25.8	25.9	25.95	26.27	102100	268173000000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIBANK	EQ	25.95	25	26	24.25	25	24.8	25.04	62600	156722000000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIBANK	EQ	24.8	25.05	26.5	25	25	25	25.29	64200	162334000000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIBANK	EQ	25	24.25	24.8	23	23	23.2	23.9	91700	219172500000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIBANK	EQ	23.2	22.6	24.5	22.6	24	24	23.97	32500	77913500000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIBANK	EQ	24	24.5	24.5	23.1	23.8	23.6	23.77	48300	114795500000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIBANK	EQ	23.6	24	24.2	22.5	23.5	23.25	23.17	30700	71142500000


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