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)	INDIAMART	5182.9	5164.9	5195	5060	5080.15	117853	6017.18	19870	23424	19.8799991607666
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIAMART	5080.15	5097	5139.95	4990	5037.35	134552	6775.29	21658	43521	32.349998474121094
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIAMART	5037.35	5054	5125	4991.65	5002.6	122836	6173.87	15715	40927	33.31999969482422
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIAMART	5002.6	5048.4	5252.65	5032.55	5124.85	195175	10102.3	27280	26808	13.739999771118164
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIAMART	5139	5060.05	5099.9	4992.9	5046	146303	7360.87	17849	40541	27.709999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIAMART	5124.85	5130	5249.9	5035.4	5139	109870	5637.2	16753	20670	18.809999465942383
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIAMART	5273.25	5273.25	5273.25	5115	5182.9	155302	8040.54	25356	25644	16.510000228881836
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIAMART	2065.95	2070	2080	2045	2058.65	6972	143.73	837	3299	47.32
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIAMART	2058.65	2063	2072.9	2037.95	2047.5	13594	278.63	1369	8966	65.96
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIAMART	2047.5	2047.55	2143.95	2043.05	2076.9	54320	1139.79	5858	17497	32.21


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