unidex_v1_arbitrum

Tables

Settlement_Interaction_event

Settlement interaction events from the UniDex V1 protocol recording contract calls with function selectors, target addresses, and value parameters. Used for tracking cross-protocol settlement operations and DEX aggregator interactions.

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_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_selector`	`STRING`	Function selector identifying the smart contract method being called. 10-character hex string including 0x prefix representing the first 4 bytes of the keccak256 hash of the function signature.

Sample Data

address	removed	in_target	log_index	in_selector	block_number	block_timestamp	transaction_hash
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	9	0x095ea7b3	70413336	2023-03-16T13:11:40.000Z	0xa51b5e39d9cc084766f049fac9351b919827b337accb2ec70d4a8dbe5407a946
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xdef1c0ded9bec7f1a1670819833240f027b25eff	22	0x415565b0	70413336	2023-03-16T13:11:40.000Z	0xa51b5e39d9cc084766f049fac9351b919827b337accb2ec70d4a8dbe5407a946
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0x1111111254eeb25477b68fb85ed929f73a960582	9	0xe449022e	70353961	2023-03-16T09:02:02.000Z	0x41562b060ab4fafd069427ce79ecfefc38d8808af9249c833c7b0de37edab859

Example Query

Query with partition filter

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

Settlement_Settlement_event

Settlement execution events from the UniDex v1 protocol containing solver addresses authorized to execute settlements. Records when solvers are added to or removed from the settlement allow list across multiple chains.

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_solver`	`STRING`	Address of the solver that executed the settlement or was added to the allow list. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_solver	log_index	block_number	block_timestamp	transaction_hash
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0x5870c519ee1c93573bd8f451fb0715d44f6984a8	13	129573496	2023-09-09T18:02:08.000Z	0xd9696af9569c2ba4bb2f01958840f4e3133dcfcd865feac571b4d1bcb93daf00
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xa82eb51c866fb85b28d3876c24505e07d6459dba	11	129529798	2023-09-09T14:40:45.000Z	0x0d83eadb93fefad57b214829af409d2416da18ec29393e2ba642e564f44077b9
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xa82eb51c866fb85b28d3876c24505e07d6459dba	10	129511479	2023-09-09T13:19:33.000Z	0xb386c2a60e5fbd309c13e5cf8cb449af9f90f0b9aa7b8aff0cf0aadea00d4f9c

Example Query

Query with partition filter

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

Settlement_Trade_event

Trade execution events from UniDex V1 settlement contracts containing order identifiers, token swap details (buy/sell tokens and amounts), owner addresses, and fee information. Used for tracking DEX (Decentralized Exchange) order settlement and trade volume analysis across multiple chains.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_sellToken`	`STRING`	Contract address of the token being sold in the trade. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyToken`	`STRING`	Contract address of the token being purchased in the trade. Hex-encoded, 0x-prefixed, 42-character string.
`in_sellAmount`	`STRING`	Amount of tokens sold in the trade. Numeric string representation of token quantity in smallest denomination.
`in_buyAmount`	`STRING`	Amount of tokens received in the trade. Numeric string representation of token quantity in smallest denomination.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
`in_orderUid`	`STRING`	Unique identifier for the order being executed in the trade. Hex-encoded string containing order hash, owner address, and validity timestamp.

Sample Data

address	removed	in_owner	log_index	in_buyToken	in_orderUid	block_number	in_buyAmount	in_feeAmount	in_sellToken	in_sellAmount	block_timestamp	transaction_hash
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0x3aaa31aa2fba1d1dbbc3a7f6e59b4a5b6fd5a607	4	0x5429706887fcb58a595677b73e9b0441c25d993d	0xc0d299238d97fb332a610e3fd29dc23c0130ede7cdfa80e711d154ddaeeae60b3aaa31aa2fba1d1dbbc3a7f6e59b4a5b6fd5a60764c23c4a	115409247	489056535119767329570	72196410000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	1100000000000000000	2023-07-27T09:14:27.000Z	0xcb453065e9507d3b4decea3c80fd049e086dc1c717e1d2cfadf4dbacbd59d903
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xc7075c47aaf974379155c9d90cc9a8e14059d9a1	8	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0xda1e644df7e2e88375a242df435f65d2352c6e4105622cdd0e2795ec6674aeddc7075c47aaf974379155c9d90cc9a8e14059d9a164c268c9	115454394	49275731	703344824310374912	0xf9df075716b2d9b95616341dc6bc64c85e56645c	301434822337364000000	2023-07-27T12:23:52.000Z	0x2d62fe0a64e54f1cfbfe6ad806fdc5862160d7c72650e19f65e757cf3ceb6de0
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xc7075c47aaf974379155c9d90cc9a8e14059d9a1	0	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0xf4a5370be6a9e8171c48941e788ac14b16cc1f2e598bea53570b084e8695f939c7075c47aaf974379155c9d90cc9a8e14059d9a164c269db	115455468	35315285	665981028895287680	0x31c91d8fb96bff40955dd2dbc909b36e8b104dde	210672230520427000000	2023-07-27T12:28:22.000Z	0x910d6751b99af5abd8e04fd42f3048291b0e83fc347eee4a6d9f5c890608b406

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Settlement_Interaction_event

Settlement_Settlement_event

Settlement_Trade_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Settlement_Interaction_event

​Settlement_Settlement_event

​Settlement_Trade_event

Tables

Settlement_Interaction_event

Settlement_Settlement_event

Settlement_Trade_event