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)	MINDACORP	200.55	201	207.8	200	204.45	692417	1404.84	11058	232461	33.56999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDACORP	204.45	203.9	203.9	193	194.95	848983	1677.3	14105	307124	36.18000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDACORP	194.95	194.65	197.95	185	190.3	1063925	2024.96	22843	289885	27.25
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDACORP	190.3	192.05	199.5	191.8	198.15	684696	1339.34	11080	200119	29.229999542236328
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDACORP	198.15	196.5	199.8	193.35	196.55	305329	600.95	6157	76947	25.200000762939453
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDACORP	198.15	199	203.4	196.5	198.15	529772	1057.56	9039	141389	26.690000534057617
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDACORP	201.35	202.85	205.9	199	200.55	699715	1416.86	11219	188030	26.8700008392334
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDACORP	100.35	100.95	101.3	98.3	99	99675	99.41	1208	47338	47.49
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDACORP	99	99.75	104.25	98.5	100.1	632337	638.11	4052	423350	66.95
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDACORP	100.1	100	103.9	99	100.1	211341	214.96	2889	102411	48.46


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