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)	ASTRAZEN	2836.95	2849	2849	2814	2816.05	4521	127.74	1422	2457	54.34999847412109
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAZEN	2816.05	2816.05	2834.65	2775	2780.5	7226	201.64	1927	3855	53.34999847412109
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAZEN	2780.5	2794.45	2797.5	2732	2769.25	10792	298.42	2445	4392	40.70000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAZEN	2769.25	2748	2851.9	2730	2831.25	20508	574.89	3612	9946	48.5
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAZEN	2804.7	2800	2830	2784.75	2800.45	10039	281.51	1525	6160	61.36000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAZEN	2831.25	2835.6	2861.95	2800	2804.7	9237	260.35	2132	4211	45.59000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAZEN	2830.25	2839	2869.9	2830.25	2836.95	7545	214.52	1381	3793	50.27000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAZEN	2616.6	2634.8	2659.9	2616.05	2618.8	14045	369.51	2902	6522	46.44
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAZEN	2618.8	2619	2655.25	2615.05	2632.2	8590	226.35	2209	5342	62.19
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAZEN	2632.2	2634	2639.95	2555	2568.5	16517	428.37	3655	10464	63.35


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