Fills

The hyperliquid.raw.fills table contains raw fill data for all trades that are executed on Hyperliquid (spot and perpetuals). To get spot pair names (e.g. HYPE/USDC), join coin to hyperliquid.raw.spot_coin_pairs on fills.coin = spot_coin_pairs.name. See Spot Coin Pairs.

Joining fills with spot coin pairs

For spot fills, coin is an identifier (e.g. @107) rather than a symbol. Join to hyperliquid.raw.spot_coin_pairs to resolve it to a pair (e.g. HYPE/USDC). Perpetual fills use the symbol directly in coin (e.g. HYPE); the join will leave pair/token columns null for those rows.

Table Columns

Column Name	Description
timestamp	The UTC timestamp of the fill.
user	The user of the order that was executed.
builder_fee	The fee paid to the builder in fee_token amount.
closed_pnl	The closed PnL of the fill in USD amount.
coin	The coin of the fill. For perpetuals this is the symbol (e.g. HYPE). For spot this is an ID representing a pair (e.g. @4). Join to `hyperliquid.raw.spot_coin_pairs` on `coin = name` to get `pair`, `token_a_symbol`, `token_b_symbol`.
dir	The direction of the fill.
fee	The fee paid to Hyperliquid in the fee_token amount.
fee_token	The token of the fee.
hash	The hash of the fill.
liquidation	Variant fill with liquidation details if this was a liquidation.
order_id	The order ID of the fill.
price	The price of the fill.
side	The side of the fill. A or B, where B = Buy, A = Ask (Sell).
size	The size of the fill.
start_position	The start position of the fill.
trade_id	The trade ID of the fill.
crossed	Whether the fill was crossed.
hip3_deployer_fee	The HIP-3 deployer fee in fee_token amount. Applicable for perpetual markets deployed via HIP-3.

Sample Query

SELECT
    f.timestamp,
    f.user,
    f.coin,
    p.pair,
    p.token_a_symbol,
    p.token_b_symbol,
    f.side,
    f.size,
    f.price
FROM hyperliquid.raw.fills f
LEFT JOIN hyperliquid.raw.spot_coin_pairs p ON f.coin = p.name
WHERE f.timestamp >= CURRENT_DATE - 7
ORDER BY f.timestamp DESC
LIMIT 100

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Joining fills with spot coin pairs

Table Columns

Sample Query

​Joining fills with spot coin pairs

​Table Columns

​Sample Query

Joining fills with spot coin pairs

Table Columns

Sample Query