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)	ENDURANCE	1594.25	1600	1609.65	1580	1586	19023	302.84	3582	8555	44.970001220703125
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ENDURANCE	1586	1591.7	1599.95	1570	1573.7	12327	194.71	3469	5758	46.709999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ENDURANCE	1573.7	1577.9	1584.05	1525	1546.25	73157	1130.66	10316	48477	66.26000213623047
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ENDURANCE	1546.25	1472	1480	1421.1	1462.15	567076	8251.64	49006	399658	70.4800033569336
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ENDURANCE	1466.5	1455	1462.4	1415.1	1423.4	72749	1040.95	11934	39331	54.060001373291016
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ENDURANCE	1462.15	1465	1484.05	1423.8	1466.5	89592	1314.05	11649	59645	66.56999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ENDURANCE	1629.35	1629.35	1637.5	1586	1594.25	28690	458.96	4477	17252	60.130001068115234
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ENDURANCE	1081.3	1075.9	1094.8	1066	1087.6	5112	55.39	680	2276	44.52
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ENDURANCE	1087.6	1104	1104	1068.2	1072.6	6614	71.32	1315	4650	70.31
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ENDURANCE	1072.6	1072.8	1098.7	1051.1	1056.8	13655	145.73	2439	6930	50.75


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