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)	ANGELONE	1402.9	1400	1407.2	1380	1384.25	205000	2856.61	12765	98281	47.93999862670898
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ANGELONE	1384.25	1384.15	1388.7	1325	1342	349633	4738.42	23240	153557	43.91999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ANGELONE	1342	1320	1367	1315	1346.45	652255	8759.92	28768	324749	49.790000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ANGELONE	1346.45	1354.9	1380	1325	1337.05	362687	4877.48	18465	139606	38.4900016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ANGELONE	1363.5	1346.9	1355.25	1300	1306.95	392989	5200.87	19117	201731	51.33000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ANGELONE	1337.05	1347.75	1382.45	1327.65	1363.5	390501	5311.56	17461	176766	45.27000045776367
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ANGELONE	1410.3	1419	1425	1396	1402.9	373633	5270.36	20360	187167	50.09000015258789
Thu Nov 11 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ANGELONE	1240.6	1244	1246	1221	1225.25	145950	1792.3	7862	81792	56.04
Fri Nov 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ANGELONE	1225.25	1230	1240	1210	1219.7	308246	3781.83	14100	210710	68.36
Mon Nov 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ANGELONE	1219.7	1225	1236.9	1204.05	1211.55	338705	4114.95	19300	195930	57.85


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