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)	COROMANDEL	820.55	816	833	786.15	793.55	806749	6528.75	29806	242766	30.09000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COROMANDEL	793.55	791.7	817.7	786	801.75	450258	3620.95	18201	183294	40.709999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COROMANDEL	801.75	807	814.95	793.95	804.35	453395	3636.59	12669	299018	65.94999694824219
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COROMANDEL	804.35	808.6	810.35	798.1	800.7	219508	1757.76	6481	127009	57.86000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COROMANDEL	807.75	807.75	808.9	787.05	789.9	289484	2308.89	13128	181550	62.720001220703125
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COROMANDEL	800.7	797	811.35	796.3	807.75	140942	1136.45	6486	59728	42.380001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COROMANDEL	794.05	799.9	832	785	820.55	803416	6548.13	40989	181783	22.6299991607666
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COROMANDEL	532.1	533	535	526.55	528.7	47203	250.79	2222	26546	56.24
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COROMANDEL	528.7	529.95	543.15	529.55	533.8	200561	1078.5	10481	69905	34.85
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COROMANDEL	533.8	532.1	542.5	530	539	69188	371.75	3056	38601	55.79


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