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)	HINDALCO	512.65	513	528.5	512.05	525.15	12631663	66192.9	173284	4690373	37.130001068115234
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALCO	525.15	527.85	533.25	519.45	522.6	10939353	57592.78	121080	4602393	42.06999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALCO	522.6	526	533.1	514.05	526.8	9863290	51583.48	138834	3247209	32.91999816894531
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALCO	526.8	536	544.4	532.1	542.3	9235351	49674.25	156545	3927198	42.52000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALCO	547.25	547.75	553.85	539.5	542.7	9110193	49748.12	179500	2643899	29.020000457763672
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALCO	542.3	547.7	553.5	541	547.25	10906403	59634.12	180185	3249038	29.790000915527344
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALCO	513.95	513	516.5	509	512.65	5078613	26073.99	77460	2213465	43.58000183105469
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALCO	216.15	216.15	217.45	213.2	214.3	5085208	10929.35	32236	989173	19.45
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALCO	214.3	216	221.2	216	220.15	15238841	33254.1	143217	6397526	41.98
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALCO	220.15	219.3	219.95	216.05	216.45	8658243	18829.84	66849	2631189	30.39


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