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)	FINEORG	3900.05	3918.9	4178.25	3918.9	4086.25	115967	4747.37	18808	19881	17.139999389648438
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINEORG	4086.25	4105	4148	4002.65	4088.2	27391	1111.81	7448	8234	30.059999465942383
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINEORG	4088.2	4106.25	4120	3876.35	3962.9	32052	1270.37	8845	11344	35.38999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINEORG	3962.9	3982.75	4008	3915.7	3926.85	8974	353.85	2791	3973	44.27000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINEORG	3972.15	3965	3965	3735	3833.1	33679	1293.32	7375	8213	24.38999938964844
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINEORG	3926.85	3946.5	4000	3906.55	3972.15	8702	344.38	2502	3579	41.130001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINEORG	3934.6	3948	4038	3878	3900.05	32561	1296.09	7332	10578	32.4900016784668
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FINEORG	1945.05	1951.95	1952	1890.9	1898.75	10159	194.39	1734	7216	71.03
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FINEORG	1898.75	1890.05	1919.2	1890.05	1900.35	37805	723.54	2265	33985	89.9
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FINEORG	1900.35	1906.9	1915	1882.65	1897.2	14082	267.75	3099	8021	56.96


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