Dataset: Exchange Rates: Currencies & Gold (2002-2024)

About this Dataset

Exchange Rates: Currencies & Gold (2002-2024)

Description:

This dataset contains the exchange rates of various currencies and gold against the Polish Zloty (PLN) from January 2, 2002, to July 31, 2024. The data includes daily exchange rates for the following currencies and commodities:

USD: United States Dollar
EUR: Euro
JPY: Japanese Yen
GBP: British Pound Sterling
AUD: Australian Dollar
CAD: Canadian Dollar
CHF: Swiss Franc
INR: Indian Rupee
ZAR: South African Rand
SGD: Singapore Dollar
MXN: Mexican Peso
BRL: Brazilian Real
KRW: South Korean Won
TRY: Turkish Lira
SEK: Swedish Krona
NOK: Norwegian Krone
Gold: Gold (in terms of PLN per unit)

Columns:

Date: The date of the exchange rate.
USD: Exchange rate of USD to PLN.
EUR: Exchange rate of EUR to PLN.
JPY: Exchange rate of JPY to PLN.
GBP: Exchange rate of GBP to PLN.
AUD: Exchange rate of AUD to PLN.
CAD: Exchange rate of CAD to PLN.
CHF: Exchange rate of CHF to PLN.
INR: Exchange rate of INR to PLN.
ZAR: Exchange rate of ZAR to PLN.
SGD: Exchange rate of SGD to PLN.
MXN: Exchange rate of MXN to PLN.
BRL: Exchange rate of BRL to PLN.
KRW: Exchange rate of KRW to PLN.
TRY: Exchange rate of TRY to PLN.
SEK: Exchange rate of SEK to PLN.
NOK: Exchange rate of NOK to PLN.
Gold: Exchange rate of Gold to PLN.

Source:

The data was obtained using the National Bank of Poland (NBP) API. This project was undertaken as part of a learning exercise to explore and utilize API data. Special thanks to NBP for providing the API and data.

Usage:

This dataset is useful for analyzing trends in exchange rates over time, understanding currency volatility, and performing financial analyses involving PLN and its exchange rates. It can be applied in economic research, financial forecasting, and investment strategy development.

Tables

Polish Zloty Exchange Rates

@kaggle.milangabriel_exchange_rates_currencies_and_gold_2002_2024.polish_zloty_exchange_rates

557.32 KB
5707 rows
19 columns


CREATE TABLE polish_zloty_exchange_rates (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "usd" DOUBLE,
  "eur" DOUBLE,
  "jpy" DOUBLE,
  "gbp" DOUBLE,
  "aud" DOUBLE,
  "cad" DOUBLE,
  "chf" DOUBLE,
  "inr" DOUBLE,
  "zar" DOUBLE,
  "sgd" DOUBLE,
  "mxn" DOUBLE,
  "brl" DOUBLE,
  "krw" DOUBLE,
  "try" DOUBLE,
  "sek" DOUBLE,
  "nok" DOUBLE,
  "gold" DOUBLE
);