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)	COALINDIA	161.3	161.3	162.8	160	160.4	6402287	10347.03	60377	2652200	41.43000030517578
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	160.4	160.65	163	159.65	160.95	5871041	9483.54	43333	1843734	31.399999618530277
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	160.95	161.85	162.5	158.35	159.95	14158927	22640.77	58727	5984886	42.27000045776367
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	159.95	160.5	169.35	160	168.6	35079516	58631.03	177536	13292058	37.88999938964844
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	168.05	167.95	169.3	165.2	166.5	10097767	16864.48	68547	3750885	37.150001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	168.6	169	170.3	165	168.05	17724098	29750.84	104692	5393651	30.43000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	163.85	163.1	164.15	160.6	161.3	4654885	7547.28	35032	1958876	42.08000183105469
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	211.35	211.35	212.6	208.4	211.95	6447592	13585.57	48911	1294489	20.08
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	211.95	212.5	212.8	208.3	211.1	5958343	12552.16	45875	1763059	29.59
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COALINDIA	211.1	210	212.6	207.7	211.85	6452638	13580.96	43299	2147545	33.28


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