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)	JBCHEPHARM	1824.65	1816	1849	1740	1760.3	85382	1538.87	11181	56024	65.62000274658203
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JBCHEPHARM	1760.3	1786.5	1786.5	1720.3	1732.35	48474	840.11	8017	27690	57.119998931884766
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JBCHEPHARM	1732.35	1735	1790.7	1706	1759.45	108232	1906.3	12092	54056	49.93999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JBCHEPHARM	1759.45	1768.65	1791.35	1752.15	1762.65	28828	510.34	6391	13781	47.79999923706055
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JBCHEPHARM	1758.55	1745	1785	1695	1705.75	59339	1032.46	9078	32463	54.709999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JBCHEPHARM	1762.65	1746.6	1768.75	1745	1758.55	46535	816.53	4275	36366	78.1500015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JBCHEPHARM	1842.75	1848	1854.9	1810	1824.65	114215	2089.69	11286	83061	72.72000122070312
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JBCHEPHARM	425.65	425	431.5	425	429.5	37648	161.51	1352	25781	68.48
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JBCHEPHARM	429.5	431.45	436.45	430.1	433.55	47665	206.34	2023	27876	58.48
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JBCHEPHARM	433.55	434.4	440	430.05	438.9	63567	277.67	3272	30693	48.28


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