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)	VARROC	428	429	433	411.25	414.7	218375	918.27	7728	97124	44.47999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VARROC	414.7	419	422	408.2	420.2	246870	1026.13	7226	124846	50.56999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VARROC	420.2	421	423.45	405.2	417.5	163835	679.8	7659	58096	35.459999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VARROC	417.5	420	426	397.55	408.45	155089	642.1	5472	78044	50.31999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VARROC	415.4	415	421	392.8	400.2	199337	814.4	7149	94154	47.22999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VARROC	408.45	408.5	417.1	406.1	415.4	168651	695.57	5960	64795	38.41999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VARROC	422.15	429.5	433.5	421.45	428	515715	2207.43	19127	195561	37.91999816894531
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VARROC	418	416.3	418.95	411	414.6	36499	151.18	2292	21224	58.15
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VARROC	414.6	420	429.95	415.1	424.7	287410	1219.87	11952	262226	91.24
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VARROC	424.7	422.7	454	422.05	440.8	214619	955.68	6697	112426	52.38


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