Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
| Property | Value |
|---|---|
| Table Name | arbitrum.perpetuals.trades |
| Table Status | Beta 🌱 |
| Unique Key | block_timestamp, unique_id |
| Clustering Key(s) | block_timestamp::date, action |
| Search Optimization | transaction_hash, project, trader |
SELECT *
FROM arbitrum.perpetuals.trades
WHERE project = 'ostium'
LIMIT 10;
market_symbol; market_address and asset_address are null because many supported real-world markets have no token contract. Ostium trades rows are opens, closes, and liquidations. Collateral top-ups, collateral removals, and take-profit / stop-loss updates are not separate trades rows.
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR(16777216) | The perpetuals project. |
| protocol | VARCHAR(16777216) | The specific protocol within the project. |
| version | VARCHAR(16777216) | Protocol version. |
| chain | VARCHAR(16777216) | Blockchain network. |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the event. |
| block_date | DATE | Calendar date of the event (UTC). |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. |
| log_index | NUMBER(38,0) | Zero-based position of this event log within its transaction. |
| unique_id | VARCHAR(16777216) | Unique identifier for the row. |
| trader | VARCHAR(42) | Wallet address that owns the position. |
| market_address | VARCHAR(42) | Contract address of the perpetuals market. |
| market_symbol | VARCHAR(16777216) | Symbol of the underlying market asset. |
| asset_address | VARCHAR(42) | Address of the underlying market asset. |
| side | VARCHAR(16777216) | Position side: long or short. |
| action | VARCHAR(16777216) | Event type: increase, decrease, or liquidation. |
| size_usd | NUMBER(38,6) | Notional size change of the position in USD. For a liquidation, the position size closed. |
| price_usd | NUMBER(38,6) | Underlying asset price in USD at the event. |
| collateral_usd | NUMBER(38,6) | Collateral opened or closed by the event, in USD. Ostium liquidations include the collateral closed. Other protocols may leave this null on liquidations. |
| pnl_usd | NUMBER(38,6) | Realized profit or loss in USD. Null on increases. |
| fee_usd | NUMBER(38,6) | Total fee for the event in USD. |
| extra_fields | VARIANT | Protocol-specific detail, including the fee breakdown, position keys, and collateral flows. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
Was this page helpful?