Requêtes prédéfinies Hyperliquid

Aperçu

Cette page répertorie toutes les requêtes SQL prédéfinies disponibles pour l'analyse de données Hyperliquid HyperCore via l'API REST SQL Explorer. Ces requêtes couvrent l'activité de trading, l'analyse de marché, le suivi des positions, la surveillance de l'infrastructure, la gestion de portefeuille et l'analyse de la plateforme.

Toutes les requêtes utilisent le même point de terminaison et la même méthode d'authentification :

Point final : ARTICLE https://api.quicknode.com/sql/rest/v1/query
Authentification : Indiquez votre Clé API dans le x-api-key en-tête
Identifiant du cluster : hyperliquid-core-mainnet

Vous souhaitez créer des requêtes personnalisées ?

Consultez la référence du schéma pour obtenir la documentation complète sur les tables et les colonnes afin de créer vos propres requêtes SQL.

Questions relatives au trading

Consulter les données relatives aux transactions individuelles et aux volumes de transactions sur Hyperliquid.

Transactions récentes

Les 100 dernières transactions avec les coordonnées de l'acheteur et du vendeur.

Requête
Réponse

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, toFloat64(price) * toFloat64(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 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "timestamp",
            "type": "DateTime64(3, 'UTC')"
        },
        {
            "name": "coin",
            "type": "LowCardinality(String)"
        }
    ],
    "data": [
      {
            "timestamp": "2026-04-02 14:21:27.666",
            "coin": "@107",
            "side": "B",
            "price": 34.625,
            "size": 12.5,
            "notional_usd": 432.8125,
            "buyer_address": "0xecb63caa47c7c4e77f60f1ce858cf28dc2b82b00",
            "seller_address": "0x9266865bb6afb4c4f618544dd3b8c970f17aa664",
            "buyer_fee": 0.00262499,
            "seller_fee": -0.00012499,
            "fee_token": "HYPE"
      }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 597,
    "statistics": {
        "elapsed": 0.007224752,
        "rows_read": 56511,
        "bytes_read": 10381799
    }
}

Volume par cryptomonnaie (24 h)

Les cryptomonnaies les plus échangées au cours des dernières 24 heures.

Requête
Réponse

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(toFloat64(price) * toFloat64(size)) AS volume_usd, min(toFloat64(price)) AS low, max(toFloat64(price)) AS high, avg(toFloat64(price)) AS avg_price FROM hyperliquid_trades WHERE timestamp > now() - INTERVAL 24 HOUR GROUP BY coin ORDER BY volume_usd DESC LIMIT 50",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "coin",
            "type": "LowCardinality(String)"
        },
        {
            "name": "trade_count",
            "type": "UInt64"
        }
    ],
    "data": [
        {
            "coin": "BTC",
            "trade_count": 722316,
            "volume_usd": 2740791882.317031,
            "low": 65697,
            "high": 69117,
            "avg_price": 67404.89164160838
        }
    ],
    "rows": 50,
    "rows_before_limit_at_least": 439,
    "statistics": {
        "elapsed": 1.491897288,
        "rows_read": 4679677,
        "bytes_read": 196233107
    }
}

Transactions des « baleines » (24 h)

Transactions supérieures à 100 000 dollars au cours des dernières 24 heures.

Requête
Réponse

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, toFloat64(price) * toFloat64(size) AS notional_usd, buyer_address, seller_address FROM hyperliquid_trades WHERE block_time > now() - INTERVAL 24 HOUR AND toFloat64(price) * toFloat64(size) > 100000 ORDER BY notional_usd DESC LIMIT 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "timestamp",
            "type": "DateTime64(3, 'UTC')"
        },
        {
            "name": "coin",
            "type": "LowCardinality(String)"
        }
    ],
    "data": [
         {
            "timestamp": "2026-04-02 01:19:25.187",
            "coin": "cash:USA500",
            "side": "A",
            "price": 6530.5,
            "size": 457.914,
            "notional_usd": 2990407.377,
            "buyer_address": "0x65c18f2bc08c9130e4d694e33bffcd3aa7cf2526",
            "seller_address": "0x8bae3527e5a33fa0cf184f37bc112d071463ab6d"
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 10527,
    "statistics": {
        "elapsed": 0.369080523,
        "rows_read": 5126495,
        "bytes_read": 618192147
    }
}

Transactions DEX (affichage détaillé)

Opérations selon le type de marché (perpétuel ou au comptant) depuis la vue détaillée.

Requête
Réponse

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 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "timestamp",
            "type": "DateTime64(3, 'UTC')"
        },
        {
            "name": "coin",
            "type": "LowCardinality(String)"
        }
    ],
    "data": [
        {
            "timestamp": "2026-04-02 14:27:56.309",
            "coin": "xyz:SILVER",
            "market_type": "perpetual",
            "side": "A",
            "price": 71.69,
            "size": 118.81,
            "usd_amount": 10.429726976538413,
            "buyer_address": "0x7b7f72a28fe109fa703eeed7984f2a8a68fedee2",
            "seller_address": "0x4bbf95c18dca8609fa2bfa01aa1f07b77e334b4b"
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 2107,
    "statistics": {
        "elapsed": 0.078426431,
        "rows_read": 279772,
        "bytes_read": 42229818
    }
}

Requêtes d'activité

Analyser les indicateurs relatifs au volume des transactions et à l'activité des utilisateurs, agrégés sur différentes périodes.

Volume horaire

Volume des transactions agrégé par heure pour les 7 derniers jours.

Requête
Réponse

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(toFloat64(price) * toFloat64(size)) AS volume_usd FROM hyperliquid_trades WHERE timestamp > now() - INTERVAL 7 DAY GROUP BY hour ORDER BY hour DESC",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "hour",
            "type": "DateTime('UTC')"
        }
    ],
    "data": [
        {
            "hour": "2026-04-02 14:00:00",
            "trades": 176175,
            "volume_usd": 304180984.4983604
        }
    ],
    "rows": 169,
    "rows_before_limit_at_least": 169,
    "statistics": {
        "elapsed": 0.974603795,
        "rows_read": 27443725,
        "bytes_read": 1096893352
    }
}

Volume quotidien

Volume quotidien des transactions au cours des 30 derniers jours.

Requête
Réponse

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(toFloat64(price) * toFloat64(size)) AS volume_usd, uniqExact(arrayJoin([buyer_address, seller_address])) AS unique_traders FROM hyperliquid_trades WHERE timestamp > now() - INTERVAL 30 DAY GROUP BY day ORDER BY day DESC",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "day",
            "type": "DateTime('UTC')"
        }
    ],
    "data": [
        {
            "day": "2026-04-02 00:00:00",
            "trades": 6287986,
            "volume_usd": 11955855129.097586,
            "unique_traders": 48424
        }
    ],
    "rows": 31,
    "rows_before_limit_at_least": 31,
    "statistics": {
        "elapsed": 3.865872434,
        "rows_read": 126043471,
        "bytes_read": 15626653528
    }
}

Meilleurs traders en volume (7 jours)

Les traders les plus actifs en termes de volume au cours des 7 derniers jours.

Requête
Réponse

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 trader, count() AS trade_count, sum(volume) AS total_volume, uniqExact(coin) AS coins_traded FROM ( SELECT buyer_address AS trader, toFloat64(price) * toFloat64(size) AS volume, coin FROM hyperliquid_trades WHERE timestamp > now() - INTERVAL 7 DAY UNION ALL SELECT seller_address AS trader, toFloat64(price) * toFloat64(size) AS volume, coin FROM hyperliquid_trades WHERE timestamp > now() - INTERVAL 7 DAY ) GROUP BY trader ORDER BY total_volume DESC LIMIT 50",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "trader",
            "type": "FixedString(42)"
        }
    ],
    "data": [
        {
            "trader": "0xc926ddba8b7617dbc65712f20cf8e1b58b8598d3",
            "trade_count": 1233956,
            "total_volume": 2862303824.2981963,
            "coins_traded": 113
        }
    ],
    "rows": 50,
    "rows_before_limit_at_least": 115776,
    "statistics": {
        "elapsed": 0.805998407,
        "rows_read": 54903106,
        "bytes_read": 4609639192
    }
}

Réponses aux requêtes

Accédez aux événements liés à l'exécution des ordres, notamment les changements de position, les liquidations et les données de PnL réalisées.

Derniers remplissages

Les 100 derniers remplissages individuels.

Requête
Réponse

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 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "time",
            "type": "DateTime64(3, 'UTC')"
        }
    ],
    "data": [
        {
            "time": "2026-04-02 14:30:57.423",
            "coin": "cash:EWY",
            "side": "B",
            "price": 120.79,
            "size": 0.41,
            "fee": 0.003961,
            "fee_token": "USDT0",
            "closed_pnl": 0,
            "dir": "Open Long",
            "user": "0xf81f37da0d288c9c214a14a7a1630306a83a298b",
            "hash": "0x281e35098f71f5ac299704383d709b0210a000ef2a75147ecbe6e05c4e75cf96"
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 1324,
    "statistics": {
        "elapsed": 0.322578231,
        "rows_read": 95344,
        "bytes_read": 19870069
    }
}

Liquidations récentes

Cas récents de liquidation avec cours de référence.

Requête
Réponse

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, toFloat64(price) * toFloat64(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 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "time",
            "type": "DateTime64(3, 'UTC')"
        }
    ],
    "data": [
        {
            "time": "2026-04-02 14:31:43.531",
            "coin": "SOL",
            "side": "B",
            "price": 78.692,
            "size": 5.02,
            "notional": 395.03383999999994,
            "liquidated_user": "0xf296d92e9b4f2975dffe7daa309b671bbaa70e07",
            "liquidation_mark_price": 78.677,
            "liquidation_method": "market",
            "user": "0xf296d92e9b4f2975dffe7daa309b671bbaa70e07"
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 100,
    "statistics": {
        "elapsed": 0.666003748,
        "rows_read": 2896592,
        "bytes_read": 198924115
    }
}

Questions relatives aux commandes

Récupérer les événements liés à la passation, à l'annulation et à la mise à jour du statut des commandes.

Commandes récentes

Les 100 dernières commandes.

Requête
Réponse

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 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "status_time",
            "type": "DateTime64(6, 'UTC')"
        }
    ],
    "data": [
        {
            "status_time": "2026-04-02 14:32:17.881790",
            "coin": "LINK",
            "side": "A",
            "order_type": "Limit",
            "limit_price": 8.5056,
            "size": 141.2,
            "orig_size": 141.2,
            "status": "open",
            "tif": "Alo",
            "user": "0x31ca8395cf837de08b24da3f660e77761dfb974b"
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 11405,
    "statistics": {
        "elapsed": 0.769894367,
        "rows_read": 8544026,
        "bytes_read": 102335620
    }
}

Répartition par type de commande (1 h)

Répartition des types de commandes au cours de la dernière heure.

Requête
Réponse

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",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "order_type",
            "type": "LowCardinality(String)"
        }
    ],
    "data": [
        {
            "order_type": "Limit",
            "side": "B",
            "status": "badAloPxRejected",
            "order_count": 23039835,
            "unique_users": 895
        }
    ],
    "rows": 99,
    "rows_before_limit_at_least": 99,
    "statistics": {
        "elapsed": 0.749435223,
        "rows_read": 103569157,
        "bytes_read": 4987744623
    }
}

Questions relatives au financement

Consulter les paiements liés au taux de financement et les données historiques sur ce taux pour les positions perpétuelles.

Derniers versements de subventions

Derniers versements de financement par cryptomonnaie.

Requête
Réponse

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(toFloat64(funding_amount)) AS total_funding, avg(toFloat64(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 50",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "coin",
            "type": "LowCardinality(String)"
        }
    ],
    "data": [
        {
            "coin": "HYPE",
            "funding_rate": 0.0000125,
            "payments": 69310,
            "total_funding": 0.011697999996314934,
            "avg_position_size": 1.3101132740587094e-13
        }
    ],
    "rows": 50,
    "rows_before_limit_at_least": 1679,
    "statistics": {
        "elapsed": 0.478083693,
        "rows_read": 1899202,
        "bytes_read": 109477210
    }
}

Historique des taux de financement par cryptomonnaie

Taux de financement horaires des principales cryptomonnaies sur 7 jours.

Requête
Réponse

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(toFloat64(funding_rate)) AS avg_funding_rate, count() AS payment_count, sum(toFloat64(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 500",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "hour",
            "type": "DateTime('UTC')"
        }
    ],
    "data": [
        {
            "hour": "2026-04-02 14:00:00",
            "coin": "BTC",
            "avg_funding_rate": -0.000007712100000001212,
            "payment_count": 27362,
            "total_funding": -0.00016900000029738266
        }
    ],
    "rows": 480,
    "rows_before_limit_at_least": 480,
    "statistics": {
        "elapsed": 0.989426874,
        "rows_read": 35919860,
        "bytes_read": 1508558992
    }
}

Questions relatives aux infrastructures

Surveiller la production de blocs, l'exécution des transactions et l'activité au niveau du réseau.

Activité du bloc

Nombre d'événements par bloc pour les blocs récents.

Requête
Réponse

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 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "block_number",
            "type": "UInt64"
        }
    ],
    "data": [
        {
            "block_number": 943554161,
            "block_time": "2026-04-02 14:35:12.633440",
            "fills_count": 0,
            "orders_count": 0,
            "misc_events_count": 0,
            "book_diffs_count": 938,
            "twap_statuses_count": 0,
            "writer_actions_count": 0
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 100,
    "statistics": {
        "elapsed": 0.331056163,
        "rows_read": 84058,
        "bytes_read": 2072672
    }
}

Transactions récentes

Dernières transactions L1 avec types d'action.

Requête
Réponse

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 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "block_time",
            "type": "DateTime64(6, 'UTC')"
        }
    ],
    "data": [
         {
            "block_time": "2026-04-02 11:13:29.980780",
            "round": 1235948152,
            "tx_hash": "0xa2ce22f60f3d5bf8c5ba88dd676510138dd38dcaeb5a7948560c48ac7a5a400a",
            "user": "0x31ca8395cf837de08b24da3f660e77761dfb974b",
            "action_type": "order",
            "is_success": 1,
            "error": null
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 10120,
    "statistics": {
        "elapsed": 5.95414221,
        "rows_read": 13524254,
        "bytes_read": 2084634902
    }
}

Répartition par type d'action (24 h)

Répartition des types de transactions.

Requête
Réponse

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",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "action_type",
            "type": "LowCardinality(String)"
        }
    ],
    "data": [
        {
            "action_type": "order",
            "tx_count": 335732028,
            "success_count": 313646463,
            "failed_count": 22085565,
            "success_rate": 93.42
        }

    ],
    "rows": 58,
    "rows_before_limit_at_least": 58,
    "statistics": {
        "elapsed": 1.023330583,
        "rows_read": 530682211,
        "bytes_read": 5306907458
    }
}

Requêtes sur le registre

Suivre les transferts d'actifs, les dépôts, les retraits et les variations de solde entre les différents comptes.

Transferts d'actifs récents

Derniers dépôts, retraits et virements internes.

Requête
Réponse

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 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "time",
            "type": "DateTime64(6, 'UTC')"
        }
    ],
    "data": [
         {
            "time": "2026-04-02 14:37:34.608701",
            "transfer_type": "send",
            "user": "0x82cd5683ef2013c30915cd84c940f378ad782d4b",
            "destination": "0x73860688e65a1e3308be5679c3a7912b405d166f",
            "token": "USDC",
            "amount": 3.125,
            "usdc_amount": null,
            "fee": 0,
            "tx_hash": "0xae9db9ac1eb86136b01704383d85e80208730091b9bb8008526664feddbc3b21"
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 484,
    "statistics": {
        "elapsed": 0.267330045,
        "rows_read": 165690,
        "bytes_read": 38213961
    }
}

Volume des transferts par type (7 jours)

Volumes de transfert globaux, regroupés par type.

Requête
Réponse

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(toFloat64(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",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "transfer_type",
            "type": "LowCardinality(String)"
        }
    ],
    "data": [
        {
            "transfer_type": "withdraw",
            "transfer_count": 27359,
            "total_usdc": 479717900.29241735,
            "unique_users": 18708
        }
    ],
    "rows": 6,
    "rows_before_limit_at_least": 6,
    "statistics": {
        "elapsed": 0.248622298,
        "rows_read": 9370470,
        "bytes_read": 93872979
    }
}

Mises à jour récentes du registre

Deltas bruts du grand livre (dépôts, retraits, liquidations, etc.).

Requête
Réponse

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 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "time",
            "type": "DateTime64(6, 'UTC')"
        }
    ],
    "data": [
        {
            "time": "2026-04-02 14:38:42.736459",
            "delta_type": "accountClassTransfer",
            "user": "0xf346d7118d40b6ea804b43fe7c8539eeb23dd377",
            "usdc_amount": 2.76,
            "token": null,
            "amount": null,
            "destination": null,
            "fee": null,
            "hash": "0xb2db9cd2b63591a4b45504383d89890204c600b85138b07656a4482575396b8f"
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 106,
    "statistics": {
        "elapsed": 0.196807126,
        "rows_read": 128376,
        "bytes_read": 29555275
    }
}

Dépôts et retraits via Bridge

Activité du pont L1 d'après le dernier instantané ABCI.

Requête
Réponse

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 toFloat64(amount_wei) DESC LIMIT 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "bridge_type",
            "type": "LowCardinality(String)"
        }
    ],
    "data": [
        {
            "bridge_type": "deposit",
            "user": "0x9d32884370875f2960d5cc4b95be26687d69aff5",
            "amount_wei": 10000000000000,
            "tx_hash": "0xde6efb62f32e0e3e19d329d3074792c11cab553d0d4d20b33b0185a0ea052c87",
            "eth_block_number": 447560809,
            "event_time": "2026-03-31T11:46:43.151693370",
            "snapshot_time": "2026-04-02 14:30:19.000000"
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 58134,
    "statistics": {
        "elapsed": 0.460661164,
        "rows_read": 58146,
        "bytes_read": 8100302
    }
}

Questions sur les marchés

Accédez aux données relatives à la configuration du marché, aux cours actuels, aux taux de financement et aux positions ouvertes.

Marchés perpétuels

Tous les marchés perpétuels avec effet de levier et décimales.

Requête
Réponse

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 500",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "coin",
            "type": "LowCardinality(String)"
        }
    ],
    "data": [
        {
            "coin": "0G",
            "market_index": 210,
            "sz_decimals": 0,
            "max_leverage": 3,
            "only_isolated": 0
        }
    ],
    "rows": 229,
    "rows_before_limit_at_least": 229,
    "statistics": {
        "elapsed": 0.001658429,
        "rows_read": 229,
        "bytes_read": 4208
    }
}

Marchés au comptant

Tous les jetons « spot » accompagnés de métadonnées.

Requête
Réponse

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 500",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "token_index",
            "type": "UInt16"
        }
    ],
    "data": [
        {
            "token_index": 0,
            "token": "USDC",
            "token_id": "0x6d1e7cde53ba9467b783cb7c530ce054",
            "full_name": null,
            "sz_decimals": 8,
            "wei_decimals": 8,
            "is_canonical": 1,
            "evm_contract": "0x6b9e773128f453f5c2c60935ee2de2cbc5390a24"
        }
    ],
    "rows": 500,
    "rows_before_limit_at_least": 500,
    "statistics": {
        "elapsed": 0.002235372,
        "rows_read": 903,
        "bytes_read": 86367
    }
}

Contexte de marché (derniers développements)

Taux de financement actuels, positions ouvertes et cours.

Requête
Réponse

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 toFloat64(day_ntl_vlm) DESC LIMIT 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "coin",
            "type": "LowCardinality(String)"
        }
    ],
    "data": [
        {
            "coin": "BTC",
            "funding": -0.0000087307,
            "open_interest": 28121.8956999999,
            "mark_px": 66819,
            "oracle_px": 66887,
            "mid_px": 66856,
            "premium": -0.0004485176,
            "day_ntl_vlm": 2867036350.5407243,
            "prev_day_px": 68354
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 916,
    "statistics": {
        "elapsed": 0.004133074,
        "rows_read": 7557,
        "bytes_read": 1040797
    }
}

Cours Oracle (tous les DEX)

Cotes et cours quotidiens de tous les actifs, selon les dernières données disponibles.

Requête
Réponse

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",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "clearinghouse",
            "type": "UInt8"
        }
    ],
    "data": [
        {
            "clearinghouse": 0,
            "coin": "BTC",
            "mark_px": "662690",
            "daily_px": "681140",
            "snapshot_time": "2026-04-02 14:30:19.000000"
        }
    ],
    "rows": 384,
    "rows_before_limit_at_least": 384,
    "statistics": {
        "elapsed": 0.004016938,
        "rows_read": 387,
        "bytes_read": 19240
    }
}

Principaux postes à pourvoir (toutes les bourses)

Principales positions de contrepartie par montant notionnel d'entrée, toutes chambres de compensation confondues (8 au total).

Requête
Réponse

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, clearinghouse, coin, size, entry_notional, margin, funding_alltime, snapshot_time FROM hyperliquid_clearinghouse_states WHERE block_number = (SELECT max(block_number) FROM hyperliquid_clearinghouse_states) AND toFloat64(size) != 0 ORDER BY abs(toFloat64(entry_notional)) DESC LIMIT 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "user",
            "type": "FixedString(42)"
        }
    ],
    "data": [
        {
            "user": "0xa5b0edf6b55128e0ddae8e51ac538c3188401d41",
            "clearinghouse": 0,
            "coin": "ETH",
            "size": 700006729,
            "entry_notional": 150410827993161,
            "margin": 55,
            "funding_alltime": 1244698606827,
            "snapshot_time": "2026-04-02 14:30:19.000000"
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 233687,
    "statistics": {
        "elapsed": 0.800346543,
        "rows_read": 233701,
        "bytes_read": 21554450
    }
}

Questions relatives au portefeuille et aux positions

Suivre les portefeuilles des utilisateurs, leurs positions, les avoirs en dépôt, les sous-comptes et les autorisations des mandataires.

Soldes ponctuels par adresse

Soldes des jetons issus du dernier instantané ABCI (remplacer l'adresse).

Requête
Réponse

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, token_idx, total, escrowed, snapshot_time FROM hyperliquid_spot_clearinghouse_states WHERE user = lower('0xYOUR_ADDRESS_HERE') AND block_number = (SELECT max(block_number) FROM hyperliquid_spot_clearinghouse_states) AND toFloat64(total) != 0 ORDER BY abs(toFloat64(total)) DESC",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "token",
            "type": "LowCardinality(String)"
        }
    ],
    "data": [],
    "rows": 0,
    "rows_before_limit_at_least": 0,
    "statistics": {
        "elapsed": 0.778542534,
        "rows_read": 26,
        "bytes_read": 1040
    }
}

Fonds propres des déposants de la chambre forte

Principaux déposants du coffre-fort, classés selon leur part de participation.

Requête
Réponse

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 toFloat64(ownership_fraction) DESC LIMIT 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "vault_name",
            "type": "String"
        }
    ],
    "data": [
        {
            "vault_name": "Less Than Zero",
            "depositor": "0x3540690b1d60e3e78eb01d51a4ceea482bd4e4eb",
            "ownership_fraction": 1.0000000000003275,
            "net_deposits": 88408429204,
            "leader": "0x3540690b1d60e3e78eb01d51a4ceea482bd4e4eb",
            "leader_commission": 0.1,
            "snapshot_time": "2026-04-02 14:42:33.000000"
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 140522,
    "statistics": {
        "elapsed": 0.569249661,
        "rows_read": 140538,
        "bytes_read": 21398893
    }
}

Mappages des sous-comptes

Relations entre les sous-comptes et le compte principal.

Requête
Réponse

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 sub_account, master_account, name, snapshot_time FROM hyperliquid_sub_accounts WHERE master_account = lower('0xYOUR_ADDRESS_HERE') AND block_number = (SELECT max(block_number) FROM hyperliquid_sub_accounts) ORDER BY name",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "sub_account",
            "type": "FixedString(42)"
        },
        {
            "name": "master_account",
            "type": "FixedString(42)"
        },
        {
            "name": "name",
            "type": "Nullable(String)"
        },
        {
            "name": "snapshot_time",
            "type": "DateTime64(6, 'UTC')"
        }
    ],
    "data": [],
    "rows": 0,
    "rows_before_limit_at_least": 0,
    "statistics": {
        "elapsed": 0.208091355,
        "rows_read": 20,
        "bytes_read": 800
    }
}

Recherches de bots/agents

Déterminez quel bot ou quelle application a envoyé des ordres de trading pour un utilisateur.

Requête
Réponse

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 agent, user, name, valid_until, snapshot_time FROM hyperliquid_agents WHERE user = lower('0xYOUR_ADDRESS_HERE') AND block_number = (SELECT max(block_number) FROM hyperliquid_agents) ORDER BY name",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "agent",
            "type": "FixedString(42)"
        },
        {
            "name": "user",
            "type": "FixedString(42)"
        },
        {
            "name": "name",
            "type": "String"
        },
        {
            "name": "valid_until",
            "type": "String"
        },
        {
            "name": "snapshot_time",
            "type": "DateTime64(6, 'UTC')"
        }
    ],
    "data": [],
    "rows": 0,
    "rows_before_limit_at_least": 0,
    "statistics": {
        "elapsed": 1.429104982,
        "rows_read": 30,
        "bytes_read": 1200
    }
}

Recherches par nom d'affichage

Convertir les adresses en noms d'affichage lisibles par l'utilisateur.

Requête
Réponse

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 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "user",
            "type": "FixedString(42)"
        }
    ],
    "data": [
        {
            "user": "0x97853a9876c539740601578de767413019a1bfd7",
            "display_name": "$500k -> $5M",
            "snapshot_time": "2026-04-02 14:42:33.000000"
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 2161,
    "statistics": {
        "elapsed": 0.004191518,
        "rows_read": 10809,
        "bytes_read": 220981
    }
}

Affichage complet du portefeuille

Portefeuille unifié regroupant les actifs à durée indéterminée, les actifs au comptant, les coffres-forts et le staking (remplacer l'adresse).

Requête
Réponse

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 'perps' AS type, coin AS asset, toFloat64(size) AS amount, toFloat64(entry_notional) AS extra FROM hyperliquid_clearinghouse_states WHERE user = lower('0xYOUR_ADDRESS_HERE') AND block_number = (SELECT max(block_number) FROM hyperliquid_clearinghouse_states) AND toFloat64(size) != 0 UNION ALL SELECT 'spot', token, toFloat64(total), toFloat64(escrowed) FROM hyperliquid_spot_clearinghouse_states WHERE user = lower('0xYOUR_ADDRESS_HERE') AND block_number = (SELECT max(block_number) FROM hyperliquid_spot_clearinghouse_states) AND toFloat64(total) != 0 UNION ALL SELECT 'vault', vault_name, toFloat64(ownership_fraction) * 1000000, toFloat64(net_deposits) FROM hyperliquid_vault_equities WHERE depositor = lower('0xYOUR_ADDRESS_HERE') AND block_number = (SELECT max(block_number) FROM hyperliquid_vault_equities) UNION ALL SELECT 'delegation', validator, toFloat64(reward), toFloat64(commission_bps) FROM hyperliquid_delegator_rewards WHERE delegator = lower('0xYOUR_ADDRESS_HERE') AND block_number = (SELECT max(block_number) FROM hyperliquid_delegator_rewards)",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "type",
            "type": "String"
        }
    ],
    "data": [],
    "rows": 0,
    "rows_before_limit_at_least": 0,
    "statistics": {
        "elapsed": 0.578220101,
        "rows_read": 55411,
        "bytes_read": 2327164
    }
}

Récompenses des délégataires par adresse

Récompenses de délégation en attente pour une adresse spécifique (remplacer l'adresse).

Requête
Réponse

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 delegator, validator, reward, commission_bps, snapshot_time, block_number FROM hyperliquid_delegator_rewards WHERE delegator = lower('0xYOUR_ADDRESS_HERE') AND block_number = (SELECT max(block_number) FROM hyperliquid_delegator_rewards) ORDER BY toFloat64(reward) DESC",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "delegator",
            "type": "FixedString(42)"
        }
    ],
    "data": [],
    "rows": 0,
    "rows_before_limit_at_least": 0,
    "statistics": {
        "elapsed": 0.006635673,
        "rows_read": 55353,
        "bytes_read": 2324844
    }
}

Historique de la Commission des validateurs

Suivre l'évolution des taux de commission d'un validateur au fil du temps.

Requête
Réponse

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, snapshot_time, commission_bps, count() AS delegator_count, sum(reward) AS total_pending_rewards FROM hyperliquid_delegator_rewards WHERE validator = lower('0xYOUR_VALIDATOR_HERE') GROUP BY block_number, snapshot_time, commission_bps ORDER BY block_number DESC LIMIT 50",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "block_number",
            "type": "UInt64"
        }
    ],
    "data": [],
    "rows": 0,
    "rows_before_limit_at_least": 0,
    "statistics": {
        "elapsed": 0.590499696,
        "rows_read": 10002172,
        "bytes_read": 420100936
    }
}

Question des constructeurs

Interroger les indicateurs d'activité de l'application front-end et de répartition des commissions des créateurs.

Activité des constructeurs (24 h)

Volume de transactions de Builder (front-end).

Requête
Réponse

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(toFloat64(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 50",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "builder",
            "type": "String"
        }
    ],
    "data": [
        {
            "builder": "0x1924b8561eef20e70ede628a296175d358be80e5",
            "builder_name": "",
            "tx_count": 48094,
            "total_fees": 29305.855998380048,
            "unique_users": 1691
        }
    ],
    "rows": 50,
    "rows_before_limit_at_least": 278,
    "statistics": {
        "elapsed": 0.194171892,
        "rows_read": 951391,
        "bytes_read": 76361419
    }
}

Volume de remplissage du générateur (24 h)

Volume de transactions acheminé via des applications de création d'applications (Phantom, Based, etc.).

Requête
Réponse

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(toFloat64(price) * toFloat64(size)) AS volume_usd, sum(toFloat64(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 50",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "builder_address",
            "type": "Nullable(FixedString(42))"
        }
    ],
    "data": [
        {
            "builder_address": "0xb84168cf3be63c6b8dad05ff5d755e97432ff80b",
            "fills": 55195,
            "volume_usd": 141339420.055671,
            "total_builder_fees": 70669.68466700001,
            "unique_users": 4417
        }
    ],
    "rows": 50,
    "rows_before_limit_at_least": 278,
    "statistics": {
        "elapsed": 0.495007795,
        "rows_read": 1390102,
        "bytes_read": 160073988
    }
}

Requêtes d'analyse

Accédez à des données analytiques pré-agrégées concernant les taux de financement, les liquidations, l'OHLCV et les indicateurs à l'échelle de la plateforme.

Récapitulatif des taux de financement (par heure)

Taux de financement horaires pré-agrégés par cryptomonnaie.

Requête
Réponse

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(toFloat64(avg_funding_rate)) DESC LIMIT 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "coin",
            "type": "LowCardinality(String)"
        }
    ],
    "data": [
        {
            "coin": "REZ",
            "hour": "2026-04-02 14:00:00",
            "avg_funding_rate": -0.0039691826,
            "total_funding": -0.00001,
            "unique_users": 234
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 7413,
    "statistics": {
        "elapsed": 0.002733238,
        "rows_read": 12067,
        "bytes_read": 462982
    }
}

Statistiques horaires sur les liquidations

Nombre de liquidations et volume horaires pré-agrégés, par cryptomonnaie.

Requête
Réponse

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 hour, coin, liquidation_count, liquidated_volume, unique_liquidated_users FROM hyperliquid_liquidations_hourly ORDER BY hour DESC, toFloat64(liquidated_volume) DESC LIMIT 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "hour",
            "type": "DateTime"
        }
    ],
    "data": [
        {
            "hour": "2026-04-02 14:00:00",
            "coin": "vntl:SEMIS",
            "liquidation_count": 10,
            "liquidated_volume": 162.00678703213836,
            "unique_liquidated_users": 2
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 834,
    "statistics": {
        "elapsed": 0.004862589,
        "rows_read": 81207,
        "bytes_read": 3069577
    }
}

OHLCV horaire

Données pré-agrégées sous forme de graphiques en chandeliers horaires, par cryptomonnaie.

Requête
Réponse

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",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "coin",
            "type": "LowCardinality(String)"
        }
    ],
    "data": [
        {
            "coin": "BTC",
            "hour": "2026-04-02 14:00:00",
            "volume": 32.26484136219877,
            "trade_count": 63,
            "high": 66790,
            "low": 66771,
            "open": 66790,
            "close": 66771
        }
    ],
    "rows": 27,
    "rows_before_limit_at_least": 27,
    "statistics": {
        "elapsed": 0.004602843,
        "rows_read": 8489,
        "bytes_read": 805413
    }
}

Indicateurs quotidiens par pièce

Volume, ordres exécutés, traders, frais et liquidations par cryptomonnaie et par jour.

Requête
Réponse

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 100",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "day",
            "type": "Date"
        }
    ],
    "data": [
        {
            "day": "2026-04-02",
            "coin": "PEOPLE",
            "volume_usd": 169.72156923975336,
            "fill_count": 1579,
            "unique_traders": 1399,
            "fees": 11.555258,
            "liquidations": 0,
            "high_price": 7.176878,
            "low_price": 7.176065
        }
    ],
    "rows": 100,
    "rows_before_limit_at_least": 1175,
    "statistics": {
        "elapsed": 0.005491583,
        "rows_read": 109908,
        "bytes_read": 9888747
    }
}

Aperçu quotidien de la plateforme

Volume quotidien, ordres exécutés, traders et frais à l'échelle de la plateforme.

Requête
Réponse

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 30",
  "clusterId": "hyperliquid-core-mainnet"
}'

{
    "meta": [
        {
            "name": "day",
            "type": "Date"
        }
    ],
    "data": [
        {
            "day": "2026-04-02",
            "total_volume_usd": 115.36229420869988,
            "total_fills": 1898,
            "active_traders": 327,
            "total_fees": 521.39143126,
            "liquidation_count": 0,
            "liquidation_volume_usd": 0,
            "coins_traded": 95,
            "total_builder_fees": 83.9536831,
            "builder_fill_count": 159
        }
    ],
    "rows": 30,
    "rows_before_limit_at_least": 37,
    "statistics": {
        "elapsed": 0.004047165,
        "rows_read": 379,
        "bytes_read": 37017
    }
}

Ressources supplémentaires

Pour plus d'informations sur l'utilisation de l'API REST de SQL Explorer :

Présentation de l'API REST - Découvrez l'authentification, l'envoi de requêtes et les formats de réponse
Tableau de bord SQL Explorer - Testez vos requêtes avant de les intégrer à votre code

Nous ❤️ les commentaires !

Si vous avez des commentaires ou des questions concernant cette documentation, faites-le nous savoir. Nous serions ravis de vous entendre !

Aperçu​

Questions relatives au trading​

Transactions récentes​

Volume par cryptomonnaie (24 h)​

Transactions des « baleines » (24 h)​

Transactions DEX (affichage détaillé)​

Requêtes d'activité​

Volume horaire​

Volume quotidien​

Meilleurs traders en volume (7 jours)​

Réponses aux requêtes​

Derniers remplissages​

Liquidations récentes​

Questions relatives aux commandes​

Commandes récentes​

Répartition par type de commande (1 h)​

Questions relatives au financement​

Derniers versements de subventions​

Historique des taux de financement par cryptomonnaie​

Questions relatives aux infrastructures​

Activité du bloc​

Transactions récentes​

Répartition par type d'action (24 h)​

Requêtes sur le registre​

Transferts d'actifs récents​

Volume des transferts par type (7 jours)​

Mises à jour récentes du registre​

Dépôts et retraits via Bridge​

Questions sur les marchés​

Marchés perpétuels​

Marchés au comptant​

Contexte de marché (derniers développements)​

Cours Oracle (tous les DEX)​

Principaux postes à pourvoir (toutes les bourses)​

Questions relatives au portefeuille et aux positions​

Soldes ponctuels par adresse​

Fonds propres des déposants de la chambre forte​

Mappages des sous-comptes​

Recherches de bots/agents​

Recherches par nom d'affichage​

Affichage complet du portefeuille​

Récompenses des délégataires par adresse​

Historique de la Commission des validateurs​

Question des constructeurs​

Activité des constructeurs (24 h)​

Volume de remplissage du générateur (24 h)​

Requêtes d'analyse​

Récapitulatif des taux de financement (par heure)​

Statistiques horaires sur les liquidations​

OHLCV horaire​

Indicateurs quotidiens par pièce​

Aperçu quotidien de la plateforme​

Ressources supplémentaires​

Nous ❤️ les commentaires !​

Aperçu

Questions relatives au trading

Transactions récentes

Volume par cryptomonnaie (24 h)

Transactions des « baleines » (24 h)

Transactions DEX (affichage détaillé)

Requêtes d'activité

Volume horaire

Volume quotidien

Meilleurs traders en volume (7 jours)

Réponses aux requêtes

Derniers remplissages

Liquidations récentes

Questions relatives aux commandes

Commandes récentes

Répartition par type de commande (1 h)

Questions relatives au financement

Derniers versements de subventions

Historique des taux de financement par cryptomonnaie

Questions relatives aux infrastructures

Activité du bloc

Transactions récentes

Répartition par type d'action (24 h)

Requêtes sur le registre

Transferts d'actifs récents

Volume des transferts par type (7 jours)

Mises à jour récentes du registre

Dépôts et retraits via Bridge

Questions sur les marchés

Marchés perpétuels

Marchés au comptant

Contexte de marché (derniers développements)

Cours Oracle (tous les DEX)

Principaux postes à pourvoir (toutes les bourses)

Questions relatives au portefeuille et aux positions

Soldes ponctuels par adresse

Fonds propres des déposants de la chambre forte

Mappages des sous-comptes

Recherches de bots/agents

Recherches par nom d'affichage

Affichage complet du portefeuille

Récompenses des délégataires par adresse

Historique de la Commission des validateurs

Question des constructeurs

Activité des constructeurs (24 h)

Volume de remplissage du générateur (24 h)

Requêtes d'analyse

Récapitulatif des taux de financement (par heure)

Statistiques horaires sur les liquidations

OHLCV horaire

Indicateurs quotidiens par pièce

Aperçu quotidien de la plateforme

Ressources supplémentaires

Nous ❤️ les commentaires !