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)	ABB	2305.8	2305	2365	2280	2335.4	203322	4741.39	16937	62444	30.709999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABB	2335.4	2344	2344.5	2223.8	2258	191104	4322.23	16873	80450	42.09999847412109
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABB	2258	2270.6	2284.95	2196	2221.25	122629	2746.72	14130	39395	32.130001068115234
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABB	2221.25	2241	2250	2211.7	2241	123789	2767.03	16468	61896	50
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABB	2238	2224	2249.9	2170.05	2179.25	242245	5356.67	36995	125414	51.77000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABB	2241	2211	2319.9	2211	2238	369714	8350.4	33005	104373	28.229999542236328
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABB	2296.7	2298	2332.95	2272.65	2305.8	161075	3709.64	20009	73947	45.90999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ABB	1285.25	1296.95	1296.95	1275	1290	6827	87.64	447
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ABB	1290	1277	1300	1276.5	1294.2	7048	91.14	625
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ABB	1294.2	1295	1329.7	1285	1322.25	32674	430.03	5216


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