Skip to main content

Hyperliquid Pre-Built Queries

Updated on
Mar 31, 2026

Overview​

This page documents all pre-built SQL queries available for Hyperliquid HyperCore data analysis through the SQL Explorer REST API. These queries cover trading activity, market analysis, position tracking, infrastructure monitoring, portfolio management, and platform analytics.

All queries use the same endpoint and authentication method:

  • Endpoint: POST https://api.quicknode.com/sql/rest/v1/query
  • Authentication: Include your API key in the x-api-key header
  • Cluster ID: hyperliquid-core-mainnet

Building Custom Queries?

See the Schema Reference for complete table and column documentation to build your own SQL queries.

Trading Queries​

Query individual trades and trading volume data from Hyperliquid.

Recent Trades​

Last 100 trades with buyer/seller details.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT timestamp, coin, side, price, size, price * size AS notional_usd, buyer_address, seller_address, buyer_fee, seller_fee, fee_token FROM hyperliquid_trades WHERE block_time > now() - INTERVAL 1 HOUR ORDER BY block_number DESC, trade_id DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Volume by Coin (24h)​

Top coins by trading volume in the last 24 hours.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT coin, count() AS trade_count, sum(price * size) AS volume_usd, min(price) AS low, max(price) AS high, avg(price) AS avg_price FROM hyperliquid_trades WHERE timestamp > now() - INTERVAL 24 HOUR GROUP BY coin ORDER BY volume_usd DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Whale Trades (24h)​

Trades over $100K in the last 24 hours.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT timestamp, coin, side, price, size, price * size AS notional_usd, buyer_address, seller_address FROM hyperliquid_trades WHERE timestamp > now() - INTERVAL 24 HOUR AND price * size > 100000 ORDER BY notional_usd DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

DEX Trades (Enriched View)​

Trades with market type (perpetual vs spot) from the enriched view.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT timestamp, coin, market_type, side, price, size, usd_amount, buyer_address, seller_address FROM hyperliquid_dex_trades WHERE block_time > now() - INTERVAL 1 HOUR ORDER BY block_number DESC, trade_id DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Activity Queries​

Analyze trading volume and user activity metrics aggregated over time periods.

Hourly Volume​

Trading volume aggregated by hour for the last 7 days.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT toStartOfHour(timestamp) AS hour, count() AS trades, sum(price * size) AS volume_usd FROM hyperliquid_trades WHERE timestamp > now() - INTERVAL 7 DAY GROUP BY hour ORDER BY hour DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Daily Volume​

Daily trading volume for the last 30 days.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT toStartOfDay(timestamp) AS day, count() AS trades, sum(price * size) AS volume_usd, uniqExact(buyer_address) + uniqExact(seller_address) AS unique_traders FROM hyperliquid_trades WHERE timestamp > now() - INTERVAL 30 DAY GROUP BY day ORDER BY day DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Top Traders by Volume (7d)​

Most active traders by volume in the last 7 days.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT buyer_address AS trader, count() AS trade_count, sum(price * size) AS total_volume, uniqExact(coin) AS coins_traded FROM hyperliquid_trades WHERE timestamp > now() - INTERVAL 7 DAY GROUP BY trader ORDER BY total_volume DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Fills Queries​

Access fill events including position changes, liquidations, and realized PnL data.

Recent Fills​

Last 100 individual fill events.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT time, coin, side, price, size, fee, fee_token, closed_pnl, dir, user, hash FROM hyperliquid_fills WHERE block_time > now() - INTERVAL 1 HOUR ORDER BY block_number DESC, tid DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Recent Liquidations​

Recent liquidation events with mark prices.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT time, coin, side, price, size, price * size AS notional, liquidated_user, liquidation_mark_price, liquidation_method, user FROM hyperliquid_fills WHERE block_time > now() - INTERVAL 24 HOUR AND is_liquidation = 1 ORDER BY block_number DESC, tid DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Orders Queries​

Retrieve order placement, cancellation, and status update events.

Recent Orders​

Latest 100 order events.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT status_time, coin, side, order_type, limit_price, size, orig_size, status, tif, user FROM hyperliquid_orders WHERE block_time > now() - INTERVAL 1 HOUR ORDER BY block_number DESC, oid DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Order Type Distribution (1h)​

Breakdown of order types in the last hour.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT order_type, side, status, count() AS order_count, uniqExact(user) AS unique_users FROM hyperliquid_orders WHERE block_time > now() - INTERVAL 1 HOUR GROUP BY order_type, side, status ORDER BY order_count DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Funding Queries​

Query funding rate payments and historical funding rate data for perpetual positions.

Latest Funding Payments​

Most recent funding payments by coin.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT coin, funding_rate, count() AS payments, sum(funding_amount) AS total_funding, avg(szi) AS avg_position_size FROM hyperliquid_funding WHERE time > now() - INTERVAL 8 HOUR GROUP BY coin, funding_rate ORDER BY abs(total_funding) DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Funding Rate History by Coin​

Hourly funding rates for top coins over 7 days.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT toStartOfHour(time) AS hour, coin, avg(funding_rate) AS avg_funding_rate, count() AS payment_count, sum(funding_amount) AS total_funding FROM hyperliquid_funding WHERE time > now() - INTERVAL 7 DAY AND coin IN ('\''BTC'\'', '\''ETH'\'', '\''SOL'\'') GROUP BY hour, coin ORDER BY hour DESC, coin LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Infrastructure Queries​

Monitor block production, transaction execution, and network-level activity.

Block Activity​

Event counts per block for recent blocks.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT block_number, block_time, fills_count, orders_count, misc_events_count, book_diffs_count, twap_statuses_count, writer_actions_count FROM hyperliquid_blocks ORDER BY block_number DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Recent Transactions​

Latest L1 transactions with action types.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT block_time, round, tx_hash, user, action_type, is_success, error FROM hyperliquid_transactions ORDER BY round DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Action Type Breakdown (24h)​

Distribution of transaction types.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT action_type, count() AS tx_count, countIf(is_success = 1) AS success_count, countIf(is_success = 0) AS failed_count, round(countIf(is_success = 1) / count() * 100, 2) AS success_rate FROM hyperliquid_transactions WHERE block_time > now() - INTERVAL 24 HOUR GROUP BY action_type ORDER BY tx_count DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Ledger Queries​

Track asset transfers, deposits, withdrawals, and balance changes across accounts.

Recent Asset Transfers​

Latest deposits, withdrawals, and internal transfers.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT time, transfer_type, user, destination, token, amount, usdc_amount, fee, tx_hash FROM hyperliquid_asset_transfers ORDER BY block_number DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Transfer Volume by Type (7d)​

Aggregate transfer volumes grouped by type.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT transfer_type, count() AS transfer_count, sum(usdc_amount) AS total_usdc, uniqExact(user) AS unique_users FROM hyperliquid_asset_transfers WHERE time > now() - INTERVAL 7 DAY GROUP BY transfer_type ORDER BY total_usdc DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Recent Ledger Updates​

Raw ledger deltas (deposits, withdrawals, liquidations, etc.).

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT time, delta_type, user, usdc_amount, token, amount, destination, fee, hash FROM hyperliquid_ledger_updates ORDER BY block_number DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Bridge Deposits & Withdrawals​

L1 bridge activity from the latest ABCI snapshot.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT bridge_type, user, amount_wei, tx_hash, eth_block_number, event_time, snapshot_time FROM hyperliquid_bridge WHERE block_number = (SELECT max(block_number) FROM hyperliquid_bridge) ORDER BY amount_wei DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Markets Queries​

Access market configuration, current prices, funding rates, and open positions data.

Perpetual Markets​

All perpetual markets with leverage and decimals.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT coin, market_index, sz_decimals, max_leverage, only_isolated FROM hyperliquid_perpetual_markets ORDER BY coin LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Spot Markets​

All spot tokens with metadata.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT token_index, token, token_id, full_name, sz_decimals, wei_decimals, is_canonical, evm_contract FROM hyperliquid_spot_markets ORDER BY token_index LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Market Context (Latest)​

Current funding rates, open interest, and prices.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT coin, funding, open_interest, mark_px, oracle_px, mid_px, premium, day_ntl_vlm, prev_day_px FROM hyperliquid_perpetual_market_contexts WHERE polled_at > now() - INTERVAL 5 MINUTE ORDER BY day_ntl_vlm DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Largest Open Positions​

Top positions by notional value.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT user, coin, size, entry_px, position_value, unrealized_pnl, return_on_equity, leverage_type, leverage_value, liquidation_price FROM hyperliquid_perpetual_positions WHERE polled_at > now() - INTERVAL 10 MINUTE ORDER BY abs(position_value) DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Oracle Prices (All DEXes)​

Mark and daily prices for all assets at the latest snapshot.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT clearinghouse, coin, mark_px, daily_px, snapshot_time FROM hyperliquid_oracle_prices WHERE block_number = (SELECT max(block_number) FROM hyperliquid_oracle_prices) ORDER BY clearinghouse, asset_idx LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Portfolio & Positions Queries​

Track user portfolios, positions, vault equity, sub-accounts, and agent authorizations.

Spot Balances for Address​

Token balances from the latest ABCI snapshot (replace address).

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "-- Replace address below\nSELECT token, token_idx, total, escrowed, snapshot_time FROM hyperliquid_spot_clearinghouse_states WHERE user = lower('\''0x742d35Cc6634C0532925a3b844Bc9e7595f0bEb'\'') AND block_number = (SELECT max(block_number) FROM hyperliquid_spot_clearinghouse_states) AND total != 0 ORDER BY abs(total) DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Vault Depositor Equity​

Top vault depositors by ownership fraction.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT vault_name, depositor, ownership_fraction, net_deposits, leader, leader_commission, snapshot_time FROM hyperliquid_vault_equities WHERE block_number = (SELECT max(block_number) FROM hyperliquid_vault_equities) ORDER BY ownership_fraction DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Sub-Account Mappings​

Sub-account to master-account relationships.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "-- Replace address to find sub-accounts for a specific master\nSELECT sub_account, master_account, name, snapshot_time FROM hyperliquid_sub_accounts WHERE master_account = lower('\''0x742d35Cc6634C0532925a3b844Bc9e7595f0bEb'\'') AND block_number = (SELECT max(block_number) FROM hyperliquid_sub_accounts) ORDER BY name LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Bot/Agent Lookups​

Find which bot or app submitted trades for a user.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "-- Replace address to find agents for a specific user\nSELECT agent, user, name, valid_until, snapshot_time FROM hyperliquid_agents WHERE user = lower('\''0x742d35Cc6634C0532925a3b844Bc9e7595f0bEb'\'') AND block_number = (SELECT max(block_number) FROM hyperliquid_agents) ORDER BY name LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Display Name Lookups​

Resolve addresses to human-readable display names.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT user, display_name, snapshot_time FROM hyperliquid_display_names WHERE block_number = (SELECT max(block_number) FROM hyperliquid_display_names) ORDER BY display_name LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Full Portfolio View​

Unified portfolio across perps, spot, vaults, and staking (replace address).

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "-- Replace address below for full portfolio snapshot\nSELECT '\''perps'\'' AS type, coin AS asset, size AS amount, entry_notional AS extra FROM hyperliquid_clearinghouse_states WHERE user = lower('\''0x742d35Cc6634C0532925a3b844Bc9e7595f0bEb'\'') AND block_number = (SELECT max(block_number) FROM hyperliquid_clearinghouse_states) AND size != 0 UNION ALL SELECT '\''spot'\'', token, total, escrowed FROM hyperliquid_spot_clearinghouse_states WHERE user = lower('\''0x742d35Cc6634C0532925a3b844Bc9e7595f0bEb'\'') AND block_number = (SELECT max(block_number) FROM hyperliquid_spot_clearinghouse_states) AND total != 0 UNION ALL SELECT '\''vault'\'', vault_name, toInt64(ownership_fraction * 1000000), net_deposits FROM hyperliquid_vault_equities WHERE depositor = lower('\''0x742d35Cc6634C0532925a3b844Bc9e7595f0bEb'\'') AND block_number = (SELECT max(block_number) FROM hyperliquid_vault_equities) UNION ALL SELECT '\''delegation'\'', validator, toInt64(reward), toInt64(commission_bps) FROM hyperliquid_delegator_rewards WHERE delegator = lower('\''0x742d35Cc6634C0532925a3b844Bc9e7595f0bEb'\'') AND block_number = (SELECT max(block_number) FROM hyperliquid_delegator_rewards) LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Builders Query​

Query frontend application activity and builder fee distribution metrics.

Builder Activity (24h)​

Builder (frontend) transaction volume.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT b.builder, l.builder_name, count() AS tx_count, sum(b.builder_fee) AS total_fees, uniqExact(b.user) AS unique_users FROM hyperliquid_builder_transactions b LEFT JOIN hyperliquid_builder_labels l ON b.builder = l.builder_address WHERE b.block_time > now() - INTERVAL 24 HOUR GROUP BY b.builder, l.builder_name ORDER BY total_fees DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Builder Fill Volume (24h)​

Trading volume routed through builder apps (Phantom, Based, etc.).

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT builder_address, count() AS fills, sum(price * size) AS volume_usd, sum(builder_fee) AS total_builder_fees, uniqExact(user) AS unique_users FROM hyperliquid_builder_fills WHERE block_time > now() - INTERVAL 24 HOUR GROUP BY builder_address ORDER BY volume_usd DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Analytics Queries​

Access pre-aggregated analytics data for funding rates, liquidations, OHLCV, and platform-wide metrics.

Funding Rate Summary (Hourly)​

Pre-aggregated hourly funding rates by coin.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT coin, hour, avg_funding_rate, total_funding, unique_users FROM hyperliquid_funding_summary_hourly WHERE hour > now() - INTERVAL 24 HOUR ORDER BY hour DESC, abs(avg_funding_rate) DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Daily Liquidation Stats​

Pre-aggregated daily liquidation counts and volume by coin.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT day, coin, liquidation_count, liquidated_volume, unique_liquidated_users FROM hyperliquid_liquidations_daily ORDER BY day DESC, liquidated_volume DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Hourly OHLCV​

Pre-aggregated hourly candlestick data per coin.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT coin, hour, volume, trade_count, high, low, open, close FROM hyperliquid_market_volume_hourly WHERE hour > now() - INTERVAL 24 HOUR AND coin = '\''BTC'\'' ORDER BY hour DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Daily Per-Coin Metrics​

Volume, fills, traders, fees, and liquidations per coin per day.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT day, coin, volume_usd, fill_count, unique_traders, fees, liquidations, high_price, low_price FROM hyperliquid_metrics_dex_overview ORDER BY day DESC, volume_usd DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Platform Daily Overview​

Platform-wide daily volume, fills, traders, and fees.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT day, total_volume_usd, total_fills, active_traders, total_fees, liquidation_count, liquidation_volume_usd, coins_traded, total_builder_fees, builder_fill_count FROM hyperliquid_metrics_overview ORDER BY day DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Staking Queries​

Access staking delegation events, undelegations, and validator reward distributions.

Staking Events​

Recent staking deposits, withdrawals, and delegations.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT time, event_type, user, amount, validator, is_undelegate, is_finalized, hash FROM hyperliquid_staking_events ORDER BY block_number DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Validator Rewards​

Recent validator reward distributions.

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
  "query": "SELECT time, validator, reward, block_number FROM hyperliquid_validator_rewards ORDER BY block_number DESC LIMIT 3",
  "clusterId": "hyperliquid-core-mainnet"
}'

Additional Resources​

For more information on using the SQL Explorer REST API:

We ❤️ Feedback!​

If you have any feedback or questions about this documentation, let us know. We'd love to hear from you!

Last updated on
Share this doc