Query 385B+ indexed Hyperliquid records. Retrieve results via REST. No pipelines. No additional vendors. All on Quicknode.
Rows Scanned Per Query
Rows · Hyperliquid
Sample Queries
Trading desks, quant teams, and data engineers all face the same bottleneck.
Getting to indexed onchain data without managing multiple data vendors or maintaining the infrastructure required to reach it.
So we built SQL Explorer.
Direct SQL access to indexed Hyperliquid data. Query trades, orders, positions, liquidations, and more. Start from 40+ pre-built queries or write your own, then retrieve results via REST.
| 1 | SELECT |
| 2 | timestamp, |
| 3 | coin, |
| 4 | side, |
| 5 | price, |
| 6 | size, |
| 7 | price * size AS notional_usd, |
| 8 | buyer_address, |
| 9 | seller_address, |
| 10 | buyer_fee, |
| 11 | seller_fee, |
| 12 | fee_token |
| 13 | FROM hyperliquid_trades |
| 14 | WHERE block_time > now() - INTERVAL 1 HOUR |
| 15 | ORDER BY block_number DESC, trade_id DESC |
| # | timestamp | coin | side | price | size | notional_usd | buyer_addr |
|---|---|---|---|---|---|---|---|
| 1 | 2026-03-26 15:27:42.406 | AZTEC | A | 0.019959 | 848 | 16.925232 | 0x4a6e4878… |
| 2 | 2026-03-26 15:27:42.406 | cash:HOOD | A | 70.782 | 0.707 | 50.042874 | 0x9badff1e… |
| 3 | 2026-03-26 15:27:42.406 | cash:HOOD | A | 70.782 | 0.707 | 50.042874 | 0xcee1cc9b… |
| 4 | 2026-03-26 15:27:42.406 | ETH | A | 2,065.1 | 2.0458 | 141.393… | 0xb6a766f5… |
| 5 | 2026-03-26 15:27:42.330 | cash:MSFT | A | 370.52 | 0.134 | 49.64968 | 0xcee1cc9b… |
| 6 | 2026-03-26 15:27:42.330 | cash:MSFT | A | 370.52 | 0.134 | 49.64968 | 0x9badff1e… |
| 7 | 2026-03-26 15:27:42.330 | ARK | A | 0.16736 | 112 | 18.74432 | 0x7717a7a2… |
SQL Explorer turns any query into a REST endpoint. No ETL, no transformation logic, no additional infrastructure. Just results your systems can consume directly.
-- Hyperliquid liquidation summary: last 24h
SELECT
count() AS total_liquidations,
toFloat64(sum(toFloat64(price) * toFloat64(size)))
AS total_liquidated_volume_usd,
countDistinct(liquidated_user) AS unique_users_liquidated,
countDistinct(coin) AS coins_affected,
countIf(side = 'A') AS long_liquidations,
countIf(side = 'B') AS short_liquidations
FROM hyperliquid_fills
WHERE is_liquidation = 1
AND time >= now() - INTERVAL 24 HOUR
AND user = liquidated_usercurl -X POST \
'https://api.quicknode.com/sql/rest/v1/query' \
-H 'x-api-key: YOUR_API_KEY' \
-H 'Content-Type: application/json' \
-d '{
"query": "...",
"clusterId": "hyperliquid-core-mainnet"
}'{
"data": [{
"total_liquidations": 4954,
"total_liquidated_volume_usd": 28872094.94,
"unique_users_liquidated": 2013,
"coins_affected": 76,
"long_liquidations": 4015,
"short_liquidations": 939
}]
}Connect results directly to your trading systems, dashboards, internal workflows, or AI agents.
From funding rate analysis to liquidation monitoring to wallet intelligence, SQL Explorer gives you direct access to the data that matters.
Track staking rewards and distribution across validators over any time window.
Analyze fill history, volume, and execution patterns for any wallet address.
Monitor liquidation notional and position sizing by asset across any time range.
SQL Explorer is part of Quicknode's full data suite. Access, stream, and query blockchain data your way, without additional vendors.
Fully indexed onchain datasets, queryable with SQL and retrievable via REST.
Push-based, deterministic event delivery into your backend systems.
Direct chain access for real-time state reads and transaction submission.
The coverage, performance, and integration your team needs, without the data management overhead.
| SQL Explorer (Beta) | Typical Analytics Platforms | |
|---|---|---|
| Infrastructure required | None — runs inside Quicknode | Separate vendor and integration work |
| Query performance | Scans 55M+ rows and GBs per query | Varies, often queue-dependent |
| Hyperliquid coverage | 35+ tables covering protocol activity | Limited or unavailable |
| API access | REST API for any query result | Often limited or plan dependent |
| Billing | Metered from your existing Quicknode credit pool | Separate contracts and pricing |
| Auth and access | Same Quicknode account and API keys | Separate identity systems |
Built for institutional trading desks and quant teams who need production-grade onchain data access. Share what you're working on below..
With our easy-to-use platform and robust documentation, you will have all the answers you need. Our support team is available for you.Still have unanswered questions?
Please reach out to support and we can help you find answers.
What is SQL Explorer?
How is SQL Explorer different from Streams?
How is SQL Explorer different from RPC?
What data is currently available?
How does the REST API work?
How does billing work?
Is SQL Explorer production ready?
🤖 Blockchain Infrastructure for AI AgentsConnect your agents now
Start building