cryptex_v1_arbitrum

Tables

MultiInvoker_Initialized_event

Contract initialization events from Cryptex’s MultiInvoker contract on Arbitrum, tracking when the contract is set up with version information. Used for monitoring contract deployments and upgrade history.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	3	2	222939883	2024-06-17T22:02:25.000Z	0xd9f0400b76fe7bf65e02abe9afbda23a9fcefd7fcefe11053eb7a8de472b6abf
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	6	1	135921999	2023-09-29T23:11:24.000Z	0xa761909c2597651e2bf029d1deca56908ad391b4f00320a67650dae358e3d5a6

Example Query

Query with partition filter

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

MultiInvoker_InterfaceFeeCharged_event

Interface fee collection events from Cryptex protocol’s MultiInvoker contract on Arbitrum, recording fees charged to user accounts per market with amount, receiver address, and optional token unwrapping flag. Used for analyzing protocol fee revenue distribution and interface partner compensation across different 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_account`	`STRING`	Account address involved in the transaction or operation. 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`	`STRUCT<amount STRING, receiver STRING, unwrap BOOL>`	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	removed	in_market	log_index	in_account	block_number	block_timestamp	transaction_hash
{“amount”:“5416”,“unwrap”:false,“receiver”:“0x8cda59615c993f925915d3eb4394badb3feef413”}	0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	0x004e1abf70e4ff99bc572843b63a63a58faa08ff	237	0x366f1b6e29e7d0430dc110486ecad6b1be861980	201946189	2024-04-17T11:55:07.000Z	0xcdcd9f9013b1f8faba4c4621a9e9f9cd4628896336ca5f37eae1b9bae10e473b
{“amount”:“5431”,“unwrap”:false,“receiver”:“0x8cda59615c993f925915d3eb4394badb3feef413”}	0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	0x004e1abf70e4ff99bc572843b63a63a58faa08ff	31	0x366f1b6e29e7d0430dc110486ecad6b1be861980	201941160	2024-04-17T11:33:52.000Z	0xb21d68d20609ae855b97bea48b84709380ec0a066ad7d52c1c213ff756605cd7
{“amount”:“99036”,“unwrap”:true,“receiver”:“0x78bc83b1255d96b190848b3a8146491cd7e63134”}	0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	0x02258be4ac91982dc1af7a3d2c4f05be6079c253	62	0xbb46131d139b64b5739c857c1583c07ca34e7b2f	201823456	2024-04-17T03:15:32.000Z	0xc1df506fafbb72abd9d97c2871b44e2ccc2283308cbbaf60b4439172390fa6e7

Example Query

Query with partition filter

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

MultiInvoker_KeeperCall_event

Keeper bot execution records from Cryptex protocol’s MultiInvoker contract on Arbitrum, tracking automated order execution fees including base fee, calldata costs, and total keeper compensation. Used for analyzing keeper profitability and protocol automation costs.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_applicableGas`	`STRING`	Gas units applicable to this keeper operation for fee calculation purposes. Represented as a string-encoded integer, typically zero when gas costs are covered through alternative mechanisms.
`in_applicableValue`	`STRING`	Total value in wei charged to the user for executing this keeper operation. Typically zero when no value transfer occurs during the keeper call execution.
`in_baseFee`	`STRING`	Base fee per gas unit for the block where the keeper call was executed, denominated in wei. This represents the network’s algorithmic base gas price on Arbitrum at the time of the transaction.
`in_calldataFee`	`STRING`	Cost in wei for processing calldata associated with this keeper operation. Represents the fee component attributed to transaction data size on Arbitrum.
`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.

Sample Data

address	removed	in_sender	log_index	in_baseFee	block_number	in_keeperFee	in_calldataFee	block_timestamp	transaction_hash
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	0x8b4e6f5e1b2be9c4a9fd4dee216fdbbdd67b05b6	40	39486000000000	249107079	97718000000000000	328802672000	2024-09-01T22:22:18.000Z	0x813110ba82fa4ddf7e2e01d47a5d9a16ec8f328a1da502af2736c130d91702d5
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	0x8b4e6f5e1b2be9c4a9fd4dee216fdbbdd67b05b6	73	65580000000000	249109058	160433000000000000	372193571200	2024-09-01T22:30:38.000Z	0x818ee8fe554034377a318a63e87112cd5aab111a14af876885b7fe113b560458
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	0x8b4e6f5e1b2be9c4a9fd4dee216fdbbdd67b05b6	9	18018000000000	248864922	45572000000000000	390619011200	2024-09-01T05:26:59.000Z	0xeba7eb23bddd6fd0fbf0723b1ef5127484195dbbe598bb37411388bde8fac43f

Example Query

Query with partition filter

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

MultiInvoker_KeeperFeeCharged_event

No description available.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`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

No sample data available.

Example Query

Query with partition filter

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

MultiInvoker_OrderCancelled_event

Order cancellation events from Cryptex MultiInvoker contract on Arbitrum, tracking when users cancel pending orders by account, market, and unique nonce identifier. Used for analyzing order management behavior and unfilled order patterns across 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.

Sample Data

address	removed	in_nonce	in_market	in_account	block_number	block_timestamp	transaction_hash
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	638	0x02258be4ac91982dc1af7a3d2c4f05be6079c253	0x2588253cc1daac3e7d823b9190ec87e75c67f2c4	151639600	2023-11-18T12:04:41.000Z	0xea8c616ba0d9f5397fbac1b8b26f4bc4df503f3c5e87616ee4447559beb0287e
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	639	0x02258be4ac91982dc1af7a3d2c4f05be6079c253	0x2588253cc1daac3e7d823b9190ec87e75c67f2c4	151640216	2023-11-18T12:07:16.000Z	0x24216702938920eb617cfd24192f25b29ae5b9d7d6cb12598ebdc78735f47825
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	640	0x02258be4ac91982dc1af7a3d2c4f05be6079c253	0x2588253cc1daac3e7d823b9190ec87e75c67f2c4	151640146	2023-11-18T12:06:57.000Z	0x40cca15b950e5d01bb8fcb88cc9f6f445880fb73124e27af2f67dda6cf8c72bd

Example Query

Query with partition filter

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

MultiInvoker_OrderExecuted_event

Order execution events from Cryptex protocol’s MultiInvoker contract on Arbitrum, tracking fulfilled orders with unique nonces, account addresses, and market identifiers. Used for analyzing order flow, account activity, and market-specific trading patterns across Cryptex 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.

Sample Data

address	removed	in_nonce	in_market	log_index	in_account	block_number	block_timestamp	transaction_hash
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	10314	0x004e1abf70e4ff99bc572843b63a63a58faa08ff	119	0x1bd8ed941d9e9b447d0fcf91abb5822a5d08b3c1	257832012	2024-09-27T08:24:46.000Z	0xbbfd669a0ec879108a1e2e75436bcf6d820f395937dbbd50ac94d81fbf253b86
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	10347	0x90a664846960aafa2c164605aebb8e9ac338f9a0	38	0x639f8cf1c6bbcd2a7d351ce84f61af3f488c34bc	257798972	2024-09-27T06:06:30.000Z	0xab2e4b87219edc2d0693250ef980286a5a0c68c5ff3048b66ba36f2e3a14facc
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	10388	0x90a664846960aafa2c164605aebb8e9ac338f9a0	23	0xcf421a0140f1ebdb2f0eea975b12e4256891ec99	258034745	2024-09-27T22:34:26.000Z	0x2a306ab6b06638b5adc493191ac9754493daf13de1106e5ec0f11cba56b4cc2c

Example Query

Query with partition filter

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

MultiInvoker_OrderPlaced_event

Limit order placement events from Cryptex protocol on Arbitrum, capturing order parameters including side, price, comparison type, and associated fees. Used for analyzing order book activity and trading strategies across Cryptex perpetual futures 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_order`	`STRUCT<side INT64, comparison INT64, fee STRING, price STRING, delta STRING, interfaceFee1 STRUCT<amount STRING, receiver STRING, unwrap BOOL>, interfaceFee2 STRUCT<amount STRING, receiver STRING, unwrap BOOL>>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.

Sample Data

address	removed	in_nonce	in_order	in_market	log_index	in_account	block_number	block_timestamp	transaction_hash
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	7407	{“fee”:“20000000”,“side”:2,“delta”:“0”,“price”:“440000”,“comparison”:-1,“interfaceFee1”:{“amount”:“0”,“unwrap”:false,“receiver”:“0x0000000000000000000000000000000000000000”},“interfaceFee2”:{“amount”:“0”,“unwrap”:false,“receiver”:“0x0000000000000000000000000000000000000000”}}	0x3d1d603073b3ceab5974db5c54568058a9551ccc	0	0x0a0ae914771ec0a5851049864ccc27b1baa8cd43	249625006	2024-09-03T10:32:13.000Z	0xa4cde9c64e3b66c256506b84ee0861b1b8672bdd59b9787d286f870627dfcf23
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	7459	{“fee”:“20000000”,“side”:1,“delta”:“0”,“price”:“893600”,“comparison”:-1,“interfaceFee1”:{“amount”:“0”,“unwrap”:false,“receiver”:“0x0000000000000000000000000000000000000000”},“interfaceFee2”:{“amount”:“0”,“unwrap”:false,“receiver”:“0x0000000000000000000000000000000000000000”}}	0xc8b73ecfdb775cb9899a0d22ffc8d11228ac35cb	20	0x0def0bacf09a27e0836ef3096f9c3ae859ac13ea	249692024	2024-09-03T15:12:18.000Z	0x56cc4e8e833395fa49393d49b0a73481ac973b9c9b16be00f1c6fa0f73189b9a
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	7458	{“fee”:“20000000”,“side”:1,“delta”:“0”,“price”:“893700”,“comparison”:-1,“interfaceFee1”:{“amount”:“0”,“unwrap”:false,“receiver”:“0x0000000000000000000000000000000000000000”},“interfaceFee2”:{“amount”:“0”,“unwrap”:false,“receiver”:“0x0000000000000000000000000000000000000000”}}	0xc8b73ecfdb775cb9899a0d22ffc8d11228ac35cb	4	0x55bcc5c24ef24fe3483d1df138db0eb648342ab8	249691952	2024-09-03T15:11:59.000Z	0x6cfc72e48bb5c31ae36a19937616b8107e54278e9d65bd4265a0f9efa6de149c

Example Query

Query with partition filter

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

TCAP_AccountSettle_event

Account settlement events from Cryptex Finance’s TCAP (Total Crypto Market Cap) token on Arbitrum, tracking version transitions for user positions. Useful for monitoring account state changes and settlement frequency across TCAP holders.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_preVersion`	`STRING`	Account version identifier before the settlement event. Numeric string identifier tracking the account state prior to this settlement action.
`in_toVersion`	`STRING`	Account’s version number after the settlement event completed. Incrementing integer value tracking the account’s state version in the TCAP protocol.

Sample Data

address	removed	log_index	in_account	block_number	in_toVersion	in_preVersion	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	3	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	110133484	2222	2222	2023-07-11T14:00:14.000Z	0x3317f67baf8f48e19c9e68222e18b2a8aad33dc692fd1ce8ba0641a97303171d
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	3	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	110245681	2230	2230	2023-07-11T22:00:29.000Z	0x8c5e405e4971c61b8dad435dc517f4223b894ebe7f457968a2a0a93a53282eaf
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	3	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	110018318	2214	2214	2023-07-11T06:00:15.000Z	0xa0362d9c7e8ad279b3765ca7d45f75d6ddd52afda65a2e3129c1abbf3f149750

Example Query

Query with partition filter

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

TCAP_ClosedUpdated_event

No description available.

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_newClosed`	`BOOL`	-
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

TCAP_FundingFeeUpdated_event

Funding fee parameter changes for Cryptex’s TCAP (Total Crypto Market Cap) token vaults on Arbitrum. Tracks governance or automated adjustments to vault funding rates, useful for monitoring protocol fee structure evolution.

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_newFundingFee`	`STRING`	The updated funding fee rate for the TCAP protocol, denominated in wei (18 decimal places). For example, ‘50000000000000000’ represents 0.05 or 5% funding fee.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	in_newFundingFee	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	3	0	76023754	2023-04-01T18:48:54.000Z	50000000000000000	0x6af676880cf1619915ae6ff8e61ccb98959dfa4aaeca6553c49e3a7910b714c4
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	1	699	91772888	2023-05-18T00:19:07.000Z	0	0x1c73cf5abfd7340386e835ef1915466b574276990c5790e72de533150e8da2bf

Example Query

Query with partition filter

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

TCAP_Initialized_event

Initialization events for Cryptex TCAP (Total Crypto Market Cap) token contracts on Arbitrum, capturing contract deployment and setup transactions. Used for tracking when new TCAP token instances are created and configured.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	9	1	76023754	2023-04-01T18:48:54.000Z	0x6af676880cf1619915ae6ff8e61ccb98959dfa4aaeca6553c49e3a7910b714c4

Example Query

Query with partition filter

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

TCAP_JumpRateUtilizationCurveUpdated_event

Interest rate curve parameter updates for Cryptex’s TCAP (Total Crypto Market Cap) token vault on Arbitrum. Tracks changes to the jump rate model including minimum, target, and maximum rates based on vault utilization thresholds.

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_anon0`	`STRUCT<minRate STRING, maxRate STRING, targetRate STRING, targetUtilization STRING>`	Contract address of the lending pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	in_anon0	log_index	in_version	block_number	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	{“maxRate”:“800000000000000000”,“minRate”:“0”,“targetRate”:“60000000000000000”,“targetUtilization”:“800000000000000000”}	8	0	76023754	2023-04-01T18:48:54.000Z	0x6af676880cf1619915ae6ff8e61ccb98959dfa4aaeca6553c49e3a7910b714c4
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	{“maxRate”:“1000000000000000000”,“minRate”:“80000000000000000”,“targetRate”:“300000000000000000”,“targetUtilization”:“800000000000000000”}	21	699	91772894	2023-05-18T00:19:08.000Z	0xa469740d2a9ed74e09fd63975a3463d37c6e520c3d7683383da82559caa3bc9c

Example Query

Query with partition filter

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

TCAP_MaintenanceUpdated_event

Maintenance ratio parameter updates for Cryptex’s TCAP (Total Crypto Market Cap) token contract on Arbitrum. Tracks changes to collateralization requirements with version tracking for protocol governance and risk management 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_newMaintenance`	`STRING`	Updated maintenance parameter value for the TCAP vault, denominated in wei (18 decimals). Represents the minimum collateralization ratio required after the maintenance update event.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash	in_newMaintenance
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	2	0	76023754	2023-04-01T18:48:54.000Z	0x6af676880cf1619915ae6ff8e61ccb98959dfa4aaeca6553c49e3a7910b714c4	50000000000000000

Example Query

Query with partition filter

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

TCAP_MakeClosed_event

Position closure events from Cryptex’s TCAP (Total Crypto Market Cap) vault on Arbitrum. Used for tracking when users close their synthetic positions, including closure amounts and version states.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_account	in_version	block_number	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	139040792365210495069	6	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	2958	119162741	2023-08-07T21:01:43.000Z	0x52eed037e721ce346a5adb938975b63622d89dd0c8155718a7b9f08350f482e8
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	2983535211078321	9	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	2959	119176572	2023-08-07T22:04:14.000Z	0x4fcfc079b211b65f7650435b073eaa8a528c6fc498e01d927dd3d407047e0f20
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	35530033407561009	15	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	2944	118994462	2023-08-07T09:00:20.000Z	0x23c72204deda8ee23fe85c15e72e16fe09fb94b6e6c081a2ab74dead4eb604f2

Example Query

Query with partition filter

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

TCAP_MakeOpened_event

Position opening events from Cryptex’s TCAP (Total Crypto Market Cap) token protocol on Arbitrum. Tracks maker positions with account addresses, collateral amounts, and version identifiers for analyzing TCAP vault activity.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_account	in_version	block_number	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	1690087658758339499	15	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	1839	105488154	2023-06-27T16:00:16.000Z	0x62bc229a2c6a2aece3ca0575bd35aa5e673f8b8b38c339ea69b03dba1d2d0cc8
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	57536727513536951	15	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	1826	105330507	2023-06-27T05:00:21.000Z	0x4cf7a1f179f7a6b9d7e8721b7da62e0228aae98cae2638a607d45de768feb4ce
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	5455062466377431318	15	0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a	1838	105482459	2023-06-27T15:36:26.000Z	0x413ac7913e66cc9afc1c6218fe1cd42b9423b05329220f533647ba69e75eb81a

Example Query

Query with partition filter

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

TCAP_MakerFeeUpdated_event

Maker fee configuration change events from the Cryptex TCAP (Total Crypto Market Cap) token contract on Arbitrum. Tracks fee adjustments (e.g., 0.15% to 0.2125%) for market makers with version numbers and timestamps for monitoring protocol economics and fee structure evolution.

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_newMakerFee`	`STRING`	Updated maker fee value in the TCAP protocol, denominated in wei (18 decimal places). Sample values like ‘1500000000000000’ represent 0.15% (0.0015 in decimal terms) of the transaction amount.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	in_newMakerFee	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	4	0	76023754	1500000000000000	2023-04-01T18:48:54.000Z	0x6af676880cf1619915ae6ff8e61ccb98959dfa4aaeca6553c49e3a7910b714c4
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	0	3640	138960136	2125000000000000	2023-10-09T07:43:09.000Z	0x976bdf6073958e1a0e06a835ed87f82ddcef29369a2e1bac71b55de3dadc1370

Example Query

Query with partition filter

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

TCAP_MakerLimitUpdated_event

Maker limit configuration changes for Cryptex TCAP (Total Crypto Market Cap) token on Arbitrum. Tracks administrative updates to maximum minting capacity with version control for analyzing protocol parameter governance.

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_newMakerLimit`	`STRING`	The updated maximum limit for maker positions in the TCAP protocol, denominated in the smallest unit (wei-equivalent). This value represents the new cap on the total amount that can be minted or created by makers, typically set in 18-decimal token units.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	in_newMakerLimit	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	7	0	76023754	2023-04-01T18:48:54.000Z	4000000000000000000000	0x6af676880cf1619915ae6ff8e61ccb98959dfa4aaeca6553c49e3a7910b714c4

Example Query

Query with partition filter

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

TCAP_OracleUpdated_event

Oracle configuration change events for Cryptex’s TCAP (Total Crypto Market Cap) token on Arbitrum, recording when price feed oracle addresses are updated. Used for tracking oracle infrastructure changes and understanding price data source history.

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_newOracle`	`STRING`	Address of the newly set oracle contract for the TCAP token price feed. Hex-encoded, 0x-prefixed 40-character Ethereum address on Arbitrum.
`in_oracleVersion`	`STRING`	Version identifier of the oracle being updated in the TCAP contract. Typically a numeric string (e.g., ‘0’, ‘1’) used to track oracle implementation changes.

Sample Data

address	removed	log_index	block_number	in_newOracle	block_timestamp	in_oracleVersion	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	1	76023754	0xaab5bf2353cc58de50c54bb0d02d8e0a0333f322	2023-04-01T18:48:54.000Z	0	0x6af676880cf1619915ae6ff8e61ccb98959dfa4aaeca6553c49e3a7910b714c4

Example Query

Query with partition filter

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

TCAP_PendingMakerFeeUpdated_event

Event log tracking proposed maker fee changes for Cryptex’s TCAP (Total Crypto Market Cap) token on Arbitrum, capturing pending fee updates before governance approval. Used to monitor fee governance proposals and protocol parameter change history.

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_newMakerFee`	`STRING`	The proposed new maker fee value in wei, pending governance approval or timelock execution. Typically represents basis points scaled to 18 decimals (e.g., 2125000000000000 = 0.2125% fee).

Sample Data

address	removed	log_index	block_number	in_newMakerFee	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	0	138753448	2125000000000000	2023-10-08T14:10:54.000Z	0x86981ef48bbff61def86914bd138d0702e81023fed544598f1dcc6364da1e1be

Example Query

Query with partition filter

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

TCAP_PendingPositionFeeUpdated_event

No description available.

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_newPositionFee`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

TCAP_PendingTakerFeeUpdated_event

Pending taker fee update events from Cryptex TCAP (Total Crypto Market Cap) token contract on Arbitrum. Tracks proposed fee changes before they are finalized, useful for monitoring protocol governance and fee structure modifications.

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_newTakerFee`	`STRING`	Proposed taker fee amount in wei (smallest unit of ETH) pending implementation in the TCAP vault contract. This value represents the fee charged to users taking positions, typically requiring a governance approval or timelock before activation.

Sample Data

address	removed	log_index	block_number	in_newTakerFee	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	0	138753455	2125000000000000	2023-10-08T14:10:56.000Z	0xda317ccc471763300a747962ceeddb6ae2d125151f69afb412e5b7b5d8466c20

Example Query

Query with partition filter

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

TCAP_PositionFeeUpdated_event

Fee configuration changes for Cryptex’s TCAP (Total Crypto Market Cap) token vault on Arbitrum. Tracks updates to position fees charged by the protocol, useful for monitoring fee parameter adjustments and governance actions.

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_newPositionFee`	`STRING`	The updated fee amount in wei (base units) charged for opening or managing a position in the TCAP protocol. Based on sample data showing 1e18 (1 full token unit), this represents fee rates stored with 18 decimal precision.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash	in_newPositionFee
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	6	0	76023754	2023-04-01T18:48:54.000Z	0x6af676880cf1619915ae6ff8e61ccb98959dfa4aaeca6553c49e3a7910b714c4	1000000000000000000

Example Query

Query with partition filter

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

TCAP_Settle_event

Settlement events from Cryptex’s TCAP (Total Crypto Market Cap) token contract on Arbitrum, recording version transitions during oracle price updates. Used for tracking TCAP price settlement frequency and version history.

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_preVersion`	`STRING`	Previous version number before the settlement event. Numeric identifier stored as string, typically incrementing sequentially with each settlement.
`in_toVersion`	`STRING`	Version number of the TCAP contract state after the settlement operation. Represented as a string-encoded integer that increments sequentially with each settlement event.

Sample Data

address	removed	log_index	block_number	in_toVersion	in_preVersion	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	1	88301629	400	400	2023-05-07T17:00:35.000Z	0x8e0ceac3dea1b57a65c94d4f67aa19701b334dbce849f8670ded1693c9c34c99
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	2	88158261	389	389	2023-05-07T07:04:08.000Z	0xb37b291bc48c90eec7db64a8ce6c3d369a3e7975e99ed00f41ff83c8ca323717
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	2	88316119	401	401	2023-05-07T18:01:59.000Z	0xf2b88fd53dc369c22a7aa551963c0382e72d9f35a79e9d2203c320262a935acd

Example Query

Query with partition filter

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

TCAP_TakeClosed_event

Position closure events from Cryptex TCAP (Total Crypto Market Cap) protocol on Arbitrum, recording when users close synthetic positions with closure amounts and version identifiers for tracking protocol state changes.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_account	in_version	block_number	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	5283170481154179764	8	0x7bc0ceafffc2f2322f07c3058ffbcc2fa7c2af7d	3465	130140315	2023-09-11T14:56:10.000Z	0xcaac01dd8b6d430a91f100aa0f64157f24ad61e48e6a7c340e3eb37091b23283
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	313451896460361737	26	0x8643c722031a05fcbb12212804693b81ccf5a4d5	3464	130137689	2023-09-11T14:45:11.000Z	0x1f01322c090ee2c4ca45ca5f7aa6030bcaa32bd1e3123ce848bb0553a2dac6d0
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	461667516730829964	48	0xc4a98221155f5d2d49b6395d0a9f94c6f0ff2e86	3464	130137686	2023-09-11T14:45:10.000Z	0x75a5007c3f925fe65f9599c972e135a7b08f2996160dc18b48d741f66cf6e963

Example Query

Query with partition filter

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

TCAP_TakeOpened_event

TCAP position opening events from Cryptex protocol on Arbitrum, capturing when users take (open) positions with account addresses, token amounts, and version identifiers. Used for tracking position creation activity and analyzing user behavior in the Total Crypto Market Cap (TCAP) synthetic asset 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_account	in_version	block_number	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	82386969767360224	24	0xb43d843538635aef1b49114bb72ae083ab63be30	4217	148679351	2023-11-09T11:42:11.000Z	0x529ebeee2e102b71770522d3471e387d0ed36ec7cfa0d27a4d12867210b17004
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	695227038756709161	13	0x5c7404cfa34e53661b7e0243f2e96ae0422436e2	4216	148661601	2023-11-09T10:27:32.000Z	0x2a34c3ef61cb712c612934242f066ce94546ef39674d1b8c9ce0eed3775917dd
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	140576196873851664	13	0xd88fed07219ba97abaa81f6e08376f90a4b20223	4212	148623250	2023-11-09T07:47:27.000Z	0xf8824e35055d4ce3be573b58f498031366bf01bcb86a1545c8d9daab974d4e44

Example Query

Query with partition filter

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

TCAP_TakerFeeUpdated_event

Event log tracking taker fee parameter changes for Cryptex’s TCAP (Total Crypto Market Cap) token on Arbitrum. Records the new fee values (in wei) and version numbers for analyzing fee structure evolution and protocol governance updates.

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_newTakerFee`	`STRING`	The updated taker fee value denominated in wei (smallest unit of ETH), represented as a string. Based on samples, typical values range from 0.0015 to 0.002125 ETH when converted from wei.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	in_newTakerFee	block_timestamp	transaction_hash
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	1	3640	138960136	2125000000000000	2023-10-09T07:43:09.000Z	0x976bdf6073958e1a0e06a835ed87f82ddcef29369a2e1bac71b55de3dadc1370
0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	false	5	0	76023754	1500000000000000	2023-04-01T18:48:54.000Z	0x6af676880cf1619915ae6ff8e61ccb98959dfa4aaeca6553c49e3a7910b714c4

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

MultiInvoker_Initialized_event

MultiInvoker_InterfaceFeeCharged_event

MultiInvoker_KeeperCall_event

MultiInvoker_KeeperFeeCharged_event

MultiInvoker_OrderCancelled_event

MultiInvoker_OrderExecuted_event

MultiInvoker_OrderPlaced_event

TCAP_AccountSettle_event

TCAP_ClosedUpdated_event

TCAP_FundingFeeUpdated_event

TCAP_Initialized_event

TCAP_JumpRateUtilizationCurveUpdated_event

TCAP_MaintenanceUpdated_event

TCAP_MakeClosed_event

TCAP_MakeOpened_event

TCAP_MakerFeeUpdated_event

TCAP_MakerLimitUpdated_event

TCAP_OracleUpdated_event

TCAP_PendingMakerFeeUpdated_event

TCAP_PendingPositionFeeUpdated_event

TCAP_PendingTakerFeeUpdated_event

TCAP_PositionFeeUpdated_event

TCAP_Settle_event

TCAP_TakeClosed_event

TCAP_TakeOpened_event

TCAP_TakerFeeUpdated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​MultiInvoker_Initialized_event

​MultiInvoker_InterfaceFeeCharged_event

​MultiInvoker_KeeperCall_event

​MultiInvoker_KeeperFeeCharged_event

​MultiInvoker_OrderCancelled_event

​MultiInvoker_OrderExecuted_event

​MultiInvoker_OrderPlaced_event

​TCAP_AccountSettle_event

​TCAP_ClosedUpdated_event

​TCAP_FundingFeeUpdated_event

​TCAP_Initialized_event

​TCAP_JumpRateUtilizationCurveUpdated_event

​TCAP_MaintenanceUpdated_event

​TCAP_MakeClosed_event

​TCAP_MakeOpened_event

​TCAP_MakerFeeUpdated_event

​TCAP_MakerLimitUpdated_event

​TCAP_OracleUpdated_event

​TCAP_PendingMakerFeeUpdated_event

​TCAP_PendingPositionFeeUpdated_event

​TCAP_PendingTakerFeeUpdated_event

​TCAP_PositionFeeUpdated_event

​TCAP_Settle_event

​TCAP_TakeClosed_event

​TCAP_TakeOpened_event

​TCAP_TakerFeeUpdated_event

Tables

MultiInvoker_Initialized_event

MultiInvoker_InterfaceFeeCharged_event

MultiInvoker_KeeperCall_event

MultiInvoker_KeeperFeeCharged_event

MultiInvoker_OrderCancelled_event

MultiInvoker_OrderExecuted_event

MultiInvoker_OrderPlaced_event

TCAP_AccountSettle_event

TCAP_ClosedUpdated_event

TCAP_FundingFeeUpdated_event

TCAP_Initialized_event

TCAP_JumpRateUtilizationCurveUpdated_event

TCAP_MaintenanceUpdated_event

TCAP_MakeClosed_event

TCAP_MakeOpened_event

TCAP_MakerFeeUpdated_event

TCAP_MakerLimitUpdated_event

TCAP_OracleUpdated_event

TCAP_PendingMakerFeeUpdated_event

TCAP_PendingPositionFeeUpdated_event

TCAP_PendingTakerFeeUpdated_event

TCAP_PositionFeeUpdated_event

TCAP_Settle_event

TCAP_TakeClosed_event

TCAP_TakeOpened_event

TCAP_TakerFeeUpdated_event