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)	VBL	945.7	946	954.25	927.05	950.2	327150	3083.95	16617	170145	52.0099983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VBL	950.2	950.2	957.65	926.4	941.45	255876	2408.47	19094	132384	51.7400016784668
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VBL	941.45	941.05	953.2	940	945.65	435785	4130.27	21464	318591	73.11000061035156
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VBL	945.65	951	951	914.6	927.2	385245	3562.62	20367	216703	56.25
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VBL	891.35	896	940.9	891.35	936.5	693127	6406.77	29181	429271	61.93000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VBL	927.2	927.2	927.5	886.3	891.35	769298	6885.14	59235	468319	60.880001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VBL	940.65	932	948.85	910.1	945.7	1106746	10312.31	46154	557566	50.380001068115234
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VBL	708.6	706	713.55	698	699.2	75101	527.34	3510	42741	56.91
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VBL	699.2	702.65	711.4	698.85	706.1	102604	725.97	6163	76513	74.57
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VBL	706.1	704.1	709.5	699.1	702.4	90903	639.6	8559	61821	68.01


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