Historical

Schemas

Column reference for the raw captured datasets. 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 with minimal remapping. Use this reference when you request an export.

Conventions

Raw financial values (prices, sizes, notionals, PnL, fees) use decimal strings rather than binary floats. Calculated custom fields are documented with the delivery.
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. Captured rows can include trader address, position context, realized PnL, fees, maker/taker, and liquidation linkage.

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.
tape_sequence	uint64	Monotonic across the whole tape.Two consumers replaying the same range get identical order. This is what makes it a tape rather than a feed.
venue	enum	Which venue printed it.
price	decimal string	USD per token, corporate-action adjusted.
price_per_share	decimal string	USD per underlying share.Both representations, always. Publishing one guarantees a class of errors.
premium_bps_at_print	decimal string	Divergence from the underlying at execution time.
session	enum	REGULAR, PRE_MARKET, POST_MARKET, OVERNIGHT, WEEKEND, HOLIDAY, HALTED.
confirmation_state	enum	SEQUENCED, INCLUDED, FINALIZED, DROPPED, REORGED.
paired_leg_asset	string?	The counter-leg when a stock leg and cash leg share a transaction.

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

transactions

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.
tx_type	enum	Includes Arbitrum types 100–106.
request_id	uint256?	Inbox queue position for cross-chain transactions.
from_is_aliased	bool	True when from is an aliased L1 sender.unaliasedFrom carries the original. Providers that drop this misattribute cross-chain activity.
confirmation_state	enum	SEQUENCED through FINALIZED, plus DROPPED and REORGED.

Live equivalent: Order lifecycle.

book_updates

One row per captured order-book delta. Apply deltas inheight order to a compatible snapshot when rebuilding a book within the available captured range.

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.
address	address	Emitting contract.
topics[]	hash[]	Indexed topics.
decoded	DecodedEvent?	Typed name, signature and parameters.
removed	bool	True when removed by a reorg.

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.
interval	enum	1s, 5s, 1m, 5m, 15m, 1h, 4h, 1d.
open / high / low / close	decimal string	Corporate-action adjusted.
vwap	decimal string	Volume-weighted average price.
crosses_session_boundary	bool	True when this candle spans more than one session.Every OHLCV series published on this chain today silently mixes regimes. Filter on this.
corporate_action_adjusted	bool	OHLC restated; adjusting_action_id names why.

Live equivalent: TWAP algos.

corporate-actions

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.
action_id	string	Stable across the lifecycle. Dedupe on this.
type	enum	FORWARD_SPLIT, REVERSE_SPLIT, CASH_DIVIDEND, STOCK_DIVIDEND, SPIN_OFF, three merger variants, REDEMPTION, NAME_CHANGE, WORTHLESS_REMOVAL, RIGHTS_DISTRIBUTION, UNIT_SPLIT.
stage	enum	ACTION_ANNOUNCED, MULTIPLIER_PENDING, PAUSE_SCHEDULED, PAUSED, MULTIPLIER_APPLIED, UNPAUSED, ACTION_COMPLETED.PAUSE_SCHEDULED is the one that matters: a knowable, advance-warned price discontinuity.
seconds_until_effective	int64	Countdown; negative once applied.
old_multiplier / new_multiplier	decimal string	The change.
details	oneof	Exactly one variant, matching type.

Live equivalent: Events.

Need a calculated schema?

OHLCV, wallet PnL, liquidation, funding, and other derived shapes are custom dataset examples, not precomputed self-serve tables. Include the required fields and calculation rules when you contact us; we confirm the source coverage and return an agreed schema with the scope.