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)	CHOLAHLDNG	694.45	691.4	698.65	684.5	696.4	78920	544.27	5349	64074	81.19000244140625
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAHLDNG	696.4	712	713.9	669.9	677	80202	550.71	5484	40135	50.040000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAHLDNG	677	675	687.45	662.15	671.6	183485	1227.03	3140	159857	87.12000274658203
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAHLDNG	671.6	676.15	689	676.15	681.75	52287	357.2	3034	31955	61.11000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAHLDNG	679.95	678.25	686.85	665	673.95	19417	131.17	1627	12631	65.05000305175781
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAHLDNG	681.75	694.9	694.9	676.85	679.95	36377	248.32	2293	19000	52.22999954223633
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAHLDNG	692.35	700	700	689.05	694.45	34960	243.12	5355	16975	48.560001373291016
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAHLDNG	499.65	490	509	485.55	503.15	45914	229.49	1355	37056	80.71
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAHLDNG	503.15	510	516	498	507.3	1235635	6348.3	2418	1204092	97.45
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAHLDNG	507.3	504.5	519.8	501.1	514.55	135017	694.13	2041	120153	88.99


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