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)	MAZDOCK	267.6	269.7	273.5	265	265.45	169649	456.2	5143	78849	46.47999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAZDOCK	265.45	265.45	269	264	267.2	104210	277.38	3695	32662	31.34000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAZDOCK	267.2	269	269	262.35	265.05	109225	289.43	4332	33494	30.670000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAZDOCK	265.05	265.8	271.95	263	264.85	97162	258.29	3022	36091	37.150001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAZDOCK	266.7	265.6	267.9	261.1	262.4	92106	243.78	2990	36879	40.040000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAZDOCK	264.85	266.4	270.5	264.2	266.7	118820	317.7	3720	39898	33.58000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAZDOCK	273.5	275.7	275.7	266.25	267.6	264157	714.17	6215	147066	55.66999816894531
Mon Oct 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MAZDOCK	145	214.9	216.95	171.95	171.95	39929204	74524.75	569001	18338844	45.93
Tue Oct 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MAZDOCK	171.95	172	184.7	164	181.45	18862563	33181.58	221335	3390934	17.98
Wed Oct 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MAZDOCK	181.45	180.45	187.4	178.1	182.25	6178509	11314.77	71868	1489483	24.11


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