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)	RATNAMANI	1991.05	2000	2050	2000	2040.7	27516	560.53	5897	9302	33.810001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RATNAMANI	2040.7	2089	2218	2066.4	2122.6	103515	2233.89	16154	27073	26.149999618530277
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RATNAMANI	2122.6	2110	2201	2084.4	2184.95	17147	368.29	3417	8075	47.09000015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RATNAMANI	2184.95	2224	2240.1	2142.05	2179.55	12631	275.7	2731	6185	48.970001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RATNAMANI	2235.4	2228	2228	2105	2136	9134	197.88	2343	4156	45.5
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RATNAMANI	2179.55	2190.45	2263	2161.7	2235.4	26916	594.55	2327	12729	47.290000915527344
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RATNAMANI	1975	1984	1999	1975	1991.05	4722	93.92	824	2897	61.34999847412109
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RATNAMANI	1093.9	1098	1104.05	1055	1071.7	32003	343.08	2261	7421	23.19
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RATNAMANI	1071.7	1072.9	1104	1062.65	1096.9	36059	390.05	1488	9703	26.91
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RATNAMANI	1096.9	1096.9	1132.8	1096	1104.05	39499	440.84	3012	18475	46.77


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