NIFTY ALL STOCK Dataset

date Date	symbol Symbol	pre_close Pre Close	open Open	high High	low Low	close Close	volume Volume	turnover_lacs Turnover Lacs	no_of_trades No Of Trades	deliv_volume Deliv Volume	deliv Deliv %
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJELEC	1217.6	1223.7	1233	1213	1221.95	61370	748.72	5262	23833	38.83000183105469
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJELEC	1221.95	1240	1240	1214.1	1220.35	72123	882.49	6326	24770	34.34000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJELEC	1220.35	1234.9	1258.25	1202.15	1220.7	475198	5800.4	38603	86105	18.1200008392334
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJELEC	1220.7	1210	1224.7	1174.6	1186.7	197919	2386.25	15968	98678	49.86000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJELEC	1187.45	1165.1	1175	1158	1165.65	61678	719.41	4650	31560	51.16999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJELEC	1186.7	1192.75	1193.7	1176.5	1187.45	90174	1067.25	5893	34518	38.27999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJELEC	1216.6	1224.75	1245	1210	1217.6	232663	2866.37	14255	50206	21.57999992370605
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJELEC	358.15	362.05	366.95	357.05	360.05	149446	540.33	4350	34407	23.02
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJELEC	360.05	362.6	370.05	353	364.85	188956	681.54	5442	71492	37.84
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJELEC	364.85	363.5	367.5	354.25	355.7	89539	322.03	3642	38276	42.75


CREATE TABLE bajajelec (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE
);