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)	AIAENG	1863.15	1863.15	1880.8	1824.35	1852.2	89124	1644.4	8662	72206	81.0199966430664
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AIAENG	1852.2	1835.4	1890	1835.4	1873.35	11612	217.16	2467	6113	52.63999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AIAENG	1873.35	1873.4	1900	1873.3	1897.5	34900	658.86	1990	31039	88.94000244140625
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AIAENG	1897.5	1929	1929	1896.55	1905.2	9416	179.42	2006	6714	71.30000305175781
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AIAENG	1883.5	1840	1877.05	1840	1865.35	47284	877.57	4392	40446	85.54000091552734
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AIAENG	1905.2	1900	1904.8	1837.15	1883.5	117775	2225.44	3895	105907	89.91999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AIAENG	1917.9	1918	1925.85	1859.55	1863.15	13378	251.65	2652	7734	57.810001373291016
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AIAENG	1649.5	1640.55	1649.55	1615.1	1622.6	3912	63.77	661	2446	62.53
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AIAENG	1622.6	1626	1637.55	1608	1621.1	7245	117.28	1111	4269	58.92
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AIAENG	1621.1	1622.15	1650	1622.15	1648.6	6281	103.18	1167	3197	50.9


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