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)	STLTECH	214.25	215.6	221.85	213	216.05	2273345	4944.81	30089	995193	43.77999877929688
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STLTECH	216.05	216.8	218.55	209.55	210.95	993769	2121.2	13785	446220	44.900001525878906
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STLTECH	210.95	210	215.7	203.6	205.45	1066516	2214.47	16035	423553	39.709999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STLTECH	205.45	206	207.7	204.5	205.95	690722	1422.66	11920	349374	50.58000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STLTECH	216.45	214	214.75	208.8	209.85	838605	1769.5	14839	408320	48.68999862670898
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STLTECH	205.95	207.75	221	205.25	216.45	2434886	5264.14	31117	686892	28.209999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STLTECH	210.65	211	219.7	209	214.25	5656347	12042.84	37591	3436424	60.75
Thu Oct 29 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	STLTECH	151.3	150.15	151	147.8	148.3	236782	353.17	3242	124041	52.39
Fri Oct 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	STLTECH	148.3	149.9	150.9	146.1	147.35	312245	462.95	5145	141029	45.17
Mon Nov 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	STLTECH	147.35	146.25	148.05	143	144.75	540952	784.58	14072	328834	60.79


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