🔍 API Diagnostics & Documentation

Generated: 2026-03-28T10:48:46.937Z

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

🔌 Data Source Health

Status and reliability of external data providers.

Source Type Status Reliability Last Success Failures
franklin_official scraper DEGRADED 95% Never (Never) 681
canary_official scraper HEALTHY 95% 3/28/2026, 8:01:23 AM (167m ago) 0
rex_osprey_official scraper HEALTHY 95% 3/28/2026, 8:01:35 AM (167m ago) 0
coinshares_official scraper DEGRADED 95% Never (Never) 563
volatilityshares_official scraper HEALTHY 90% 3/28/2026, 8:02:26 AM (166m ago) 0
sec_edgar api HEALTHY 100% 3/27/2026, 8:00:00 PM (888m ago) 0
proshares_official scraper DEGRADED 95% Never (Never) 1689
teucrium_official scraper DEGRADED 90% Never (Never) 563
amplify_official scraper HEALTHY 90% 3/28/2026, 8:03:45 AM (165m ago) 0
etf_com scraper HEALTHY 88% 3/28/2026, 8:11:47 AM (156m ago) 0
yahoo_finance api HEALTHY 90% 3/28/2026, 10:45:22 AM (3m ago) 0
alpha_vantage api HEALTHY 88% 3/28/2026, 10:45:24 AM (3m ago) 0
finnhub api HEALTHY 88% 3/28/2026, 10:45:26 AM (3m ago) 0
twelve_data api HEALTHY 90% 3/28/2026, 10:45:28 AM (3m ago) 0
coingecko api HEALTHY 92% 3/28/2026, 10:45:28 AM (3m ago) 0
coinmarketcap api HEALTHY 90% 3/28/2026, 10:45:28 AM (3m ago) 0
etfdb scraper DEGRADED 85% 3/22/2026, 8:13:57 AM (8794m ago) 471
sosovalue scraper HEALTHY 85% 3/28/2026, 8:07:21 AM (161m ago) 0
bitwise_official scraper HEALTHY 95% 3/28/2026, 8:00:18 AM (168m ago) 0
grayscale_official scraper DEGRADED 95% 1/14/2026, 8:00:39 PM (104568m ago) 435

💾 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": "d6e9995b-1837-4c85-aefb-e39cabbd4c84",
  "etfId": "64bfef27-8911-49f6-afd3-8df3e7d8812b",
  "snapshotDate": "2026-03-28",
  "nav": "14.250000",
  "navConfidence": 95,
  "navSourcesCount": null,
  "marketPriceClose": "14.210000",
  "marketPriceHigh": "14.210000",
  "marketPriceLow": "3.000000",
  "marketPriceOpen": null,
  "premiumDiscountPct": null,
  "aum": "8837522.00",
  "aumConfidence": 95,
  "xrpHoldings": null,
  "xrpHoldingsConfidence": null,
  "sharesOutstanding": "620000",
  "volume": null,
  "volumeUsd": null,
  "bidAskSpreadPct": null,
  "dailyFlowUsd": "1520000.00",
  "dailyFlowXrp": "272026.000000",
  "cumulativeFlowUsd": null,
  "notionalExposure": null,
  "futuresContractsHeld": null,
  "distributionYield": null,
  "verificationStatus": "pending",
  "verificationNotes": null,
  "createdAt": "2026-03-28T00:00:30.800Z",
  "updatedAt": "2026-03-28T10:45:28.830Z"
}
GET /api/v1/etfs/:ticker/snapshots/latest operational
Get latest snapshot for an ETF
View Sample Data
{
  "id": "d6e9995b-1837-4c85-aefb-e39cabbd4c84",
  "etfId": "64bfef27-8911-49f6-afd3-8df3e7d8812b",
  "snapshotDate": "2026-03-28",
  "nav": "14.250000",
  "navConfidence": 95,
  "navSourcesCount": null,
  "marketPriceClose": "14.210000",
  "marketPriceHigh": "14.210000",
  "marketPriceLow": "3.000000",
  "marketPriceOpen": null,
  "premiumDiscountPct": null,
  "aum": "8837522.00",
  "aumConfidence": 95,
  "xrpHoldings": null,
  "xrpHoldingsConfidence": null,
  "sharesOutstanding": "620000",
  "volume": null,
  "volumeUsd": null,
  "bidAskSpreadPct": null,
  "dailyFlowUsd": "1520000.00",
  "dailyFlowXrp": "272026.000000",
  "cumulativeFlowUsd": null,
  "notionalExposure": null,
  "futuresContractsHeld": null,
  "distributionYield": null,
  "verificationStatus": "pending",
  "verificationNotes": null,
  "createdAt": "2026-03-28T00:00:30.800Z",
  "updatedAt": "2026-03-28T10:45:28.830Z"
}
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: