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)	DEEPAKNTR	2338.75	2330	2402	2328	2365.35	595943	14140.94	40070	120189	20.170000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DEEPAKNTR	2365.35	2382.3	2391.9	2327.2	2349.35	391382	9225.67	28133	116471	29.76000022888184
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DEEPAKNTR	2349.35	2359.75	2365.15	2261.8	2320.7	595603	13744.39	39999	198863	33.38999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DEEPAKNTR	2320.7	2332	2365.9	2280.55	2307.25	498481	11534.61	32656	208796	41.88999938964844
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DEEPAKNTR	2289.75	2285	2285	2203.85	2211.85	440069	9834.66	35656	203845	46.31999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DEEPAKNTR	2307.25	2319.9	2333.85	2283.95	2289.75	381875	8792.79	23520	160170	41.93999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DEEPAKNTR	2362.4	2370	2373.4	2322.4	2338.75	393196	9226.5	30518	97238	24.729999542236328
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DEEPAKNTR	373.1	370.1	379	370.1	374.75	172951	650.6	6215	64975	37.57
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DEEPAKNTR	374.75	375.05	389.7	371.8	384.7	505078	1940.07	14811	196307	38.87
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DEEPAKNTR	384.7	385.85	388	377.25	386.45	286109	1097.59	11001	110436	38.6


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