> ## 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.
# perennial_v1_arbitrum
> Tables in tt-contracts.perennial_v1_arbitrum
## Tables
### Collateral\_AccountSettle\_event
Account settlement events from Perennial V1 protocol's collateral contract on Arbitrum, recording collateral adjustments and shortfall statuses per product. Used for tracking margin changes, liquidations, and account-level position settlements across Perennial 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_product` | `STRING` | Product contract address associated with the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_newShortfall` | `STRING` | Updated collateral shortfall for the account-product pair after settlement, denominated in the collateral token's smallest unit. Typically zero when accounts remain sufficiently collateralized; non-zero values indicate undercollateralized positions requiring liquidation or additional deposits. |
| address | removed | in\_amount | log\_index | in\_account | in\_product | block\_number | block\_timestamp | in\_newShortfall | transaction\_hash |
| ------------------------------------------ | ------- | -------------------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | false | -5870853185568364665 | 0 | 0x9680f3957510cf85751a096c2194520c36a4a003 | 0x4243b34374cfb0a12f184b92f52035d03d4f7056 | 151248508 | 2023-11-17T07:39:13.000Z | 0 | 0x25ec0cb18c362ecbda3b80c88fede4994bff2ff039d90045a386914aab0a7a1e |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | false | 117270966644878150 | 7 | 0x50ed348f85de0772a61ff63bbe33df8db30de1b2 | 0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0 | 151376230 | 2023-11-17T16:35:34.000Z | 0 | 0xdb929ef9b45e6113f464876d480181a7fcd6e65c90fdc9c81a2dafce9aa07a5a |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | false | 0 | 6 | 0x1960628db367281b1a186dd5b80b5dd6978f016f | 0x4e67a8a428206af5a6ac00ba08a67ce827182985 | 151272598 | 2023-11-17T09:19:56.000Z | 0 | 0xfc81953fe7cef05860139708e47f187cb2698c0e03873d0553c3a36334ff720b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Collateral_AccountSettle_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Collateral\_Deposit\_event
Collateral deposit events from Perennial V1 protocol on Arbitrum, recording when users add margin to perpetual futures products. Tracks user addresses, product contracts, and deposit amounts (in wei) for monitoring collateralization and capital flows.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_product` | `STRING` | Product contract address associated with the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_user | removed | in\_amount | log\_index | in\_product | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | 0xd100396d978a2cf7299122a2a012cd81541af9af | false | 11029180000000000000 | 8 | 0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0 | 151693981 | 2023-11-18T15:56:12.000Z | 0x269042e1277a3ddc084a7270fc2f62f95f194d86bf7deb2bc07cccae91081553 |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | 0xb78a48658642e77942495f16993b94303c361661 | false | 10000000000000000000 | 8 | 0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0 | 151537339 | 2023-11-18T04:48:26.000Z | 0xb0ae9d8e1673f5ccdf0265ce3742c991c5fc27917d5e404af230241bbc3ec7ae |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | 0xa43867a72cbba85af92a5d171403a8858d29cefd | false | 10000000000000000000 | 8 | 0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0 | 151524867 | 2023-11-18T03:53:21.000Z | 0xf06980ab24cec4ed1bd511801c1f267107ace55bafc4e5befaf4a8bf7a1e7b4e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Collateral_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Collateral\_FeeClaim\_event
Fee claim events from Perennial V1 protocol collateral contracts on Arbitrum, tracking when accounts withdraw accumulated trading fees. Used for analyzing fee distribution and protocol revenue flows to market makers and liquidity providers.
| 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_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 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ----------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | false | 0 | 1 | 0x708f741b5fa76c9f4a70355207b4f0226ce265f3 | 68473566 | 2023-03-10T08:28:55.000Z | 0xe1114d534d439dc78cb19709087ced2958c5fa83e69fae3080fc2497a2d9a28f |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | false | 15887536455445420600856 | 3 | 0x9474b771fb46e538cfed114ca816a3e25bb346cf | 316707590 | 2025-03-17T17:44:06.000Z | 0x319d7ce88e49d9eaeb6a6ec9fa8749ed8e2d5c79e641581a2d00518d2e271de3 |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | false | 0 | 4 | 0x8f106d448ff23946083e01de1021202b1dd5fbe4 | 376297872 | 2025-09-06T12:46:14.000Z | 0x1975b5897092c669226290c399b303eaf691ec6c872515bfd3b7aec2d48c0969 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Collateral_FeeClaim_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Collateral\_Initialized\_event
Collateral module initialization events from Perennial v1 derivatives protocol on Arbitrum. Tracks when new collateral contracts are deployed and activated for managing user margin deposits.
| 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 |
| ------------------------------------------ | ------- | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | false | 0 | 1 | 54344764 | 2023-01-20T19:02:40.000Z | 0x16b81029bb798a337a4751e0dfc0e1b20e452bc75ad4c2931f5d9dc74f704852 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Collateral_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Collateral\_Liquidation\_event
Liquidation events from Perennial V1 protocol on Arbitrum, recording when undercollateralized positions are closed by liquidators with associated fees and product details. Used for analyzing liquidation activity, liquidator profitability, and protocol risk management.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_product` | `STRING` | Product contract address associated with the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_liquidator` | `STRING` | Address of the account executing the liquidation 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. |
| in\_fee | address | in\_user | removed | log\_index | in\_product | block\_number | in\_liquidator | block\_timestamp | transaction\_hash |
| ------------------- | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 549938410117332465 | 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | 0x66a7fdb96c583c59597de16d8b2b989231415339 | false | 7 | 0x5b99d122af97ba012aa237bd01577278bfaaff1e | 67405517 | 0xaf30f4a07cce62c976e94bb9578bb7f52dd1bedf | 2023-03-06T21:31:16.000Z | 0x88b3b42e1bc0c14dd63e18f44364ea0de0fdbd80942c3a71ed5c2ea4d0bb24ae |
| 2965311424359419242 | 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | 0x5e497af585322a9feeac2d4894dbb1e894ffd8ac | false | 31 | 0x5e660b7b8357059241eaec143e1e68a5a108d035 | 129690368 | 0xb2e93ad65d3c03c2e7ff14e1230a1b61af433df9 | 2023-09-10T04:23:36.000Z | 0xb478a7048ce3464170331b48f3f9e6742e841454a214848072b935b57ca76c48 |
| 2969348793691118583 | 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | 0x938443cb215be0357b56762427e7829c0e8097b9 | false | 6 | 0x5e660b7b8357059241eaec143e1e68a5a108d035 | 129690370 | 0xb2e93ad65d3c03c2e7ff14e1230a1b61af433df9 | 2023-09-10T04:23:36.000Z | 0x077a55006b127cafb273c45fa39587a47f1c3031780a5c0f91a9cd16c270af1e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Collateral_Liquidation_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Collateral\_ProductSettle\_event
Product settlement events from Perennial V1 protocol on Arbitrum capturing protocol and product fee distributions. Used for tracking fee accrual and settlement patterns across different derivative products.
| 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_product` | `STRING` | Product contract address associated with the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_protocolFee` | `STRING` | Fee collected by the protocol from the transaction or operation. Numeric string representation without decimals. |
| `in_productFee` | `STRING` | Product-specific fee amount collected during this settlement event, denominated in the collateral token's smallest unit. Typically zero in sample data, but represents fees retained by the product when non-zero. |
| address | removed | log\_index | in\_product | block\_number | in\_productFee | in\_protocolFee | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | -------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | false | 6 | 0x4e67a8a428206af5a6ac00ba08a67ce827182985 | 222296653 | 0 | 0 | 2024-06-16T01:17:57.000Z | 0x15ec0330234e322179fbcfaa58f74ae63ec9d0893406ccecaf7c8b091b40acf4 |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | false | 2 | 0x5e660b7b8357059241eaec143e1e68a5a108d035 | 222296653 | 0 | 0 | 2024-06-16T01:17:57.000Z | 0x15ec0330234e322179fbcfaa58f74ae63ec9d0893406ccecaf7c8b091b40acf4 |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | false | 2 | 0x5e660b7b8357059241eaec143e1e68a5a108d035 | 222334738 | 0 | 0 | 2024-06-16T03:56:48.000Z | 0x16dc9ac23280f9c6844962445c5e320154bdf51a193564a56acda530fc882afa |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Collateral_ProductSettle_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Collateral\_ShortfallResolution\_event
Collateral shortfall resolution events from Perennial V1 protocol on Arbitrum, recording when undercollateralized positions are liquidated or resolved. Tracks the product contract address, resolution amount in wei, and enables analysis of protocol solvency events and liquidation 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_product` | `STRING` | Product contract address associated with the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | removed | in\_amount | log\_index | in\_product | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | --------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | false | 317696785398559381789 | 11 | 0x260422c091da8c88ef21f5d1112ab43aa94787cd | 124863022 | 2023-08-25T15:14:59.000Z | 0x2a137b5180a4b974c4c0da28eb3bb0b6729db32ff715252be10cb627709b0bb8 |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | false | 18854001632689509616 | 1 | 0x4e67a8a428206af5a6ac00ba08a67ce827182985 | 82490914 | 2023-04-20T16:32:20.000Z | 0xc42053708777fc5d0c65cf59b1fde17f2336a2b7eecd71f97d9c4f13ec135961 |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | false | 14757671225819369644 | 148 | 0x260422c091da8c88ef21f5d1112ab43aa94787cd | 82471182 | 2023-04-20T15:10:28.000Z | 0xa66d9d8f2a07940bfdc9919a12f9d6a8108d0a721263be84339acef77d38efc9 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Collateral_ShortfallResolution_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Collateral\_Withdrawal\_event
Collateral withdrawal events from Perennial V1 protocol on Arbitrum, tracking user withdrawals from specific perpetual products with amounts and timestamps. Used for analyzing capital flows and position sizing across Perennial's derivative 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_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_product` | `STRING` | Product contract address associated with the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_user | removed | in\_amount | log\_index | in\_product | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | 0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a | false | 64107312984347978256 | 11 | 0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0 | 166301849 | 2024-01-02T11:41:19.000Z | 0x9cebc0fd1fdc1eb89d6597fa714de54f7132f82ed861ec10737b86c0c22a3371 |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | 0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a | false | 65553769041815046080 | 9 | 0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0 | 166347781 | 2024-01-02T14:51:36.000Z | 0x7e265da77b1ed22476abfa0339b3e324879af8a8a0630c55489eee36aa5c7e03 |
| 0xaf8ced28fce00abd30463d55da81156aa5aeeec2 | 0xea281a4c70ee2ef5ce3ed70436c81c0863a3a75a | false | 58953191176896761688 | 9 | 0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0 | 166474622 | 2024-01-02T23:42:14.000Z | 0x96af5777b2d627b6be0c4d463ebb3653be19e03d69186a8effce2e917ac22149 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Collateral_Withdrawal_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Market\_AccountPositionProcessed\_event
Account position settlement events from Perennial V1 protocol on Arbitrum containing processed order states, collateral changes, and fee breakdowns including maker/taker, liquidation, and settlement fees for tracking account-level position 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_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_orderId` | `STRING` | Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations. |
| `in_order` | `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. |
| `in_accumulationResult` | `STRUCT` | Accumulated fee breakdown and collateral changes for the account position, including settlement, liquidation, and various trading fees. All fee components are typically zero unless position changes or settlements occurred. |
| address | removed | in\_order | log\_index | in\_account | in\_orderId | block\_number | block\_timestamp | transaction\_hash | in\_accumulationResult |
| ------------------------------------------ | ------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- | ------------------------------------------ | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------ |
| 0xc8b73ecfdb775cb9899a0d22ffc8d11228ac35cb | false | \{"orders":"0","longNeg":"0","longPos":"0","makerNeg":"0","makerPos":"0","shortNeg":"0","shortPos":"0","timestamp":"1725207420","collateral":"0","protection":"0","makerReferral":"0","takerReferral":"0"} | 7 | 0x0000000000000000000000000000000000000000 | 0 | 249020240 | 2024-09-01T16:17:08.000Z | 0x71858a6891397464a23074cced1a711058b3e38f065714dd62ebe3745e082bcd | \{"linearFee":"0","collateral":"0","adiabaticFee":"0","settlementFee":"0","liquidationFee":"0","subtractiveFee":"0","proportionalFee":"0"} |
| 0xc8b73ecfdb775cb9899a0d22ffc8d11228ac35cb | false | \{"orders":"0","longNeg":"0","longPos":"0","makerNeg":"0","makerPos":"0","shortNeg":"0","shortPos":"0","timestamp":"1725233110","collateral":"0","protection":"0","makerReferral":"0","takerReferral":"0"} | 4 | 0x0000000000000000000000000000000000000000 | 0 | 249122016 | 2024-09-01T23:25:17.000Z | 0x7ec360075377628aaaa439cdfd7afa89031ba841c809c7afa111ae41e1116a17 | \{"linearFee":"0","collateral":"0","adiabaticFee":"0","settlementFee":"0","liquidationFee":"0","subtractiveFee":"0","proportionalFee":"0"} |
| 0xe8bf156034b64a7266acd28046f67f3fa7ecc53a | false | \{"orders":"0","longNeg":"0","longPos":"0","makerNeg":"0","makerPos":"0","shortNeg":"0","shortPos":"0","timestamp":"1725195000","collateral":"0","protection":"0","makerReferral":"0","takerReferral":"0"} | 3 | 0x0000000000000000000000000000000000000000 | 0 | 248970798 | 2024-09-01T12:50:07.000Z | 0xb5beabd239b8c7ef1f425202e385adfa17c544a6fe240ad0ddfbace85d201e24 | \{"linearFee":"0","collateral":"0","adiabaticFee":"0","settlementFee":"0","liquidationFee":"0","subtractiveFee":"0","proportionalFee":"0"} |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Market_AccountPositionProcessed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Market\_BeneficiaryUpdated\_event
Beneficiary update events from Perennial V1 protocol markets on Arbitrum, tracking changes to designated recipient addresses for market fees or rewards. Useful for monitoring protocol governance changes and fee distribution configuration across different market contracts.
| 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_newBeneficiary` | `STRING` | Updated beneficiary address that will receive fees or rewards from this Perennial v1 market. Hex-encoded, 0x-prefixed 40-character string; commonly set to zero address when removing beneficiary designation. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_newBeneficiary |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 0x5bef017ac7ea4f6f59946f27d50a137d4362f6a4 | false | 18 | 245394056 | 2024-08-22T03:14:57.000Z | 0xa47a4e296b809c1de120d4e017174a6eb4920a9e1afe104ad30f9aa8c9434dea | 0x0000000000000000000000000000000000000000 |
| 0xe588d7d041e18e754e95ef51d77f6e0fc6334efd | false | 38 | 247655841 | 2024-08-28T16:56:25.000Z | 0x40412c755da71b71a2394edd1119d11f1a9c31d04236f2a5449ff6c82e287e2b | 0x0000000000000000000000000000000000000000 |
| 0xb8df4bea28b1f0748d386e8a69ea1bd46b70922d | false | 16 | 247655841 | 2024-08-28T16:56:25.000Z | 0x40412c755da71b71a2394edd1119d11f1a9c31d04236f2a5449ff6c82e287e2b | 0x0000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Market_BeneficiaryUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Market\_CoordinatorUpdated\_event
Coordinator address update events from Perennial v1 markets on Arbitrum, capturing when market contracts change their coordinator contract reference. Used to track protocol governance changes and market configuration 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_newCoordinator` | `STRING` | Contract address of the newly assigned coordinator for the Perennial v1 market on Arbitrum. Hex-encoded, 0x-prefixed 40-character string representing the coordinator role updated in this event. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_newCoordinator |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 0xe8bf156034b64a7266acd28046f67f3fa7ecc53a | false | 21 | 242618793 | 2024-08-14T01:26:01.000Z | 0x2bd182e6744fa7370b2bfa3dd7a9362dd2ae4888812642106e9cc1894417b174 | 0x86a2b58445986ed5e6c43be8f2e7b9dcb0128092 |
| 0xb7558189c794239ef9453208f2e58fa049e1035c | false | 71 | 244539214 | 2024-08-19T15:40:22.000Z | 0xbea1c49603d345a8d244b0bcae415806eb50104fe31a0a9255462bcad5d28bc5 | 0x86a2b58445986ed5e6c43be8f2e7b9dcb0128092 |
| 0xe8bf156034b64a7266acd28046f67f3fa7ecc53a | false | 75 | 244539214 | 2024-08-19T15:40:22.000Z | 0xbea1c49603d345a8d244b0bcae415806eb50104fe31a0a9255462bcad5d28bc5 | 0x86a2b58445986ed5e6c43be8f2e7b9dcb0128092 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Market_CoordinatorUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Market\_ExposureClaimed\_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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Market_ExposureClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Market\_FeeClaimed\_event
Fee claim events from Perennial V1 perpetual futures markets on Arbitrum, recording when accounts withdraw accumulated trading fees. Used for tracking fee distributions and market maker profitability 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_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | removed | in\_amount | log\_index | in\_account | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xe8bf156034b64a7266acd28046f67f3fa7ecc53a | false | 54745469 | 1 | 0x602ac53904bdcf08507915643976c9df6bd89c9a | 256027444 | 2024-09-22T02:27:30.000Z | 0xe92301cb4aca71bc042ddc3d005df6ecfe6b8985af7525c04c10865068647961 |
| 0xe8bf156034b64a7266acd28046f67f3fa7ecc53a | false | 298708853 | 18 | 0x5d400b68a010832fe2f43d126f58f938b4502a24 | 256026764 | 2024-09-22T02:24:39.000Z | 0xbcd07371827f471134bccba17209a781c8b04093122b88a5b9bb60679ad52dbc |
| 0xe8bf156034b64a7266acd28046f67f3fa7ecc53a | false | 340114632 | 1 | 0x5d79df94314c8372f6558b7c4240ed2cc92b99dd | 261359472 | 2024-10-07T15:20:04.000Z | 0x230d3814a0c5d3abae70ce2b6264c08ba9435daee6c20c7d34d1f338084d5fb2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Market_FeeClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Market\_OracleUpdated\_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_newOracle` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Market_OracleUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Market\_OrderCreated\_event
Order creation events from Perennial V1 derivatives protocol on Arbitrum, capturing account positions (long, short, maker), collateral changes, and referral fees. Used for tracking position adjustments and protocol fee distribution.
| 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_order` | `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\_order | log\_index | in\_account | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb7558189c794239ef9453208f2e58fa049e1035c | false | \{"orders":"0","longNeg":"0","longPos":"0","makerNeg":"0","makerPos":"0","shortNeg":"0","shortPos":"0","timestamp":"1724215460","collateral":"-4853544400","protection":"0","makerReferral":"0","takerReferral":"0"} | 10 | 0x18ac6951ef84d343c5303ce2bba09bbafd696145 | 245070910 | 2024-08-21T04:44:17.000Z | 0x2b7b1bead454297ac7a36309ffc88f7cdb215503449eabef73c59db3d5c095b5 |
| 0x1a1745e9cc740269d3e75b506e1abf7cbf1fe7d3 | false | \{"orders":"0","longNeg":"0","longPos":"0","makerNeg":"0","makerPos":"0","shortNeg":"0","shortPos":"0","timestamp":"1724257420","collateral":"-2823726900","protection":"0","makerReferral":"0","takerReferral":"0"} | 19 | 0x18ac6951ef84d343c5303ce2bba09bbafd696145 | 245238383 | 2024-08-21T16:23:39.000Z | 0x3bbefb31b7420f709ace0e7cfcdf80212659262f85cd52af8d0016d35c6ea94b |
| 0xb7558189c794239ef9453208f2e58fa049e1035c | false | \{"orders":"0","longNeg":"0","longPos":"0","makerNeg":"0","makerPos":"0","shortNeg":"0","shortPos":"0","timestamp":"1724257460","collateral":"-947633900","protection":"0","makerReferral":"0","takerReferral":"0"} | 9 | 0x18ac6951ef84d343c5303ce2bba09bbafd696145 | 245238517 | 2024-08-21T16:24:13.000Z | 0x437d71d04e2cc8b03fd9ea4d27eb35970e08cd7fd322846d63289159d9c3839b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Market_OrderCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Market\_ParameterUpdated\_event
Market configuration change events from Perennial v1 protocol on Arbitrum, capturing fee structure updates (funding, position, settlement fees) and risk parameter adjustments for individual perpetual markets. Used for tracking protocol governance actions and fee schedule changes across different market contracts.
| 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_newParameter` | `STRUCT` | Updated parameter configuration for the Perennial V1 market contract including fee rates, settlement flags, and position limits. Contains nested fields for fundingFee, interestFee, positionFee, settlementFee, riskFee, oracleFee (all in basis points), settlement behavior flags (settle, closed, makerCloseAlways, takerCloseAlways), and maximum pending position counts (maxPendingLocal, maxPendingGlobal). |
| address | removed | log\_index | block\_number | block\_timestamp | in\_newParameter | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ |
| 0xb7558189c794239ef9453208f2e58fa049e1035c | false | 20 | 240402382 | 2024-08-07T14:28:03.000Z | \{"closed":false,"settle":false,"riskFee":"1000000","oracleFee":"0","fundingFee":"50000","interestFee":"50000","positionFee":"50000","settlementFee":"200000","maxPendingLocal":"6","makerCloseAlways":false,"maxPendingGlobal":"12","takerCloseAlways":true} | 0xe69bbb984c5d23baf45a070a1be95a4e81160bca4c2d74d658aa69669ab4e151 |
| 0xc8b73ecfdb775cb9899a0d22ffc8d11228ac35cb | false | 59 | 267255465 | 2024-10-24T19:01:12.000Z | \{"closed":false,"settle":true,"riskFee":"1000000","oracleFee":"0","fundingFee":"100000","interestFee":"100000","positionFee":"100000","settlementFee":"200000","maxPendingLocal":"6","makerCloseAlways":false,"maxPendingGlobal":"12","takerCloseAlways":true} | 0xba6dead255288075dce80c3927a8651d95611359794b7a4a2ac5268ed077ad37 |
| 0xe588d7d041e18e754e95ef51d77f6e0fc6334efd | false | 79 | 267255465 | 2024-10-24T19:01:12.000Z | \{"closed":false,"settle":true,"riskFee":"1000000","oracleFee":"0","fundingFee":"100000","interestFee":"100000","positionFee":"100000","settlementFee":"200000","maxPendingLocal":"6","makerCloseAlways":false,"maxPendingGlobal":"12","takerCloseAlways":true} | 0xba6dead255288075dce80c3927a8651d95611359794b7a4a2ac5268ed077ad37 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Market_ParameterUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Market\_PositionProcessed\_event
Position settlement events from Perennial v1 perpetual futures markets on Arbitrum, capturing profit and loss (PnL), funding rates, interest fees, and liquidation details for maker, long, and short positions. Used for analyzing trader profitability, fee accumulation, and liquidation activity across market participants.
| Column | Type | Description |
| ----------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_orderId` | `STRING` | Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations. |
| `in_order` | `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. |
| `in_accumulationResult` | `STRUCT` | Accumulated fees, funding payments, and profit/loss (PnL) amounts calculated for this position processing event across maker, long, and short positions. Values are denominated in the market's collateral token with negative values indicating debits and positive values indicating credits. |
| address | removed | in\_order | log\_index | in\_orderId | block\_number | block\_timestamp | transaction\_hash | in\_accumulationResult |
| ------------------------------------------ | ------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 0xc8b73ecfdb775cb9899a0d22ffc8d11228ac35cb | false | \{"orders":"0","longNeg":"0","longPos":"0","makerNeg":"0","makerPos":"0","shortNeg":"0","shortPos":"0","timestamp":"1723950460","collateral":"-2678782505","protection":"0","makerReferral":"0","takerReferral":"0"} | 3 | 118 | 244068298 | 2024-08-18T06:43:58.000Z | 0x52154313714f2201e4c3ade2b743dae799d1b13f278defdd3f675b50a88148e6 | \{"pnlLong":"0","pnlMaker":"0","pnlShort":"0","fundingFee":"971","fundingLong":"18950","interestFee":"808","positionFee":"0","fundingMaker":"-9061","fundingShort":"-10860","interestLong":"-10469","interestMaker":"15368","interestShort":"-5707","settlementFee":"0","liquidationFee":"0","positionFeeMaker":"0","positionFeeImpact":"0","positionFeeExposure":"0","positionFeeProtocol":"0","positionFeeSubtractive":"0","positionFeeExposureMaker":"0","positionFeeExposureProtocol":"0"} |
| 0xc8b73ecfdb775cb9899a0d22ffc8d11228ac35cb | false | \{"orders":"0","longNeg":"0","longPos":"0","makerNeg":"0","makerPos":"0","shortNeg":"0","shortPos":"0","timestamp":"1723964278","collateral":"0","protection":"0","makerReferral":"0","takerReferral":"0"} | 3 | 119 | 244071677 | 2024-08-18T06:58:12.000Z | 0xb66e8e59f18762910b45182381589721ac27bda9fcdd23a46b7a81a2c1944f48 | \{"pnlLong":"-93204972","pnlMaker":"42396857","pnlShort":"50808115","fundingFee":"23834","fundingLong":"464779","interestFee":"44446","positionFee":"0","fundingMaker":"-222258","fundingShort":"-266355","interestLong":"-575314","interestMaker":"844485","interestShort":"-313617","settlementFee":"0","liquidationFee":"5000000","positionFeeMaker":"0","positionFeeImpact":"0","positionFeeExposure":"-129194","positionFeeProtocol":"0","positionFeeSubtractive":"0","positionFeeExposureMaker":"129194","positionFeeExposureProtocol":"0"} |
| 0xc8b73ecfdb775cb9899a0d22ffc8d11228ac35cb | false | \{"orders":"0","longNeg":"0","longPos":"0","makerNeg":"0","makerPos":"0","shortNeg":"0","shortPos":"0","timestamp":"1723963427","collateral":"0","protection":"0","makerReferral":"0","takerReferral":"0"} | 4 | 118 | 244068298 | 2024-08-18T06:43:58.000Z | 0x52154313714f2201e4c3ade2b743dae799d1b13f278defdd3f675b50a88148e6 | \{"pnlLong":"-480588138","pnlMaker":"218608794","pnlShort":"261979344","fundingFee":"614894","fundingLong":"11990436","interestFee":"699204","positionFee":"0","fundingMaker":"-5733874","fundingShort":"-6871456","interestLong":"-9050476","interestMaker":"13284889","interestShort":"-4933617","settlementFee":"0","liquidationFee":"5000000","positionFeeMaker":"0","positionFeeImpact":"0","positionFeeExposure":"-666160","positionFeeProtocol":"0","positionFeeSubtractive":"0","positionFeeExposureMaker":"666160","positionFeeExposureProtocol":"0"} |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Market_PositionProcessed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Market\_RiskParameterUpdated\_event
Risk parameter configuration change events from Perennial V1 perpetual futures markets on Arbitrum. Contains margin requirements, maker/taker fee structures, liquidation parameters, and utilization curve settings for analyzing market risk controls and fee adjustments.
| 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_newRiskParameter` | `STRUCT, makerFee STRUCT, makerLimit STRING, efficiencyLimit STRING, liquidationFee STRING, utilizationCurve STRUCT, pController STRUCT, minMargin STRING, minMaintenance STRING, staleAfter STRING, makerReceiveOnly BOOL>` | Structured data containing updated risk management parameters for the Perennial V1 market, including margin requirements, fee structures, liquidity provider limits, and utilization curves. Each parameter update represents a configuration change to the market's trading and liquidation rules. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_newRiskParameter |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 0xc8b73ecfdb775cb9899a0d22ffc8d11228ac35cb | false | 25 | 257265274 | 2024-09-25T16:51:15.000Z | 0x91bbfa9414a0ce2b72332f5c06b4004c7717a5325f39216a931289ea0565fa40 | \{"margin":"95000","makerFee":\{"scale":"50000000000","linearFee":"100","adiabaticFee":"0","proportionalFee":"0"},"takerFee":\{"scale":"50000000000","linearFee":"1500","adiabaticFee":"9400","proportionalFee":"3200"},"minMargin":"50000000","makerLimit":"50000000000","staleAfter":"40","maintenance":"80000","pController":\{"k":"2304000000","max":"4820000","min":"-4820000"},"liquidationFee":"5000000","minMaintenance":"40000000","efficiencyLimit":"1000000","makerReceiveOnly":false,"utilizationCurve":\{"maxRate":"750000","minRate":"0","targetRate":"750000","targetUtilization":"500000"}} |
| 0xc8b73ecfdb775cb9899a0d22ffc8d11228ac35cb | false | 22 | 239722696 | 2024-08-05T14:55:52.000Z | 0xae0b91ed000a1447c6ce51be29f290fde931af0f9ae01b011f8087560579754c | \{"margin":"95000","makerFee":\{"scale":"50000000000","linearFee":"100","adiabaticFee":"0","proportionalFee":"0"},"takerFee":\{"scale":"50000000000","linearFee":"1500","adiabaticFee":"23000","proportionalFee":"10000"},"minMargin":"50000000","makerLimit":"50000000000","staleAfter":"40","maintenance":"80000","pController":\{"k":"4608000000","max":"3000000","min":"-3000000"},"liquidationFee":"5000000","minMaintenance":"40000000","efficiencyLimit":"1000000","makerReceiveOnly":false,"utilizationCurve":\{"maxRate":"750000","minRate":"0","targetRate":"750000","targetUtilization":"500000"}} |
| 0x5bef017ac7ea4f6f59946f27d50a137d4362f6a4 | false | 22 | 245394056 | 2024-08-22T03:14:57.000Z | 0xa47a4e296b809c1de120d4e017174a6eb4920a9e1afe104ad30f9aa8c9434dea | \{"margin":"19000","makerFee":\{"scale":"500000000000","linearFee":"100","adiabaticFee":"0","proportionalFee":"0"},"takerFee":\{"scale":"500000000000","linearFee":"800","adiabaticFee":"2400","proportionalFee":"400"},"minMargin":"50000000","makerLimit":"1000000000000","staleAfter":"40","maintenance":"16000","pController":\{"k":"9990000000","max":"3200000","min":"-3200000"},"liquidationFee":"5000000","minMaintenance":"40000000","efficiencyLimit":"1000000","makerReceiveOnly":false,"utilizationCurve":\{"maxRate":"750000","minRate":"0","targetRate":"750000","targetUtilization":"500000"}} |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Market_RiskParameterUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Market\_Updated\_event
Position update events from Perennial V1 perpetual futures markets on Arbitrum. Tracks changes to maker, long, and short positions with collateral adjustments, account addresses, and referrer data for analyzing trading activity and position management.
| 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_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_newMaker` | `STRING` | Updated position size for the maker (liquidity provider) side after this event. Specified in the protocol's base units, typically representing the amount of liquidity provided to the market. |
| `in_newLong` | `STRING` | New long position size for the account in this market after the update. Denominated in the protocol's base units (typically 1e6 or 1e18 scaled). |
| `in_newShort` | `STRING` | Updated short position size for the account after this market update event. Denominated in the market's base units, with zero indicating no short position held. |
| `in_collateral` | `STRING` | Contract address of the collateral asset or vault. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_protect` | `BOOL` | Indicates whether protection mode is enabled for this position update. Protection mode, when true, applies additional safeguards or restrictions to the position modification on the Perennial protocol. |
| `in_referrer` | `STRING` | Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_sender | log\_index | in\_account | in\_newLong | in\_protect | in\_version | in\_newMaker | in\_newShort | in\_referrer | block\_number | in\_collateral | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------ | ----------- | ----------- | ------------ | ------------ | ------------------------------------------ | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb7558189c794239ef9453208f2e58fa049e1035c | false | 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | 30 | 0x95465e180697879cdd127b210c4830a16e3f96e4 | 105298300000 | false | 1726692990 | 0 | 0 | 0x1813505edb82a5c0fc39ddb13213ac530eb5db6e | 254918009 | 1499990000 | 2024-09-18T20:56:28.000Z | 0xdef63681305f2e26eb4e9d40fcb92c8a11749f9ee3bc15af8f7b82177b15b8e9 |
| 0xb7558189c794239ef9453208f2e58fa049e1035c | false | 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | 15 | 0x95465e180697879cdd127b210c4830a16e3f96e4 | 105298300000 | false | 1726692770 | 0 | 0 | 0x1813505edb82a5c0fc39ddb13213ac530eb5db6e | 254917141 | 7999000000 | 2024-09-18T20:52:48.000Z | 0x0d43ef5a141045d7f49783b86ebed8c9386143d083ac7610610120d03147bbe9 |
| 0xb7558189c794239ef9453208f2e58fa049e1035c | false | 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | 6 | 0x95465e180697879cdd127b210c4830a16e3f96e4 | 0 | false | 1726700900 | 0 | 0 | 0x1813505edb82a5c0fc39ddb13213ac530eb5db6e | 254948870 | -9072447777 | 2024-09-18T23:08:20.000Z | 0x5890f8b6f8de183dddfe86899d940158deed72723f24bbe5dad07cdb1fb19689 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.Market_Updated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MarketFactory\_MarketCreated\_event
Market deployment events from Perennial V1 protocol's factory contract on Arbitrum, recording new perpetual market creation with associated collateral token and oracle addresses. Used to track protocol expansion and market configuration 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_market` | `STRING` | Trading pair or market identifier specifying the assets being traded or operated on. |
| `in_definition` | `STRUCT` | Nested structure containing the core configuration parameters for the newly created Perennial market, including token and oracle contract addresses. Defines the settlement token and price feed oracle that the market will use for perpetual futures trading. |
| address | removed | in\_market | log\_index | block\_number | in\_definition | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------------------------------------------------------------------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xdad8a103473dfd47f90168a0e46766ed48e26ec7 | false | 0xbc96a6e57000ade8755a896dfbd0552fe90141dd | 16 | 256556300 | \{"token":"0x52c64b8998eb7c80b6f526e99e29abdcc86b841b","oracle":"0x2821c8140cfebbd1b5ea8640d8ea3002b82dcf00"} | 2024-09-23T15:20:53.000Z | 0x115c14fa098d2a8c9e291f7f49704788030c23763a6b9219df9ac8abb6dbcb09 |
| 0xdad8a103473dfd47f90168a0e46766ed48e26ec7 | false | 0xb7558189c794239ef9453208f2e58fa049e1035c | 16 | 240402382 | \{"token":"0x52c64b8998eb7c80b6f526e99e29abdcc86b841b","oracle":"0x5d406166adbc524759052fd846f635217b17e959"} | 2024-08-07T14:28:03.000Z | 0xe69bbb984c5d23baf45a070a1be95a4e81160bca4c2d74d658aa69669ab4e151 |
| 0xdad8a103473dfd47f90168a0e46766ed48e26ec7 | false | 0xe588d7d041e18e754e95ef51d77f6e0fc6334efd | 36 | 247655841 | \{"token":"0x52c64b8998eb7c80b6f526e99e29abdcc86b841b","oracle":"0x9599f89aa0bd797dc28b14570731c4730dd9a6eb"} | 2024-08-28T16:56:25.000Z | 0x40412c755da71b71a2394edd1119d11f1a9c31d04236f2a5449ff6c82e287e2b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.MarketFactory_MarketCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MultiInvoker\_Initialized\_event
Contract initialization events for the Perennial V1 MultiInvoker contract on Arbitrum, tracking version upgrades and deployment instances. Used to identify when the batched transaction interface was deployed or upgraded.
| 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.perennial_v1_arbitrum.MultiInvoker_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MultiInvoker\_InterfaceFeeCharged\_event
Interface fee charge events from Perennial v1 protocol on Arbitrum, capturing fee amounts, receiver addresses, and market/account associations. Used for tracking protocol fee distribution and analyzing fee revenue across different markets and participants.
| 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":"336588","unwrap":false,"receiver":"0x8cda59615c993f925915d3eb4394badb3feef413"} | 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 0x90a664846960aafa2c164605aebb8e9ac338f9a0 | 25 | 0x2ed7c7a444480e1034ec069106ec767b6e834fd0 | 207960921 | 2024-05-05T03:31:03.000Z | 0xeabd643d4b952eabfbbddf61095f5c07903dff997ded9e6ac71b633b94b7f859 |
| \{"amount":"112195","unwrap":true,"receiver":"0x7fba85b7a0f256393072839de6d5149c0f6fa996"} | 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 0x90a664846960aafa2c164605aebb8e9ac338f9a0 | 20 | 0x2ed7c7a444480e1034ec069106ec767b6e834fd0 | 207960921 | 2024-05-05T03:31:03.000Z | 0xeabd643d4b952eabfbbddf61095f5c07903dff997ded9e6ac71b633b94b7f859 |
| \{"amount":"157650","unwrap":false,"receiver":"0x8cda59615c993f925915d3eb4394badb3feef413"} | 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 0x90a664846960aafa2c164605aebb8e9ac338f9a0 | 39 | 0x3e22901f96f85de35cfca88444651282eba39f36 | 208036388 | 2024-05-05T08:46:49.000Z | 0x3e45056c42e330a639ddfd9818df27227ebbd0fce4f0a8b1c34d9c662548ed62 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.MultiInvoker_InterfaceFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MultiInvoker\_KeeperCall\_event
Keeper bot execution logs from Perennial V1 protocol on Arbitrum, recording compensation paid to automated keepers for maintaining the protocol. Contains base fees, keeper fees, calldata costs, and sender addresses for analyzing keeper economics and protocol maintenance 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 consumed that are eligible for keeper compensation. This value is zero in all sample transactions, indicating potential unused or optional gas tracking. |
| `in_applicableValue` | `STRING` | Value eligible for keeper fee calculation in the Perennial v1 protocol on Arbitrum. Measured in wei; all sample values are 0, indicating no applicable value in these keeper operations. |
| `in_baseFee` | `STRING` | Base network fee per gas unit at the time of the keeper call, denominated in wei. This represents the Arbitrum L2 base fee component of transaction costs. |
| `in_calldataFee` | `STRING` | Calldata fee component paid for this keeper operation, measured in wei. Represents the cost associated with transaction input data 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 | 0x5a8557449c05fa515fea099178d42b9415b9f118 | 12 | 80700000000000 | 274165133 | 443854000000000000 | 59421026544000 | 2024-11-13T21:33:40.000Z | 0 | 0xb468c033cd06e66efdcaaf2071101740aad4a8f0440c6fea2da41f7412d96f86 | 0 |
| 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 0x5a8557449c05fa515fea099178d42b9415b9f118 | 12 | 276720000000000 | 274062056 | 1147306000000000000 | 77700148732800 | 2024-11-13T14:21:07.000Z | 0 | 0x82c60a058a400b3184cde06cd3971a091993889fa37ba5f50187f699d316898a | 0 |
| 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 0x5a8557449c05fa515fea099178d42b9415b9f118 | 12 | 69175500000000 | 274165352 | 407349000000000000 | 59421026544000 | 2024-11-13T21:34:35.000Z | 0 | 0x6e24638812faeb264946897f442347d7fe6a7da20ce53f317d0fda89c3322d19 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_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.perennial_v1_arbitrum.MultiInvoker_KeeperFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MultiInvoker\_OrderCancelled\_event
Order cancellation events from Perennial V1 protocol's MultiInvoker contract on Arbitrum, tracking cancelled orders by account, market, and nonce identifier. Used for analyzing order lifecycle and trader behavior patterns.
| 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 | 3363 | 0x90a664846960aafa2c164605aebb8e9ac338f9a0 | 3 | 0xd8ab31a65dada7e20f87660cff44fff13d30ca5a | 225240124 | 2024-06-24T13:50:43.000Z | 0x13ed83c454a3e7a9264d2a866c9c41905b5fba868858426a5f5a81f2b1833938 |
| 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 3362 | 0x90a664846960aafa2c164605aebb8e9ac338f9a0 | 1 | 0xd8ab31a65dada7e20f87660cff44fff13d30ca5a | 225240124 | 2024-06-24T13:50:43.000Z | 0x13ed83c454a3e7a9264d2a866c9c41905b5fba868858426a5f5a81f2b1833938 |
| 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 3369 | 0x90a664846960aafa2c164605aebb8e9ac338f9a0 | 9 | 0xd8ab31a65dada7e20f87660cff44fff13d30ca5a | 225247094 | 2024-06-24T14:19:48.000Z | 0x1d91f6329d7d60d6a49ead923456d473b34ee1bf742559dac39d489ca158732c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.MultiInvoker_OrderCancelled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MultiInvoker\_OrderExecuted\_event
Order execution events from Perennial V1 protocol's MultiInvoker contract on Arbitrum, tracking when limit or conditional orders are filled with account, market, and sequential nonce identifiers. Used for analyzing automated order execution patterns and market-specific trading 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_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 | 9956 | 0x02258be4ac91982dc1af7a3d2c4f05be6079c253 | 14 | 0x2dc4f5bb4f5ce62ca844dfa598a37d6cf31ac513 | 256012474 | 2024-09-22T01:24:53.000Z | 0xaf74008b5ddb2b3c7228915d69edfd4498227fc253438122de2949b5336c8f12 |
| 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 9939 | 0x02258be4ac91982dc1af7a3d2c4f05be6079c253 | 16 | 0x2dc4f5bb4f5ce62ca844dfa598a37d6cf31ac513 | 255996271 | 2024-09-22T00:17:00.000Z | 0x5df92c6c1b420fc9c1eb3eb6da122718f31b2761fe373e28992cc5881684b293 |
| 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 9959 | 0x02258be4ac91982dc1af7a3d2c4f05be6079c253 | 21 | 0x2dc4f5bb4f5ce62ca844dfa598a37d6cf31ac513 | 256030893 | 2024-09-22T02:41:53.000Z | 0xfd11fd240b334d66c6e6423892f427fd211ebcf939cad8c02b1d52e8ee77b527 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.MultiInvoker_OrderExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MultiInvoker\_OrderPlaced\_event
Limit order placements from Perennial v1 perpetual futures protocol on Arbitrum. Contains trigger price, position delta, side (long/short), fees, and account data for analyzing conditional order strategies and automated trading behavior.
| 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 | 1816 | \{"fee":"3000000","side":1,"delta":"-224395570","price":"2500000","comparison":1,"interfaceFee1":\{"amount":"0","unwrap":false,"receiver":"0x0000000000000000000000000000000000000000"},"interfaceFee2":\{"amount":"56098","unwrap":false,"receiver":"0x8cda59615c993f925915d3eb4394badb3feef413"}} | 0x3d1d603073b3ceab5974db5c54568058a9551ccc | 24 | 0x6d1afe57141eaf3e99d0a49e6563409baff240d0 | 182937774 | 2024-02-21T08:00:34.000Z | 0x89682301fe605dee7859a9cc000389677e3640833293b242392f8729cd4a4afd |
| 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 1815 | \{"fee":"3000000","side":1,"delta":"-224395570","price":"1835000","comparison":-1,"interfaceFee1":\{"amount":"0","unwrap":false,"receiver":"0x0000000000000000000000000000000000000000"},"interfaceFee2":\{"amount":"41176","unwrap":false,"receiver":"0x8cda59615c993f925915d3eb4394badb3feef413"}} | 0x3d1d603073b3ceab5974db5c54568058a9551ccc | 23 | 0x6d1afe57141eaf3e99d0a49e6563409baff240d0 | 182937774 | 2024-02-21T08:00:34.000Z | 0x89682301fe605dee7859a9cc000389677e3640833293b242392f8729cd4a4afd |
| 0x431603567ecbb4aa1ce5a4fdbe5554caea658832 | false | 1817 | \{"fee":"20000000","side":1,"delta":"1187349","price":"2917000000","comparison":-1,"interfaceFee1":\{"amount":"0","unwrap":false,"receiver":"0x0000000000000000000000000000000000000000"},"interfaceFee2":\{"amount":"346349","unwrap":false,"receiver":"0x8cda59615c993f925915d3eb4394badb3feef413"}} | 0x90a664846960aafa2c164605aebb8e9ac338f9a0 | 0 | 0x62ebf9bc4220903bec0b7e7a3e702263515ebac7 | 182960828 | 2024-02-21T09:37:36.000Z | 0x0e761bc172de769f144153b9a32a491b5201612d2425a63df7ff4fe0e2bf5c1b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.perennial_v1_arbitrum.MultiInvoker_OrderPlaced_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***