Skip to main content
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 NameDescription
timestampThe UTC timestamp of the fill.
userThe user of the order that was executed.
builder_feeThe fee paid to the builder in USD amount.
closed_pnlThe closed PnL of the fill in USD amount.
coinThe 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.
dirThe direction of the fill.
feeThe fee paid to Hyperliquid in the fee_token amount.
fee_tokenThe token of the fee.
hashThe hash of the fill.
liquidationVariant fill with liquidation details if this was a liquidation.
order_idThe order ID of the fill.
priceThe price of the fill.
sideThe side of the fill. A or B, where B = Buy, A = Ask (Sell).
sizeThe size of the fill.
start_positionThe start position of the fill.
trade_idThe trade ID of the fill.
crossedWhether the fill was crossed.
builder_addressThe builder address associated with this fill (if any).
twap_idThe TWAP order ID if this fill was part of a TWAP order.

​
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