Run SQL query
run_queryRun one read-only ClickHouse SELECT over Ironflow's Hyperliquid tables (hl.fills, hl.wallet_daily, hl.wallet_behavior, hl.funding, hl.mark_prices, hl.oracle_prices, hl.open_interest, hl.liquidations, hl.builder_fills, hl.transfers, hl.vault_operations). Aggregate in SQL: results are capped (1,000 rows keyless). Keyless: last 24 hours, 5 s per query, 60 query seconds per hour per IP; a free key from https://ironflow.sh/key gives 30 days of history.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | One ClickHouse SELECT (or WITH ... SELECT) over hl.* tables, without a FORMAT clause | |
| max_rows | No | Most rows to return (default 200, capped by your tier) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | Rows as positional arrays | |
| stats | No | elapsed_ms, rows_read, bytes_read | |
| limits | No | Your tier's limits | |
| notice | No | Present when the API added a note: how a market name was read, that data starts later than asked because of the history window, or a next step such as a free key | |
| columns | No | Column names in row order | |
| row_count | No | Rows returned | |
| truncated | No | true when more rows existed than were returned | |
| column_types | No | ClickHouse types in row order | |
| budget_remaining_seconds | No | Query seconds left this hour |