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)	DMART	4140	4140	4140.2	4075	4081.9	299981	12299.96	48901	162025	54.0099983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DMART	4081.9	4090	4146.8	4045.2	4073.55	288091	11794.75	42750	133514	46.34000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DMART	4073.55	4098.9	4128.95	3995	4015	456874	18508.31	68449	268512	58.77000045776367
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DMART	4015	4078.7	4078.7	3983	4002.1	380364	15274.66	63079	171157	45
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DMART	4162.7	4138	4157	4080.1	4142.25	336884	13905.28	46982	122323	36.310001373291016
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DMART	4002.1	4034.1	4182	4001	4162.7	699250	28817.81	78452	285228	40.790000915527344
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DMART	4236.65	4231.05	4235	4122.35	4140	337719	14052.37	58828	173940	51.5
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DMART	1838.35	1849.7	1867	1820	1828.5	429407	7909.88	18482	140343	32.68
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DMART	1828.5	1831	1854.85	1815	1824.2	459356	8427.26	26025	182999	39.84
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DMART	1824.2	1827	1853	1827	1843.55	394268	7261.46	26515	132906	33.71


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