Baselight

Metals Price Historical Data (MCX Data - 7 Metals)

Gold, Silver, Lead, Zinc, Copper, Nickel & Aluminum MCX Historical Data of 10 yr

@kaggle.naveennas_metals_price_historical_data_mcx_data_7_metals

Loading...
Loading...

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:

  1. Date: The date on which the market data was recorded (format: DD-MM-YYYY).
  2. Price: The closing price of Copper on the given date, reflecting the last traded price of the day.
  3. Open: The opening price of Copper at the start of trading on the given date.
  4. High: The highest price Copper reached during the trading day.
  5. Low: The lowest price Copper traded at during the day.
  6. Vol. (Volume): The total volume of Copper traded on the given day, typically in thousands (K).
  7. 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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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

Share link

Anyone who has the link will be able to view this.