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)	ZYDUSWELL	1681.9	1695.7	1695.7	1661.55	1672.55	59197	990.89	7631	42195	71.27999877929688
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZYDUSWELL	1672.55	1670	1685.55	1644.95	1656.55	45446	756.26	4640	32791	72.1500015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZYDUSWELL	1656.55	1671.5	1747.95	1636.55	1647.45	58918	977.02	10774	36978	62.7599983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZYDUSWELL	1647.45	1656.35	1659.95	1617.55	1622.65	45970	747.78	6413	32456	70.5999984741211
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZYDUSWELL	1567.9	1567.5	1567.5	1481	1496.2	166228	2508.27	25371	110756	66.62999725341797
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZYDUSWELL	1622.65	1620	1634.95	1549.2	1567.9	410760	6519.05	18453	358081	87.18000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ZYDUSWELL	1702.35	1727.9	1730	1675	1681.9	102484	1741.6	11212	67400	65.7699966430664
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ZYDUSWELL	1470.3	1462	1479.95	1462	1465.95	1118	16.42	301	617	55.19
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ZYDUSWELL	1465.95	1467	1498	1462.05	1473.8	3210	47.44	629	1765	54.98
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ZYDUSWELL	1473.8	1463.55	1493.95	1443	1449.05	6749	98.78	1289	3319	49.18


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