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)	SHARDACROP	618.9	631	671	629.9	657.85	2244098	14801.25	68112	869465	38.7400016784668
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHARDACROP	657.85	660.1	673	645.1	661.9	774057	5132.8	39329	233928	30.21999931335449
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHARDACROP	661.9	659.1	668.4	596	604.15	507347	3156.11	32931	175186	34.529998779296875
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHARDACROP	604.15	608.6	624.9	599.1	609.5	260440	1594.98	18990	77416	29.729999542236328
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHARDACROP	583.95	591.6	609.95	537	558.6	343855	1993.36	17489	135951	39.540000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHARDACROP	609.5	609.9	614	562.95	583.95	354177	2084.41	21695	159330	44.9900016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHARDACROP	602.35	599.95	630	598.6	618.9	597071	3661.16	25568	270234	45.2599983215332
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SHARDACROP	215.2	214.5	239	214.4	234.3	47597	108.62	1707	21654	45.49
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SHARDACROP	234.3	235.1	281.15	234.25	281.15	165040	440.53	5963	71521	43.34
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SHARDACROP	281.15	300.5	319.95	282.3	289.6	421597	1278.32	12832	93744	22.24


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