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)	SIEMENS	2438.4	2441	2465	2410.25	2422.8	161131	3929.23	14631	49718	30.86000061035156
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SIEMENS	2422.8	2385	2429.8	2350	2415.8	550531	13165.36	37425	222145	40.34999847412109
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SIEMENS	2415.8	2424.25	2498	2354	2363.65	992812	24118.07	75756	184022	18.540000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SIEMENS	2363.65	2363.65	2426.15	2363.65	2417.4	187312	4502.4	17904	53882	28.770000457763672
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SIEMENS	2442.4	2425	2430	2392.65	2401.8	159111	3838.59	30529	76000	47.77000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SIEMENS	2417.4	2421.15	2449.5	2395.1	2442.4	184030	4473.05	23871	74696	40.59000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SIEMENS	2439.05	2435	2459.35	2400	2438.4	199336	4873.77	18712	51916	26.040000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SIEMENS	1496.7	1496.7	1507.9	1487.1	1491.25	158161	2364.67	9173	22365	14.14
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SIEMENS	1491.25	1499	1518.9	1485.6	1513.7	338340	5078.9	13781	82279	24.32
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SIEMENS	1513.7	1516	1517.5	1492.65	1511.15	318700	4800.23	22062	127777	40.09


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