Ironflow
Read-only ClickHouse SQL over Ironflow's Hyperliquid tables: every fill, trade, liquidation, funding payment, candle, open interest reading and wallet of the last year (hl.* tables; GET /v1/query/schema lists them for free). Use it when no single endpoint answers the question: custom aggregations, joins, wallet cohorts or backtest datasets. Up to 30 s and 10,000 rows a query.
The wallet the 402 directs payment to. Its whole payment record — every payer, every chain — is on the merchant page.
Asset 0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913
The payTo wallet does not resolve to a registered ERC-8004 agent. That is not a verdict on the service — most of the catalog is unregistered.
Live 402 challenge
Captured by the enrichment pass, not read just now. Prices can change — always read the 402 the endpoint answers with.
{
"error": {
"code": "PAYMENT_REQUIRED",
"message": "this endpoint is paid per call with x402: $0.005 per request, $0.01 per SQL query, in USDC on Base. Pay the PAYMENT-REQUIRED header and retry with PAYMENT-SIGNATURE. The same data is free within limits under /v1 (a free key: https://ironflow.sh/key?utm_source=api)"
}
}Accepts
The payment requirements as published to the catalog. Read the live 402 before paying — a price here is a claim, not a quote.
Pay 0.01 USDC on Base to 0x9594…63155. The signed payment is good for 1 minute.
- Paid to
- 0x9594…63155
- USD Coin contract
- 0x8335…02913
- Payment window
- 1 minute
- As published
- 10000 smallest units
The catalog’s raw entry
[
{
"asset": "0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913",
"extra": {
"name": "USD Coin",
"version": "2"
},
"payTo": "0x959408fd3edc4ca6116de1ba6004ac87ebc63155",
"amount": "10000",
"scheme": "exact",
"network": "eip155:8453",
"maxTimeoutSeconds": 60
}
]Extensions
{
"bazaar": {
"info": {
"input": {
"body": {
"sql": "SELECT market, round(sum(volume_usd)) AS usd FROM hl.market_hourly WHERE hour > now() - INTERVAL 1 DAY GROUP BY market ORDER BY usd DESC LIMIT 5",
"max_rows": 100
},
"type": "http",
"method": "POST",
"bodyType": "json"
},
"output": {
"type": "json",
"example": {
"rows": [
[
"BTC-PERP",
1530000000
]
],
"columns": [
"market",
"usd"
]
}
}
},
"schema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"input"
],
"properties": {
"input": {
"type": "object",
"required": [
"type",
"method",
"bodyType",
"body"
],
"properties": {
"body": {
"type": "object",
"required": [
"sql"
],
"properties": {
"sql": {
"type": "string",
"description": "One SELECT over hl.* tables"
},
"max_rows": {
"type": "integer",
"description": "Most rows to return, up to 10000"
}
}
},
"type": {
"type": "string",
"const": "http"
},
"method": {
"enum": [
"POST"
],
"type": "string"
},
"bodyType": {
"enum": [
"json",
"form-data",
"text"
],
"type": "string"
}
},
"additionalProperties": false
},
"output": {
"type": "object",
"required": [
"type"
],
"properties": {
"type": {
"type": "string"
},
"example": {
"type": "object",
"properties": {
"rows": {
"type": "array",
"items": {
"type": "array"
},
"description": "Rows, each an array in column order"
},
"error": {
"type": "object",
"properties": {
"code": {
"type": "string",
"description": "Machine-readable code: INVALID_PARAMETER, HISTORY_OUT_OF_RANGE, QUERY_WINDOW_EXCEEDED, RATE_LIMIT_EXCEEDED, NOT_FOUND, INTERNAL_ERROR"
},
"message": {
"type": "string",
"description": "What went wrong and how to fix the request"
},
"upgrade": {
"type": "object",
"properties": {},
"description": "On a limit error: the plan or paid call that lifts it"
}
},
"description": "Present instead of the data on a 4xx or 5xx answer."
},
"columns": {
"type": "array",
"items": {
"type": "string",
"description": "Column"
},
"description": "Column names"
}
},
"description": "Query result"
}
}
}
}
}
}
}Provenance
- Seen in the source catalog
- 2026-11-05 15:28Z
- Last indexed by Roundhouse
- 2026-11-09 19:00Z
- Last enriched (probe, favicon, geo)
- 2026-11-05 22:45Z
- x402 version
- 2
- Max timeout
- 60s
- Liveness probe
- HTTP 402
Hand this page to an agent
Copy the prompt and paste it into Claude, an MCP client or your own agent — it will vet this service and call it over the free read API. No key, no account.
GET api.roundhouseai.io/v0/endpoints
This endpoint's own trailing-30-day call count, as published by the upstream catalog and snapshotted daily. 3 snapshots so far. Verified volume counts only settlements with an on-chain EIP-3009 marker.
Show the promptHide the prompt
Using Roundhouse, look up the x402 service Ironflow and tell me whether it is worth paying: what a call costs, whether the endpoint answered when last probed, and what its payment record actually shows. curl -s 'https://api.roundhouseai.io/v0/endpoints?q=Ironflow' curl -s 'https://api.roundhouseai.io/v0/merchants/<the payTo wallet returned above>' Then call it: read the price from the live 402 at https://api.ironflow.sh/x402/v1/query, never from a cached figure, and pay with an x402 client. The /v0 API needs an API key (`authorization: Bearer rh_live_…`) on everything except /v0/unified* and /v0/endpoints. Either pay over x402 (mint a personal key for $0.01 at GET https://api.roundhouseai.io/v0/test/x402), or ask me for an organization key, which I create at https://roundhouseai.io/dashboard/connections. If you have neither, ask before going further. If you do not have Roundhouse tools or skills installed, read https://roundhouseai.io/skill.md first — it is the whole procedure.