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)	IBULHSGFIN	219.5	219.8	221.7	213.55	214.35	7621080	16513.09	50441	2275260	29.850000381469727
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IBULHSGFIN	214.35	215.15	216.25	208.15	209.1	7733436	16353.78	48028	2535415	32.790000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IBULHSGFIN	209.1	210	211.2	195.7	197.4	17061964	34413.57	117545	5674981	33.2599983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IBULHSGFIN	197.4	199	207.9	194	206.65	13045603	26194.12	91891	2421345	18.559999465942383
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IBULHSGFIN	205.4	202	206.7	196.9	197.85	8838265	17776.84	63250	2400195	27.15999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IBULHSGFIN	206.65	206.6	208.7	201.8	205.4	10956644	22534.36	79986	2017800	18.420000076293945
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IBULHSGFIN	219.55	220	222.75	218.55	219.5	7967823	17579.97	58515	2161831	27.1299991607666
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IBULHSGFIN	313.2	315	318.3	310.65	312.7	18294197	57586.17	148130	1155966	6.32
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IBULHSGFIN	312.7	314	328.6	310.3	325.15	31124957	99637.36	257310	2952687	9.49
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IBULHSGFIN	325.15	325.5	335.8	321.05	329.6	38042432	125370.69	287931	1529935	4.02


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