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)	IPCALAB	1045.7	1050	1051.75	1028.25	1036.65	52032	541.86	5155	14727	28.299999237060547
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IPCALAB	1036.65	1039.7	1054	1010	1020.3	174628	1785.45	10341	91995	52.68000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IPCALAB	1020.3	1024	1024	996.55	1001.35	162046	1635.76	9697	62034	38.27999877929688
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IPCALAB	1001.35	1007	1024.9	1002.55	1020.5	119278	1209.74	12283	40261	33.75
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IPCALAB	1004	989	1005.1	975.95	993.75	325629	3232.14	20146	150820	46.31999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IPCALAB	1020.5	1029	1029	985.15	1004	118579	1197.96	7330	62217	52.470001220703125
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IPCALAB	1054.65	1061.75	1067.65	1040	1045.7	125055	1317.48	10370	40158	32.11000061035156
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IPCALAB	1136.25	1136.9	1143.15	1126.1	1138.35	38106	434.1	5952	24554	64.44
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IPCALAB	1138.35	1146.9	1146.9	1131.25	1141.2	72652	827.17	5116	48182	66.32
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IPCALAB	1141.2	1139.9	1151.85	1126.1	1140.75	91587	1045.13	5968	57570	62.86


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