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)	RELIANCE	2352.75	2341	2348.45	2321.1	2331.3	5104761	119153.66	230586	2346527	45.970001220703125
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	2331.3	2342	2356.8	2305	2317.1	4944725	115255.87	243702	2190778	44.310001373291016
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	2317.1	2330.65	2360	2310	2356.05	5566080	130152.61	186348	2963152	53.2400016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	2356.05	2371.15	2387.2	2358	2383.5	5300891	125793.55	180905	3104784	58.56999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	2381.05	2373.25	2384.5	2344.1	2376.4	7357863	174231.87	283837	4905802	66.66999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	2383.5	2395.7	2395.7	2365.1	2381.05	5752361	137020.87	210155	3608073	62.720001220703125
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	2383.55	2392	2401.45	2347.2	2352.75	4417864	104571.43	236441	2596474	58.77000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	1514.05	1518	1527.1	1505.5	1509.6	6402372	97010.63	122265	1523290	23.79
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	1509.6	1512	1540.95	1512	1535.3	8096561	123947.1	151727	3386321	41.82
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	1535.3	1533	1541.65	1523	1537.15	9593498	147042.83	149003	5288843	55.13


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