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)	ALEMBICLTD	100.35	100.2	100.8	99.2	99.4	82974	82.85	1294	45532	54.880001068115234
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALEMBICLTD	99.4	99.4	100.95	98	98.35	147152	145.71	2390	93780	63.72999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALEMBICLTD	98.35	98.75	99.2	96.25	96.85	122131	118.72	2581	73372	60.08000183105469
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALEMBICLTD	96.85	98	98.75	96.35	96.85	118786	115.36	2137	82275	69.26000213623047
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALEMBICLTD	98.05	98.3	98.3	96.5	96.6	142790	138.54	2634	76951	53.88999938964844
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALEMBICLTD	96.85	97.7	99.15	96.85	98.05	231566	226.26	4305	73942	31.93000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALEMBICLTD	101.4	102.4	102.4	100	100.35	115398	116.58	3487	57635	49.93999862670898
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ALEMBICLTD	59.6	60.75	63.55	59.5	61.15	665343	413.37	5197	212103	31.88
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ALEMBICLTD	61.15	61.75	62.7	60.5	61.9	289027	178.25	2256	140074	48.46
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ALEMBICLTD	61.9	61.85	62.4	59.4	59.95	172904	105.47	4469	102623	59.35


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