Table Details
| 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 Variational Omni user USDC collateral movement on Arbitrum. action_type distinguishes a deposit from a withdrawal.
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. |
| action_type | VARCHAR(16777216) | Direction of the collateral movement: deposit or withdrawal. |
| event_name | VARCHAR(16777216) | Source event name: Deposited or Withdrawn. |
| pool_address | VARCHAR(42) | Settlement pool the collateral moved through. |
| 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. |
Sample Query
SELECT *
FROM arbitrum.perpetuals.user_actions
WHERE block_timestamp >= '2026-07-01'
LIMIT 100;