AltFinance Data API

X-API-Key: afi_live_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

curl https://api.altfndata.com/v1/health

{
  "status": "healthy",
  "version": "1.0.0",
  "timestamp": "2026-03-04T13:00:00.000000+00:00",
  "athena_database": "altfinancedb"
}

curl -H "X-API-Key: YOUR_KEY" https://api.altfndata.com/v1/tables

{
  "tables": [
    {"name": "watches",     "description": "Luxury watch auction results",         "column_count": 122},
    {"name": "handbags",    "description": "Luxury handbag auction results",       "column_count": 67},
    {"name": "jewelry",     "description": "Jewelry and gemstone auction results", "column_count": 99},
    {"name": "gems",        "description": "Gemstone auction results",             "column_count": 75},
    {"name": "automobile",  "description": "Collector car auction results",        "column_count": 66},
    {"name": "motorcycle",  "description": "Collector motorcycle auction results", "column_count": 66},
    {"name": "aircraft",    "description": "Aircraft auction results",             "column_count": 84},
    {"name": "wine_whisky", "description": "Wine and whisky auction results",      "column_count": 74}
  ]
}

curl -H "X-API-Key: YOUR_KEY" https://api.altfndata.com/v1/tables/watches/schema

{
  "table": "watches",
  "columns": [
    {"name": "item_title", "type": "string"},
    {"name": "designer", "type": "string"},
    {"name": "usd_price_decimal", "type": "double"},
    {"name": "sale_date", "type": "string"}
  ]
}

{
  "fields": ["item_title", "designer", "usd_price_decimal", "sale_date", "vendor"],
  "filters": [
    {"field": "designer", "op": "eq", "value": "Rolex"},
    {"field": "usd_price_decimal", "op": "gte", "value": 50000}
  ],
  "sort": [
    {"field": "usd_price_decimal", "direction": "desc"}
  ],
  "limit": 20,
  "offset": 0
}

{"field": "column_name", "op": "eq", "value": "some_value"}

{"field": "column_name", "direction": "desc"}

{
  "table": "watches",
  "query_execution_id": "ae3d3e58-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
  "execution_time_ms": 1505,
  "result_count": 5,
  "limit": 20,
  "offset": 0,
  "fields": ["item_title", "designer", "usd_price_decimal", "sale_date", "vendor"],
  "data": [
    {
      "item_title": "Ref.6239, Cosmograph Daytona \"Paul Newman\"",
      "designer": "Rolex",
      "usd_price_decimal": 17752500.0,
      "sale_date": "-",
      "vendor": "Phillips"
    }
  ]
}

curl -H "X-API-Key: YOUR_KEY" \
  "https://api.altfndata.com/v1/tables/watches/query?designer=Rolex&limit=5&sort=usd_price_decimal:desc"

Page 1: limit=100&offset=0
Page 2: limit=100&offset=100
Page 3: limit=100&offset=200

{"detail": "Rate limit exceeded (30 requests/minute). Try again later."}

{"detail": "Daily row quota exceeded (10000 rows/day). Resets at midnight UTC."}

# List tables
curl -H "X-API-Key: YOUR_KEY" https://api.altfndata.com/v1/tables

# Simple GET query
curl -H "X-API-Key: YOUR_KEY" \
  "https://api.altfndata.com/v1/tables/watches/query?designer=Rolex&limit=10&sort=usd_price_decimal:desc"

# POST query with filters
curl -X POST https://api.altfndata.com/v1/tables/watches/query \
  -H "X-API-Key: YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "fields": ["item_title", "designer", "vendor", "usd_price_decimal", "sale_date"],
    "filters": [
      {"field": "designer", "op": "eq", "value": "Rolex"},
      {"field": "usd_price_decimal", "op": "gte", "value": 50000}
    ],
    "sort": [{"field": "usd_price_decimal", "direction": "desc"}],
    "limit": 20
  }'

import requests

API_KEY = "YOUR_KEY"
BASE = "https://api.altfndata.com"
HEADERS = {"X-API-Key": API_KEY}


# List tables
tables = requests.get(f"{BASE}/v1/tables", headers=HEADERS).json()
for t in tables["tables"]:
    print(f"{t['name']}: {t['column_count']} columns")


# Get schema
schema = requests.get(f"{BASE}/v1/tables/watches/schema", headers=HEADERS).json()
for col in schema["columns"][:10]:
    print(f"  {col['name']}: {col['type']}")


# Query: Top 10 Rolex watches by price
resp = requests.post(
    f"{BASE}/v1/tables/watches/query",
    headers={**HEADERS, "Content-Type": "application/json"},
    json={
        "fields": ["item_title", "vendor", "usd_price_decimal", "sale_date"],
        "filters": [
            {"field": "designer", "op": "eq", "value": "Rolex"},
            {"field": "usd_price_decimal", "op": "is_not_null"},
        ],
        "sort": [{"field": "usd_price_decimal", "direction": "desc"}],
        "limit": 10,
    },
)
data = resp.json()
print(f"\n{data['result_count']} results ({data['execution_time_ms']}ms)\n")
for row in data["data"]:
    print(f"  ${row['usd_price_decimal']:,.0f}  {row['vendor']}  {row['item_title'][:60]}")


# Pagination
all_results = []
offset = 0
while True:
    resp = requests.post(
        f"{BASE}/v1/tables/watches/query",
        headers={**HEADERS, "Content-Type": "application/json"},
        json={
            "fields": ["item_title", "usd_price_decimal"],
            "filters": [{"field": "designer", "op": "eq", "value": "Patek Philippe"}],
            "sort": [{"field": "usd_price_decimal", "direction": "desc"}],
            "limit": 100,
            "offset": offset,
        },
    )
    page = resp.json()
    all_results.extend(page["data"])
    if page["result_count"] < 100:
        break
    offset += 100

print(f"Total Patek Philippe records: {len(all_results)}")

const API_KEY = "YOUR_KEY";
const BASE = "https://api.altfndata.com";

// List tables
const tables = await fetch(`${BASE}/v1/tables`, {
  headers: { "X-API-Key": API_KEY },
}).then((r) => r.json());

console.log(tables);

// Query watches
const resp = await fetch(`${BASE}/v1/tables/watches/query`, {
  method: "POST",
  headers: {
    "X-API-Key": API_KEY,
    "Content-Type": "application/json",
  },
  body: JSON.stringify({
    fields: ["item_title", "designer", "usd_price_decimal", "vendor"],
    filters: [
      { field: "designer", op: "eq", value: "Omega" },
      { field: "usd_price_decimal", op: "gte", value: 10000 },
    ],
    sort: [{ field: "usd_price_decimal", direction: "desc" }],
    limit: 10,
  }),
}).then((r) => r.json());

console.log(`${resp.result_count} results (${resp.execution_time_ms}ms)`);
resp.data.forEach((row) => {
  console.log(`  $${row.usd_price_decimal}  ${row.item_title}`);
});

pip install altfinance-mcp

{
  "mcpServers": {
    "altfinance": {
      "command": "altfinance-mcp",
      "env": {
        "ALTFINANCE_API_KEY": "YOUR_KEY"
      }
    }
  }
}

export ALTFINANCE_API_KEY="YOUR_KEY"
claude mcp add altfinance -- altfinance-mcp