MTG Sales Tracker

Hey internet, welcome to my little project
Its hard to find collated sales data so I’m picking up the torch and keeping this dataset alive.

Since I’m starting fresh, the data only goes back to 5/27/2025 → present.

---

Dataset Structure

Database Schema

# Sets
sets = {
    "set_id": int,
    "name": str,
    "abbreviation": str,
    "published_on": str
}

# Products
products = {
    "product_id": int,
    "set_id": int,
    "name": str,
    "image_url": str,
    "released_on": str,
    "last_scraped_at": str,
    "manapool_url": str
}

# Sales
sales = {
    "id": int,
    "product_id": int,
    "order_date": str,
    "purchase_price": float,
    "shipping_price": float,
    "quantity": int,
    "condition": str,
    "variant": str,
    "language": str,
    "marketplace": str,
    "sale_fingerprint": str
}

# Listings
listings = {
    "id": str,
    "run_id": str,
    "scraped_at": str,
    "scrape_date_utc": str,
    "product_id": int,
    "listing_id": float,
    "seller_id": str,
    "seller_key": str,
    "seller_name": str,
    "price": float,
    "quantity": int,
    "shipping_price": float,
    "seller_rating": int,
    "seller_sales": str,
    "seller_programs": str,
    "language": str,
    "previous_price": float,
    "previous_quantity": int,
    "gap_hours": float
}

# Manapool Snapshots
manapool_snapshots = {
    "id": int,
    "product_id": int,
    "scraped_at": str,
    "low_price": float,
    "market_price": float,
    "available_quantity": int
}

---

What’s Next?

Future updates will probably include:

• Identifiers for popular datasets
• Occasional data dumps
• Maybe even an API if folks are into it

---

That’s it for now.
Have fun poking around, and feel free to hit me up if you’ve got questions!