cap_v4_arbitrum

Tables

Positions_FeePaid_event

Fee payment records from CAP Protocol v4 perpetual futures positions on Arbitrum, breaking down total fees into pool, treasury, keeper, and staking components for each trade or liquidation. Used for analyzing fee distribution across market participants and protocol revenue streams.

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
11180100	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	0x0d05cac6cc857eccb89919ac38a69c779631aa5f	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	ARB-USD	9	61044	4248438	154758050	559005	3717383	2655273	2023-11-28T01:22:31.000Z	false	0x27654485f3f222b03ffc018bc959f9c0e946bc9581656c942d862aa6f5409818
1276562	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	0x8524dd01937fc9ed964a9c2fe6c38f19a51d31a7	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	BTC-USD	19	61087	485093	154961451	63828	424456	303183	2023-11-28T16:10:34.000Z	false	0x13fe02033b84474b6f5669ad013c5bc65f19d66cb1876f015ef085ffc5e051ea
1276562	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	0x8524dd01937fc9ed964a9c2fe6c38f19a51d31a7	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	BTC-USD	122	0	485093	155008936	63828	424456	303183	2023-11-28T19:42:27.000Z	true	0xf90d50c1d1f5fddf6fff0f155210b2b8c1ed8c158bc4c4b77ff753cc1239cf86

Example Query

Query with partition filter

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

Positions_PositionDecreased_event

Position decrease events from CAP v4 perpetual futures protocol on Arbitrum. Records trade closures and partial exits with profit/loss, fees, margin adjustments, and funding payments for tracking trader performance.

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	in_pnlUsd	log_index	in_orderId	block_number	in_fundingFee	block_timestamp	in_positionSize	in_positionPrice	transaction_hash	in_fundingTracker	in_positionMargin
2100000	-84773088	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	3000000000	0xe87a10d5b212d169ccbc9a50cf5e23dd3da27cb6	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2296451258740000000000	true	750000000	ETH-USD	-84780645520795200000	14	68324	175003181	310818	2024-01-28T09:48:55.000Z	3980000000	2233117148660864148019	0x2bc817ecffc6ee17923bf4981abb63976bd3ac9f44798a8b91880796d18a690d	744844673249800912710	995000000
3500000	-121289294	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	5000000000	0xe87a10d5b212d169ccbc9a50cf5e23dd3da27cb6	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2287603516290000000000	true	1250000000	ETH-USD	-121300106940560100000	8	68321	174945606	706920	2024-01-28T05:44:32.000Z	6980000000	2233117148660864148019	0x956bd76c88ce9bb0f7a392cbb931ff30386d86beb7854b6a32dc2a4a3f4b73f9	743808610028484487771	1745000000
1400000	-36008933	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	2000000000	0xe87a10d5b212d169ccbc9a50cf5e23dd3da27cb6	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2273815000000000000000	true	500000000	ETH-USD	-36010373357320000000	8	68330	175102538	440432	2024-01-28T16:45:10.000Z	1980000000	2233117148660864148019	0x9a2c2de5bd71c805d4966459b74eb81b84ebb2b21f2dea217bb857c80f6c3272	747046837693962287332	495000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cap_v4_arbitrum.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 Arbitrum. Records trades with size, margin, price execution, and funding tracker data for analyzing leverage trading activity and position sizing 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.

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
9945000000000000	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	1989000000000000000	0x3ddae0946d70d2bb87085c211eb173acddb7317f	false	0x0000000000000000000000000000000000000000	1574900000000	true	99500000000000000	PEPE-USD	17	40342	106109686	2023-06-29T12:11:41.000Z	1989000000000000000	1574900000000	0x4399a5d328d8871a9f6622be07892de9faf6ad77a7fb06d6b8af786bdc65146c	155584277297904126216	99500000000000000
10000000000000000	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	2000000000000000000	0x948aa7dfca47d0d699eb90c9da6aa0373c56c9cd	false	0x0000000000000000000000000000000000000000	1599900000000	false	100000000000000000	PEPE-USD	8	40352	106122867	2023-06-29T13:06:26.000Z	2000000000000000000	1599900000000	0x30d416c6ec9f403a5e8142b66c9c94f7220bd69d86dcd8fc73049829505b40cd	155584277297904126216	100000000000000000
2637950000000000	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	527590000000000000	0x402220adc7c10190e13acdbe12582515b0011230	false	0x0000000000000000000000000000000000000000	1571200000000	false	33000000000000000	PEPE-USD	8	40369	106144092	2023-06-29T14:34:40.000Z	527590000000000000	1571200000000	0xdc4d2e5ba8f6d30980d0ece71d0263379d89d394178ead8a8be58cdefb8f853e	156383364055894993795	33000000000000000

Example Query

Query with partition filter

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

PositionsV2_FeePaid_event

Fee payment events from CAP Protocol V4 perpetual futures positions on Arbitrum, breaking down total fees into pool, staking, treasury, and keeper components. Used for analyzing fee distribution and protocol revenue across different markets (ETH-USD, BTC-USD, ARB-USD).

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
925000	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	0x01ffcc7285866e5cee14c8e807cb2e8d5f61079f	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	ETH-USD	16	26889	450937	88420078	23125	90187	360750	2023-05-08T01:45:46.000Z	false	0x927fde2a9f9fda2636673590f54cf764d0235d40260df6da8112a6f829d369e6
2000000	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	0x24d197db5f5963084c85b4dca98e4acaae83bf16	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	ETH-USD	9	26893	975000	88420627	50000	195000	780000	2023-05-08T01:48:04.000Z	false	0x4619c6ee99b01cd1be82e98c7594803fd20860f9d5044d775a1d79bafc84701b
2353215	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	0x1645521a6df217605d9949aafb84927018868cdf	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	BTC-USD	11	26887	1147192	88419907	58830	229438	917753	2023-05-08T01:45:04.000Z	false	0xcdc80d313a86ef6e85bcad38eaff8ae47d6856f6d3bf39c1ad2e90b85dfc5fff

Example Query

Query with partition filter

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

PositionsV2_PositionDecreased_event

Position reduction and closure events from CAP v4 perpetual futures protocol on Arbitrum. Tracks realized profit/loss, fees, margin changes, and funding payments when traders decrease or exit leveraged positions across crypto markets.

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	in_pnlUsd	log_index	in_orderId	block_number	in_fundingFee	block_timestamp	in_positionSize	in_positionPrice	transaction_hash	in_fundingTracker	in_positionMargin
500000000000000	3110653137058520	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	1000000000000000000	0x01ffcc7285866e5cee14c8e807cb2e8d5f61079f	false	0x0000000000000000000000000000000000000000	1897120000000000000000	true	249385968860263920	ETH-USD	5895855424581587757	7	26647	88090893	271038379918331	2023-05-07T02:19:37.000Z	10000000000000000000	1902522430770205299102	0x253796e9f53d22a1bb69a24c0e27a32aed74b4fa5268c71ed9cffdf7bdbf1c1b	243630736574747964745	2493859688602639205
2000000000000000	-475689872590807	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	1000000000000000000	0x01ffcc7285866e5cee14c8e807cb2e8d5f61079f	false	0x0000000000000000000000000000000000000000	324891808250000000000	true	250000000000000000	BNB-USD	-914394857587678755	16	26758	88290565	114155251141552	2023-05-07T16:14:26.000Z	0	324700285370000000000	0xe9600f4689c0220249798e12ef39ed8660e25d498c0efa79c16b40a98f181470	-109719939361131433143	0
238645000000000000	2012110531550073664	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	477290000000000000000	0x09cc15dda77789d42c0133c909e88fb6e3af793a	false	0x0000000000000000000000000000000000000000	1914690000000000000000	false	10606400000000000000	ETH-USD	3855162934618261205278	9	26714	88261767	267349448306410342	2023-05-07T14:14:42.000Z	0	1905589213580000000000	0xcdc264a57cab563cf83787ae12925a3df1e221e43314a6e2a178c09fafede122	247377563239292901945	0

Example Query

Query with partition filter

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

PositionsV2_PositionIncreased_event

Position increase events from CAP perpetual futures protocol on Arbitrum, tracking when traders add size to existing positions or open new ones. Contains execution details including size added, entry price, margin posted, fees, and funding tracker for analyzing position building patterns and leverage usage.

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
2000000	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	4000000000	0x948aa7dfca47d0d699eb90c9da6aa0373c56c9cd	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1916070000000000000000	false	129032300	ETH-USD	9	26625	88077556	2023-05-07T01:23:21.000Z	32000000000	1889990787944687499999	0xdd6b7ecd97d402bed9eb77903aec34646a03b50cc15d2536cac608be84679de0	-32622888196792398326	3091048525
2500000	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	5000000000	0x9131d344038e3f731e1272a0d8c7e195de06a718	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1910182500000000000000	false	200000000	ETH-USD	9	26789	88369897	2023-05-07T21:59:36.000Z	5000000000	1910182500000000000000	0x1e61c906fbde16f40d4243049330c98f40d0c00aa64f3c4421c09620181f3d48	-38062856065301293164	200000000
3684635	0xf7d5e17b430bf1e8b55b3675e5c216e6abc4fa39	7369270000	0x6b2d6564452b01f6994d2b9163bd371273b5e9a5	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1902145774920000000000	false	147385400	ETH-USD	9	26672	88137661	2023-05-07T05:37:54.000Z	7369270000	1902145774920000000000	0xbb6d158f05b770c34a95c971272f7116fe85581c222a04bbb50ac0cc6a2f4568	-34060068266171014189	147385400

Example Query

Query with partition filter

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

PositionsV3_FeePaid_event

Fee payment events from CAP Protocol V3 perpetual positions on Arbitrum, showing total fee breakdown into pool, staking, treasury, and keeper components for each order execution or liquidation. Used for analyzing protocol revenue distribution and trading costs across markets.

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
7500000	0x09df8c3b7b2f4a60208012e0d0b25352fa5f00d7	0x97eda3c9f1e4c7ef743b552ab687aa49fca804c0	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	ARB-USD	9	25715	3656250	87413259	187500	731250	2925000	2023-05-05T03:01:55.000Z	false	0x665e40f69c412cc16a8e979cd03ca74ae93c6b6ae082cc71eeb165b590015e48
62500000	0x09df8c3b7b2f4a60208012e0d0b25352fa5f00d7	0x84a9165bbc73baaf09017a9f132630ced8723485	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	ARB-USD	10	25730	30468750	87423401	1562500	6093750	24375000	2023-05-05T03:45:39.000Z	false	0x9976bdc5410e3dc60d9100b233fdf3aa52bd3b102d0faad0026c18d4db5aecf1
62500000	0x09df8c3b7b2f4a60208012e0d0b25352fa5f00d7	0x84a9165bbc73baaf09017a9f132630ced8723485	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	ARB-USD	8	25728	30468750	87422322	1562500	6093750	24375000	2023-05-05T03:40:57.000Z	false	0x92586b9e6983fe091a5a62c161dd53fad98108416eb4aee55ffb1f32e850f33e

Example Query

Query with partition filter

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

PositionsV3_PositionDecreased_event

Position closure events from CAP Protocol v3 perpetual futures on Arbitrum, capturing realized PnL, fees, and final position state when traders reduce or exit positions. Used for analyzing trading performance, fee generation, and position lifecycle tracking across SUI-USD and other perpetual markets.

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	in_pnlUsd	log_index	in_orderId	block_number	in_fundingFee	block_timestamp	in_positionPrice	transaction_hash	in_fundingTracker
6250000	44973965	0x09df8c3b7b2f4a60208012e0d0b25352fa5f00d7	2500000000	0x57067c10baa7ab532c9f520e03e99645b12298f3	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1400338500000000000	false	125000000	SUI-USD	44969467603500000000	9	25176	87030248	0	2023-05-04T00:02:24.000Z	1375592166000000000	0x4a96be9bf6dcf2ff59af3414571d0df3d8221bb4174d19a71444e879130058ca	2723666574721808936
1250000000000000	51202744111950960	0x09df8c3b7b2f4a60208012e0d0b25352fa5f00d7	500000000000000000	0x6f8adc605edf0da9f3970d12405e8e47e9ac7454	false	0x0000000000000000000000000000000000000000	1483704890000000000	false	29251700680272109	SUI-USD	97378247667284162505	23	25199	87037806	28538812785388	2023-05-04T00:34:04.000Z	1345809768023072373	0x0c47df986fdac53e9883fa195fcbde44f5dc608ac3e0642d931c361322402bc3	3247924517430902795
2500000	13872236	0x09df8c3b7b2f4a60208012e0d0b25352fa5f00d7	1000000000	0x57067c10baa7ab532c9f520e03e99645b12298f3	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1502124200000000000	false	50000000	SUI-USD	13870848776400000000	22	25202	87038820	0	2023-05-04T00:38:32.000Z	1481571490000000000	0x51e790000608f47a5ca86f4d2d6a6ec2ff33703a93453fa70cfd3e2fe51ea896	3294442830429571493

Example Query

Query with partition filter

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

PositionsV3_PositionIncreased_event

Position increase events from Cap Protocol V3 perpetual futures on Arbitrum, capturing new or expanded positions with entry price, size, margin, and funding tracker data. Used for analyzing trader behavior, position sizing patterns, and market directional exposure across crypto assets like ETH-USD and FLOKI-USD.

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
10500000	0x09df8c3b7b2f4a60208012e0d0b25352fa5f00d7	3000000000	0x701386193b756f4931f68881f536724a808cdcba	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	37326600000000	false	150000000	FLOKI-USD	10	21993	84673686	2023-04-27T01:34:37.000Z	3000000000	37326600000000	0x65d33df9c8959c0498c37f20d51f85fc6e4714d9c43e53eaad58537f3889d619	24265108607594262036	150000000
266040	0x09df8c3b7b2f4a60208012e0d0b25352fa5f00d7	532080000	0x1161d38bae997334717ae9329790cb0fcdf38618	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1924300000000000000000	false	76011400	ETH-USD	9	22504	84934948	2023-04-27T19:46:07.000Z	532080000	1924300000000000000000	0x57151d1883af7c6b9b126b231c94aa5ade407ebff0fa884137844027369e27d3	-18480353617468422855	76011400
7054000	0x09df8c3b7b2f4a60208012e0d0b25352fa5f00d7	14108000000	0x8d2a995f34ed5b0f475159da50dc39ff3b6707f0	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1932291999990000000000	false	282160000	ETH-USD	15	22421	84920035	2023-04-27T18:43:37.000Z	14108000000	1932291999990000000000	0xe1ecaa01bf2a882db1f7f3e081b033bbe269305b26e925bcd93d72b25b0ec3c0	-18817987143561345621	282160000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cap_v4_arbitrum.PositionsV3_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 Arbitrum. Records forced position closures with liquidation price, position size, margin amounts in USD, and directional data (long/short) for analyzing leverage risk and liquidation cascades across BTC-USD, ETH-USD, and other perpetual markets.

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`	Position margin value denominated in USD at the time of liquidation. Represented as a string with 18 decimal places of precision (e.g., “162186116000000000000” = ~162.19 USD).
`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	in_marginUsd	block_timestamp	transaction_hash
2185570000000000	0xda813cc90041c9951ac7593252ba5a4ab70c14be	4371140000000000000	0x88c21e961503061ecc51db6bd09c01d5dacce427	false	0x0000000000000000000000000000000000000000	27992484435050000000000	false	89200000000000000	BTC-USD	13	71487856	162186116000000000000	2023-03-19T16:37:33.000Z	0xfb6688e937e2d59a76e137113ad597c24024ac659fd34350c74e59ca8f94ed54
1375950000000000	0xda813cc90041c9951ac7593252ba5a4ab70c14be	2751900000000000000	0xcdbc0f810414fc48aaefc9e959de0af878319cd5	false	0x0000000000000000000000000000000000000000	1821819764000000000000	false	56200000000000000	ETH-USD	93	71486997	101747852000000000000	2023-03-19T16:34:04.000Z	0x87755e4c5ea4ebdc97fd3eda23dcd4e8df9b855bc382256efd1f85b35f805e7c
747655	0xda813cc90041c9951ac7593252ba5a4ab70c14be	1495310000	0xa7cc8da2a472612aeb25218a4fb9d995fa3472a6	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1809476495890000000000	false	29906200	ETH-USD	10	71483423	29896499026844000000	2023-03-19T16:19:18.000Z	0x13204a4f29873e533289547bfc7892f54fc28d4e93bf5cca5cac39ce64bc25ac

Example Query

Query with partition filter

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

Rewards_RewardClaimed_event

Reward claim events from CAP v4 protocol on Arbitrum, recording when users claim accrued rewards with token address and claimed amount. Useful for tracking reward distribution patterns and user claim behavior across the protocol.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x858cdc40c5e09100b70c9652ec7581a2360d1a61	0xc8d272c3a3a7f5ca3be9c9b1e6b1dfe445e89248	false	0x912ce59144191c1204e64559fe8253a0e49e6548	4813661249002162049	1	203023906	2024-04-20T16:09:17.000Z	0x37aa99cff36d0f2b64c4ea7f9cbe255914b31e5c5547b4c2327e1d9d5331b363
0x858cdc40c5e09100b70c9652ec7581a2360d1a61	0xa07ef06b52941a680096dcc4d835895d83c12a89	false	0x912ce59144191c1204e64559fe8253a0e49e6548	8811365927933970057	1	107721817	2023-07-04T07:41:43.000Z	0xc788897dd90fbc8e85d46f35abac786c154ffb8107da3cb7208e50b5c3a33934
0x858cdc40c5e09100b70c9652ec7581a2360d1a61	0x87e2014ace92c43b08f0749a530e5b3f4ffec9dc	false	0x912ce59144191c1204e64559fe8253a0e49e6548	355615691213668441452	1	107635644	2023-07-04T01:33:35.000Z	0xc7883af965fd8c9f791870dac52f82b4fa2cc095393a5a1886cc75db3adbe9a6

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Positions_FeePaid_event

Positions_PositionDecreased_event

Positions_PositionIncreased_event

PositionsV2_FeePaid_event

PositionsV2_PositionDecreased_event

PositionsV2_PositionIncreased_event

PositionsV3_FeePaid_event

PositionsV3_PositionDecreased_event

PositionsV3_PositionIncreased_event

Processor_PositionLiquidated_event

Rewards_RewardClaimed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Positions_FeePaid_event

​Positions_PositionDecreased_event

​Positions_PositionIncreased_event

​PositionsV2_FeePaid_event

​PositionsV2_PositionDecreased_event

​PositionsV2_PositionIncreased_event

​PositionsV3_FeePaid_event

​PositionsV3_PositionDecreased_event

​PositionsV3_PositionIncreased_event

​Processor_PositionLiquidated_event

​Rewards_RewardClaimed_event

Tables

Positions_FeePaid_event

Positions_PositionDecreased_event

Positions_PositionIncreased_event

PositionsV2_FeePaid_event

PositionsV2_PositionDecreased_event

PositionsV2_PositionIncreased_event

PositionsV3_FeePaid_event

PositionsV3_PositionDecreased_event

PositionsV3_PositionIncreased_event

Processor_PositionLiquidated_event

Rewards_RewardClaimed_event