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)	VENKEYS	2629.75	2630	2657	2375	2398.8	473857	11535.65	55542	113948	24.049999237060547
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VENKEYS	2398.8	2380	2425.55	2250	2280.3	159662	3721.03	17878	55964	35.04999923706055
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VENKEYS	2280.3	2298	2319.25	2231	2253.95	70590	1597.53	9881	20232	28.65999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VENKEYS	2253.95	2269.5	2284.95	2230.05	2242.95	44030	994.36	6215	16530	37.540000915527344
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VENKEYS	2198.15	2198	2221.75	2176.35	2186.25	56292	1239.55	8671	16628	29.540000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VENKEYS	2242.95	2249	2273.2	2188	2198.15	62622	1384.9	7925	29431	47
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VENKEYS	2618.75	2631	2683	2612	2629.75	47890	1263.87	6950	14092	29.43000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VENKEYS	1760.25	1768.95	1818	1765	1783.25	331378	5951	19584	44204	13.34
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VENKEYS	1783.25	1792.75	1813	1785	1791.3	161955	2913.37	8920	30370	18.75
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VENKEYS	1791.3	1787.6	1787.6	1758.2	1765.6	75133	1329.68	6088	26632	35.45


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