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)	VGUARD	215	216.1	216.75	214.4	214.75	135113	290.98	3497	67445	49.91999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VGUARD	214.75	220	224.55	217.6	222.65	902150	1994.69	17347	472448	52.369998931884766
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VGUARD	222.65	225.45	225.5	217	218	360555	795.71	10390	172530	47.84999847412109
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VGUARD	218	219.6	220	217.5	219.5	197639	432.83	6311	104558	52.900001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VGUARD	219.75	218.85	218.9	216.1	216.8	181182	393.01	5265	115604	63.810001373291016
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VGUARD	219.5	221.15	221.15	216.1	219.75	230925	504.81	6920	111560	48.310001373291016
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VGUARD	217.5	215.5	216.9	214.35	215	209724	451.03	4477	108769	51.86000061035156
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VGUARD	212.6	212.1	213.5	212	212.65	68794	146.45	2212	35874	52.15
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VGUARD	212.65	213.45	216.8	212.65	215.55	242587	521.66	6108	159770	65.86
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VGUARD	215.55	215	219.1	215	215.9	178878	387.94	5455	95682	53.49


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