Table Details
| Property | Value |
|---|---|
| Table Name | megaeth.perpetuals.trades |
| Table Status | Beta 🌱 |
| Unique Key | block_timestamp, unique_id |
| Clustering Key(s) | block_timestamp::date, action |
| Search Optimization | transaction_hash, project, trader |
Table Columns
| 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 added on an increase or returned on a decrease, in USD. 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. |
Sample Query
SELECT *
FROM megaeth.perpetuals.trades
WHERE block_date = '2026-07-23'
LIMIT 100;