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)	ACC	2293.6	2298.2	2322.45	2270	2274.75	184813	4234.14	16556	51401	27.809999465942383
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ACC	2274.75	2282.7	2292.75	2239.25	2282.2	201382	4571.47	13911	76541	38.0099983215332
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ACC	2282.2	2286	2310	2262.2	2304.75	608392	13915.44	25086	364410	59.900001525878906
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ACC	2304.75	2317.3	2338.8	2290.2	2310.3	367725	8508.26	19685	97993	26.649999618530277
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ACC	2303.55	2290	2297	2240	2249.35	359096	8136.62	27438	179550	50
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ACC	2310.3	2280	2324.8	2265	2303.55	876424	20177.51	47079	350881	40.040000915527344
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ACC	2306.55	2308.9	2328	2286.25	2293.6	253714	5843.12	13054	125753	49.560001373291016
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ACC	1445.65	1452.5	1457	1438.2	1440.1	321092	4638.18	12889	82053	25.55
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ACC	1440.1	1442	1501.7	1442	1493.05	1503364	22318.17	42586	394367	26.23
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ACC	1493.05	1493	1494	1467.1	1476.3	568262	8403.37	18109	146128	25.71


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