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)	SPANDANA	377.3	376	433.9	371.3	415.75	4921473	20420.03	99844	365664	7.429999828338623
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPANDANA	415.75	408.7	417.65	400	405.35	714019	2922.21	19458	107548	15.0600004196167
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPANDANA	405.35	407	430	393.2	401	1017092	4251.66	27013	137351	13.5
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPANDANA	401	404.9	459.95	404.1	438.65	3408431	15025.79	72879	417511	12.25
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPANDANA	428.45	427.95	429	410	415.3	241853	1014.6	7585	67134	27.76000022888184
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPANDANA	438.65	439.5	440	421.7	428.45	712915	3057.7	18651	128688	18.049999237060547
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPANDANA	404.5	410	412.55	375	377.3	1488523	5808.23	35826	287814	19.34000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SPANDANA	1194.1	1191.35	1195.95	1181.55	1185.55	9344	110.94	897	3284	35.15
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SPANDANA	1185.55	1182.4	1197.45	1175.1	1181.55	14191	167.66	1167	7405	52.18
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SPANDANA	1181.55	1187	1200	1167.5	1174.95	14166	167.51	1233	7601	53.66


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