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)	NAUKRI	4995.5	4960	4999	4832.2	4844.9	440333	21585.39	40258	195266	44.34999847412109
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAUKRI	4844.9	4848.9	4903.3	4758.05	4796.55	274867	13224.81	34222	97825	35.59000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAUKRI	4796.55	4800	4917.4	4755.15	4775.2	353243	17026.47	41533	89667	25.3799991607666
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAUKRI	4775.2	4820.9	4957.8	4820.9	4913.1	386362	18959.14	46435	110661	28.63999938964844
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAUKRI	4888.5	4800	4840	4580	4595.65	925735	42877.67	93162	302635	32.689998626708984
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAUKRI	4913.1	4960	5020.35	4841.05	4888.5	264005	12901.86	34849	121945	46.18999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAUKRI	5115.1	5070	5109.95	4960	4995.5	375267	18800.17	50381	116904	31.14999961853028
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NAUKRI	2530.05	2533.3	2590	2530	2565.6	60629	1555.78	4840	19299	31.83
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NAUKRI	2565.6	2550	2564.45	2521.15	2535.2	188017	4766.65	18162	126690	67.38
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NAUKRI	2535.2	2535.2	2580	2533.05	2567.45	125129	3212.82	12757	48503	38.76


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