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)	CDSL	1565.85	1575.9	1586	1552.1	1573.95	547485	8600.66	28621	301945	55.150001525878906
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CDSL	1573.95	1525	1538	1500	1514.95	835445	12680.06	64579	432137	51.72999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CDSL	1514.95	1522.6	1533.3	1482.25	1504.35	432963	6512.66	35140	208856	48.2400016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CDSL	1504.35	1520.05	1547	1506.25	1510.85	822933	12544.53	55439	328123	39.869998931884766
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CDSL	1522.8	1516	1541	1510	1519.55	591928	9033.19	35371	297921	50.33000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CDSL	1510.85	1517	1538	1512.25	1522.8	486801	7425.98	28310	238395	48.970001220703125
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CDSL	1530.95	1538.65	1594.9	1532	1565.85	932210	14633.92	53223	403628	43.29999923706055
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CDSL	222.7	223.5	225	221	221.8	207544	463.56	3434	109700	52.86
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CDSL	221.8	222.7	259	222.25	252.5	7326527	17954.47	74536	2047118	27.94
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CDSL	252.5	252.5	257.4	242.3	248.2	2124843	5312.56	27992	588249	27.68


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