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)	CUB	144.7	145.9	145.9	143.7	144.35	1161616	1683.33	19596	508441	43.77000045776367
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CUB	144.35	143.9	144.65	139	139.85	4337671	6117.12	30325	2402957	55.400001525878906
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CUB	139.85	140.95	141.4	136.6	139.2	4525520	6305.24	22287	730643	16.139999389648438
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CUB	139.2	139.7	140.8	138.55	139.8	1947520	2724.64	39895	1130029	58.02000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CUB	139.9	139	139.7	135.8	136.15	898637	1237.08	7784	496121	55.209999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CUB	139.8	140.9	140.95	139	139.9	917906	1287.02	22942	463753	50.52000045776367
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CUB	146.9	147.9	148	144.3	144.7	3073735	4482.54	44994	843011	27.43000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CUB	233.95	235.4	235.4	231.6	233.5	904067	2101.78	4711	749749	82.93
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CUB	233.5	234.3	235	230.45	231.8	510686	1190.29	4789	393651	77.08
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CUB	231.8	231.5	231.85	227.7	228.5	559865	1285.99	7699	449053	80.21


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