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)	AEGISCHEM	221.1	221.35	230.5	217.95	228.2	1225148	2772.98	23932	525677	42.90999984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AEGISCHEM	228.2	226.5	226.8	215.2	216.55	640662	1414.98	11326	350767	54.75
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AEGISCHEM	216.55	217.95	218.25	209	213.55	430830	916.71	8891	161895	37.58000183105469
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AEGISCHEM	213.55	214	216.3	207.1	209.4	464848	982.27	15131	281486	60.54999923706055
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AEGISCHEM	213.25	216.45	221.5	215	216.5	3192772	6953.64	36929	2082131	65.20999908447266
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AEGISCHEM	209.4	210.25	217.4	206.7	213.25	523123	1104.71	11651	223852	42.790000915527344
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AEGISCHEM	214.65	217.5	223.7	213	221.1	758746	1659.15	14386	326121	42.97999954223633
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AEGISCHEM	193.45	193.9	199	192.85	196.25	141773	278.64	4945	67584	47.67
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AEGISCHEM	196.25	196	201	193.2	198.45	154614	304.4	2596	86727	56.09
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AEGISCHEM	198.45	197.95	202	190	192.75	125409	247.3	4104	73640	58.72


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