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)	MARUTI	8593.65	8639.9	8680	8492.1	8550.55	404421	34595.06	53568	139754	34.560001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	8550.55	8545	8615	8400	8511.65	446099	37835.91	69565	118693	26.61000061035156
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	8511.65	8616.7	8789.1	8436.05	8599.45	998182	85905.74	111099	271811	27.229999542236328
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	8599.45	8622	8989.8	8622	8949.45	1403525	124521.47	138958	552702	39.380001068115234
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	8805.45	8738	8865	8673.3	8737.15	671572	58940.41	77804	229313	34.150001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	8949.45	9050	9050	8789.9	8805.45	811887	71959.27	96059	341625	42.08000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	8515.25	8550	8798	8522.7	8593.65	810019	70308.27	110587	145605	17.979999542236328
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	7368.6	7377	7409.95	7282.05	7311.7	634725	46583.07	42182	94094	14.82
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	7311.7	7327.6	7368	7312	7329.85	616838	45271.74	51801	173302	28.1
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MARUTI	7329.85	7328.95	7332	7226	7254.25	571967	41614.07	42037	152281	26.62


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