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)	SUDARSCHEM	626.25	630	640	617	619.15	185067	1153.41	9877	95167	51.41999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUDARSCHEM	619.15	619.95	624.65	599	604.65	103180	627.52	6190	48407	46.91999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUDARSCHEM	604.65	610	610	587.15	592.2	79517	472.63	5256	35828	45.060001373291016
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUDARSCHEM	592.2	595	600.25	583.3	596.5	73847	437.32	4560	35089	47.52000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUDARSCHEM	610.65	606.1	606.1	594	598.65	72964	437.61	3709	30920	42.380001068115234
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUDARSCHEM	596.5	598	613	588.05	610.65	143300	865.87	7478	70264	49.02999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUDARSCHEM	612.85	619	636.2	614.1	626.25	521621	3272.4	20640	199628	38.27000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUDARSCHEM	407.1	408	413.25	406	407.15	73389	300.73	2713	38892	52.99
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUDARSCHEM	407.15	406.6	422	406.4	414.05	188657	783.04	5988	89131	47.25
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUDARSCHEM	414.05	413	432.5	410	425.55	366008	1551.32	10186	135278	36.96


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