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)	VOLTAS	1220.3	1220.35	1245	1218.85	1234.7	712330	8797.16	23953	213388	29.959999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VOLTAS	1234.7	1234.8	1239.85	1213.4	1224.2	280046	3433.75	18684	83653	29.8700008392334
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VOLTAS	1224.2	1222.1	1247.85	1190	1198.75	1207465	14697.13	37145	491379	40.70000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VOLTAS	1198.75	1202.4	1236.05	1200.9	1224.05	695568	8473.44	36899	307998	44.27999877929688
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VOLTAS	1238.75	1228	1228	1182.95	1192.3	816198	9774.27	42385	308734	37.83000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VOLTAS	1224.05	1223.05	1242.65	1213.8	1238.75	379632	4678.24	15880	106062	27.940000534057617
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VOLTAS	1214.7	1219.5	1230.9	1204.15	1220.3	628333	7656.25	27161	153323	24.39999961853028
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VOLTAS	659.3	659.3	663	651.35	653.3	820283	5389.27	16577	274447	33.46
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VOLTAS	653.3	654.95	660.85	647.6	659.55	1167011	7618.37	17041	577810	49.51
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VOLTAS	659.55	657.95	665	656.05	663.7	1224987	8100.39	23477	509709	41.61


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