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)	EIDPARRY	487.35	490	498	485.3	488.1	257881	1267.75	11150	88802	34.439998626708984
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EIDPARRY	488.1	489.9	504.95	487.05	494.9	344294	1709.08	13594	91857	26.68000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EIDPARRY	494.9	494.9	496.9	471.5	477.5	215398	1036.38	11226	72126	33.47999954223633
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EIDPARRY	477.5	483.1	485	468	480.4	238803	1140.42	9477	67914	28.440000534057617
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EIDPARRY	470.4	465	467.5	452.3	454.35	268077	1231.27	11265	142754	53.25
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EIDPARRY	480.4	481.9	485.4	469	470.4	307898	1469.63	14201	181038	58.79999923706055
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EIDPARRY	472.3	472.65	495.25	469.4	487.35	362764	1762.8	13371	100002	27.56999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EIDPARRY	201.55	202.3	212.8	201.65	208.35	1338877	2800.64	14379	407780	30.46
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EIDPARRY	208.35	211	225	211	223.35	1674181	3684.53	20619	642030	38.35
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EIDPARRY	223.35	224	230.8	219.4	228.8	648588	1473.92	11696	236923	36.53


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