Dataset: Metals Price Historical Data (MCX Data - 7 Metals)

About this Dataset

Metals Price Historical Data (MCX Data - 7 Metals)

This dataset contains historical price data for seven essential metals traded on the Multi Commodity Exchange (MCX) India: Gold, Silver, Lead, Zinc, Copper, Nickel, and Aluminum. The data is meticulously collected to support prediction models, trend analysis, and statistical exploration of metal price movements.

The dataset includes:

Daily price data for 7 metals
Open price, high/low values, and closing prices
Data across multiple periods, useful for preliminary exploration, model training, and analysis

Description for each column in the dataset:

Date: The date on which the market data was recorded (format: DD-MM-YYYY).
Price: The closing price of Copper on the given date, reflecting the last traded price of the day.
Open: The opening price of Copper at the start of trading on the given date.
High: The highest price Copper reached during the trading day.
Low: The lowest price Copper traded at during the day.
Vol. (Volume): The total volume of Copper traded on the given day, typically in thousands (K).
Change %: The percentage change in the closing price from the previous trading day.

Tables

Aluminium Historical Data

@kaggle.naveennas_metals_price_historical_data_mcx_data_7_metals.aluminium_historical_data

74.04 KB
2735 rows
7 columns


CREATE TABLE aluminium_historical_data (
  "date" VARCHAR,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" VARCHAR,
  "change" VARCHAR
);

Copper Historical Data

@kaggle.naveennas_metals_price_historical_data_mcx_data_7_metals.copper_historical_data

90.1 KB
2758 rows
7 columns


CREATE TABLE copper_historical_data (
  "date" VARCHAR,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" VARCHAR,
  "change" VARCHAR
);

Lead Historical Data

@kaggle.naveennas_metals_price_historical_data_mcx_data_7_metals.lead_historical_data

71.74 KB
2757 rows
7 columns


CREATE TABLE lead_historical_data (
  "date" VARCHAR,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" VARCHAR,
  "change" VARCHAR
);

Nickel Historical Data

@kaggle.naveennas_metals_price_historical_data_mcx_data_7_metals.nickel_historical_data

91.3 KB
2755 rows
7 columns


CREATE TABLE nickel_historical_data (
  "date" VARCHAR,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" VARCHAR,
  "change" VARCHAR
);

Refined Gold Historical Data

@kaggle.naveennas_metals_price_historical_data_mcx_data_7_metals.refined_gold_historical_data

91.83 KB
2760 rows
7 columns


CREATE TABLE refined_gold_historical_data (
  "date" VARCHAR,
  "price" BIGINT,
  "open" BIGINT,
  "high" BIGINT,
  "low" BIGINT,
  "vol" VARCHAR,
  "change" VARCHAR
);

Silver Historical Data

@kaggle.naveennas_metals_price_historical_data_mcx_data_7_metals.silver_historical_data

95.84 KB
2759 rows
7 columns


CREATE TABLE silver_historical_data (
  "date" VARCHAR,
  "price" BIGINT,
  "open" BIGINT,
  "high" BIGINT,
  "low" BIGINT,
  "vol" VARCHAR,
  "change" VARCHAR
);

Zinc Historical Data

@kaggle.naveennas_metals_price_historical_data_mcx_data_7_metals.zinc_historical_data

83.84 KB
2758 rows
7 columns


CREATE TABLE zinc_historical_data (
  "date" VARCHAR,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" VARCHAR,
  "change" VARCHAR
);