# PSA Auction Prices Realized Scraper - Sold Comps (`jungle_synthesizer/psa-auction-prices-realized-scraper`) Actor Scrape PSA Auction Prices Realized (APR) — sold-comp price data for PSA-graded sports, Pokemon, and TCG cards. Captures price, date, auction house, grade, and sub-grades when available. Card ID schema is joinable with PSA Population data for full scarcity-plus-price analysis. - **URL**: https://apify.com/jungle\_synthesizer/psa-auction-prices-realized-scraper.md - **Developed by:** [BowTiedRaccoon](https://apify.com/jungle_synthesizer) (community) - **Categories:** E-commerce, Sports - **Stats:** 3 total users, 1 monthly users, 92.3% runs succeeded, NaN bookmarks - **User rating**: No ratings yet ## Pricing Pay per event This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event ## What's an Apify Actor? Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Actors are written with capital "A". ## How to integrate an Actor? If asked about integration, you help developers integrate Actors into their projects. You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready. The best way to integrate Actors is as follows. In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md): ```bash pip install apify-client ``` In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md): ````bash # MacOS / Linux curl -fsSL https://apify.com/install-cli.sh | bash # Windows irm https://apify.com/install-cli.ps1 | iex ```bash In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md). If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md). For usage examples, see the [API](#api) section below. For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt). # README ## PSA Auction Prices Realized Scraper Scrape PSA Auction Prices Realized (APR) — sold-comp price data for PSA-graded sports cards, Pokemon, and trading card games. Returns sale price, date, auction house, grade, cert number, and sub-grades when available. The output schema is joinable with PSA Population Report data via `card_id`, enabling full scarcity-plus-price analysis. ### What you get Each record represents one sold lot: | Field | Description | |-------|-------------| | `apr_id` | Unique PSA APR sale record ID | | `card_id` | PSA internal card spec ID (joinable with pop data) | | `cert_number` | PSA cert number of the specific copy sold | | `category` | Card category (sports / pokemon / tcg / non-sport) | | `sport` | Sport tag (baseball / basketball / football / etc.) | | `year` | Card year | | `brand` | Brand / manufacturer | | `set_name` | Set name | | `card_number` | Card number within the set | | `player_or_subject` | Player name or card subject | | `parallel_or_variant` | Parallel or variant (refractor / autograph variant / etc.) | | `grade` | PSA grade label (PSA 10 / PSA 9 / etc.) | | `grade_numeric` | Numeric grade value | | `qualifier` | Grade qualifier flag (OC / PD / MK / etc.) | | `auction_house` | Where the comp sold (eBay / Goldin / Heritage / PWCC / etc.) | | `listing_type` | Listing type (auction / fixed-price / best-offer) | | `sold_price` | Final sale price | | `currency` | Sale currency (USD) | | `sold_at` | Sale timestamp (ISO 8601) | | `autograph` | True if autographed card | | `memorabilia` | True if card contains memorabilia (jersey / patch / etc.) | | `source_url` | Original auction listing URL | | `image_url` | Card image URL from the APR listing | Sub-grade fields (`subgrade_centering`, `subgrade_corners`, `subgrade_edges`, `subgrade_surface`) are populated when the `Include Sub-Grades` option is enabled. ### Modes #### Search (recommended for targeted research) Search PSA APR by player name, set, or keyword: ```json { "mode": "search", "searchQuery": "mike trout rookie", "maxItems": 100 } ```` #### APR Archive Walk Walk all APR data by category or sport: ```json { "mode": "apr_walk", "category": "pokemon", "maxItems": 500 } ``` Category options: `sports`, `pokemon`, `tcg`, `non-sport` (blank = all) Sport filter (within `sports` category): `baseball`, `basketball`, `football`, `hockey`, `soccer`, `golf`, `boxing` #### Specific Card URLs Fetch sales data for specific PSA spec pages directly: ```json { "mode": "card_urls", "cardUrls": [ "https://www.psacard.com/spec/psa/887339" ] } ``` ### Filtering options - **Grade Filter** — restrict to a specific grade (e.g. `"10"`, `"9"`, `"8.5"`) - **Year From / Year To** — filter cards by production year - **Include Sub-Grades** — capture centering / edges / corners / surface sub-grades (costs one extra fetch per card) ### Joining with PSA Population data The `card_id` field is the PSA spec ID — the same identifier used by PSA's pop report. Joining APR output to pop data gives you scarcity context alongside realized prices: ```sql SELECT apr.card_id, apr.set_name, apr.player_or_subject, apr.grade, apr.sold_price, apr.sold_at, pop.psa_10_count, pop.total_graded FROM apr_sales AS apr JOIN psa_population AS pop ON apr.card_id = pop.spec_id AND apr.grade_numeric = 10 ``` ### Notes - PSA APR is behind Cloudflare. The actor uses a residential proxy with Cloudflare bypass — a residential proxy entitlement is required. - Sale history is fetched from PSA's JSON API. Each card spec gets a paginated API call. - `maxItems` limits total output records (sale events), not the number of card specs scraped. - Default timeout is 4 hours. Large APR archive walks may require extended run time. # Actor input Schema ## `sp_intended_usage` (type: `string`): Please describe how you plan to use the data extracted by this crawler. ## `sp_improvement_suggestions` (type: `string`): Provide any feedback or suggestions for improvements. ## `sp_contact` (type: `string`): Provide your email address so we can get in touch with you. ## `mode` (type: `string`): Walk APR by category/sport/set, search by player/keyword, or fetch a single APR card URL list. ## `category` (type: `string`): Top-level category filter. Blank = all. ## `sport` (type: `string`): Sport filter (baseball / basketball / football / hockey / etc.). Leave blank for all sports. ## `yearFrom` (type: `integer`): Filter cards from this year onwards. 0 = no floor. ## `yearTo` (type: `integer`): Filter cards up to this year. 0 = no ceiling. ## `gradeFilter` (type: `string`): Optional grade filter (e.g. '10', '9', '8.5'). Blank = all grades. ## `searchQuery` (type: `string`): Free-text search (player / set / card name). Used when mode=search. ## `cardUrls` (type: `array`): When mode=card\_urls, list of PSA APR card URLs to fetch directly. ## `includeSubgrades` (type: `boolean`): Capture centring / edges / corners / surface sub-grades when exposed (mostly pre-2015 lots). Costs an extra detail-page fetch per card. ## `maxItems` (type: `integer`): Maximum APR records to return. 0 = unlimited. ## `proxyConfiguration` (type: `object`): No description ## Actor input object example ```json { "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "mode": "apr_walk", "yearFrom": 0, "yearTo": 0, "cardUrls": [ "https://www.psacard.com/auctionprices/baseball-cards/2009-topps/mike-trout-661/83821/" ], "includeSubgrades": true, "maxItems": 10, "proxyConfiguration": { "useApifyProxy": true, "apifyProxyGroups": [ "RESIDENTIAL" ], "apifyProxyCountry": "US" } } ``` # Actor output Schema ## `results` (type: `string`): No description # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "mode": "apr_walk", "category": "", "sport": "", "yearFrom": 0, "yearTo": 0, "gradeFilter": "", "searchQuery": "", "cardUrls": [ "https://www.psacard.com/auctionprices/baseball-cards/2009-topps/mike-trout-661/83821/" ], "includeSubgrades": true, "maxItems": 10, "proxyConfiguration": { "useApifyProxy": true, "apifyProxyGroups": [ "RESIDENTIAL" ], "apifyProxyCountry": "US" } }; // Run the Actor and wait for it to finish const run = await client.actor("jungle_synthesizer/psa-auction-prices-realized-scraper").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "mode": "apr_walk", "category": "", "sport": "", "yearFrom": 0, "yearTo": 0, "gradeFilter": "", "searchQuery": "", "cardUrls": ["https://www.psacard.com/auctionprices/baseball-cards/2009-topps/mike-trout-661/83821/"], "includeSubgrades": True, "maxItems": 10, "proxyConfiguration": { "useApifyProxy": True, "apifyProxyGroups": ["RESIDENTIAL"], "apifyProxyCountry": "US", }, } # Run the Actor and wait for it to finish run = client.actor("jungle_synthesizer/psa-auction-prices-realized-scraper").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"]) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) # 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "sp_intended_usage": "Describe your intended use...", "sp_improvement_suggestions": "Share your suggestions here...", "sp_contact": "Share your email here...", "mode": "apr_walk", "category": "", "sport": "", "yearFrom": 0, "yearTo": 0, "gradeFilter": "", "searchQuery": "", "cardUrls": [ "https://www.psacard.com/auctionprices/baseball-cards/2009-topps/mike-trout-661/83821/" ], "includeSubgrades": true, "maxItems": 10, "proxyConfiguration": { "useApifyProxy": true, "apifyProxyGroups": [ "RESIDENTIAL" ], "apifyProxyCountry": "US" } }' | apify call jungle_synthesizer/psa-auction-prices-realized-scraper --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=jungle_synthesizer/psa-auction-prices-realized-scraper", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "PSA Auction Prices Realized Scraper - Sold Comps", "description": "Scrape PSA Auction Prices Realized (APR) — sold-comp price data for PSA-graded sports, Pokemon, and TCG cards. Captures price, date, auction house, grade, and sub-grades when available. Card ID schema is joinable with PSA Population data for full scarcity-plus-price analysis.", "version": "0.1", "x-build-id": "Ip3SPp71wHRHbtOyd" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/jungle_synthesizer~psa-auction-prices-realized-scraper/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-jungle_synthesizer-psa-auction-prices-realized-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/jungle_synthesizer~psa-auction-prices-realized-scraper/runs": { "post": { "operationId": "runs-sync-jungle_synthesizer-psa-auction-prices-realized-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/jungle_synthesizer~psa-auction-prices-realized-scraper/run-sync": { "post": { "operationId": "run-sync-jungle_synthesizer-psa-auction-prices-realized-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "required": [ "sp_intended_usage", "sp_improvement_suggestions" ], "properties": { "sp_intended_usage": { "title": "What is the intended usage of this data?", "minLength": 1, "type": "string", "description": "Please describe how you plan to use the data extracted by this crawler." }, "sp_improvement_suggestions": { "title": "How can we improve this crawler for you?", "minLength": 1, "type": "string", "description": "Provide any feedback or suggestions for improvements." }, "sp_contact": { "title": "Contact Email", "minLength": 1, "type": "string", "description": "Provide your email address so we can get in touch with you." }, "mode": { "title": "Mode", "enum": [ "apr_walk", "search", "card_urls" ], "type": "string", "description": "Walk APR by category/sport/set, search by player/keyword, or fetch a single APR card URL list." }, "category": { "title": "Category", "enum": [ "", "sports", "pokemon", "tcg", "non-sport" ], "type": "string", "description": "Top-level category filter. Blank = all." }, "sport": { "title": "Sport", "type": "string", "description": "Sport filter (baseball / basketball / football / hockey / etc.). Leave blank for all sports." }, "yearFrom": { "title": "Year From", "type": "integer", "description": "Filter cards from this year onwards. 0 = no floor.", "default": 0 }, "yearTo": { "title": "Year To", "type": "integer", "description": "Filter cards up to this year. 0 = no ceiling.", "default": 0 }, "gradeFilter": { "title": "Grade Filter", "type": "string", "description": "Optional grade filter (e.g. '10', '9', '8.5'). Blank = all grades." }, "searchQuery": { "title": "Search Query", "type": "string", "description": "Free-text search (player / set / card name). Used when mode=search." }, "cardUrls": { "title": "Card URLs", "type": "array", "description": "When mode=card_urls, list of PSA APR card URLs to fetch directly.", "items": { "type": "string" } }, "includeSubgrades": { "title": "Include Sub-Grades", "type": "boolean", "description": "Capture centring / edges / corners / surface sub-grades when exposed (mostly pre-2015 lots). Costs an extra detail-page fetch per card.", "default": true }, "maxItems": { "title": "Max Items", "type": "integer", "description": "Maximum APR records to return. 0 = unlimited.", "default": 10 }, "proxyConfiguration": { "title": "Proxy configuration", "type": "object", "description": "" } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } } } ```