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)	DIXON	4525.05	4550	4555.55	4456.7	4492.55	236324	10650.72	29607	62041	26.25
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DIXON	4492.55	4500	4519	4360	4397.25	234439	10352.76	35098	87183	37.18999862670898
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DIXON	4397.25	4421.8	4444	4258	4312.85	339528	14660.59	43972	141808	41.77000045776367
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DIXON	4312.85	4350	4499	4325.65	4485	268806	11931.28	33738	80205	29.84000015258789
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DIXON	4499.55	4474	4474	4350	4364.55	247863	10874.9	32022	94139	37.97999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DIXON	4485	4500	4538	4448.4	4499.55	156483	7029.04	21038	47971	30.65999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DIXON	4628.4	4656	4659	4500	4525.05	275028	12558.18	38410	97297	35.380001068115234
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DIXON	3799.3	3770	3839	3770	3786.55	14306	543.62	2593	4621	32.3
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DIXON	3786.55	3780	3935.1	3779	3905.7	33288	1286.21	5742	10703	32.15
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DIXON	3905.7	3911	4049	3881.85	3952.3	49637	1969.97	7384	17106	34.46


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