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)	BIOCON	392.7	393.8	395.7	389.65	391.65	2637508	10358.14	38038	1206178	45.72999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BIOCON	391.65	390.5	404.5	390.25	399.3	6057343	24214.59	100358	2322633	38.34000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BIOCON	399.3	403.9	410.7	399.7	404.6	7761396	31561.91	105556	1989944	25.63999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BIOCON	404.6	404.6	409.2	401.5	407.25	2428075	9877.01	34272	783267	32.2599983215332
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BIOCON	403.7	400	404.6	394.7	402.9	2008633	8035.44	45035	566299	28.190000534057617
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BIOCON	407.25	406.1	408	401.25	403.7	1556043	6291.64	32679	688374	44.2400016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BIOCON	387.25	388	394.35	384.7	392.7	4692928	18337.1	63448	1936683	41.27000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BIOCON	293.7	294	295.15	291.55	294.55	829510	2435.47	7965	174479	21.03
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BIOCON	294.55	294.5	298.3	294.1	296.15	1572279	4661.71	26651	512614	32.6
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BIOCON	296.15	295.8	304.3	293.7	300.95	5147717	15480.57	46828	1262622	24.53


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