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)	JCHAC	1858.05	1878.5	1897.45	1854.95	1859.15	6724	125.72	1164	3824	56.869998931884766
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JCHAC	1859.15	1868.45	1904.75	1860	1867.35	13353	250.18	1611	11077	82.95999908447266
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JCHAC	1867.35	1875	2017.1	1754	1791.05	159681	3044.03	20076	32814	20.549999237060547
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JCHAC	1791.05	1806	1836.1	1780	1788.85	37858	680.89	2226	30361	80.19999694824219
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JCHAC	1837.8	1837.8	1837.8	1795	1809.55	23660	429.99	1091	19922	84.19999694824219
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JCHAC	1788.85	1800	1868.5	1790	1837.8	18126	332.53	3041	5596	30.8700008392334
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JCHAC	1892.45	1901.95	1949	1851	1858.05	13386	253.6	2576	5920	44.22999954223633
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JCHAC	1918.25	1926.65	1926.95	1900	1906.95	582	11.12	171	325	55.84
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JCHAC	1906.95	1901.45	1920	1883.3	1897	2140	40.64	950	1336	62.43
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JCHAC	1897	1885.8	1924.95	1885.5	1912.7	1300	24.76	424	665	51.15


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