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)	SUNDARMFIN	2262.35	2254.9	2258.05	2216.5	2250.05	17196	385.95	2037	10703	62.2400016784668
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDARMFIN	2250.05	2285	2317.65	2211	2288.95	56193	1268.32	9830	12813	22.799999237060547
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDARMFIN	2288.95	2261	2275.95	2200	2228.05	31030	690.11	4946	19906	64.1500015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDARMFIN	2228.05	2231	2256.55	2210	2232.6	6211	138.85	1490	3172	51.06999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDARMFIN	2219.25	2219.25	2222.95	2185.8	2201.9	23696	521.61	3297	13271	56.0099983215332
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDARMFIN	2232.6	2252.75	2252.75	2210.05	2219.25	7458	166.04	1326	4801	64.37000274658203
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDARMFIN	2266.15	2268	2277.75	2222	2262.35	18540	418.55	3715	8411	45.369998931884766
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDARMFIN	1630.8	1647.95	1651.65	1624.05	1643.7	4504	73.78	410	2749	61.03
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDARMFIN	1643.7	1625	1655	1625	1641.7	7396	121.33	687	3525	47.66
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDARMFIN	1641.7	1638.35	1663.25	1632.4	1655.4	16999	280.92	1553	10943	64.37


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