Documentation Index
Fetch the complete documentation index at: https://docs.asksurf.ai/llms.txt
Use this file to discover all available pages before exploring further.
3 tables in this category.
Tables
| View Name | Database | Source | ORDER BY |
|---|
agent.hyperliquid_market_data | agent | hyperliquid.market_data | coin, snapshot_time |
agent.hyperliquid_funding_rates | agent | hyperliquid.funding_rates | coin, time |
agent.hyperliquid_perp_meta | agent | hyperliquid.perp_meta | coin |
agent.hyperevm_dex_trades
Sample Queries
1. Get recent Transfer events for USDC
SELECT *
FROM ethereum.event_logs
WHERE topics[1] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
AND address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
ORDER BY block_number DESC
LIMIT 10
2. Count transactions per day for the last week
SELECT block_date, count() AS tx_count
FROM ethereum.transactions
WHERE block_date >= today() - 7
GROUP BY block_date
ORDER BY block_date
Table Schemas
agent.hyperliquid_market_data
Hourly perpetual futures market snapshots from Hyperliquid Info API. Includes funding rates, open interest, prices (oracle, mark, mid), 24h volume, and premium for all listed perpetual contracts. ReplacingMergeTree — use FINAL.
Engine: ReplacingMergeTree | Partition: toYYYYMM(snapshot_date) | ORDER BY: coin, snapshot_time
| Column | Type | Description |
|---|
snapshot_time | DateTime64(3) | Hourly snapshot timestamp (DateTime64). |
coin | String | Perpetual contract ticker (e.g., ‘BTC’, ‘ETH’, ‘SOL’). Links to perp_meta. |
funding | Float64 | Current predicted funding rate (per-hour). Positive = longs pay shorts. |
open_interest | Float64 | Total open interest in contract units (not USD). |
prev_day_px | Float64 | Previous day’s closing price. |
day_ntl_vlm | Float64 | 24-hour notional volume in USD. |
premium | Nullable(Float64) | Basis premium (mark - oracle). Nullable. |
oracle_px | Float64 | Oracle price (external reference, typically Pyth/Chainlink). |
mark_px | Float64 | Mark price (used for margin and liquidation calculations). |
mid_px | Nullable(Float64) | Mid price of the order book. Nullable. |
impact_bid_px | Nullable(Float64) | Price for a standard-size market sell. Nullable — indicates depth. |
impact_ask_px | Nullable(Float64) | Price for a standard-size market buy. Nullable — indicates depth. |
snapshot_date | Date | Date of the snapshot (partition key). |
- Use FINAL when querying — this is a ReplacingMergeTree table
- snapshot_time is hourly — one snapshot per (coin, hour)
- day_ntl_vlm is 24h notional volume in USD at snapshot time
- funding is the current predicted funding rate (annualize by multiplying by 8760)
- open_interest is in contract units, not USD — multiply by mark_px for USD OI
- Hourly snapshots only — no tick-level or trade-level data
- ReplacingMergeTree — always use FINAL for consistent reads
- OI is in contract units, not USD — requires multiplication by price
- Not all fields are always populated (mid_px, impact_bid/ask_px can be null)
agent.hyperliquid_funding_rates
Historical funding rate settlements for Hyperliquid perpetual contracts. Every 1-hour funding event is recorded with the settlement rate and premium. ReplacingMergeTree — use FINAL.
Engine: ReplacingMergeTree | Partition: toYYYYMM(funding_date) | ORDER BY: coin, time
| Column | Type | Description |
|---|
time | DateTime64(3) | Settlement timestamp (DateTime64). |
coin | String | Perpetual contract ticker (e.g., ‘BTC’, ‘ETH’). Links to perp_meta. |
funding_rate | Float64 | Settlement funding rate. Positive = longs pay shorts. |
premium | Float64 | Mark-to-oracle premium at settlement time. |
funding_date | Date | Date of the funding settlement (partition key). |
- Use FINAL when querying — ReplacingMergeTree table
- funding_rate is per-settlement-period (hourly). Annualize: rate * 8760
- premium tracks the basis between mark and oracle price at settlement
- For average daily funding: avg(funding_rate) grouped by funding_date and coin
- ReplacingMergeTree — use FINAL for deduplication
- Funding rates are per-hour settlements — not continuous
- Historical backfill depth depends on when the pipeline was started
coin
| Column | Type | Description |
|---|
coin | String | Perpetual contract ticker (e.g., ‘BTC’, ‘ETH’, ‘SOL’). Primary key. |
sz_decimals | UInt8 | Number of decimal places for position/order sizing. |
max_leverage | UInt16 | Maximum leverage allowed for this contract. |
updated_at | DateTime64(3) | Last metadata refresh timestamp. |
- Small table (~229 rows) — safe to SELECT * or use in subqueries without filtering
- JOIN with market_data or funding_rates ON coin for enrichment
- sz_decimals determines the minimum trade size increment for each contract
- Only covers perpetual contracts — no spot or options metadata
- Max leverage may change over time — only current value is stored