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)	SANOFI	7505.35	7505	7505	7350	7457.8	6791	503.64	2144	2867	42.220001220703125
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SANOFI	7457.8	7500	7538	7390	7419.3	2998	222.43	1492	1725	57.540000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SANOFI	7419.3	7395	7541.05	7311.3	7326.85	3175	233.82	1311	1587	49.97999954223633
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SANOFI	7326.85	7365.4	7399.95	7300	7381.3	4616	339.11	890	3056	66.19999694824219
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SANOFI	7296.65	7370	7370	7231.35	7257.15	5542	403.02	1688	3592	64.80999755859375
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SANOFI	7381.3	7391.05	7420.1	7283.05	7296.65	5093	373.12	1469	3578	70.25
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SANOFI	7528.4	7528	7534.75	7473.2	7505.35	2873	215.61	1162	1603	55.79999923706055
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SANOFI	7006	7025.85	7040.3	6985	7014.4	1706	119.46	348	1448	84.88
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SANOFI	7014.4	7014	7014	6955	6989.6	2241	156.68	1024	1665	74.3
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SANOFI	6989.6	7005.8	7005.8	6876	6899.55	4102	283.51	1038	2680	65.33


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