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)	ICICIPRULI	544.2	543.9	548.75	534.1	535.8	1177060	6397.55	26014	826231	70.19000244140625
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIPRULI	535.8	535.7	538	516	522.95	914910	4789.63	38700	368045	40.22999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIPRULI	522.95	523.25	527.1	510.5	515.9	1168893	6038.6	42337	540845	46.27000045776367
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIPRULI	515.9	515	523	513.6	515.8	1128825	5839.73	46531	705261	62.47999954223633
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIPRULI	527.85	526.4	528	513.5	517.3	1108104	5755.99	29713	551902	49.810001373291016
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIPRULI	515.8	519	529	505.35	527.85	2317150	12019.81	89088	1293559	55.83000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIPRULI	553.75	554.5	555.8	540	544.2	715909	3922.42	35553	416726	58.209999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIPRULI	482.45	482.5	484.8	479.55	480.95	613516	2957.09	11022	277815	45.28
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIPRULI	480.95	482.25	487.35	480.6	486.45	880457	4268.25	20473	395155	44.88
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ICICIPRULI	486.45	486.95	488.25	481.65	483.2	861600	4173.99	13344	402860	46.76


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