← Back to directory

Read-only ClickHouse SQL over Ironflow's Hyperliquid tables: every fill, trade, ...

https://api.ironflow.sh/x402/v1/query

Overview

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.

Protocol x402 (POST)
Price $0.01
Payment Asset USD Coin
Payment Network eip155:8453
Category crypto/wallet
Provider Ironflow
Source bazaar
Indexed 2026-11-05 16:09:21

Health

Status unknown
Latency (p50) —
Uptime (30d) —
Reliability Score —
Last Checked Never
Last Healthy Never
Consecutive Failures 0

x402 Payment Validation

Payment Requirements —
Asset Verified —
Facilitator —

Input Schema

{ "body": { "max_rows": 100, "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" }, "bodyType": "json", "method": "POST", "type": "http" }

Output Schema

{ "example": { "columns": [ "market", "usd" ], "rows": [ [ "BTC-PERP", 1530000000 ] ] }, "type": "json" }