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)	LALPATHLAB	3101.25	3109	3140	3020.5	3086.2	167038	5150.2	22089	42292	25.31999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LALPATHLAB	3086.2	3080	3105	2997.05	3029.35	168720	5109.9	21729	69581	41.2400016784668
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LALPATHLAB	3029.35	3030	3062.95	2956	2998.05	133342	4005.75	19109	53664	40.25
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LALPATHLAB	2998.05	3003.35	3025	2952	2959.75	180685	5375.44	25516	94533	52.31999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LALPATHLAB	2928.2	2860.05	2904.15	2802	2837.25	246293	6998.03	32990	82620	33.54999923706055
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LALPATHLAB	2959.75	2974	2995.95	2895.6	2928.2	347918	10195.12	32909	118627	34.099998474121094
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LALPATHLAB	3211.35	3214	3233.75	3080	3101.25	174206	5466.64	29140	60554	34.7599983215332
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LALPATHLAB	1493.95	1495	1546	1487.5	1533.4	59533	904.17	5056	22719	38.16
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LALPATHLAB	1533.4	1540	1571.9	1528	1534.7	91815	1424.21	9042	33902	36.92
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LALPATHLAB	1534.7	1530	1554.75	1513.85	1540.2	78684	1210.44	9455	46930	59.64


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