[Supanode](https://supanode.xyz/)[Learn](https://supanode.xyz/learn)Query Hyperliquid fills without confusing trades and orders

# Query Hyperliquid fills without confusing trades and orders

Use the documented fill table, time partition and aggregation level for reproducible analysis.

**On this page**[One order can produce several fills](https://supanode.xyz/learn/query-hyperliquid-fills#one-order-can-produce-several-fills)[A bounded Supanode SQL example](https://supanode.xyz/learn/query-hyperliquid-fills#a-bounded-supanode-sql-example)[Define the unit of analysis](https://supanode.xyz/learn/query-hyperliquid-fills#define-the-unit-of-analysis)[Know what a fill table cannot answer](https://supanode.xyz/learn/query-hyperliquid-fills#know-what-a-fill-table-cannot-answer)[Sources](https://supanode.xyz/learn/query-hyperliquid-fills#sources)

## One order can produce several fills

A fill records executed trading activity. It differs from an order request, an order update and a complete order-book state. Summing fills can measure executed notional, but it does not reconstruct every resting order or establish the price available before a trade.

## A bounded Supanode SQL example

```
SELECT coin, count() AS fills, sum(price * size) AS notional
FROM hyperliquid.raw_node_fills_by_block
PREWHERE utc_fill_dt = toDate('2026-10-01')
GROUP BY coin
ORDER BY notional DESC
LIMIT 20
```

The table and partition column follow Supanode's Hyperliquid Indexer Docs. Use provisioned credentials from environment variables and confirm the requested date is inside current coverage. The example performs no account action.

## Define the unit of analysis

1.  Choose fill-level or order-level analysis before joining tables.
2.  Keep market identifiers, side and maker/taker interpretation consistent.
3.  Use the documented timestamps and within-block ordering fields when event order matters.
4.  Inspect liquidation, TWAP and builder-related columns only over periods where those fields are populated.

## Know what a fill table cannot answer

A fill dataset does not automatically contain a funding-rate time series or an order-level book at each moment. Supanode documents its fill database and separately provisioned book archive as distinct components. Use the appropriate source for each hypothesis, and compare sample counts against a second official source where its retention permits.

## Sources

-   [Supanode Hyperliquid Indexer](https://supanode.xyz/docs/hyperliquid/indexer)
-   [Supanode Hyperliquid schema](https://supanode.xyz/docs/hyperliquid/tables)
-   [Hyperliquid official Info API](https://hyperliquid.gitbook.io/hyperliquid-docs/for-developers/api/info-endpoint)
-   [ClickHouse PREWHERE](https://clickhouse.com/docs/sql-reference/statements/select/prewhere)

## Continue reading

[Hyperliquid WebSocket guide](https://supanode.xyz/blog/hyperliquid-websocket-api)[Hyperliquid Indexer Docs](https://supanode.xyz/docs/hyperliquid/indexer)[Learn library](https://supanode.xyz/learn)

---
Source: https://supanode.xyz/learn/query-hyperliquid-fills