Skip to main content

​
Tables

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_solverSTRINGAddress of the solver that executed the settlement or was added to the allow list. Hex-encoded, 0x-prefixed, 42-character string.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.unidex_v1_bsc.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_sellTokenSTRINGContract address of the token being sold in the trade. Hex-encoded, 0x-prefixed, 42-character string.
in_buyTokenSTRINGContract address of the token being purchased in the trade. Hex-encoded, 0x-prefixed, 42-character string.
in_sellAmountSTRINGAmount of tokens sold in the trade. Numeric string representation of token quantity in smallest denomination.
in_buyAmountSTRINGAmount of tokens received in the trade. Numeric string representation of token quantity in smallest denomination.
in_feeAmountSTRINGFee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
in_orderUidSTRINGUnique identifier for the order being executed in the trade. Hex-encoded string containing order hash, owner address, and validity timestamp.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.unidex_v1_bsc.Settlement_Trade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100