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)	INDIANB	168.05	168.15	170.3	162.65	168.45	6560635	10938.05	40493	1740062	26.520000457763672
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIANB	168.45	169.15	178.7	155.3	158.95	20025570	33719.3	123349	6265275	31.290000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIANB	158.95	158.25	163.1	153.35	155.65	7173035	11253.21	68154	1967667	27.43000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIANB	155.65	158	159.85	153.6	155.6	4416559	6925.95	33774	1263513	28.61000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIANB	157.8	154.5	157.5	152.05	153.15	2893723	4471.87	19645	979530	33.849998474121094
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIANB	155.6	156.7	158.5	154.6	157.8	2860373	4496.09	20229	590572	20.649999618530277
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIANB	168.15	168.5	171.95	165.6	168.05	7137949	12056.37	48898	1555034	21.790000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIANB	100.95	101.9	102.35	100.55	101.35	957240	971.76	7684	282409	29.5
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIANB	101.35	101.6	103.7	101.4	102.85	1551597	1594.68	14602	579876	37.37
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIANB	102.85	102.85	104.4	102.15	102.85	1142845	1179.94	12508	441050	38.59


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