Data model
Printing prices (weekly)
Weekly TCGplayer price rollups per printing, for longer-range history. TCGplayer only, like the daily series.
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. | ||||
| finish | string | mtgjson | daily | scripts/ingest-mtgjson.ts (prices) |
| normal, foil, or etched. | ||||
| week_start | string | mtgjson | daily | scripts/ingest-mtgjson.ts (prices) |
| Monday of the rolled-up week. | ||||
| high_cents | number | mtgjson | daily | scripts/ingest-mtgjson.ts (prices) |
| Weekly high, TCGplayer retail USD cents. | ||||
| low_cents | number | mtgjson | daily | scripts/ingest-mtgjson.ts (prices) |
| Weekly low, TCGplayer retail USD cents. | ||||
| close_cents | number | mtgjson | daily | scripts/ingest-mtgjson.ts (prices) |
| Last daily point of the week, TCGplayer retail USD cents. | ||||
TypeScript model
interface printing_price_weekly {
printing_id: string
finish: string
week_start: string
high_cents: number
low_cents: number
close_cents: number
}