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)	ESCORTS	1858.95	1862	1862	1828.1	1835.5	716017	13174.89	22707	444420	62.06999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ESCORTS	1835.5	1840	1844.65	1810.1	1823.85	712900	12983.3	20491	399020	55.970001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ESCORTS	1823.85	1825.85	1849.85	1820	1841.05	1213130	22237.52	35931	550032	45.34000015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ESCORTS	1841.05	1833.5	1859	1825.55	1855.95	615172	11365.91	32422	282788	45.970001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ESCORTS	1846.8	1845	1862	1841	1854.45	368706	6825.04	10383	204192	55.380001068115234
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ESCORTS	1855.95	1855	1864.7	1844.55	1846.8	411418	7624.86	13600	234587	57.02000045776367
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ESCORTS	1844.65	1865.05	1882.1	1852.45	1858.95	918951	17149.43	26600	270317	29.420000076293945
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ESCORTS	629.6	630	634.4	603.05	606.2	4151641	25447.75	46650	499627	12.03
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ESCORTS	606.2	606.2	620.7	604.55	618.9	2294478	14086.26	30831	480115	20.92
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ESCORTS	618.9	618	625	612.25	620.85	1663980	10297.09	21528	284152	17.08


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