Pakistan Stock Exchange Complete
Complete Data from Jan-2018 to May-2022
@kaggle.mirfanazam_pakistan_stock_exchange_complete
Complete Data from Jan-2018 to May-2022
@kaggle.mirfanazam_pakistan_stock_exchange_complete
Pakistan Stock Exchange was established on September 18, 1947 and was formally incorporated on March 10, 1949 under the name of ‘Karachi Stock Exchange’, as a Company limited by Guarantee. In October 1970, a second stock exchange was established in Lahore to meet the stock trading needs of the provincial metropolis. In October 1989, Islamabad Stock Exchange was established to cater to the investors of the northern parts of the country. Because the three exchanges had separate management, trading interfaces, indices, and had no mutualized structure, therefore the Stock Exchanges (Corporatization, Demutualization and Integration) Act, 2012 was promulgated by the Government of Pakistan which ultimately resulted in the three exchanges integrating their operations effective January 11, 2016 under the new name ‘Pakistan Stock Exchange Limited’ (PSX).
This dataset contains data for 314 regular stocks from 1-Jan-2018 to 31-May-2022.
CREATE TABLE fnel (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE ftmm (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE fudlm (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE gati (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE gatm (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE gemunsl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE gggl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE ggl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE ghgl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE ghni (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE ghnl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE glaxo (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE gskch (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE gtech (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE gtyr (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE gvgl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE gwlc (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE habsm (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hael (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hascol (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hbl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hcar (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hgfa (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hicl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hifa (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hino (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hinoon (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hirat (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hmb (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hrpl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hsm (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE htl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hubc (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hubcsc2 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE hubphlsc (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" BIGINT,
"volume" BIGINT
);CREATE TABLE humnl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE iblhl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE icibl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE icl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE idrt (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE idsm (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE idym (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE ilp (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE image (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE iml (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE indu (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE inil (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE isl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE ittefaq (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE jatm (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);Anyone who has the link will be able to view this.