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)	GLAXO	1549.75	1564	1580	1545	1573.2	37352	585.07	5866	20296	54.34000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAXO	1573.2	1588	1594	1568.8	1580.5	99846	1576.24	3905	87702	87.83999633789062
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAXO	1580.5	1553	1571.1	1535.5	1550.3	92176	1426.84	10075	61877	67.12999725341797
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAXO	1550.3	1567	1574.5	1532.5	1537.75	111577	1746.87	6278	92633	83.0199966430664
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAXO	1562.95	1555	1578.95	1554.25	1569.55	63179	991.4	9583	47648	75.41999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAXO	1537.75	1558	1567.3	1533.7	1562.95	38776	602.7	4527	20162	52
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAXO	1571.45	1587.95	1590	1542	1549.75	45364	708.84	9901	21807	48.06999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAXO	1610.3	1626	1651.5	1614.1	1631.85	174481	2830.47	3000	155690	89.23
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAXO	1631.85	1645	1645.65	1615.35	1624.45	43839	711.94	3175	27877	63.59
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAXO	1624.45	1624	1630	1602	1611.1	50214	809.12	2369	35343	70.38


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