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 aabs (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE abl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE abot (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE acietf (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE acpl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE adams (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE agha (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE agic (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE agil (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE agl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE agp (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE agsml (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE agtl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE ahcl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE ahl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE aicl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE airlink (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE akbl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE akdhl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE alife (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE alnrs (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE altn (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE anl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE apl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE asc (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE asl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE astl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE astm (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE atba (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE atrl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE avn (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE bafl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE bahl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE bcl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE beco (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE berg (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE bgl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE bifo (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE bilf (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE bipl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE bnwm (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE bop (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE bpl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE brr (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE btl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE buxl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE bwcl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE ceni (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE cepb (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);CREATE TABLE chcc (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT
);Anyone who has the link will be able to view this.