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)	BAJAJCON	179.85	181	181.8	179.6	180.05	455569	820.87	8378	295758	64.91999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJCON	180.05	180.8	181.5	177.2	177.9	506863	909.01	8952	277923	54.83000183105469
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJCON	177.9	179.8	180.2	177.25	179.15	345855	618.8	8812	149998	43.369998931884766
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJCON	179.15	179.85	180.7	178	178.95	381786	683.11	8694	207479	54.34000015258789
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJCON	174.95	174.5	174.95	172.1	172.8	417316	722.22	12084	212746	50.97999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJCON	178.95	176.9	177.15	172.4	174.95	657673	1151.92	11410	375711	57.130001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJCON	187.5	185.1	185.8	178.9	179.85	1904090	3437.03	25933	1067977	56.09000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJCON	236.1	236.1	243	236.1	239.35	85650	205.34	1622	49607	57.92
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJCON	239.35	245	247	239.6	240.65	205087	498.98	8169	85659	41.77
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJCON	240.65	240.05	242.95	236.8	239.95	448670	1076.05	8065	358356	79.87


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