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)	HCLTECH	1156.75	1160	1167.1	1137.35	1163.8	3625482	42024.1	108136	1977007	54.52999877929688
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	1163.8	1157	1171.35	1146	1157.35	3824483	44306.29	102739	2329668	60.90999984741211
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	1157.35	1158.95	1169.85	1148.55	1161.95	3267641	37901.89	98059	2081413	63.70000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	1161.95	1172	1189	1166	1180.9	3772972	44668.83	111046	2220882	58.86000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	1190.35	1179	1179	1158.05	1163.7	3912397	45609.51	108734	2714179	69.37000274658203
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	1180.9	1184.95	1191.9	1174.1	1190.35	2053245	24319.73	106669	1202738	58.58000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	1170.95	1162	1170.85	1151	1156.75	4169794	48507.39	94552	2386842	57.2400016784668
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	568.1	569.4	572.9	566.85	571.95	918373	5239.18	17539	503196	54.79
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	571.95	572.55	575	570.5	573.55	1075642	6166.04	52734	523259	48.65
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HCLTECH	573.55	574	588.5	572.85	585.05	3269446	19098.27	77707	1071299	32.77


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