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)	HEROHONDA	EQ	1145.2	1200	1236.8	1171	1209.95	1207.6	1209.11	10631	1285400800000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROHONDA	EQ	1207.6	1200	1220	1176	1200	1199.85	1200.93	19849	2383719075000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROHONDA	EQ	1199.85	1155	1178	1140	1140	1143.8	1159.74	2525	292835460000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROHONDA	EQ	1143.8	1183	1189.95	1150.25	1165	1161.4	1167.29	4375	510688695000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROHONDA	EQ	1161.4	1140	1140	1069	1105	1106.55	1103.52	9093	1003429065000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROHONDA	EQ	1106.55	1105.05	1135	1100	1115.1	1126.35	1123.41	11113	1248446415000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROHONDA	EQ	1126.35	1100	1135	1095	1130	1125.1	1106.96	11333	1254517810000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROHONDA	EQ	1125.1	1176	1198	1150	1180	1174.95	1174.81	4353	511395235000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROHONDA	EQ	1174.95	1198	1198	1140	1140	1146.4	1172.03	7221	846320885000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HEROHONDA	EQ	1146.4	1194	1198	1157.5	1190	1190.3	1182.32	12898	1524953345000


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