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)	SAIL	104.45	104.7	106.7	103.85	105.1	39818820	42102.51	96978	12533574	31.479999542236328
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SAIL	105.1	104.45	106.25	102	102.45	41791347	43436.53	107314	11283009	27
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SAIL	102.45	103	104.1	99.5	101.9	43278258	43938.07	109044	10472819	24.200000762939453
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SAIL	101.9	102.3	104	100.55	103.6	38882386	39761.8	86687	9141983	23.51000022888184
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SAIL	103.4	102.5	103.1	101.1	101.75	24260135	24758.13	66719	7436544	30.649999618530277
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SAIL	103.6	101	106.75	101	103.4	84638735	88697.64	177535	22410532	26.479999542236328
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SAIL	104.15	104.7	105.7	103.3	104.45	32947766	34548.2	90656	11678104	35.439998626708984
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SAIL	42.9	43.15	43.5	42.55	42.9	24324562	10459.94	27490	1913403	7.87
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SAIL	42.9	44	47.6	43.7	47.25	90919639	41917.41	107837	8002890	8.8
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SAIL	47.25	46.7	47.55	46.2	46.65	35905086	16841.54	45989	3166329	8.82


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