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)	VAIBHAVGBL	449.2	451	468	448.25	460.65	236658	1090.65	12953	116106	49.060001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VAIBHAVGBL	460.65	469	469	452	460.5	174944	810.19	10472	98669	56.400001525878906
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VAIBHAVGBL	460.5	460.95	460.95	447.05	452.8	112998	510.61	8683	51987	46.0099983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VAIBHAVGBL	452.8	453.8	458.25	447.05	450.65	69042	310.86	6412	40981	59.36000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VAIBHAVGBL	441.35	445.35	447	435.05	444.05	116081	511.74	8760	55617	47.90999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VAIBHAVGBL	450.65	454.4	454.65	439.05	441.35	125194	558.43	11305	77969	62.27999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VAIBHAVGBL	451.55	457	457	445.65	449.2	178138	802.72	10253	98811	55.470001220703125
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VAIBHAVGBL	826.05	815.05	852	815.05	849.7	14393	121.54	576	12459	86.56
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VAIBHAVGBL	849.7	866.9	866.9	841.05	853.1	2402	20.43	269	1728	71.94
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VAIBHAVGBL	853.1	849.95	857	849.5	851.35	6862	58.45	448	6002	87.47


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