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)	GARFIBRES	3139.85	3155.55	3155.55	3100.1	3110.1	3813	119.3	1016	2349	61.61000061035156
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GARFIBRES	3110.1	3100.1	3119.8	3044.25	3100.75	18213	558.54	7522	12579	69.06999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GARFIBRES	3100.75	3116.3	3116.3	3022	3050.95	7675	234.5	3077	3706	48.290000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GARFIBRES	3050.95	3050.95	3094.15	3038	3045.6	4848	148.24	1280	3199	65.98999786376953
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GARFIBRES	3064.1	3047.35	3064.1	3005.25	3050.25	11628	353.09	2647	7348	63.18999862670898
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GARFIBRES	3045.6	3060.85	3075.65	3016.5	3064.1	5350	162.88	1517	3323	62.11000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GARFIBRES	3131.9	3146	3189.7	3116	3139.85	5389	169.71	1789	3117	57.84000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GARFIBRES	1203.5	1210.35	1210.35	1180.05	1200.85	647	7.74	151	469	72.49
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GARFIBRES	1200.85	1206.65	1240	1177.45	1217	1647	19.88	243	1284	77.96
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GARFIBRES	1217	1237.65	1237.65	1210	1226.8	3165	38.69	364	2650	83.73


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