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)	ALKYLAMINE	3117.6	3095	3150	3060	3102.5	129652	4023.05	21370	46850	36.13999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKYLAMINE	3102.5	3160	3170	3066	3104.1	60719	1888.23	11756	26953	44.38999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKYLAMINE	3104.1	3128.45	3149.95	3067.15	3110.35	37611	1169.66	8031	13133	34.91999816894531
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKYLAMINE	3110.35	3110.35	3149.55	3085	3110.6	34552	1073.84	8093	17511	50.68000030517578
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKYLAMINE	3142.45	3113	3138	3100	3119.4	25228	786.89	6230	11292	44.7599983215332
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKYLAMINE	3110.6	3120	3198	3102.2	3142.45	59408	1873.96	10012	22992	38.70000076293945
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKYLAMINE	3211.3	3200	3200	3101.8	3117.6	194197	6095.69	34837	88576	45.61000061035156
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKYLAMINE	1085	1101	1134.75	1087.8	1100.4	24274	270.19	2114	15844	65.27
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKYLAMINE	1100.4	1118.6	1199	1105.15	1164.2	43331	500.22	4285	22220	51.28
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ALKYLAMINE	1164.2	1173.55	1198.3	1152.65	1163.1	24076	283.63	2419	15238	63.29


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