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)	BSOFT	475.2	468.6	478	461.2	467.4	1861340	8743.18	33150	315001	16.920000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BSOFT	467.4	469.6	473	449	452.75	1295173	5963.65	26548	407897	31.489999771118164
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BSOFT	452.75	453	457.2	440.45	442.55	1517358	6771.87	33321	455886	30.040000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BSOFT	442.55	446	464	445.55	455.75	2815110	12859.82	58948	705879	25.06999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BSOFT	463.05	458.95	459	449.5	453	2074346	9429.46	47566	889088	42.86000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BSOFT	455.75	458.05	465.9	456	463.05	2075464	9543.62	41148	733555	35.34000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BSOFT	476.75	478.85	486.9	473	475.2	2113638	10148.05	41981	579334	27.40999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BSOFT	70.7	71.15	72	70.65	71.6	56070	40	685	29027	51.77
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BSOFT	71.6	71.45	74.9	70.9	73.35	292223	213.92	1881	159533	54.59
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BSOFT	73.35	73.35	73.35	71	72.15	281102	202.47	4109	195249	69.46


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