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)	RHIM	434.5	432.05	438.25	429	431.3	50897	219.91	2567	26851	52.7599983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RHIM	431.3	429.95	436	415	416.8	93240	394.05	4039	53700	57.59000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RHIM	416.8	417.7	422.45	404	409.65	144475	598.17	4719	87254	60.38999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RHIM	409.65	414.45	426.5	414.45	423.85	89917	379.23	4331	52463	58.34999847412109
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RHIM	425.05	470	493.9	446.3	486.05	2481055	11716.87	64193	505876	20.38999938964844
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RHIM	423.85	425	429.95	414.6	425.05	66610	281.05	5599	34961	52.4900016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RHIM	439.45	442.9	448	430.3	434.5	77508	338.3	3619	34868	44.9900016784668
Thu Jul 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	RHIM	322.4	324.9	328	320.35	322.4	86577	280.17	3133	53984	62.35
Fri Jul 23 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	RHIM	322.4	322.4	328	322.3	322.85	39196	127.09	2245	23300	59.44
Mon Jul 26 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	RHIM	322.85	327	346.5	327	334.3	307989	1043.53	11911	141959	46.09


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