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)	JAMNAAUTO	103.65	104.45	109.35	103.7	107.7	3486025	3717.21	30943	1119133	32.099998474121094
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JAMNAAUTO	107.7	108.6	109.8	105.1	105.65	1243932	1330.99	14458	373188	30
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JAMNAAUTO	105.65	106.5	106.9	103	104.55	663516	693.58	7323	207045	31.200000762939453
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JAMNAAUTO	104.55	105.5	108.3	104.7	107.3	1203744	1287.66	10122	348743	28.96999931335449
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JAMNAAUTO	109.35	107.45	108.4	106	106.9	876261	937.73	12109	286542	32.70000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JAMNAAUTO	107.3	107.8	111.7	104.7	109.35	2174539	2366.17	23423	564706	25.96999931335449
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JAMNAAUTO	104.8	105	106.05	103.45	103.65	1409493	1473.76	13517	658003	46.68000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JAMNAAUTO	46.6	46.4	47.4	46.2	46.65	328198	153.16	2270	120764	36.8
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JAMNAAUTO	46.65	46.4	48.65	46.4	47.3	2396253	1146.12	8515	1152092	48.08
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JAMNAAUTO	47.3	47.2	47.75	46.4	46.6	803317	377.91	4820	339199	42.22


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