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)	JKTYRE	133.2	131	133	130.1	130.6	1224701	1603.1	11795	491503	40.130001068115234
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKTYRE	130.6	130.7	131.65	126.5	127.15	723829	927.59	9976	397336	54.88999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKTYRE	127.15	129.3	129.3	123.25	123.6	888042	1111.48	13120	380772	42.880001068115234
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKTYRE	123.6	124.5	126.15	123.85	124.1	619240	772.68	7609	241018	38.91999816894531
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKTYRE	125.4	125	125.3	120.15	121.25	773607	949.33	10624	359161	46.43000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKTYRE	124.1	125	125.9	124.15	125.4	477570	597.52	5951	158874	33.27000045776367
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JKTYRE	136.3	132.05	134.35	131	133.2	1331264	1773.37	12919	386813	29.059999465942383
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JKTYRE	74.9	74.5	76.9	74.45	75.2	487832	368.25	3880	134628	27.6
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JKTYRE	75.2	75.05	78.45	75.05	77.95	1205899	928.93	8138	469551	38.94
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JKTYRE	77.95	77	77.7	75.15	75.95	782765	598.08	8501	310977	39.73


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