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)	NATCOPHARM	911.7	902	925.75	902	911.1	75693	692.11	4410	28994	38.29999923706055
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NATCOPHARM	911.1	910.65	917.9	895.1	906.75	84999	771.98	4737	41861	49.25
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NATCOPHARM	906.75	903.3	919	900.8	910.7	91115	828.69	3720	40013	43.90999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NATCOPHARM	910.7	906.6	924	906.6	920.85	93019	855.1	4439	46047	49.5
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NATCOPHARM	921.1	920	926.6	912.7	922.65	72201	665.57	3189	39383	54.54999923706055
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NATCOPHARM	920.85	923	925.5	912.3	921.1	96886	889.58	5217	59040	60.93999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NATCOPHARM	919.55	922	924.15	909.7	911.7	61338	560.71	3243	28243	46.040000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NATCOPHARM	593.45	595.9	634.8	594.95	618.3	778947	4830.47	22573	182978	23.49
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NATCOPHARM	618.3	619	632.35	617.2	620.85	349602	2181.67	14899	171800	49.14
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NATCOPHARM	620.85	617.85	617.85	605	608	156810	957.27	5904	50652	32.3


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