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)	HDFCLIFE	634.4	637	637	622.1	624.35	1909456	11970.04	57560	742803	38.900001525878906
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCLIFE	624.35	620.1	623.7	600	603.25	3030728	18413.46	103252	1531641	50.540000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCLIFE	603.25	606.4	607.85	594	600.45	1954492	11739.33	64626	885017	45.27999877929688
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCLIFE	600.45	606.75	606.75	596.1	600.2	2644690	15862.75	69386	1601599	60.560001373291016
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCLIFE	606.25	600.7	601.5	593	595.35	2557745	15264.75	63303	1594187	62.33000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCLIFE	600.2	600.2	611.5	590.45	606.25	6231536	37373.89	129569	4172391	66.95999908447266
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCLIFE	644.15	646.05	647.3	631.05	634.4	2076930	13271.69	47989	1316428	63.380001068115234
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCLIFE	626.05	623	626	616.35	621.45	1749377	10853.34	69565	554279	31.68
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCLIFE	621.45	622.7	638.8	618.4	634.25	1973981	12465.91	48203	873147	44.23
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCLIFE	634.25	631	637.45	626.4	630.7	2401828	15157.53	40553	1693746	70.52


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