Billions of Onchain Data Records,
Queryable with SQL

-- 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_user

curl -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
  }]
}