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)	PIDILITIND	2503.2	2504	2510	2472.6	2481.8	452448	11238	44379	273717	60.5
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PIDILITIND	2481.8	2468	2478.85	2420	2435.5	380883	9294.9	38197	204520	53.70000076293945
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PIDILITIND	2435.5	2445.8	2445.8	2402.55	2415.35	547630	13232.48	38088	378953	69.19999694824219
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PIDILITIND	2415.35	2423.55	2495.5	2420.35	2480.6	363447	8907.14	36666	166821	45.900001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PIDILITIND	2489.05	2474	2474	2421.55	2432.25	396913	9689.55	40448	269864	67.98999786376953
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PIDILITIND	2480.6	2496	2498.25	2460.55	2489.05	172476	4279.57	28814	77391	44.869998931884766
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PIDILITIND	2522.9	2539.8	2539.8	2491	2503.2	675190	16925.47	35177	529496	78.41999816894531
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PIDILITIND	1386.9	1388.05	1412	1387	1405.35	252523	3542.67	8995	88057	34.87
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PIDILITIND	1405.35	1405	1411	1395.5	1399.05	206412	2894.2	13354	91234	44.2
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PIDILITIND	1399.05	1395.5	1402.9	1391.55	1397.65	243932	3405.12	12089	125618	51.5


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