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)	INDIACEM	229.5	230.5	234.55	224.7	226.4	4151772	9547.1	29866	574758	13.84000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIACEM	226.4	226.7	228.55	218.2	221.55	3524612	7846.54	24577	515408	14.619999885559082
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIACEM	221.55	222.1	224.65	216.2	220.7	2479458	5460.92	19250	283831	11.449999809265137
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIACEM	220.7	220.9	224.9	220.5	223.6	2485295	5540.09	15372	428325	17.229999542236328
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIACEM	222.95	222	222.05	208.85	210	5999938	12931.19	40500	1050446	17.510000228881836
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIACEM	223.6	223.6	226.9	219.5	222.95	2961103	6621.65	19530	306967	10.369999885559082
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIACEM	231.45	232.25	233.7	228.05	229.5	2126521	4918.86	16383	329846	15.510000228881836
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIACEM	71.4	71.25	73.9	71.25	73.1	1457401	1061.01	8529	540870	37.11
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIACEM	73.1	73.05	77.5	73.05	77.1	4216377	3220.72	34410	1556841	36.92
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIACEM	77.1	76.9	78.9	75.5	76.4	1743819	1337.05	10202	664857	38.13


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