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)	HFCL	82.5	83.2	83.85	81.5	82.25	6713713	5546.04	29754	1847470	27.520000457763672
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HFCL	82.25	82.55	82.85	80.5	80.9	7765584	6308.68	34096	2608016	33.58000183105469
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HFCL	80.9	81.55	81.85	78.35	80	10370855	8306.14	42896	2494771	24.059999465942383
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HFCL	80	80.6	81.85	80.3	80.9	6116291	4948.19	24289	1613131	26.3700008392334
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HFCL	83	81.8	84.15	80.7	81.1	10358348	8531.01	37331	2393423	23.11000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HFCL	80.9	81.4	84.9	79.65	83	15664502	12963.39	54289	3508742	22.399999618530277
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HFCL	83.85	84.2	84.2	82.2	82.5	7257937	6021.6	30701	2452963	33.79999923706055
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HFCL	17.55	17.65	17.95	17.4	17.45	915041	161.39	1483	396928	43.38
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HFCL	17.45	17.55	18.1	17.45	17.9	2380198	424.79	2869	1051326	44.17
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HFCL	17.9	17.85	18.3	17.7	17.75	2882181	517.93	3935	1011913	35.11


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