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)	ADANIGREEN	1912.55	1912.55	1958.5	1902.45	1950.35	296479	5743.93	19851	146267	49.33000183105469
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIGREEN	1950.35	1970	2051.2	1966.05	2024.65	470440	9496.85	37759	217590	46.25
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIGREEN	2024.65	2035	2050	1856	1928	561637	10986.57	45147	279929	49.84000015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIGREEN	1928	1932.2	1941.5	1891.55	1919.8	348096	6680.7	21650	162802	46.77000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIGREEN	1907.95	1915.6	1917.35	1875	1907.6	397431	7551.82	33549	280775	70.6500015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIGREEN	1919.8	1929	1945	1888	1907.95	555955	10635.8	44573	323249	58.13999938964844
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIGREEN	1916.3	1915	1925	1881	1912.55	242268	4627.89	14208	135367	55.869998931884766
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIGREEN	166.45	169.35	174.75	168.1	174.75	5417952	9395.12	35158	1451570	26.79
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIGREEN	174.75	179.15	183.45	177.55	183.45	3087009	5593.24	23173	1096256	35.51
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIGREEN	183.45	187.8	192.6	183	192.6	3670040	6996.43	23947	924520	25.19


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