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)	CAPLIPOINT	829.65	826.05	831.95	800.45	805.55	63024	513.98	5251	26785	42.5
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CAPLIPOINT	805.55	810	817.6	787	801.35	70844	565.51	5960	28635	40.41999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CAPLIPOINT	801.35	802	808.05	787	790.4	55375	439.94	5746	23223	41.93999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CAPLIPOINT	790.4	796	801	775	782.15	53910	425.33	4131	24149	44.79999923706055
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CAPLIPOINT	799.4	795	805	775	782.45	61001	483.71	6287	22076	36.18999862670898
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CAPLIPOINT	782.15	782.15	805.4	779.05	799.4	68059	538.07	5286	25892	38.040000915527344
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CAPLIPOINT	825.7	833.65	846	811	829.65	275012	2300.44	20015	49339	17.940000534057617
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CAPLIPOINT	300.85	304.9	305.05	294	294.6	65188	192.95	3965	46624	71.52
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CAPLIPOINT	294.6	299.95	299.95	294	295.35	53868	159.4	5918	37671	69.93
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CAPLIPOINT	295.35	299.9	299.9	294.4	296.8	68488	203.07	4092	34150	49.86


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