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)	HATSUN	1114.65	1113	1144	1070.35	1085	59382	659.31	8070	18490	31.13999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HATSUN	1085	1082.5	1173.05	1082.45	1134.4	158256	1812.63	12508	36537	23.09000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HATSUN	1134.4	1130	1189	1125	1141.3	178711	2058.19	13591	52883	29.59000015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HATSUN	1141.3	1145.15	1168.85	1135	1145.05	66803	766.04	5770	33926	50.790000915527344
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HATSUN	1151.5	1166	1166	1140	1146.15	19275	221.46	3164	5968	30.959999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HATSUN	1145.05	1133	1164.95	1133	1151.5	24858	286.22	3402	7571	30.459999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HATSUN	1150.35	1147	1147	1102.25	1114.65	46887	528.58	7104	15051	32.099998474121094
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HATSUN	586.25	587	591.9	576.05	580.75	7949	46.21	497	4226	53.16
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HATSUN	580.75	588.95	590.25	577	579.75	3475	20.18	286	2230	64.17
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HATSUN	579.75	582.1	584.8	576	580.1	3508	20.39	236	2837	80.87


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