🔍 API Diagnostics & Documentation

Generated: 2025-12-06T04:57:15.438Z

📖 How to use this API

This API provides real-time and historical data for XRP-related ETFs. It aggregates data from multiple sources (like Yahoo Finance) and provides standardized access to NAV, AUM, Price, and Volume metrics.

Base URL: https://etfapi.xpmarket.com

Authentication: Public endpoints (GET) require no authentication. Admin endpoints (POST) require an x-admin-token header.

📊 ETF Status Board

Current status of all tracked ETFs and their data freshness.

Ticker	Name	Issuer	Status	Last Data Update	Data Health
XRP	Bitwise XRP ETF	Bitwise Asset Management	active	12/6/2025, 4:56:01 AM (0h ago)	FRESH
XRPC	Canary Capital XRP ETF	Canary Capital	active	12/6/2025, 4:56:01 AM (0h ago)	FRESH
GXRP	Grayscale XRP Trust ETF	Grayscale Investments	active	12/6/2025, 4:56:01 AM (0h ago)	FRESH
XRPZ	Franklin XRP ETF	Franklin Templeton	active	12/6/2025, 4:56:01 AM (0h ago)	FRESH
XRPR	REX-Osprey XRP ETF	REX Shares / Osprey Funds	active	12/6/2025, 4:56:01 AM (0h ago)	FRESH
TOXR	21Shares XRP ETF	21Shares	pending	11/28/2025, 12:38:03 AM (196h ago)	STALE

🔌 Data Source Health

Status and reliability of external data providers.

Source	Type	Status	Reliability	Last Success	Failures
bitwise_official	scraper	HEALTHY	95%	12/4/2025, 12:00:12 PM (2457m ago)	0
grayscale_official	scraper	HEALTHY	95%	12/4/2025, 12:00:41 PM (2456m ago)	0
franklin_official	scraper	DEGRADED	95%	Never (Never)	34
canary_official	scraper	HEALTHY	95%	12/4/2025, 12:01:28 PM (2455m ago)	0
rex_osprey_official	scraper	HEALTHY	95%	12/4/2025, 12:01:40 PM (2455m ago)	0
sosovalue	scraper	HEALTHY	85%	12/4/2025, 12:03:46 PM (2453m ago)	0
etf_com	scraper	HEALTHY	88%	12/4/2025, 12:05:53 PM (2451m ago)	0
sec_edgar	api	HEALTHY	100%	12/4/2025, 12:00:00 PM (2457m ago)	0
yahoo_finance	api	HEALTHY	90%	12/6/2025, 4:55:01 AM (2m ago)	0
etfdb	scraper	HEALTHY	85%	12/4/2025, 12:07:43 PM (2449m ago)	0
alpha_vantage	api	HEALTHY	88%	12/6/2025, 4:55:02 AM (2m ago)	0
finnhub	api	HEALTHY	88%	12/6/2025, 4:55:03 AM (2m ago)	0
twelve_data	api	HEALTHY	90%	12/6/2025, 4:55:04 AM (2m ago)	0
coingecko	api	HEALTHY	92%	12/6/2025, 4:55:04 AM (2m ago)	0
coinmarketcap	api	HEALTHY	90%	12/6/2025, 4:55:04 AM (2m ago)	0

💾 Database Statistics

ETFs: 6 Data Sources: 15 Raw Data Points: 10 recent Snapshots: 10 recent Verification Logs: 10 recent

🌐 Endpoint Reference

GET /health operational

Health check with DB and Redis status

View Sample Data

{
  "status": "ok",
  "db": "connected",
  "redis": "connected"
}

GET /api/v1/etfs operational

List all ETFs

Count: 6

View Sample Data

{
  "id": "616b32d4-988b-418d-89e2-d4376f015a38",
  "ticker": "XRP",
  "name": "Bitwise XRP ETF",
  "issuer": "Bitwise Asset Management",
  "exchange": "NYSE",
  "cusip": null,
  "isin": null,
  "launchDate": "2025-11-20",
  "expenseRatio": "0.0034",
  "expenseRatioWaivedUntil": "2025-12-20",
  "custodian": "Coinbase Custody Trust Company",
  "benchmark": "CME CF XRP-Dollar Reference Rate - New York Variant",
  "status": "active",
  "issuerHoldingsUrl": "https://bitxrpetf.com/",
  "secCik": "0002039525",
  "createdAt": "2025-11-27T09:05:41.892Z",
  "updatedAt": "2025-11-27T09:05:41.892Z"
}

GET /api/v1/etfs/:ticker operational

Get specific ETF by ticker

Available Tickers:

/api/v1/etfs/XRP - Bitwise XRP ETF
/api/v1/etfs/XRPC - Canary Capital XRP ETF
/api/v1/etfs/GXRP - Grayscale XRP Trust ETF
/api/v1/etfs/XRPZ - Franklin XRP ETF
/api/v1/etfs/XRPR - REX-Osprey XRP ETF
/api/v1/etfs/TOXR - 21Shares XRP ETF

GET /api/v1/etfs/:ticker/snapshots operational

Get daily snapshots for an ETF

Count: 10

View Sample Data

{
  "id": "e603b78a-ab2f-4a68-98af-55b896bcbe5b",
  "etfId": "dc4f1cc2-b9fa-499c-b69e-c37a586be9b1",
  "snapshotDate": "2025-12-06",
  "nav": null,
  "navConfidence": null,
  "navSourcesCount": null,
  "marketPriceClose": "16.650000",
  "marketPriceHigh": "16.660000",
  "marketPriceLow": "16.650000",
  "marketPriceOpen": null,
  "premiumDiscountPct": null,
  "aum": null,
  "aumConfidence": null,
  "xrpHoldings": null,
  "xrpHoldingsConfidence": null,
  "sharesOutstanding": null,
  "volume": "425266",
  "volumeUsd": "7151175.00",
  "bidAskSpreadPct": null,
  "dailyFlowUsd": null,
  "dailyFlowXrp": null,
  "cumulativeFlowUsd": null,
  "verificationStatus": "pending",
  "verificationNotes": null,
  "createdAt": "2025-12-06T00:00:06.146Z",
  "updatedAt": "2025-12-06T04:56:01.763Z"
}

GET /api/v1/etfs/:ticker/snapshots/latest operational

Get latest snapshot for an ETF

View Sample Data

{
  "id": "e603b78a-ab2f-4a68-98af-55b896bcbe5b",
  "etfId": "dc4f1cc2-b9fa-499c-b69e-c37a586be9b1",
  "snapshotDate": "2025-12-06",
  "nav": null,
  "navConfidence": null,
  "navSourcesCount": null,
  "marketPriceClose": "16.650000",
  "marketPriceHigh": "16.660000",
  "marketPriceLow": "16.650000",
  "marketPriceOpen": null,
  "premiumDiscountPct": null,
  "aum": null,
  "aumConfidence": null,
  "xrpHoldings": null,
  "xrpHoldingsConfidence": null,
  "sharesOutstanding": null,
  "volume": "425266",
  "volumeUsd": "7151175.00",
  "bidAskSpreadPct": null,
  "dailyFlowUsd": null,
  "dailyFlowXrp": null,
  "cumulativeFlowUsd": null,
  "verificationStatus": "pending",
  "verificationNotes": null,
  "createdAt": "2025-12-06T00:00:06.146Z",
  "updatedAt": "2025-12-06T04:56:01.763Z"
}

GET /api/v1/verification/flagged operational

Get flagged verification logs

Count: 1

POST /api/v1/admin/jobs/trigger operational AUTH REQUIRED

Trigger data collection or verification jobs

Jobs: fetch_market_prices, fetch_daily_holdings, run_verification

📋 Copy for AI Analysis

Use this formatted data to share with AI for debugging or analysis:

{
  "timestamp": "2025-12-06T04:57:15.438Z",
  "database": {
    "etfs": {
      "count": 6,
      "isEmpty": false
    },
    "dataSources": {
      "count": 15,
      "isEmpty": false
    },
    "rawDataPoints": {
      "count": 10,
      "isEmpty": false,
      "latest": "2025-12-06T04:55:04.498Z"
    },
    "dailySnapshots": {
      "count": 10,
      "isEmpty": false,
      "latest": "2025-12-06T04:56:01.763Z"
    },
    "verificationLogs": {
      "count": 10,
      "isEmpty": false,
      "latest": "2025-12-06T04:56:01.755Z"
    }
  },
  "etfStatuses": [
    {
      "id": "616b32d4-988b-418d-89e2-d4376f015a38",
      "ticker": "XRP",
      "name": "Bitwise XRP ETF",
      "issuer": "Bitwise Asset Management",
      "exchange": "NYSE",
      "cusip": null,
      "isin": null,
      "launchDate": "2025-11-20",
      "expenseRatio": "0.0034",
      "expenseRatioWaivedUntil": "2025-12-20",
      "custodian": "Coinbase Custody Trust Company",
      "benchmark": "CME CF XRP-Dollar Reference Rate - New York Variant",
      "status": "active",
      "issuerHoldingsUrl": "https://bitxrpetf.com/",
      "secCik": "0002039525",
      "createdAt": "2025-11-27T09:05:41.892Z",
      "updatedAt": "2025-11-27T09:05:41.892Z",
      "lastUpdate": "2025-12-06T04:56:01.609Z",
      "lastSnapshotDate": "2025-12-06"
    },
    {
      "id": "7a67ddbd-2837-4f7b-b8de-363483e12b5c",
      "ticker": "XRPC",
      "name": "Canary Capital XRP ETF",
      "issuer": "Canary Capital",
      "exchange": "NASDAQ",
      "cusip": null,
      "isin": null,
      "launchDate": "2025-11-13",
      "expenseRatio": "0.0050",
      "expenseRatioWaivedUntil": null,
      "custodian": "BitGo",
      "benchmark": null,
      "status": "active",
      "issuerHoldingsUrl": "https://canary-capital.com/",
      "secCik": null,
      "createdAt": "2025-11-27T09:05:41.901Z",
      "updatedAt": "2025-11-27T09:05:41.901Z",
      "lastUpdate": "2025-12-06T04:56:01.645Z",
      "lastSnapshotDate": "2025-12-06"
    },
    {
      "id": "149d13c8-13f6-4425-9877-90550f9e8333",
      "ticker": "GXRP",
      "name": "Grayscale XRP Trust ETF",
      "issuer": "Grayscale Investments",
      "exchange": "NYSE",
      "cusip": null,
      "isin": null,
      "launchDate": "2025-11-24",
      "expenseRatio": "0.0075",
      "expenseRatioWaivedUntil": null,
      "custodian": "Coinbase Custody",
      "benchmark": null,
      "status": "active",
      "issuerHoldingsUrl": "https://www.grayscale.com/",
      "secCik": null,
      "createdAt": "2025-11-27T09:05:41.906Z",
      "updatedAt": "2025-11-27T09:05:41.906Z",
      "lastUpdate": "2025-12-06T04:56:01.681Z",
      "lastSnapshotDate": "2025-12-06"
    },
    {
      "id": "b2e1c7fb-22b9-4ee3-a86e-0708a255fff8",
      "ticker": "XRPZ",
      "name": "Franklin XRP ETF",
      "issuer": "Franklin Templeton",
      "exchange": "NYSE",
      "cusip": null,
      "isin": null,
      "launchDate": "2025-11-24",
      "expenseRatio": "0.0019",
      "expenseRatioWaivedUntil": null,
      "custodian": null,
      "benchmark": null,
      "status": "active",
      "issuerHoldingsUrl": "https://www.franklintempleton.com/",
      "secCik": null,
      "createdAt": "2025-11-27T09:05:41.911Z",
      "updatedAt": "2025-11-27T09:05:41.911Z",
      "lastUpdate": "2025-12-06T04:56:01.720Z",
      "lastSnapshotDate": "2025-12-06"
    },
    {
      "id": "dc4f1cc2-b9fa-499c-b69e-c37a586be9b1",
      "ticker": "XRPR",
      "name": "REX-Osprey XRP ETF",
      "issuer": "REX Shares / Osprey Funds",
      "exchange": "CBOE",
      "cusip": null,
      "isin": null,
      "launchDate": "2025-09-18",
      "expenseRatio": null,
      "expenseRatioWaivedUntil": null,
      "custodian": null,
      "benchmark": null,
      "status": "active",
      "issuerHoldingsUrl": "https://www.rexshares.com/xrpr/",
      "secCik": null,
      "createdAt": "2025-11-27T09:05:41.916Z",
      "updatedAt": "2025-11-27T09:05:41.916Z",
      "lastUpdate": "2025-12-06T04:56:01.763Z",
      "lastSnapshotDate": "2025-12-06"
    },
    {
      "id": "7ef39a62-bf16-4b06-8f32-a53dee6a7166",
      "ticker": "TOXR",
      "name": "21Shares XRP ETF",
      "issuer": "21Shares",
      "exchange": "CBOE",
      "cusip": null,
      "isin": null,
      "launchDate": "2025-11-25",
      "expenseRatio": null,
      "expenseRatioWaivedUntil": null,
      "custodian": null,
      "benchmark": null,
      "status": "pending",
      "issuerHoldingsUrl": null,
      "secCik": null,
      "createdAt": "2025-11-27T09:05:41.920Z",
      "updatedAt": "2025-11-27T09:05:41.920Z",
      "lastUpdate": "2025-11-28T00:38:03.202Z",
      "lastSnapshotDate": "2025-11-28"
    }
  ],
  "endpoints": [
    {
      "endpoint": "GET /health",
      "status": "operational",
      "description": "Health check with DB and Redis status",
      "sampleData": {
        "status": "ok",
        "db": "connected",
        "redis": "connected"
      },
      "isEmpty": false
    },
    {
      "endpoint": "GET /api/v1/etfs",
      "status": "operational",
      "description": "List all ETFs",
      "count": 6,
      "sampleData": {
        "id": "616b32d4-988b-418d-89e2-d4376f015a38",
        "ticker": "XRP",
        "name": "Bitwise XRP ETF",
        "issuer": "Bitwise Asset Management",
        "exchange": "NYSE",
        "cusip": null,
        "isin": null,
        "launchDate": "2025-11-20",
        "expenseRatio": "0.0034",
        "expenseRatioWaivedUntil": "2025-12-20",
        "custodian": "Coinbase Custody Trust Company",
        "benchmark": "CME CF XRP-Dollar Reference Rate - New York Variant",
        "status": "active",
        "issuerHoldingsUrl": "https://bitxrpetf.com/",
        "secCik": "0002039525",
        "createdAt": "2025-11-27T09:05:41.892Z",
        "updatedAt": "2025-11-27T09:05:41.892Z"
      },
      "isEmpty": false
    },
    {
      "endpoint": "GET /api/v1/etfs/:ticker",
      "status": "operational",
      "description": "Get specific ETF by ticker",
      "examples": [
        {
          "url": "/api/v1/etfs/XRP",
          "ticker": "XRP",
          "name": "Bitwise XRP ETF"
        },
        {
          "url": "/api/v1/etfs/XRPC",
          "ticker": "XRPC",
          "name": "Canary Capital XRP ETF"
        },
        {
          "url": "/api/v1/etfs/GXRP",
          "ticker": "GXRP",
          "name": "Grayscale XRP Trust ETF"
        },
        {
          "url": "/api/v1/etfs/XRPZ",
          "ticker": "XRPZ",
          "name": "Franklin XRP ETF"
        },
        {
          "url": "/api/v1/etfs/XRPR",
          "ticker": "XRPR",
          "name": "REX-Osprey XRP ETF"
        },
        {
          "url": "/api/v1/etfs/TOXR",
          "ticker": "TOXR",
          "name": "21Shares XRP ETF"
        }
      ],
      "isEmpty": false
    },
    {
      "endpoint": "GET /api/v1/etfs/:ticker/snapshots",
      "status": "operational",
      "description": "Get daily snapshots for an ETF",
      "count": 10,
      "sampleData": {
        "id": "e603b78a-ab2f-4a68-98af-55b896bcbe5b",
        "etfId": "dc4f1cc2-b9fa-499c-b69e-c37a586be9b1",
        "snapshotDate": "2025-12-06",
        "nav": null,
        "navConfidence": null,
        "navSourcesCount": null,
        "marketPriceClose": "16.650000",
        "marketPriceHigh": "16.660000",
        "marketPriceLow": "16.650000",
        "marketPriceOpen": null,
        "premiumDiscountPct": null,
        "aum": null,
        "aumConfidence": null,
        "xrpHoldings": null,
        "xrpHoldingsConfidence": null,
        "sharesOutstanding": null,
        "volume": "425266",
        "volumeUsd": "7151175.00",
        "bidAskSpreadPct": null,
        "dailyFlowUsd": null,
        "dailyFlowXrp": null,
        "cumulativeFlowUsd": null,
        "verificationStatus": "pending",
        "verificationNotes": null,
        "createdAt": "2025-12-06T00:00:06.146Z",
        "updatedAt": "2025-12-06T04:56:01.763Z"
      },
      "isEmpty": false
    },
    {
      "endpoint": "GET /api/v1/etfs/:ticker/snapshots/latest",
      "status": "operational",
      "description": "Get latest snapshot for an ETF",
      "sampleData": {
        "id": "e603b78a-ab2f-4a68-98af-55b896bcbe5b",
        "etfId": "dc4f1cc2-b9fa-499c-b69e-c37a586be9b1",
        "snapshotDate": "2025-12-06",
        "nav": null,
        "navConfidence": null,
        "navSourcesCount": null,
        "marketPriceClose": "16.650000",
        "marketPriceHigh": "16.660000",
        "marketPriceLow": "16.650000",
        "marketPriceOpen": null,
        "premiumDiscountPct": null,
        "aum": null,
        "aumConfidence": null,
        "xrpHoldings": null,
        "xrpHoldingsConfidence": null,
        "sharesOutstanding": null,
        "volume": "425266",
        "volumeUsd": "7151175.00",
        "bidAskSpreadPct": null,
        "dailyFlowUsd": null,
        "dailyFlowXrp": null,
        "cumulativeFlowUsd": null,
        "verificationStatus": "pending",
        "verificationNotes": null,
        "createdAt": "2025-12-06T00:00:06.146Z",
        "updatedAt": "2025-12-06T04:56:01.763Z"
      },
      "isEmpty": false
    },
    {
      "endpoint": "GET /api/v1/verification/flagged",
      "status": "operational",
      "description": "Get flagged verification logs",
      "count": 1,
      "isEmpty": false
    },
    {
      "endpoint": "POST /api/v1/admin/jobs/trigger",
      "status": "operational",
      "description": "Trigger data collection or verification jobs",
      "requiresAuth": true,
      "availableJobs": [
        "fetch_market_prices",
        "fetch_daily_holdings",
        "run_verification"
      ],
      "isEmpty": false
    }
  ]
}