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)	RAMCOCEM	873	874.85	894.95	861	882.5	271556	2406.57	12351	102860	37.880001068115234
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAMCOCEM	882.5	882.5	888.1	863.05	876.1	115045	1006.5	7277	25476	22.13999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAMCOCEM	876.1	880.45	890	860	877.35	210219	1844.58	7772	87724	41.72999954223633
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAMCOCEM	877.35	880	897.2	878.15	890.1	218765	1941.65	19121	92401	42.2400016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAMCOCEM	890.45	885	886.9	868.25	872.9	107865	945.13	5650	49748	46.119998931884766
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAMCOCEM	890.1	890.2	898.2	885.95	890.45	168295	1501.14	10901	71484	42.47999954223633
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAMCOCEM	888.95	888.95	894.9	869.55	873	134348	1183.07	7661	56055	41.720001220703125
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RAMCOCEM	754.65	757	759.5	748.7	753.4	92492	697.31	2153	46033	49.77
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RAMCOCEM	753.4	753.9	780.45	752.3	769.1	851564	6570.95	27697	383807	45.07
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RAMCOCEM	769.1	772.7	773.85	756.2	761.15	301227	2300.92	7537	60459	20.07


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