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)	LAXMIMACH	10845.6	10705	11047.9	10705	10835	8309	902.25	3218	2336	28.11000061035156
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAXMIMACH	10835	10900	11400	10820.75	11171.2	25780	2862.34	8745	7300	28.31999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAXMIMACH	11171.2	11220	11290	10856.15	11076.6	14918	1645.65	5302	5555	37.2400016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAXMIMACH	11076.6	11100	11770	11049.8	11691.95	33681	3869.5	8196	13242	39.31999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAXMIMACH	11177.85	11000	11099.95	10891.5	10944.65	7183	788.49	2629	2225	30.979999542236328
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAXMIMACH	11691.95	11770	11790	11105.1	11177.85	16768	1904.69	5601	5583	33.29999923706055
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAXMIMACH	11133.3	11000	11224	10795	10845.6	4248	465.8	2150	1696	39.91999816894531
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LAXMIMACH	3290.15	3323.9	3323.9	3250	3294.9	8390	275.57	972	6644	79.19
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LAXMIMACH	3294.9	3294.9	3345	3294.9	3320.85	4978	165.42	1062	3542	71.15
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LAXMIMACH	3320.85	3331.15	3425	3300	3340.6	11895	397.78	1412	8283	69.63


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