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)	ABCAPITAL	124.7	127.05	129.3	123.3	123.65	9373250	11832.17	45496	2673431	28.520000457763672
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABCAPITAL	123.65	123.8	124.75	119.45	120.35	3502998	4263.87	20535	1450869	41.41999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABCAPITAL	120.35	120.5	121.65	117.1	118.65	3018779	3584.98	17448	757342	25.09000015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABCAPITAL	118.65	119.5	120.7	118	119.1	4337200	5184.8	18791	976624	22.520000457763672
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABCAPITAL	120.45	119.65	120.65	116.55	117.1	2922439	3473.23	15935	870807	29.799999237060547
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABCAPITAL	119.1	119.7	121.85	118.3	120.45	3037306	3654.5	16608	888380	29.25
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABCAPITAL	126.25	126.4	127.25	124.2	124.7	3695103	4644.77	19020	1355124	36.66999816894531
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ABCAPITAL	102.7	103.2	103.4	101.2	101.5	982667	1003.01	9428	374847	38.15
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ABCAPITAL	101.5	101.4	108.5	101.4	106.35	4467967	4729.42	39178	1667986	37.33
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ABCAPITAL	106.35	106.55	109.75	106.15	107.75	4053643	4383.42	54085	1325570	32.7


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