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)	UBL	1656.9	1656.75	1672.6	1647.05	1659.55	105058	1746.04	10034	29942	28.5
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UBL	1659.55	1662.85	1667.9	1597	1607.4	128297	2086.59	11995	34886	27.190000534057617
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UBL	1607.4	1605.75	1618.8	1580	1597.45	162883	2599.9	23752	21168	13
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UBL	1597.45	1597.5	1607.4	1590	1598.8	147262	2353.73	12382	82106	55.7599983215332
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UBL	1625.1	1618	1619.9	1584.2	1593.35	90806	1449.72	6768	26927	29.649999618530277
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UBL	1598.8	1605	1636.5	1580.8	1625.1	214598	3462.46	13186	86059	40.09999847412109
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UBL	1670.85	1652	1672.95	1627.5	1656.9	281009	4636.05	17934	110365	39.27000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UBL	1270.05	1271.7	1285.45	1263.5	1273.75	170248	2170.73	7179	14934	8.77
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UBL	1273.75	1275	1284.6	1265.1	1281.4	347781	4440.19	14928	156443	44.98
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UBL	1281.4	1283.95	1293.95	1278.5	1280.85	234725	3015.99	9800	56431	24.04


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