cap_v4_base

Tables

Positions_FeePaid_event

Fee payment records from CAP v4 perpetual futures protocol on Base, capturing total fees and breakdowns across keeper, pool, staking, and treasury components for position orders and liquidations.

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_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`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_poolFee`	`STRING`	Fee amount allocated to the liquidity pool. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_stakingFee`	`STRING`	Fee amount allocated to staking rewards or staking pool participants. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_treasuryFee`	`STRING`	Fee amount allocated to the protocol treasury. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_keeperFee`	`STRING`	Fee paid to the keeper for executing the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_isLiquidation`	`BOOL`	Boolean flag indicating whether the fee payment was associated with a liquidation event.

Sample Data

in_fee	address	in_user	removed	in_asset	in_market	log_index	in_orderId	in_poolFee	block_number	in_keeperFee	in_stakingFee	in_treasuryFee	block_timestamp	in_isLiquidation	transaction_hash
154000000000000	0xa9130f365710bd1cbcdebe83e308039260c02f09	0x077f7a7b115c989d07f8d8efb16a2c2747b4270d	false	0x0000000000000000000000000000000000000000	ETH-USD	6	248	7315000000000	6418652	7700000000000	7315000000000	131670000000000	2023-11-10T14:30:51.000Z	false	0x79e050052b22484b9c4c7f830f8a4578ef73534bb745f1843ce8706716817979
154000000000000	0xa9130f365710bd1cbcdebe83e308039260c02f09	0x077f7a7b115c989d07f8d8efb16a2c2747b4270d	false	0x0000000000000000000000000000000000000000	ETH-USD	5	249	7315000000000	6421554	7700000000000	7315000000000	131670000000000	2023-11-10T16:07:35.000Z	false	0xed729049f226250ab9d9758f73cfed9bec7e357bc58210c5280d1eeb3d9543c2
175000000000000	0xa9130f365710bd1cbcdebe83e308039260c02f09	0x1496294adcc04f835994d5c80901c7d98061cf16	false	0x0000000000000000000000000000000000000000	ETH-USD	5	244	8312500000000	6396530	8750000000000	8312500000000	149625000000000	2023-11-10T02:13:27.000Z	false	0x7f3e4663d2a64af1a5996f1c774252cf6188d9a0b377c036bcdde099cfd007c8

Example Query

Query with partition filter

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

Positions_PositionDecreased_event

Position reduction events from CAP v4 perpetual futures protocol on Base, capturing partial or full position closes with realized PnL, fees, and remaining position state for analyzing trader exits and profit-taking 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_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`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_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_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_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_positionMargin`	`STRING`	Total margin held for the position after the event. String-encoded integer value representing the cumulative collateral backing the position in the smallest unit of the relevant token or currency.
`in_positionSize`	`STRING`	Total size of the trading position after the event. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value.
`in_positionPrice`	`STRING`	Average entry price of the trading position after the event. String-encoded integer value representing the weighted average price per unit of the position.
`in_fundingTracker`	`STRING`	Cumulative funding rate tracker at the time of the position event. String-encoded integer value used to calculate funding fee accruals for perpetual futures positions.
`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_pnlUsd`	`STRING`	Profit and loss realized from closing the position denominated in USD. String-encoded integer value with 18 decimal places representing the net gain or loss in USD, where negative values indicate losses and positive values indicate profits.
`in_fundingFee`	`STRING`	Funding fee charged for holding a perpetual futures position. String-encoded integer value representing the periodic payment in the smallest unit of the relevant token or currency.

Sample Data

in_fee	in_pnl	address	in_size	in_user	removed	in_asset	in_price	in_isLong	in_margin	in_market	log_index	in_orderId	block_number	block_timestamp	in_positionSize	in_positionPrice	transaction_hash	in_fundingTracker	in_positionMargin
2800000000000000	-123320555210873	0xa9130f365710bd1cbcdebe83e308039260c02f09	4000000000000000000	0x6f133b985501dbc3a697fb5244924b57c5ac8c72	false	0x0000000000000000000000000000000000000000	2295212771880000000000	false	80000000000000000	ETH-USD	3	347	9001687	2024-01-09T09:32:01.000Z	0	2295283535790000000000	0x8fa9b542003ad62f39e78f263d64ac15bc26a20680436d00abf3e72f47a0ef73	481536810114077818101	0
35000000000000	2123203703141610	0xa9130f365710bd1cbcdebe83e308039260c02f09	50000000000000000	0x7242eae4a7b72d60d55019234c39a6a138b12ddb	false	0x0000000000000000000000000000000000000000	2430995002490000000000	false	48611111111111111	ETH-USD	3	395	10285265	2024-02-08T02:37:57.000Z	300000000000000000	2331970053428888888887	0x3510608ddee932644fe11f958e7a98495f831aa9a0e5343475140e8091cf9613	764413522442844941381	291666666666666668
35000000000000	2139720976570299	0xa9130f365710bd1cbcdebe83e308039260c02f09	50000000000000000	0x7242eae4a7b72d60d55019234c39a6a138b12ddb	false	0x0000000000000000000000000000000000000000	2431765358230000000000	false	48611111111111111	ETH-USD	3	394	10285240	2024-02-08T02:37:07.000Z	350000000000000000	2331970053428888888887	0x1e68211542e2242a8b0e24647052d25972a3ff7c6d543f5a2db645ed50f10f4a	764413522442844941381	340277777777777779

Example Query

Query with partition filter

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

Positions_PositionIncreased_event

Position increase events from CAP v4 perpetual futures protocol on Base, recording when traders add size or margin to existing positions. Contains execution price, position size, margin posted, funding tracker state, and fee data for analyzing leverage trading patterns and position management behavior.

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_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`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_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_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_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_positionMargin`	`STRING`	Total margin held for the position after the event. String-encoded integer value representing the cumulative collateral backing the position in the smallest unit of the relevant token or currency.
`in_positionSize`	`STRING`	Total size of the trading position after the event. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value.
`in_positionPrice`	`STRING`	Average entry price of the trading position after the event. String-encoded integer value representing the weighted average price per unit of the position.
`in_fundingTracker`	`STRING`	Cumulative funding rate tracker at the time of the position event. String-encoded integer value used to calculate funding fee accruals for perpetual futures positions.
`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_fee	address	in_size	in_user	removed	in_asset	in_price	in_isLong	in_margin	in_market	log_index	in_orderId	block_number	block_timestamp	in_positionSize	in_positionPrice	transaction_hash	in_fundingTracker	in_positionMargin
7000000000000	0xa9130f365710bd1cbcdebe83e308039260c02f09	10000000000000000	0x32628392acfd81597e284ddad6c30b5f3e53284c	false	0x0000000000000000000000000000000000000000	1683210294350000000000	true	200000000000000	ETH-USD	7	32	2783122	2023-08-18T10:46:31.000Z	10000000000000000	1683210294350000000000	0x9750bce975dd7f115cde8519f6ff41007e6e148051e0ed09ef6f05bbb5a51832	17180365296803652968	200000000000000
700000000000000	0xa9130f365710bd1cbcdebe83e308039260c02f09	1000000000000000000	0x5ae6f18a18b6ffc279cd5fddbab2271c0055dd77	false	0x0000000000000000000000000000000000000000	1805500000000000000000	false	20000000000000000	ETH-USD	7	216	6080033	2023-11-02T18:23:33.000Z	1000000000000000000	1805500000000000000000	0x683771f459fa1bf69d781e3575f0a10ba593379616fdf7a19d8c80d101d82517	227048699385634848171	20000000000000000
9387000000000	0xa9130f365710bd1cbcdebe83e308039260c02f09	13410000000000000	0xfe1fb05931a2ef49d021194ed4be86de71a1c514	false	0x0000000000000000000000000000000000000000	1648680000000000000000	true	1000000000000000	ETH-USD	8	38	3199763	2023-08-28T02:14:33.000Z	13410000000000000	1648680000000000000000	0x8ccbf0b472b435391bbadf9f22955530386645bc07faa71c19c1bc86ac1d3119	109474885844748858447	1000000000000000

Example Query

Query with partition filter

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

Processor_PositionLiquidated_event

Position liquidation events from CAP v4 perpetual futures protocol on Base. Records forced position closures with liquidation price, remaining margin, position size, and fees for tracking liquidation cascades and protocol risk events.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`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_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_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_marginUsd`	`STRING`	Margin amount denominated in USD for the liquidated position, represented as a string-encoded integer in the smallest unit. Typically zero in this dataset, indicating margin is tracked in the native asset rather than USD terms.
`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_fee	address	in_size	in_user	removed	in_asset	in_price	in_isLong	in_margin	in_market	log_index	block_number	block_timestamp	transaction_hash
292502000000000	0xa420e7faf14e33f6b7df4d843ca3af2e7b29d5d7	417860000000000000	0x1496294adcc04f835994d5c80901c7d98061cf16	false	0x0000000000000000000000000000000000000000	2078322317260000000000	true	8400000000000000	ETH-USD	7	6414543	2023-11-10T12:13:53.000Z	0xbd0356fad401b6a9090f5e58a5fd133a36e62c5889c263a203671dbcad903fe8
495411000000000	0xa420e7faf14e33f6b7df4d843ca3af2e7b29d5d7	707730000000000000	0x5ae6f18a18b6ffc279cd5fddbab2271c0055dd77	false	0x0000000000000000000000000000000000000000	1867110000000000000000	false	14200000000000000	ETH-USD	8	6174886	2023-11-04T23:05:19.000Z	0xe0c04b88cb9b33ac6b867458584a9a0cc55526ac6c20eb610336c83ac9b6841c
350000000000000	0xa420e7faf14e33f6b7df4d843ca3af2e7b29d5d7	500000000000000000	0x22b5629ce137d9b714fd22fbaf19ccbf5f04e58e	false	0x0000000000000000000000000000000000000000	1526798801940000000000	true	50000000000000000	ETH-USD	66	5169325	2023-10-12T16:26:37.000Z	0x719bca13ed41c6591e01cb739ae6f49e84304c0860fe8b32267fea510f150e3f

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Positions_FeePaid_event

Positions_PositionDecreased_event

Positions_PositionIncreased_event

Processor_PositionLiquidated_event

​Tables

​Positions_FeePaid_event

​Positions_PositionDecreased_event

​Positions_PositionIncreased_event

​Processor_PositionLiquidated_event

Tables

Positions_FeePaid_event

Positions_PositionDecreased_event

Positions_PositionIncreased_event

Processor_PositionLiquidated_event