Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
User USDC collateral deposits and withdrawals for Variational Omni and Ostium on Arbitrum.
| Property | Value |
|---|---|
| Table Name | arbitrum.perpetuals.user_actions |
| Table Status | Beta 🌱 |
| Unique Key | block_timestamp, unique_id |
| Clustering Key(s) | block_timestamp::date |
arbitrum.perpetuals.user_actions contains one row per user USDC collateral movement on Arbitrum. Coverage includes Variational Omni settlement-pool deposits and withdrawals and Ostium OLP vault LP deposits and withdrawals. Ostium rows are completed USDC vault LP movements, not trader margin. action_type distinguishes a deposit from a withdrawal. Filter project to 'variational' or 'ostium'.
| 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. |
| action_type | VARCHAR(16777216) | Direction of the collateral movement: deposit or withdrawal. |
| event_name | VARCHAR(16777216) | Protocol event that recorded the deposit or withdrawal. |
| pool_address | VARCHAR(42) | Vault or pool that received or sent the collateral. |
| user_address | VARCHAR(42) | The user: payer for deposits, payee for withdrawals. |
| token_address | VARCHAR(42) | Collateral token address. |
| token_symbol | VARCHAR(16777216) | Collateral token symbol. |
| token_decimals | NUMBER(38,0) | Collateral token decimals. |
| raw_amount_str | VARCHAR(16777216) | Collateral amount in token base units, as a string. |
| amount | NUMBER(38,6) | Collateral amount in token units. |
| usd_amount | NUMBER(38,6) | USD value of the movement. |
| usd_exchange_rate | FLOAT | USD value of one unit of the collateral token. |
| extra_fields | VARIANT | VARIANT column with protocol-specific detail. |
| transaction_hash | VARCHAR(66) | Transaction hash. |
| transaction_index | NUMBER(38,0) | Position of the transaction within the block. |
| transaction_from_address | VARCHAR(42) | Sender of the transaction. |
| transaction_to_address | VARCHAR(42) | Recipient of the transaction. |
| log_index | NUMBER(38,0) | Position of the event log within the block. |
| topic0 | VARCHAR(66) | Event signature hash. |
| block_number | NUMBER(38,0) | Block number containing the event. |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the event. |
| block_hash | VARCHAR(66) | Hash of the block containing the event. |
| unique_id | VARCHAR(16777216) | Unique identifier for the row. |
| _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. |
SELECT *
FROM arbitrum.perpetuals.user_actions
WHERE project = 'ostium'
LIMIT 10;
Was this page helpful?