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)	NATIONALUM	116.8	117.35	121.5	117	117.85	27147310	32398.3	69978	6531325	24.059999465942383
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NATIONALUM	117.85	118.5	120.9	117.9	119	20083666	24032.47	66711	4985091	24.81999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NATIONALUM	119	120	121.45	114.3	119.2	39305478	46174.98	106384	6305485	16.040000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NATIONALUM	119.2	121.3	126.25	121.3	124.7	39566419	49147.19	125332	10021414	25.32999992370605
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NATIONALUM	125.9	124	126.9	121.4	122.5	25387059	31487.21	74126	6895459	27.15999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NATIONALUM	124.7	125.95	128.25	125.3	125.9	28640085	36323.81	93039	7993307	27.90999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NATIONALUM	116.05	115.8	118.6	115.25	116.8	19078393	22340.9	58565	6341438	33.2400016784668
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NATIONALUM	43.65	43.7	44.05	42.85	43.2	8132650	3530.14	11267	3556432	43.73
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NATIONALUM	43.2	43.3	46.25	43.1	45.95	20691143	9363.34	29530	6157308	29.76
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NATIONALUM	45.95	45.95	46.65	45.15	45.65	11015257	5051.78	16027	2809791	25.51


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