Historical

Schemas

Column reference for every archive dataset. Raw event tables carry the live stream's exact field set plus two archive columns (height, block_time). Backtest on history, deploy on the feed, zero remapping. The same names work in the query API, database access, and exports.

Conventions

Financial values (prices, sizes, notionals, PnL, fees) are byte-exact decimal strings, never floats. They reconcile to the chain and to the live streams character-for-character.
Sides are B (buy/bid) and A (sell/ask); market symbols cover perps (BTC), spot (@N), and HIP-3 (dex:SYMBOL).
Every raw table is ordered and partitioned by time. Filter block_time (and coin where present) before anything else.

trades

One row per executed fill, currently growing by ~6.5M rows a day. Full wallet attribution: trader address, position context, realized PnL, fees, maker/taker, and liquidation linkage on every row.

Field	Type	Description
height	uint64	L1 block height the event was produced in. Rows are ordered by height; joins across datasets use it.
block_time	datetime64(3)	Block timestamp, millisecond precision, UTC. The partitioning column; filter on it first.
coin	string	Market symbol (perp, spot @N, or HIP-3 dex:SYMBOL).
px	string	Fill price.Byte-exact decimal string, never a float.
sz	string	Fill size in base units.Byte-exact decimal string.
notional	string	Fill notional in USDC.Byte-exact decimal string.
side	string	Aggressor side: B (buy) or A (sell).
user	string	Trader's wallet address. Full attribution on every fill.
dir	string	Position context: Open Long, Close Short, etc.
start_position	string	Trader's position before the fill.Byte-exact decimal string.
closed_pnl	string	Realized PnL closed by this fill.Byte-exact decimal string.
fee	string	Fee paid (negative when rebated).Pair with is_rebate.
is_rebate	bool	True when the fee is a maker rebate.
crossed	bool	True if this side crossed the book (taker).
oid / cloid / tid	uint64 / string / uint64	Order id, client order id, and trade id.
twap_id	uint64?	Set when the fill belongs to a native TWAP execution.
liquidation	object?	Liquidation details (liquidated user, mark price) when applicable.

Live equivalent: Trades & swaps. The liquidation object is preserved as a nested column; for flat liquidation analysis use the liquidations derived table below.

orders

One row per order-status event: placements, cancels, fills, triggers, rejections. 1.65B+ events archived, ~725M added per day.

Field	Type	Description
height	uint64	L1 block height the event was produced in. Rows are ordered by height; joins across datasets use it.
block_time	datetime64(3)	Block timestamp, millisecond precision, UTC. The partitioning column; filter on it first.
user	string	Wallet that owns the order.
coin	string	Market symbol.
side	string	B (buy) or A (sell).
limit_px	string	Limit price.Byte-exact decimal string.
sz	string	Order size.Byte-exact decimal string.
order_type	string	Limit, trigger (stop/TP), etc.
tif	string	Time-in-force: Gtc, Ioc, Alo.
trigger_px / trigger_condition	string?	Trigger parameters for stop and take-profit orders.
reduce_only	bool	True for reduce-only orders.
status	string	open / filled / canceled / triggered / rejected.
oid / cloid	uint64 / string	Order id and optional client order id.

Live equivalent: Order lifecycle.

book_updates

One row per order-book delta: every change to every book, 1B+ rows and counting. Apply deltas in height order to a snapshot for exact reconstruction at any block.

Field	Type	Description
height	uint64	L1 block height the event was produced in. Rows are ordered by height; joins across datasets use it.
block_time	datetime64(3)	Block timestamp, millisecond precision, UTC. The partitioning column; filter on it first.
update_type	enum	NEW / UPDATE / MODIFIED / REMOVE.
coin	string	Market symbol.
oid	uint64	Order id the delta applies to.
user	string	Owner's wallet address.
side	string	B (bid) or A (ask).
px	string	Price of the affected order.Byte-exact decimal string.
sz	string	Size after the change (0 on remove).Byte-exact decimal string.
block_height	uint64	Block the delta belongs to; apply in order.

Live equivalent: Raw book diffs.

top_of_book

One row per best-bid/ask tick per market.

Field	Type	Description
height	uint64	L1 block height the event was produced in. Rows are ordered by height; joins across datasets use it.
block_time	datetime64(3)	Block timestamp, millisecond precision, UTC. The partitioning column; filter on it first.
coin	string	Market symbol.
bid_px	string	Best bid price.Byte-exact decimal string.
bid_sz	string	Size resting at the best bid.Byte-exact decimal string.
ask_px	string	Best ask price.Byte-exact decimal string.
ask_sz	string	Size resting at the best ask.Byte-exact decimal string.

Live equivalent: L2 book subscribed with n_levels: 1.

twaps

One row per TWAP status or progress event. executed_ntl / executed_sz gives the average fill price so far; twap_id joins to the same column on trades.

Field	Type	Description
height	uint64	L1 block height the event was produced in. Rows are ordered by height; joins across datasets use it.
block_time	datetime64(3)	Block timestamp, millisecond precision, UTC. The partitioning column; filter on it first.
twap_id	uint64	TWAP identifier; joins to twap_id on fills.
coin	string	Market symbol.
user	string	Wallet running the TWAP.
side	string	B (buy) or A (sell).
sz	string	Total TWAP size.Byte-exact decimal string.
executed_sz	string	Size executed so far.Byte-exact decimal string.
executed_ntl	string	Notional executed so far; divide by executed_sz for average fill price.Byte-exact decimal string.
minutes	uint32	Configured duration.
status	string	activated / finished / canceled / terminated.

Live equivalent: TWAP algos.

events

One row per ledger or market event: per-user funding payments with the applied rate, liquidations, deposits, withdrawals, and position updates, discriminated by type.

Field	Type	Description
height	uint64	L1 block height the event was produced in. Rows are ordered by height; joins across datasets use it.
block_time	datetime64(3)	Block timestamp, millisecond precision, UTC. The partitioning column; filter on it first.
type	string	funding / liquidation / deposit / withdraw / position update.
user	string	Affected wallet.
coin	string	Market symbol (funding, liquidation).
usdc	string	USDC amount of the event (signed for funding).Byte-exact decimal string.
funding_rate	string	Funding rate applied (funding events).Byte-exact decimal string.
szi	string	Signed position size the payment applied to.Byte-exact decimal string.
liquidation	object?	Liquidated size, price, and mark price (liquidation events).

Live equivalent: Events.

Derived datasets

Precomputed from the raw tables above, refreshed continuously. Use them when the stock shape fits; recompute from raw when it doesn't.

ohlcv_1s / ohlcv_1m / ohlcv_1h / ohlcv_1d

Field	Type	Description
ts	datetime64(3)	Candle open time, UTC, aligned to the interval (1s / 1m / 1h / 1d per table).
coin	string	Market symbol.
open	string	First trade price in the interval.Byte-exact decimal string.
high	string	Highest trade price in the interval.Byte-exact decimal string.
low	string	Lowest trade price in the interval.Byte-exact decimal string.
close	string	Last trade price in the interval.Byte-exact decimal string.
volume	string	Base-asset size traded in the interval.Byte-exact decimal string.

wallet_pnl

Field	Type	Description
user	string	Wallet address.
realized_pnl	string	Realized PnL closed by the wallet's fills over the window.Byte-exact decimal string.
volume	string	Total notional traded.Byte-exact decimal string.
win_rate	float64	Share of PnL-closing fills with positive realized PnL. Statistical, not financial: the one column that is a float.

liquidations

Field	Type	Description
height	uint64	L1 block height the event was produced in. Rows are ordered by height; joins across datasets use it.
block_time	datetime64(3)	Block timestamp, millisecond precision, UTC. The partitioning column; filter on it first.
coin	string	Market the liquidation executed in.
victim	string	Liquidated wallet address.
sz	string	Liquidated size.Byte-exact decimal string.
px	string	Execution price of the liquidation.Byte-exact decimal string.
mark_px	string	Mark price at the time of liquidation.Byte-exact decimal string.

funding

Field	Type	Description
height	uint64	L1 block height the event was produced in. Rows are ordered by height; joins across datasets use it.
block_time	datetime64(3)	Block timestamp, millisecond precision, UTC. The partitioning column; filter on it first.
coin	string	Market symbol.
funding_rate	string	Funding rate applied at this interval.Byte-exact decimal string.