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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

address	removed	in_amount	log_index	in_account	in_product	block_number	block_timestamp	transaction_hash
0xaf8ced28fce00abd30463d55da81156aa5aeeec2	false	-5870853185568364665	0	0x9680f3957510cf85751a096c2194520c36a4a003	0x4243b34374cfb0a12f184b92f52035d03d4f7056	151248508	2023-11-17T07:39:13.000Z	0x25ec0cb18c362ecbda3b80c88fede4994bff2ff039d90045a386914aab0a7a1e
0xaf8ced28fce00abd30463d55da81156aa5aeeec2	false	117270966644878150	7	0x50ed348f85de0772a61ff63bbe33df8db30de1b2	0x1cd33f4e6edeee8263aa07924c2760cf2ec8aad0	151376230	2023-11-17T16:35:34.000Z	0xdb929ef9b45e6113f464876d480181a7fcd6e65c90fdc9c81a2dafce9aa07a5a
0xaf8ced28fce00abd30463d55da81156aa5aeeec2	false	0	6	0x1960628db367281b1a186dd5b80b5dd6978f016f	0x4e67a8a428206af5a6ac00ba08a67ce827182985	151272598	2023-11-17T09:19:56.000Z	0xfc81953fe7cef05860139708e47f187cb2698c0e03873d0553c3a36334ff720b

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_account	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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0xaf8ced28fce00abd30463d55da81156aa5aeeec2	false	0	1	54344764	2023-01-20T19:02:40.000Z	0x16b81029bb798a337a4751e0dfc0e1b20e452bc75ad4c2931f5d9dc74f704852

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

address	removed	log_index	in_product	block_number	block_timestamp	transaction_hash
0xaf8ced28fce00abd30463d55da81156aa5aeeec2	false	6	0x4e67a8a428206af5a6ac00ba08a67ce827182985	222296653	2024-06-16T01:17:57.000Z	0x15ec0330234e322179fbcfaa58f74ae63ec9d0893406ccecaf7c8b091b40acf4
0xaf8ced28fce00abd30463d55da81156aa5aeeec2	false	2	0x5e660b7b8357059241eaec143e1e68a5a108d035	222296653	2024-06-16T01:17:57.000Z	0x15ec0330234e322179fbcfaa58f74ae63ec9d0893406ccecaf7c8b091b40acf4
0xaf8ced28fce00abd30463d55da81156aa5aeeec2	false	2	0x5e660b7b8357059241eaec143e1e68a5a108d035	222334738	2024-06-16T03:56:48.000Z	0x16dc9ac23280f9c6844962445c5e320154bdf51a193564a56acda530fc882afa

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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<timestamp STRING, orders STRING, collateral STRING, makerPos STRING, makerNeg STRING, longPos STRING, longNeg STRING, shortPos STRING, shortNeg STRING, protection STRING, makerReferral STRING, takerReferral STRING>`	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<collateral STRING, linearFee STRING, proportionalFee STRING, adiabaticFee STRING, settlementFee STRING, liquidationFee STRING, subtractiveFee STRING>`	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.

Sample Data

address	removed	in_order	log_index	in_account	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	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	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	248970798	2024-09-01T12:50:07.000Z	0xb5beabd239b8c7ef1f425202e385adfa17c544a6fe240ad0ddfbace85d201e24	{“linearFee”:“0”,“collateral”:“0”,“adiabaticFee”:“0”,“settlementFee”:“0”,“liquidationFee”:“0”,“subtractiveFee”:“0”,“proportionalFee”:“0”}

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_account	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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newOracle`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_order`	`STRUCT<timestamp STRING, orders STRING, collateral STRING, makerPos STRING, makerNeg STRING, longPos STRING, longNeg STRING, shortPos STRING, shortNeg STRING, protection STRING, makerReferral STRING, takerReferral STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.

Sample Data

address	removed	in_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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newParameter`	`STRUCT<fundingFee STRING, interestFee STRING, positionFee STRING, oracleFee STRING, riskFee STRING, maxPendingGlobal STRING, maxPendingLocal STRING, settlementFee STRING, takerCloseAlways BOOL, makerCloseAlways BOOL, closed BOOL, settle BOOL>`	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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_order`	`STRUCT<timestamp STRING, orders STRING, collateral STRING, makerPos STRING, makerNeg STRING, longPos STRING, longNeg STRING, shortPos STRING, shortNeg STRING, protection STRING, makerReferral STRING, takerReferral STRING>`	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<positionFee STRING, positionFeeMaker STRING, positionFeeProtocol STRING, positionFeeSubtractive STRING, positionFeeExposure STRING, positionFeeExposureMaker STRING, positionFeeExposureProtocol STRING, positionFeeImpact STRING, fundingMaker STRING, fundingLong STRING, fundingShort STRING, fundingFee STRING, interestMaker STRING, interestLong STRING, interestShort STRING, interestFee STRING, pnlMaker STRING, pnlLong STRING, pnlShort STRING, settlementFee STRING, liquidationFee STRING>`	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.

Sample Data

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”}

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newRiskParameter`	STRUCT<margin STRING, maintenance STRING, takerFee STRUCT<linearFee STRING, proportionalFee STRING, adiabaticFee STRING, scale STRING>, makerFee STRUCT<linearFee STRING, proportionalFee STRING, adiabaticFee STRING, scale STRING>, makerLimit STRING, efficiencyLimit STRING, liquidationFee STRING, utilizationCurve STRUCT<minRate STRING, maxRate STRING, targetRate STRING, targetUtilization STRING>, pController STRUCT<k STRING, min STRING, max STRING>, 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.

Sample Data

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”}}

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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.

Sample Data

address	removed	in_sender	log_index	in_account	in_newLong	in_protect	in_version	in_referrer	block_number	in_collateral	block_timestamp	transaction_hash
0xb7558189c794239ef9453208f2e58fa049e1035c	false	0x431603567ecbb4aa1ce5a4fdbe5554caea658832	30	0x95465e180697879cdd127b210c4830a16e3f96e4	105298300000	false	1726692990	0x1813505edb82a5c0fc39ddb13213ac530eb5db6e	254918009	1499990000	2024-09-18T20:56:28.000Z	0xdef63681305f2e26eb4e9d40fcb92c8a11749f9ee3bc15af8f7b82177b15b8e9
0xb7558189c794239ef9453208f2e58fa049e1035c	false	0x431603567ecbb4aa1ce5a4fdbe5554caea658832	15	0x95465e180697879cdd127b210c4830a16e3f96e4	105298300000	false	1726692770	0x1813505edb82a5c0fc39ddb13213ac530eb5db6e	254917141	7999000000	2024-09-18T20:52:48.000Z	0x0d43ef5a141045d7f49783b86ebed8c9386143d083ac7610610120d03147bbe9
0xb7558189c794239ef9453208f2e58fa049e1035c	false	0x431603567ecbb4aa1ce5a4fdbe5554caea658832	6	0x95465e180697879cdd127b210c4830a16e3f96e4	0	false	1726700900	0x1813505edb82a5c0fc39ddb13213ac530eb5db6e	254948870	-9072447777	2024-09-18T23:08:20.000Z	0x5890f8b6f8de183dddfe86899d940158deed72723f24bbe5dad07cdb1fb19689

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_definition`	`STRUCT<token STRING, oracle STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

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

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_fee`	`STRUCT<amount STRING, receiver STRING, unwrap BOOL>`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	address	removed	in_market	log_index	in_account	block_number	block_timestamp	transaction_hash
{“amount”:“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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_applicableGas`	`STRING`	Gas units 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.

Sample Data

address	removed	in_sender	log_index	in_baseFee	block_number	in_keeperFee	in_calldataFee	block_timestamp	transaction_hash
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	0x5a8557449c05fa515fea099178d42b9415b9f118	12	80700000000000	274165133	443854000000000000	59421026544000	2024-11-13T21:33:40.000Z	0xb468c033cd06e66efdcaaf2071101740aad4a8f0440c6fea2da41f7412d96f86
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	0x5a8557449c05fa515fea099178d42b9415b9f118	12	276720000000000	274062056	1147306000000000000	77700148732800	2024-11-13T14:21:07.000Z	0x82c60a058a400b3184cde06cd3971a091993889fa37ba5f50187f699d316898a
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	0x5a8557449c05fa515fea099178d42b9415b9f118	12	69175500000000	274165352	407349000000000000	59421026544000	2024-11-13T21:34:35.000Z	0x6e24638812faeb264946897f442347d7fe6a7da20ce53f317d0fda89c3322d19

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.

Sample Data

address	removed	in_nonce	in_market	log_index	in_account	block_number	block_timestamp	transaction_hash
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.

Sample Data

address	removed	in_nonce	in_market	log_index	in_account	block_number	block_timestamp	transaction_hash
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_order`	`STRUCT<side INT64, comparison INT64, fee STRING, price STRING, delta STRING, interfaceFee1 STRUCT<amount STRING, receiver STRING, unwrap BOOL>, interfaceFee2 STRUCT<amount STRING, receiver STRING, unwrap BOOL>>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.

Sample Data

address	removed	in_nonce	in_order	in_market	log_index	in_account	block_number	block_timestamp	transaction_hash
0x431603567ecbb4aa1ce5a4fdbe5554caea658832	false	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

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Collateral_AccountSettle_event

Collateral_Deposit_event

Collateral_FeeClaim_event

Collateral_Initialized_event

Collateral_Liquidation_event

Collateral_ProductSettle_event

Collateral_ShortfallResolution_event

Collateral_Withdrawal_event

Market_AccountPositionProcessed_event

Market_BeneficiaryUpdated_event

Market_CoordinatorUpdated_event

Market_ExposureClaimed_event

Market_FeeClaimed_event

Market_OracleUpdated_event

Market_OrderCreated_event

Market_ParameterUpdated_event

Market_PositionProcessed_event

Market_RiskParameterUpdated_event

Market_Updated_event

MarketFactory_MarketCreated_event

MultiInvoker_Initialized_event

MultiInvoker_InterfaceFeeCharged_event

MultiInvoker_KeeperCall_event

MultiInvoker_KeeperFeeCharged_event

MultiInvoker_OrderCancelled_event

MultiInvoker_OrderExecuted_event

MultiInvoker_OrderPlaced_event

​Tables

​Collateral_AccountSettle_event

​Collateral_Deposit_event

​Collateral_FeeClaim_event

​Collateral_Initialized_event

​Collateral_Liquidation_event

​Collateral_ProductSettle_event

​Collateral_ShortfallResolution_event

​Collateral_Withdrawal_event

​Market_AccountPositionProcessed_event

​Market_BeneficiaryUpdated_event

​Market_CoordinatorUpdated_event

​Market_ExposureClaimed_event

​Market_FeeClaimed_event

​Market_OracleUpdated_event

​Market_OrderCreated_event

​Market_ParameterUpdated_event

​Market_PositionProcessed_event

​Market_RiskParameterUpdated_event

​Market_Updated_event

​MarketFactory_MarketCreated_event

​MultiInvoker_Initialized_event

​MultiInvoker_InterfaceFeeCharged_event

​MultiInvoker_KeeperCall_event

​MultiInvoker_KeeperFeeCharged_event

​MultiInvoker_OrderCancelled_event

​MultiInvoker_OrderExecuted_event

​MultiInvoker_OrderPlaced_event

Tables

Collateral_AccountSettle_event

Collateral_Deposit_event

Collateral_FeeClaim_event

Collateral_Initialized_event

Collateral_Liquidation_event

Collateral_ProductSettle_event

Collateral_ShortfallResolution_event

Collateral_Withdrawal_event

Market_AccountPositionProcessed_event

Market_BeneficiaryUpdated_event

Market_CoordinatorUpdated_event

Market_ExposureClaimed_event

Market_FeeClaimed_event

Market_OracleUpdated_event

Market_OrderCreated_event

Market_ParameterUpdated_event

Market_PositionProcessed_event

Market_RiskParameterUpdated_event

Market_Updated_event

MarketFactory_MarketCreated_event

MultiInvoker_Initialized_event

MultiInvoker_InterfaceFeeCharged_event

MultiInvoker_KeeperCall_event

MultiInvoker_KeeperFeeCharged_event

MultiInvoker_OrderCancelled_event

MultiInvoker_OrderExecuted_event

MultiInvoker_OrderPlaced_event