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)	ADANIENT	1751.85	1758	1770	1733.7	1757.3	855996	15026.69	22314	162686	19.01000022888184
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIENT	1757.3	1765	1765.5	1722.1	1731.8	854871	14912.63	27482	122732	14.359999656677246
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIENT	1731.8	1739.4	1747	1677.05	1716	1480201	25406.6	38936	326424	22.049999237060547
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIENT	1716	1724.6	1791.9	1718.1	1783.15	1674022	29576.92	44563	315114	18.81999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIENT	1786.1	1764	1774.9	1743.35	1764.3	1196002	21057.68	34655	331716	27.739999771118164
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIENT	1783.15	1799	1809	1766	1786.1	1747943	31269.21	44387	396828	22.700000762939453
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIENT	1779.35	1771.95	1787	1746.4	1751.85	588866	10410.16	19672	113916	19.34000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIENT	208.35	209	210.45	206.65	207.85	1553127	3233.77	10641	238996	15.39
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIENT	207.85	208	213.2	207.5	211.2	2991937	6305.94	19649	497418	16.63
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIENT	211.2	210.25	212.35	205.8	208.3	2512421	5246.74	14792	497223	19.79


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