# Global Import-Export Market Price Ranking (2017-2023)

For each exporter and HS6 product, compares observed unit values across destination markets, including the highest, lowest, and median prices and traded quantities.

## What one row represents
one exporter and HS6 product

## Included measures and context
- Highest- and lowest-price destination markets
- Median unit value and price spread
- Average quantity and total trade value

## Metric notes
- HS6 codes identify products at the six-digit Harmonized System level.
- Fields marked USD are monetary values denominated in US dollars.
- Values ending in pct are percentages.
- Country fields ending in ISO3 use three-letter ISO 3166-1 country codes.

## Fields
Column names are shown exactly as they appear in the Parquet file. The schema lists the same fields, and the sample file shows example values.

- `exporter_iso3` — `fixed_size_binary[3]`
- `hs_code` — `fixed_size_binary[6]`
- `num_markets` — `uint32`
- `highest_price_importer_iso3` — `fixed_size_binary[3]`
- `highest_price_usd_per_ton` — `float64`
- `lowest_price_importer_iso3` — `fixed_size_binary[3]`
- `lowest_price_usd_per_ton` — `float64`
- `median_price_across_markets` — `float64`
- `price_spread_pct` — `float64`
- `avg_quantity_metric_tons` — `float64`
- `total_trade_value_usd` — `float64`

## Coverage and size
- Coverage: 2017-2023 price history summary
- Records: 730,677
- Parquet file size: 30 MB
- Release: 1.0.0
- SHA-256: `526a8e136f74997c83ba617a68c9878dd80810a513c249269d40e43a5fb3d6f3`

## Files
- `data.parquet` — complete dataset
- `manifest.json` — dataset description, coverage, record count, and download details
- `schema.json` — field names, row definition, included measures, and metric notes
- `sample.json` — example records
- `README.md` — these notes

## Read the Parquet file with Python
```python
import pandas as pd

data = pd.read_parquet("data.parquet")
print(data.head())
```

Install `pandas` and `pyarrow` if they are not already available: `python -m pip install pandas pyarrow`.

## Sources and related files
- OECD BIMTS HS2017-6D
- Dataset page: https://www.yugalinks.com/datasets/import-export/import-export-market-price-ranking-v1/
- Original dataset record: https://huggingface.co/datasets/yugalinks/import-export-market-price-ranking-v1