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)	BANKINDIA	58.45	58.9	59.4	56.2	56.5	17236563	9987.05	35978	4666807	27.07999992370605
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKINDIA	56.5	57	59.4	56.2	57.75	21473785	12524.18	41481	5105770	23.780000686645508
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKINDIA	57.75	58.1	58.5	55.8	57.35	12214209	6974.97	24225	2530665	20.71999931335449
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKINDIA	57.35	57.6	57.95	56.5	56.65	5690067	3240.82	13063	1581944	27.799999237060547
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKINDIA	56.25	55.75	56.4	55.05	55.15	4763279	2653.18	12583	1424244	29.899999618530277
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKINDIA	56.65	56.9	57.7	56	56.25	6821612	3871.16	13817	1974117	28.940000534057617
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKINDIA	57.75	58.25	59.6	57.5	58.45	17408255	10198.93	36985	4930005	28.31999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKINDIA	70.4	70.1	71.1	69.6	70.45	1611534	1134.77	5708	171761	10.66
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKINDIA	70.45	70.1	71.75	69.6	71.25	2310241	1640.1	7623	524970	22.72
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKINDIA	71.25	70.8	71.1	70	70.7	1432268	1011.14	5809	265135	18.51


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