Trades

The lighter_robinhood.raw.trades table contains raw trade records.

Table Columns

Unique key: timestamp, trade_id

Column Name	Data Type	Description
`trade_id`	`NUMBER(38,0)`	Unique identifier for the trade.
`tx_hash`	`VARCHAR`	On-chain transaction hash.
`type`	`VARCHAR`	Trade event type: `trade`, `liquidation`, or `deleverage`.
`market_id`	`NUMBER(38,0)`	Market this trade belongs to.
`size`	`VARCHAR`	Trade size in base asset units.
`price`	`VARCHAR`	Execution price.
`usd_amount`	`VARCHAR`	USD value of the trade.
`ask_id`	`NUMBER(38,0)`	Order ID of the ask side.
`bid_id`	`NUMBER(38,0)`	Order ID of the bid side.
`ask_client_id`	`NUMBER(38,0)`	Client-assigned order ID for ask side.
`bid_client_id`	`NUMBER(38,0)`	Client-assigned order ID for bid side.
`ask_account_id`	`NUMBER(38,0)`	Account ID of the ask (sell) side.
`bid_account_id`	`NUMBER(38,0)`	Account ID of the bid (buy) side.
`is_maker_ask`	`BOOLEAN`	True if the maker is on the ask side.
`block_height`	`NUMBER(38,0)`	Block height of the trade.
`timestamp`	`TIMESTAMP_NTZ(9)`	UTC timestamp of the trade.
`taker_position_size_before`	`VARCHAR`	Taker’s position size before this trade.
`taker_entry_quote_before`	`VARCHAR`	Taker’s entry quote before this trade.
`taker_initial_margin_fraction_before`	`NUMBER(38,0)`	Taker’s initial margin fraction before this trade.
`maker_fee`	`NUMBER(38,0)`	Maker fee in ppm.
`maker_position_size_before`	`VARCHAR`	Maker’s position size before this trade.
`maker_entry_quote_before`	`VARCHAR`	Maker’s entry quote before this trade.
`maker_initial_margin_fraction_before`	`NUMBER(38,0)`	Maker’s initial margin fraction before this trade.
`transaction_time`	`NUMBER(38,0)`	Unix transaction timestamp in microseconds.
`_created_at`	`TIMESTAMP_NTZ(9)`	Timestamp when the row was first recorded.
`_updated_at`	`TIMESTAMP_NTZ(9)`	Timestamp when the row was last updated.
`transaction_time_ts`	`TIMESTAMP_NTZ(9)`	UTC transaction timestamp.
`taker_fee`	`NUMBER(38,0)`	Taker fee in ppm.
`taker_position_sign_changed`	`BOOLEAN`	Whether taker’s position sign changed.
`maker_position_sign_changed`	`BOOLEAN`	Whether maker’s position sign changed.

Sample Query

SELECT
    trade_id,
    timestamp,
    market_id,
    type,
    size,
    price,
    usd_amount
FROM lighter_robinhood.raw.trades
WHERE timestamp >= CURRENT_DATE - 1
ORDER BY timestamp DESC
LIMIT 100;

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query