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)	INFY	1738.55	1732	1753.95	1710.15	1741.1	4700077	81602.95	193857	2276923	48.43999862670898
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	1741.1	1722.2	1732	1695.4	1715	4310209	73892.75	254813	2500420	58.0099983215332
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	1715	1710	1725	1696	1717.3	6053401	103638.06	222044	4052016	66.94000244140625
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	1717.3	1735	1743	1725	1737.3	3867244	67139	178730	2358994	61
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	1769.6	1740	1745.95	1713	1721.35	7551371	129935.28	430200	5283038	69.95999908447266
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	1737.3	1755.65	1773.9	1748.75	1769.6	4334630	76313.32	206904	2830975	65.30999755859375
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	1787.1	1779	1779	1734	1738.55	3832922	67273.67	183506	2209861	57.650001525878906
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	731.15	735	740	732.55	736.85	2112415	15533.69	36769	561646	26.59
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	736.85	738.9	740.8	730.9	734.7	5658200	41600.25	102483	3413440	60.33
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INFY	734.7	733.9	748	733.9	746	7882938	58701.73	105632	3682521	46.72


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