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.

Columns

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.

Sample Data

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
0xe18fc0406a25c83b9ab57ee57cdd2957c39949aea6527a82258549cb30ab1887	-35104	0xbed32937d8a5d1421241f52809908f1a17d75bdb	1000000	0xb680a49875b3a47ed2fe621ab3a126b0244af3cb	false	177221094200	false	142857	124	0x0000000000000000000000000000000000000000	19907066	0x4554482d55534400000000000000000000000000000000000000000000000000	2022-08-10T12:33:19.000Z	false	0xbcec88c096a35af6471c329fa6afddadad4dd1e52c3fb0ffc4eff669ce72f858
0x19a2daa35f3bdbb87f65db9b5368c37c6c11b1608dfa70f89eac29fdc2ea6d1c	-29410	0xbed32937d8a5d1421241f52809908f1a17d75bdb	10000000	0x79a5eb64b936446eab7c8a128aa1d033651e17fa	false	185850050902	false	200000	2	0x0000000000000000000000000000000000000000	19945214	0x4554482d55534400000000000000000000000000000000000000000000000000	2022-08-10T21:40:20.000Z	false	0x0041f3bfd33459abfa54174884c2dbe1daca56f265942bbcbeac3f69b9a59c5e
0xbaa150f2aaddc470a68291ea472cef58635edf33d21d55a581e1a3475c942ed6	7987	0xbed32937d8a5d1421241f52809908f1a17d75bdb	10000000	0x66fde45e27195818eea327daada35adad9e6bd2c	false	2396321530671	false	200000	0	0x0000000000000000000000000000000000000000	19928221	0x4254432d55534400000000000000000000000000000000000000000000000000	2022-08-10T16:39:19.000Z	false	0x179284412389b8fc28987fcfd2fdd627aee2a585ba0035c74fdd404cfa81c091

Example Query

Query with partition filter

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.

Columns

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.

Sample Data

in_key	address	in_size	in_user	removed	in_price	in_isLong	in_margin	in_currency	block_number	in_productId	block_timestamp	transaction_hash
0x77b39c41bbef3fa6604badfc37689b08085a9e1c90d32d89d2ea436f16e9906f	0xbed32937d8a5d1421241f52809908f1a17d75bdb	200000000	0x16099dd4a4201a67c9b4916a4fb4322973507d8e	false	292656350372	true	4000000	0x0000000000000000000000000000000000000000	7158020	0x4554482d55534400000000000000000000000000000000000000000000000000	2022-03-01T08:19:18.000Z	0xad58ba3cc8188291c9f62d79b034e69f3f618a2a67eeea4541de3d84ad1a3963
0xa31d0abdbbe712d5fd8e69fe38fe485a1750500258514bc0b651a405d3076b29	0xbed32937d8a5d1421241f52809908f1a17d75bdb	1000000000	0x19f72b0354799dabc9903b0b8d524f3b41851410	false	295172632406	true	100000000	0x0000000000000000000000000000000000000000	7199438	0x4554482d55534400000000000000000000000000000000000000000000000000	2022-03-01T21:17:53.000Z	0x41d71ed4dbed5bdd5a429a3f5359ab992ae75cb4cc40beb11ab039f4e8cb4c74
0xa31d0abdbbe712d5fd8e69fe38fe485a1750500258514bc0b651a405d3076b29	0xbed32937d8a5d1421241f52809908f1a17d75bdb	1000000000	0x19f72b0354799dabc9903b0b8d524f3b41851410	false	295190636921	true	100000000	0x0000000000000000000000000000000000000000	7201109	0x4554482d55534400000000000000000000000000000000000000000000000000	2022-03-01T21:47:18.000Z	0xc3d5534cbee7e68aa718d3617a430ea8160a33c864b276977ef4effd3a042c8f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cap_v3_arbitrum.Trading_PositionUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

Trading_ClosePosition_event

Trading_PositionUpdated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Trading_ClosePosition_event

​Trading_PositionUpdated_event

Tables

Trading_ClosePosition_event

Trading_PositionUpdated_event