🔍 API Diagnostics & Documentation

Generated: 2026-01-27T02:32:58.607Z

📖 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.

📊 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 1/27/2026, 2:30:30 AM (0h ago) FRESH
XRPC Canary Capital XRP ETF Canary Capital active 1/27/2026, 2:30:30 AM (0h ago) FRESH
GXRP Grayscale XRP Trust ETF Grayscale Investments active 1/27/2026, 2:30:30 AM (0h ago) FRESH
XRPZ Franklin XRP ETF Franklin Templeton active 1/27/2026, 2:30:30 AM (0h ago) FRESH
XRPR REX-Osprey XRP ETF REX Shares / Osprey Funds active 1/27/2026, 2:30:30 AM (0h ago) FRESH
TOXR 21Shares XRP ETF 21Shares pending 11/28/2025, 12:38:03 AM (1441h ago) STALE
XRPL CoinShares XRP ETF CoinShares active 1/27/2026, 1:00:00 AM (1h ago) FRESH
XXRP Teucrium 2x Long Daily XRP ETF Teucrium active 1/27/2026, 2:30:30 AM (0h ago) FRESH
XRPI Volatility Shares XRP ETF Volatility Shares active 1/27/2026, 2:30:30 AM (0h ago) FRESH
UXRP ProShares Ultra XRP ETF ProShares active 1/27/2026, 2:30:30 AM (0h ago) FRESH
XRPS ProShares Short XRP ETF ProShares active 1/27/2026, 2:30:30 AM (0h ago) FRESH
RIPS ProShares UltraShort XRP ETF ProShares active 1/27/2026, 1:00:00 AM (1h ago) FRESH
XRPT Volatility Shares 2X XRP ETF Volatility Shares active 1/27/2026, 2:30:30 AM (0h ago) FRESH
XRPM Amplify XRP 3% Monthly Premium Income ETF Amplify ETFs active 1/27/2026, 2:30:30 AM (0h ago) FRESH

🔌 Data Source Health

Status and reliability of external data providers.

Source Type Status Reliability Last Success Failures
amplify_official scraper DEGRADED 90% 1/26/2026, 12:03:41 PM (869m ago) 3
coinmarketcap api HEALTHY 90% 1/27/2026, 2:30:30 AM (2m ago) 0
sosovalue scraper HEALTHY 85% 1/27/2026, 12:07:41 AM (145m ago) 0
etfdb scraper HEALTHY 85% 1/27/2026, 12:18:41 AM (134m ago) 0
sec_edgar api HEALTHY 100% 1/27/2026, 12:00:00 AM (152m ago) 0
bitwise_official scraper HEALTHY 95% 1/27/2026, 12:00:11 AM (152m ago) 0
grayscale_official scraper DEGRADED 95% 1/14/2026, 8:00:39 PM (17672m ago) 73
franklin_official scraper DEGRADED 95% Never (Never) 319
canary_official scraper HEALTHY 95% 1/27/2026, 12:01:15 AM (151m ago) 0
rex_osprey_official scraper HEALTHY 95% 1/27/2026, 12:01:28 AM (151m ago) 0
coinshares_official scraper DEGRADED 95% Never (Never) 201
yahoo_finance api HEALTHY 90% 1/27/2026, 2:30:22 AM (2m ago) 0
volatilityshares_official scraper HEALTHY 90% 1/27/2026, 12:02:18 AM (150m ago) 0
alpha_vantage api HEALTHY 88% 1/27/2026, 2:30:23 AM (2m ago) 0
finnhub api HEALTHY 88% 1/27/2026, 2:30:25 AM (2m ago) 0
proshares_official scraper DEGRADED 95% Never (Never) 603
teucrium_official scraper DEGRADED 90% Never (Never) 201
twelve_data api HEALTHY 90% 1/27/2026, 2:30:29 AM (2m ago) 0
etf_com scraper HEALTHY 88% 1/27/2026, 12:12:23 AM (140m ago) 0
coingecko api HEALTHY 92% 1/27/2026, 2:30:30 AM (2m ago) 0

💾 Database Statistics

ETFs: 14 Data Sources: 20 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: 14
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",
  "etfType": "spot",
  "leverageMultiplier": "1.0",
  "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
  • /api/v1/etfs/XRPL - CoinShares XRP ETF
  • /api/v1/etfs/XXRP - Teucrium 2x Long Daily XRP ETF
  • /api/v1/etfs/XRPI - Volatility Shares XRP ETF
  • /api/v1/etfs/UXRP - ProShares Ultra XRP ETF
  • /api/v1/etfs/XRPS - ProShares Short XRP ETF
  • /api/v1/etfs/RIPS - ProShares UltraShort XRP ETF
  • /api/v1/etfs/XRPT - Volatility Shares 2X XRP ETF
  • /api/v1/etfs/XRPM - Amplify XRP 3% Monthly Premium Income ETF
GET /api/v1/etfs/:ticker/snapshots operational
Get daily snapshots for an ETF
Count: 10
View Sample Data
{
  "id": "b2c74076-fce5-4f49-98c8-a27ff5792136",
  "etfId": "64bfef27-8911-49f6-afd3-8df3e7d8812b",
  "snapshotDate": "2026-01-27",
  "nav": null,
  "navConfidence": null,
  "navSourcesCount": null,
  "marketPriceClose": "21.430000",
  "marketPriceHigh": "21.430000",
  "marketPriceLow": "1.000000",
  "marketPriceOpen": null,
  "premiumDiscountPct": null,
  "aum": "6900000.00",
  "aumConfidence": 85,
  "xrpHoldings": null,
  "xrpHoldingsConfidence": null,
  "sharesOutstanding": null,
  "volume": "3000000",
  "volumeUsd": "64290000.00",
  "bidAskSpreadPct": null,
  "dailyFlowUsd": "4870000.00",
  "dailyFlowXrp": "232026.000000",
  "cumulativeFlowUsd": null,
  "notionalExposure": null,
  "futuresContractsHeld": null,
  "distributionYield": null,
  "verificationStatus": "pending",
  "verificationNotes": null,
  "createdAt": "2026-01-27T00:00:29.801Z",
  "updatedAt": "2026-01-27T02:30:30.531Z"
}
GET /api/v1/etfs/:ticker/snapshots/latest operational
Get latest snapshot for an ETF
View Sample Data
{
  "id": "b2c74076-fce5-4f49-98c8-a27ff5792136",
  "etfId": "64bfef27-8911-49f6-afd3-8df3e7d8812b",
  "snapshotDate": "2026-01-27",
  "nav": null,
  "navConfidence": null,
  "navSourcesCount": null,
  "marketPriceClose": "21.430000",
  "marketPriceHigh": "21.430000",
  "marketPriceLow": "1.000000",
  "marketPriceOpen": null,
  "premiumDiscountPct": null,
  "aum": "6900000.00",
  "aumConfidence": 85,
  "xrpHoldings": null,
  "xrpHoldingsConfidence": null,
  "sharesOutstanding": null,
  "volume": "3000000",
  "volumeUsd": "64290000.00",
  "bidAskSpreadPct": null,
  "dailyFlowUsd": "4870000.00",
  "dailyFlowXrp": "232026.000000",
  "cumulativeFlowUsd": null,
  "notionalExposure": null,
  "futuresContractsHeld": null,
  "distributionYield": null,
  "verificationStatus": "pending",
  "verificationNotes": null,
  "createdAt": "2026-01-27T00:00:29.801Z",
  "updatedAt": "2026-01-27T02:30:30.531Z"
}
GET /api/v1/verification/flagged operational
Get flagged verification logs
Count: 2

📋 Copy for AI Analysis

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