New Zealand Exchange Data (NZX)
From 01 Sep - 10 Sep 2021
@kaggle.kkhandekar_new_zealand_exchange_data_nzx
From 01 Sep - 10 Sep 2021
@kaggle.kkhandekar_new_zealand_exchange_data_nzx
New Zealand's Exchange (the NZX), or Te Paehoko o Aotearoa in te reo Māori, is the national stock exchange for New Zealand and a publicly owned company.[1] NZX is the parent company of Smartshares, LifeSaver (a financial provider for KiwiSaver), and Wealth Technologies. On 30 August 2020, the NZX had a total of 184 listed securities with a combined market value of NZ$184.87 billion. The main trading board is typically open from 10am through till 4:45pm.
NZX data at the end of each day from 01 Sep - 10 Sep 2021.
CREATE TABLE nzxdata_01sep2021 (
"code" VARCHAR,
"company" VARCHAR,
"price" VARCHAR,
"change" VARCHAR,
"volume" BIGINT,
"value" VARCHAR,
"capitalisation" VARCHAR
);CREATE TABLE nzxdata_02sep2021 (
"code" VARCHAR,
"company" VARCHAR,
"price" VARCHAR,
"change" VARCHAR,
"volume" BIGINT,
"value" VARCHAR,
"capitalisation" VARCHAR
);CREATE TABLE nzxdata_03sep2021 (
"code" VARCHAR,
"company" VARCHAR,
"price" VARCHAR,
"change" VARCHAR,
"volume" BIGINT,
"value" VARCHAR,
"capitalisation" VARCHAR
);CREATE TABLE nzxdata_06sep2021 (
"code" VARCHAR,
"company" VARCHAR,
"price" VARCHAR,
"change" VARCHAR,
"volume" BIGINT,
"value" VARCHAR,
"capitalisation" VARCHAR
);CREATE TABLE nzxdata_07sep2021 (
"code" VARCHAR,
"company" VARCHAR,
"price" VARCHAR,
"change" VARCHAR,
"volume" BIGINT,
"value" VARCHAR,
"capitalisation" VARCHAR
);CREATE TABLE nzxdata_08sep2021 (
"code" VARCHAR,
"company" VARCHAR,
"price" VARCHAR,
"change" VARCHAR,
"volume" BIGINT,
"value" VARCHAR,
"capitalisation" VARCHAR
);CREATE TABLE nzxdata_09sep2021 (
"code" VARCHAR,
"company" VARCHAR,
"price" VARCHAR,
"change" VARCHAR,
"volume" BIGINT,
"value" VARCHAR,
"capitalisation" VARCHAR
);CREATE TABLE nzxdata_10sep2021 (
"code" VARCHAR,
"company" VARCHAR,
"price" VARCHAR,
"change" VARCHAR,
"volume" BIGINT,
"value" VARCHAR,
"capitalisation" VARCHAR
);Anyone who has the link will be able to view this.