Instrument code examples:
ETH-USDC.HLPERP.HL (Hyperliquid), NVDA-USDC.XYZ.HLPERP.HL (Hyperliquid HIP-3 sub-dex xyz), BTC-USDC.LIGHTER (Lighter), ETH-USDG.LIGHTER.LRHC (Lighter Robinhood).
Format: perp-trades.json.v1. History: dune.dune.historical_perp_trades, which also holds Kalshi perpetuals trades. Kalshi has no live public endpoint.
Coverage
One day of history, 2026-11-17, fromhistorical_perp_trades. Counts change from day to day.
Hyperliquid includes HIP-3 builder markets; their sub-dex is in
venue.dex. Lighter includes only linear perpetual markets with the deployment’s quote asset (USDC on Lighter, USDG on Lighter Robinhood). Spot fills are not in the feed. To browse instruments, open the instrument explorer.
Message envelope
Trade fields
Quantities and prices are exact decimal strings, for example"1744.1". They have no exponent, and trailing zeros come from the venue. Compare them as numbers.
Parties
Venue notes
- Hyperliquid:
value_usdis computed by Dune from an oracle price. A TWAP slice carriestwap_idon one side. Backstop liquidations havemechanism: system; auto-deleverage rows havekind: deleverage. - Lighter: parties are venue account numbers (
addressisnull).value_usd.sourceisvenue_reported: the USD amount Lighter reports.tx.hashis 80 hex characters without0x.
Example
Hyperliquid, captured on 19 November 2026:Compatibility
Version 1 changes only by addition: new optional fields, new enum values, new venues. Any other change ships asperp-trades.json.v2. Keep unknown enum values instead of rejecting them.
History
dune.dune.historical_perp_trades has one row per trade. Party fields are flattened with taker_ and maker_ prefixes, for example taker_fee and maker_position_effect.
On 19 November 2026, every venue had a partition for every day from its first day to 2026-11-18. Known gaps, such as four Lighter blocks that Dune holds back because Lighter reports invalid rows in them, are listed in the data caveats below.
Kalshi notes: a block is one second of trades. Kalshi quotes per contract; Dune converts
size and executed_price to base units. Kalshi’s public tape has no parties and no liquidation marker.
DuneSQL
Known data caveats
- Four Lighter blocks are missing from history: 61656974, 61657213 and 61657799 (2025-10-10) and 83816295 (2025-11-04).
- Lighter trades before 2025-12-22 have
executed_atequal to the block time, because Lighter’s export has no transaction time for them. - From September to October 2026, eight Lighter markets were sent live under a second listing id (
<id>~1) and code (for exampleRAY2-USDC.LIGHTER). History uses the original id and code.