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)	BAYERCROP	4985	5000	5000	4830	4848.05	12957	634.08	3481	8995	69.41999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAYERCROP	4848.05	4880	4880	4670	4683.7	22842	1077.28	6545	13510	59.150001525878906
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAYERCROP	4683.7	4685	4725	4669.6	4698.05	5774	270.94	1757	2588	44.81999969482422
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAYERCROP	4698.05	4698.15	4729.55	4634.55	4663	29870	1393.66	2244	26667	89.27999877929688
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAYERCROP	4609.5	4612	4629.95	4535.15	4562.1	14732	673.79	3040	9572	64.97000122070312
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAYERCROP	4663	4680	4700	4591	4609.5	74730	3457.02	3168	69424	92.9000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAYERCROP	5034.25	5039.95	5050.45	4976	4985	6456	323.27	1606	4340	67.22000122070312
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAYERCROP	3562.8	3574.95	3635	3574.95	3618.1	2603	94.22	1465	1680	64.54
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAYERCROP	3618.1	3614.3	3649	3591	3639.05	20305	738.72	1112	19520	96.13
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAYERCROP	3639.05	3632	3790.95	3624.15	3743.55	64408	2367.66	3362	57557	89.36


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