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)	IRCTC	860.65	861	865.5	851.25	855.75	2105561	18061.43	60856	421805	20.030000686645508
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCTC	855.75	858.75	868.55	830	835.6	4119747	34752.55	119511	1255559	30.479999542236328
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCTC	835.6	842.5	848.6	821.5	838.05	3851680	32207.94	100550	802175	20.82999992370605
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCTC	838.05	859	868.4	845.1	849.95	6791815	57986.08	148381	925931	13.630000114440918
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCTC	845.9	835.5	841.95	825	830.75	2582020	21545.92	86584	942210	36.4900016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCTC	849.95	855	855.15	840.3	845.9	2569073	21740.74	70970	664616	25.8700008392334
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCTC	860.9	860.5	871.85	857	860.65	2603770	22524.91	70447	654310	25.1299991607666
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCTC	933.45	941.9	953.85	934.8	944.35	1718655	16233.76	42462	248844	14.48
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCTC	944.35	944	944	927.05	930.4	657531	6146.12	20140	186971	28.44
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCTC	930.4	928	943.5	927.55	931.4	868570	8114.73	24396	165272	19.03


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