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)	CESC	84.4	84.65	85	82.8	83	1910006	1596.77	18911	1280861	67.05999755859375
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CESC	83	83	84.75	82.8	83.15	2190788	1837.19	19720	1366936	62.38999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CESC	83.15	83.8	84.25	82.6	83.25	4396198	3658.48	38762	1295316	29.459999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CESC	83.25	83.25	84.5	83.2	84.25	1272811	1068.37	12407	754399	59.27000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CESC	83.7	83.5	84.8	82.95	83.65	1544790	1296.07	14685	808626	52.34999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CESC	84.25	84.6	85.1	83.5	83.7	1487730	1248.66	17843	802178	53.91999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CESC	85.1	85.35	85.5	84.1	84.4	909433	771.16	11920	586600	64.5
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CESC	736.8	741.1	749.45	738.1	746.8	240137	1783.7	4537	86271	35.93
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CESC	746.8	750	760.3	746.4	754.95	755454	5687.41	19268	106716	14.13
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CESC	754.95	753	755.25	738.85	742.15	201435	1503.92	11857	26876	13.34


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