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)	GNFC	468.85	470.2	476.25	453.5	455.2	946615	4382.21	15405	362157	38.2599983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GNFC	455.2	500.7	535	500.7	515.55	16927605	87843.75	183703	2433836	14.380000114440918
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GNFC	515.55	516	543.9	507.85	538.35	11116752	58924.6	152196	1379953	12.40999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GNFC	538.35	540	551.4	532.1	546.5	4484583	24371.46	65192	865694	19.299999237060547
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GNFC	570.75	560	577.9	559.4	565.9	4794759	27275.37	58033	531695	11.09000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GNFC	546.5	541.8	573	541.5	570.75	6122332	34514.33	84858	798644	13.039999961853027
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GNFC	462.5	463.95	472	462.6	468.85	723134	3388.44	11871	297424	41.130001068115234
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GNFC	163.9	164.6	164.6	161.35	162.1	408863	666.45	5288	209135	51.15
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GNFC	162.1	158.55	171.6	155	168.3	1865039	3061.85	19638	505080	27.08
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GNFC	168.3	165	174.35	163.25	170.2	1567146	2665.65	25338	419634	26.78


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