> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# cryptex_v1_arbitrum
> Tables in tt-contracts.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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| in\_fee | 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | in\_sender | log\_index | in\_baseFee | block\_number | in\_keeperFee | in\_calldataFee | block\_timestamp | in\_applicableGas | transaction\_hash | in\_applicableValue |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------- | ------------- | ------------------ | --------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ | ------------------- |
| 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 0x8b4e6f5e1b2be9c4a9fd4dee216fdbbdd67b05b6 | 40 | 39486000000000 | 249107079 | 97718000000000000 | 328802672000 | 2024-09-01T22:22:18.000Z | 0 | 0x813110ba82fa4ddf7e2e01d47a5d9a16ec8f328a1da502af2736c130d91702d5 | 0 |
| 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 0x8b4e6f5e1b2be9c4a9fd4dee216fdbbdd67b05b6 | 73 | 65580000000000 | 249109058 | 160433000000000000 | 372193571200 | 2024-09-01T22:30:38.000Z | 0 | 0x818ee8fe554034377a318a63e87112cd5aab111a14af876885b7fe113b560458 | 0 |
| 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 0x8b4e6f5e1b2be9c4a9fd4dee216fdbbdd67b05b6 | 9 | 18018000000000 | 248864922 | 45572000000000000 | 390619011200 | 2024-09-01T05:26:59.000Z | 0 | 0xeba7eb23bddd6fd0fbf0723b1ef5127484195dbbe598bb37411388bde8fac43f | 0 |
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | in\_nonce | in\_market | log\_index | in\_account | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | --------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 638 | 0x02258be4ac91982dc1af7a3d2c4f05be6079c253 | 0 | 0x2588253cc1daac3e7d823b9190ec87e75c67f2c4 | 151639600 | 2023-11-18T12:04:41.000Z | 0xea8c616ba0d9f5397fbac1b8b26f4bc4df503f3c5e87616ee4447559beb0287e |
| 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 639 | 0x02258be4ac91982dc1af7a3d2c4f05be6079c253 | 0 | 0x2588253cc1daac3e7d823b9190ec87e75c67f2c4 | 151640216 | 2023-11-18T12:07:16.000Z | 0x24216702938920eb617cfd24192f25b29ae5b9d7d6cb12598ebdc78735f47825 |
| 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 640 | 0x02258be4ac91982dc1af7a3d2c4f05be6079c253 | 0 | 0x2588253cc1daac3e7d823b9190ec87e75c67f2c4 | 151640146 | 2023-11-18T12:06:57.000Z | 0x40cca15b950e5d01bb8fcb88cc9f6f445880fb73124e27af2f67dda6cf8c72bd |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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, interfaceFee2 STRUCT>` | 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | log\_index | in\_version | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0 | false | 9 | 1 | 76023754 | 2023-04-01T18:48:54.000Z | 0x6af676880cf1619915ae6ff8e61ccb98959dfa4aaeca6553c49e3a7910b714c4 |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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). |
| address | removed | log\_index | block\_number | in\_newMakerFee | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ---------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0 | false | 0 | 138753448 | 2125000000000000 | 2023-10-08T14:10:54.000Z | 0x86981ef48bbff61def86914bd138d0702e81023fed544598f1dcc6364da1e1be |
**Query with partition filter**
```sql theme={null}
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.*
| 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` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | log\_index | block\_number | in\_newTakerFee | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ---------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0 | false | 0 | 138753455 | 2125000000000000 | 2023-10-08T14:10:56.000Z | 0xda317ccc471763300a747962ceeddb6ae2d125151f69afb412e5b7b5d8466c20 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.cryptex_v1_arbitrum.TCAP_TakerFeeUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***