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)	POLYMED	887.15	888	891.6	858	863.25	35893	313.17	3506	18471	51.459999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYMED	863.25	867.6	867.6	820	829.5	86280	718.03	9763	41540	48.150001525878906
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYMED	829.5	825	834.6	737.05	764.3	270403	2074.16	26550	112976	41.77999877929688
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYMED	764.3	789.8	798	755.65	783.8	65704	508.39	9368	29613	45.06999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYMED	764	759	795	757.8	780.3	465573	3628	8410	411842	88.45999908447266
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYMED	783.8	787.75	792.45	753.3	764	74781	571.85	9855	35094	46.93000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYMED	901.45	908	908.1	882.05	887.15	20777	184.88	2995	10165	48.91999816894531
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYMED	218.05	218	218.25	214.75	217.35	32977	71.43	730	21250	64.44
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYMED	217.35	219	219	210	213.45	19241	41.15	667	14702	76.41
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYMED	213.45	215.15	217.5	213.95	215.9	41224	88.73	471	35075	85.08


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