unidex_v1_polygon

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	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	293	0xa6886da9	46370565	2023-08-16T09:15:57.000Z	0x3197616a304e2d0296954d3e254b401b17e075764963ceac33df0a92b081d371
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	162	0x46c67b6d	44040093	2023-06-18T05:10:58.000Z	0xb95af2246f385b476f231ebbb3637c7a3da5988bdd70ef4865a98584768f0292
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0x580a84c73811e1839f75d86d75d88cca0c241ff4	352	0x095ea7b3	40551304	2023-03-20T03:51:06.000Z	0x8c7c9adb05598aeaae09c8732b725699ac7386dfa5c0861503f1740df973f9b0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unidex_v1_polygon.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	220	43302725	2023-05-29T21:14:13.000Z	0x989084b21905dbdc86c73bd965c47df95be4cb61a7140ffb8dbc4616c2cac015
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0x5870c519ee1c93573bd8f451fb0715d44f6984a8	110	43302418	2023-05-29T21:03:16.000Z	0x53fc6e1d8e7149bee29b9c0da542fc3ea56f9b1f3d126359e461add1fb154f68
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0x5870c519ee1c93573bd8f451fb0715d44f6984a8	399	43591564	2023-06-06T09:33:47.000Z	0x8cdb1d882dab69f5e88fbf2c4b2b1aacf1ec37d6145c8d67b05aa8f86b91b63c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unidex_v1_polygon.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	0xc797dbcb6d0518b4cd8dadd58f831365bbdb0e6c	151	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0xecfd25ea47a9da60bc9d482aa62dfba05f8d9d7173c7097eb2fa5bdcff5c29ffc797dbcb6d0518b4cd8dadd58f831365bbdb0e6c642893d9	41030132	453424354959085753	17891	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	519684	2023-04-01T19:59:25.000Z	0x8c9451401cf4579f259d99b72b6d5d29058cb30b6ed15a1d9df9b7780e531a4e
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0x970a0575a3e5a1c76493b5744b90bd0a490b0886	200	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x275c01a0bb4501bbc9e48070baa4425bbccca9a1797f27e0cc445d49e704c778970a0575a3e5a1c76493b5744b90bd0a490b0886ffffffff	41029939	519684	28076884139984792	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	500000000000000000	2023-04-01T19:51:29.000Z	0x8865ae50157447756d01f3b19869bf5dd395078e5fdd13b05c5023eb6fd86e75
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xfbbe90dd04250b5e789ed9d1bfba2476e524a852	250	0x8f3cf7ad23cd3cadbd9735aff958023239c6a063	0xedefe9a10f4d77c1f8fc4f3c1d38e4d72189a8ae28be5736bd4df0ecffcfaa08fbbe90dd04250b5e789ed9d1bfba2476e524a852640fecb8	40321220	9922875925878557587	64121	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	10000000	2023-03-14T03:11:10.000Z	0x31dbb689de886fd442901f90c698b3167e013129a2aa6f5926af6d980989fd28

Example Query

Query with partition filter

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