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)	JUBLFOOD	3187.5	3230	3250	3165.3	3207.9	1106226	35520.7	85296	351196	31.75
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLFOOD	3207.9	3215	3235	3130.65	3173.9	708488	22508.28	67648	152325	21.5
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLFOOD	3173.9	3184	3259.85	3130	3240.2	793853	25337.74	73207	261195	32.900001525878906
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLFOOD	3240.2	3250	3268.65	3211.6	3221.75	486790	15758.84	43371	161824	33.2400016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLFOOD	3180.25	3160	3160	3060	3080	1100454	34013.42	99164	434146	39.45000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLFOOD	3221.75	3241	3248	3162	3180.25	743416	23690.43	60241	387349	52.09999847412109
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLFOOD	3301.6	3283.95	3336	3089.65	3187.5	3460824	111920.49	275792	983157	28.40999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLFOOD	1652.3	1656.95	1673	1652.8	1663.15	1142694	19018.71	27428	154096	13.49
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLFOOD	1663.15	1665	1688.35	1655.5	1682.7	840514	14079.07	26148	193180	22.98
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLFOOD	1682.7	1681	1696.9	1668.05	1682.75	975751	16445.85	26219	166278	17.04


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