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)	ADANIPORTS	732.5	735	741.15	724	726.95	2453595	17950.02	52953	560441	22.84000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIPORTS	726.95	728.8	729.9	713.35	715.15	2610637	18809.86	52490	548527	21.01000022888184
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIPORTS	715.15	719	723	703	717.8	3207780	22913.15	65830	612589	19.100000381469727
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIPORTS	717.8	722	735.4	719.05	733.45	3186942	23267.58	64251	841284	26.399999618530277
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIPORTS	731.05	727.9	733.9	719.45	723.7	3621116	26281.94	60339	1031506	28.489999771118164
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIPORTS	733.45	736.9	741.55	728.05	731.05	4752601	34903.11	78316	1954413	41.119998931884766
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIPORTS	745.2	744.05	745	729.4	732.5	2689612	19833.6	48154	865684	32.189998626708984
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIPORTS	366	368	379.25	366	377.65	11377167	42744.59	89107	1155555	10.16
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIPORTS	377.65	377.95	384.7	376.5	383.15	5919760	22593.37	54749	1072204	18.11
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANIPORTS	383.15	382.7	384.35	379.2	382.5	3684824	14076.36	41829	1082913	29.39


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