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)	MIDHANI	190.8	191.25	195.75	189.45	193.05	554727	1072.76	10460	258030	46.5099983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MIDHANI	193.05	193.35	194.8	189.45	192.05	191841	369.13	4418	94276	49.13999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MIDHANI	192.05	192.8	192.8	187.85	190.1	157834	299.52	5984	84589	53.59000015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MIDHANI	190.1	190.4	192.5	188.5	191.05	160071	304.88	6847	61861	38.650001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MIDHANI	188.7	187	188	183.2	184.7	297499	550.41	11963	196859	66.16999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MIDHANI	191.05	191	191.4	188.1	188.7	105645	200.15	4860	49784	47.119998931884766
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MIDHANI	189.3	190	193.15	189.3	190.8	261027	498.78	5225	105098	40.2599983215332
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MIDHANI	156.4	156.45	157.4	153.25	155.35	196821	305.87	2363	78536	39.9
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MIDHANI	155.35	155.95	164.5	155.85	161.7	1274221	2055.38	10761	467372	36.68
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MIDHANI	161.7	162	162.85	158.2	159.7	445640	715.31	4084	223932	50.25


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