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)	RECLTD	140.6	141.5	142.05	137.4	140.6	21717440	30415.05	43584	9891781	45.54999923706055
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RECLTD	140.6	141	141.3	136.45	137.2	8013447	11076.48	47841	4810121	60.02999877929688
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RECLTD	137.2	137.2	137.6	133.4	135.3	6373393	8606.51	33683	3357172	52.66999816894531
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RECLTD	135.3	136	138.65	135.2	138.35	3996445	5478.48	24701	2124135	53.150001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RECLTD	140.85	140.25	141	138.65	138.95	4483378	6248.52	16668	2677256	59.720001220703125
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RECLTD	138.35	138.75	141.2	138.35	140.85	4715871	6611.42	33668	2656252	56.33000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RECLTD	142.05	142.9	143.3	139.95	140.6	4107555	5802.04	18212	2229642	54.27999877929688
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RECLTD	143.1	143.3	144.3	141.55	143.95	2167762	3107.01	8670	606363	27.97
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RECLTD	143.95	143.95	145.9	143.5	145.45	2583542	3742.51	11728	773087	29.92
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RECLTD	145.45	145	145.95	142.3	143	2935857	4234.5	15960	874809	29.8


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