Data model
Printing prices (current)
Latest known price per printing and finish.
6 columns. Every value below is generated from the provenance registry.
| Field | Type | Source | Updated | Written by |
|---|---|---|---|---|
| printing_id | string | mtgjson | daily | scripts/ingest-mtgjson.ts (prices) |
| FK to card_printings — resolved from mtgjson_uuid at ingest. | ||||
| vendor | string | mtgjson | daily | scripts/ingest-mtgjson.ts (prices) |
| Price source: tcgplayer, cardkingdom, cardmarket, cardhoarder, manapool (open set). | ||||
| finish | string | mtgjson | daily | scripts/ingest-mtgjson.ts (prices) |
| normal, foil, or etched. | ||||
| price_cents | number | mtgjson | daily | scripts/ingest-mtgjson.ts (prices) |
| Latest retail price in integer cents. | ||||
| currency | string | mtgjson | daily | scripts/ingest-mtgjson.ts (prices) |
| USD (paper US vendors, MTGO tix proxy) or EUR (cardmarket). | ||||
| price_date | string | mtgjson | daily | scripts/ingest-mtgjson.ts (prices) |
| The day the latest point was quoted. | ||||
TypeScript model
interface printing_prices_current {
printing_id: string
vendor: string
finish: string
price_cents: number
currency: string
price_date: string
}