> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# cap_v3_arbitrum
> Tables in tt-contracts.cap_v3_arbitrum
## Tables
### Trading\_ClosePosition\_event
Position closure events from Cap Protocol v3 perpetual futures on Arbitrum, including PnL, fees, liquidation status, and product identifiers (ETH-USD, BTC-USD). Used for tracking trader performance and liquidation analysis.
| Column | Type | Description |
| ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_key` | `STRING` | Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_productId` | `STRING` | Identifier for the financial product or trading pair involved in the transaction. Numeric string representation of the product ID in the protocol's internal indexing system. |
| `in_currency` | `STRING` | Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_isLong` | `BOOL` | Boolean flag indicating whether the position is long or short. True represents a long position (betting on price increase), false represents a short position (betting on price decrease). |
| `in_price` | `STRING` | Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision. |
| `in_margin` | `STRING` | Margin amount posted or held for the trading position. String-encoded integer value representing collateral in the smallest unit of the relevant token or currency. |
| `in_size` | `STRING` | Size of the position in the derivative contract. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value. |
| `in_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| `in_pnl` | `STRING` | Profit and loss realized from closing the position. String-encoded integer value representing the net gain or loss in the smallest unit of the relevant token or currency, where negative values indicate losses and positive values indicate profits. |
| `in_wasLiquidated` | `BOOL` | Boolean flag indicating whether the position was liquidated. True when the position was forcibly closed due to insufficient margin, false when voluntarily closed by the user. |
| in\_fee | in\_key | in\_pnl | address | in\_size | in\_user | removed | in\_price | in\_isLong | in\_margin | log\_index | in\_currency | block\_number | in\_productId | block\_timestamp | in\_wasLiquidated | transaction\_hash |
| ------- | ------------------------------------------------------------------ | ------- | ------------------------------------------ | -------- | ------------------------------------------ | ------- | ------------- | ---------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------------------------------ | ------------------------ | ----------------- | ------------------------------------------------------------------ |
| 0 | 0xe18fc0406a25c83b9ab57ee57cdd2957c39949aea6527a82258549cb30ab1887 | -35104 | 0xbed32937d8a5d1421241f52809908f1a17d75bdb | 1000000 | 0xb680a49875b3a47ed2fe621ab3a126b0244af3cb | false | 177221094200 | false | 142857 | 124 | 0x0000000000000000000000000000000000000000 | 19907066 | 0x4554482d55534400000000000000000000000000000000000000000000000000 | 2022-08-10T12:33:19.000Z | false | 0xbcec88c096a35af6471c329fa6afddadad4dd1e52c3fb0ffc4eff669ce72f858 |
| 0 | 0x19a2daa35f3bdbb87f65db9b5368c37c6c11b1608dfa70f89eac29fdc2ea6d1c | -29410 | 0xbed32937d8a5d1421241f52809908f1a17d75bdb | 10000000 | 0x79a5eb64b936446eab7c8a128aa1d033651e17fa | false | 185850050902 | false | 200000 | 2 | 0x0000000000000000000000000000000000000000 | 19945214 | 0x4554482d55534400000000000000000000000000000000000000000000000000 | 2022-08-10T21:40:20.000Z | false | 0x0041f3bfd33459abfa54174884c2dbe1daca56f265942bbcbeac3f69b9a59c5e |
| 0 | 0xbaa150f2aaddc470a68291ea472cef58635edf33d21d55a581e1a3475c942ed6 | 7987 | 0xbed32937d8a5d1421241f52809908f1a17d75bdb | 10000000 | 0x66fde45e27195818eea327daada35adad9e6bd2c | false | 2396321530671 | false | 200000 | 0 | 0x0000000000000000000000000000000000000000 | 19928221 | 0x4254432d55534400000000000000000000000000000000000000000000000000 | 2022-08-10T16:39:19.000Z | false | 0x179284412389b8fc28987fcfd2fdd627aee2a585ba0035c74fdd404cfa81c091 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.cap_v3_arbitrum.Trading_ClosePosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Trading\_PositionUpdated\_event
Position update events from Cap Finance V3 perpetual futures protocol on Arbitrum, capturing margin, size, and direction changes for leveraged positions across trading pairs like ETH-USD. Used for analyzing trader behavior, position sizing, and leverage patterns.
| Column | Type | Description |
| ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_key` | `STRING` | Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_productId` | `STRING` | Identifier for the financial product or trading pair involved in the transaction. Numeric string representation of the product ID in the protocol's internal indexing system. |
| `in_currency` | `STRING` | Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_isLong` | `BOOL` | Boolean flag indicating whether the position is long or short. True represents a long position (betting on price increase), false represents a short position (betting on price decrease). |
| `in_margin` | `STRING` | Margin amount posted or held for the trading position. String-encoded integer value representing collateral in the smallest unit of the relevant token or currency. |
| `in_size` | `STRING` | Size of the position in the derivative contract. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value. |
| `in_price` | `STRING` | Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision. |
| `in_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| in\_fee | in\_key | address | in\_size | in\_user | removed | in\_price | in\_isLong | in\_margin | log\_index | in\_currency | block\_number | in\_productId | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------------------------------ | ------------------------------------------ | ---------- | ------------------------------------------ | ------- | ------------ | ---------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0 | 0x77b39c41bbef3fa6604badfc37689b08085a9e1c90d32d89d2ea436f16e9906f | 0xbed32937d8a5d1421241f52809908f1a17d75bdb | 200000000 | 0x16099dd4a4201a67c9b4916a4fb4322973507d8e | false | 292656350372 | true | 4000000 | 0 | 0x0000000000000000000000000000000000000000 | 7158020 | 0x4554482d55534400000000000000000000000000000000000000000000000000 | 2022-03-01T08:19:18.000Z | 0xad58ba3cc8188291c9f62d79b034e69f3f618a2a67eeea4541de3d84ad1a3963 |
| 0 | 0xa31d0abdbbe712d5fd8e69fe38fe485a1750500258514bc0b651a405d3076b29 | 0xbed32937d8a5d1421241f52809908f1a17d75bdb | 1000000000 | 0x19f72b0354799dabc9903b0b8d524f3b41851410 | false | 295172632406 | true | 100000000 | 0 | 0x0000000000000000000000000000000000000000 | 7199438 | 0x4554482d55534400000000000000000000000000000000000000000000000000 | 2022-03-01T21:17:53.000Z | 0x41d71ed4dbed5bdd5a429a3f5359ab992ae75cb4cc40beb11ab039f4e8cb4c74 |
| 0 | 0xa31d0abdbbe712d5fd8e69fe38fe485a1750500258514bc0b651a405d3076b29 | 0xbed32937d8a5d1421241f52809908f1a17d75bdb | 1000000000 | 0x19f72b0354799dabc9903b0b8d524f3b41851410 | false | 295190636921 | true | 100000000 | 0 | 0x0000000000000000000000000000000000000000 | 7201109 | 0x4554482d55534400000000000000000000000000000000000000000000000000 | 2022-03-01T21:47:18.000Z | 0xc3d5534cbee7e68aa718d3617a430ea8160a33c864b276977ef4effd3a042c8f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.cap_v3_arbitrum.Trading_PositionUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***