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)	TCIEXP	1952.15	1952.15	1980	1867	1875.35	43974	834.61	7500	28757	65.4000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCIEXP	1875.35	1870	1870	1738	1831.65	82906	1483.52	13739	41311	49.83000183105469
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCIEXP	1831.65	1831.65	1856.8	1726.4	1765.6	65098	1148.84	7762	41492	63.7400016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCIEXP	1765.6	1773.55	1805.9	1680.3	1720.95	62350	1074.14	10960	32054	51.40999984741211
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCIEXP	1757.95	1750	1811	1730.15	1783.25	49039	873.14	6226	31612	64.45999908447266
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCIEXP	1720.95	1730	1770	1730	1757.95	17829	312.94	2761	10207	57.25
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCIEXP	1961.35	1980	1980	1931.45	1952.15	12003	234.29	3273	6581	54.83000183105469
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TCIEXP	742.35	751.9	751.9	736.3	739.6	7219	53.45	1313	3821	52.93
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TCIEXP	739.6	740	746.35	728.8	730.85	20434	150.27	2631	13912	68.08
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TCIEXP	730.85	734.9	745.85	721.75	728.55	10896	79.74	1265	6853	62.89


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