uniswaplabs_v3_bsc

Tables

UniversalRouter_execute_function

Uniswap UniversalRouter execute function calls on BNB Smart Chain (BSC), capturing transaction-level data including commands, inputs, gas consumption, and execution status. Useful for analyzing routing patterns, failed transactions, and gas efficiency of swaps and liquidity operations through Uniswap’s universal router contract.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_commands`	`STRING`	Encoded sequence of operation commands to be executed by the Uniswap Universal Router contract. Hex-encoded byte string where each byte represents a specific router command type.
`in_inputs`	`ARRAY<STRING>`	Array of ABI-encoded parameters corresponding to each command in the Universal Router execution sequence. Hex-encoded byte strings containing operation-specific data such as token amounts, addresses, and swap paths.

Sample Data

gas	status	gas_used	in_inputs	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
177740	false	177544	[]	0x24856bc3	0xec8b0f7ffe3ae75d7ffab09429e3675bb63503e4	33610946	0x3f595b0cca0037e6d6859d6f93bbc40fb91e5bb9	2023-11-18T21:18:22.000Z	0xe4e13641e4be2d1837c337ea779bf68e2b52bdb0b53f1888163992666bdb10fa
177300	false	177106	[]	0x24856bc3	0xec8b0f7ffe3ae75d7ffab09429e3675bb63503e4	33612482	0xd414a0d48bb195321a01fa5f3dfe5919f56bf01b	2023-11-18T22:35:18.000Z	0xf82576bc74875e78a91687eacbf59f920a35fde7e77cdb97a4a7af33a2cfe069
178862	false	178662	[]	0x24856bc3	0xec8b0f7ffe3ae75d7ffab09429e3675bb63503e4	33604154	0xfc591bd7ce14b4bf2b23b5f52fb55fec9b07ccde	2023-11-18T15:36:41.000Z	0xd7656f08e14dc0a5b4dc697523f9c8ee6c15c4574e0e6e3015a27540c48557fb

Example Query

Query with partition filter

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

UniversalRouter_execute2_function

Failed execute2 function calls to Uniswap’s UniversalRouter contract on BNB Smart Chain. All sample records show failed transactions (status=false) with null command and deadline parameters, useful for analyzing router execution failures and transaction revert 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_commands`	`STRING`	Encoded sequence of operation commands to be executed by the Uniswap Universal Router contract. Hex-encoded byte string where each byte represents a specific router command type.
`in_inputs`	`ARRAY<STRING>`	Array of ABI-encoded parameters corresponding to each command in the Universal Router execution sequence. Hex-encoded byte strings containing operation-specific data such as token amounts, addresses, and swap paths.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.

Sample Data

gas	status	gas_used	in_inputs	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
294239	false	11081	[]	0x3593564c	0xec8b0f7ffe3ae75d7ffab09429e3675bb63503e4	33896910	0xa189a5aeeee39a388f73af8b40efd2f504a5565a	2023-11-28T20:26:11.000Z	0x3081ed93b45ad54dfbe7fc2c15a75eaaf22fdfbfab347923f0efe291e0d6a49f
292686	false	11081	[]	0x3593564c	0xec8b0f7ffe3ae75d7ffab09429e3675bb63503e4	33895511	0xf6b35aa8e8929762d5b0f7c5be5ac0bd981a7128	2023-11-28T19:16:13.000Z	0x80613b6a73b90105b558a5720dd502853552a3a7765f630a09d729dac222f7c5
312857	false	11081	[]	0x3593564c	0xec8b0f7ffe3ae75d7ffab09429e3675bb63503e4	33895771	0x1cba06536b0b8c6e74901f7d21b7f4825f445774	2023-11-28T19:29:13.000Z	0xa6e3b20d196c1bd8e8cebbfa28916f051a03c8645d618f55540d5eab7c9d0770

Example Query

Query with partition filter

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

UniversalRouter_uniswapV3SwapCallback_function

Callback function executions from Uniswap V3 UniversalRouter swaps on BNB Smart Chain, capturing token amount deltas (amount0Delta and amount1Delta) during swap settlements. Used for analyzing swap execution details and liquidity pool token 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_amount0Delta`	`STRING`	Change in amount for the first token in a Uniswap V3 liquidity pool swap. Positive values indicate tokens owed to the pool, negative values indicate tokens owed to the recipient.
`in_amount1Delta`	`STRING`	Change in amount for the second token in a Uniswap V3 liquidity pool swap. Positive values indicate tokens owed to the pool, negative values indicate tokens owed to the recipient.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

gas	status	in_data	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_amount0Delta	in_amount1Delta	transaction_hash
188826	true	0x0000000000000000000000000000000000000000000000000000000000000040000000000000000000000000dfaa5acd08745b64db62d1bc30ef2cce6ce8cdc4000000000000000000000000000000000000000000000000000000000000002bba2ae424d960c26247dd6c32edc70b295c744c4300271055d398326f99059ff775485246999027b3197955000000000000000000000000000000000000000000	27476	0xfa461e33	0xec8b0f7ffe3ae75d7ffab09429e3675bb63503e4	33488423	0x023b6298e2f9ae728b324757599f2a36e002a55a	0,2	2023-11-14T14:48:29.000Z	-20438952680883954274	27806399655	0x0679898cec179bbca1d002e5c654c1a06e2bda1fdca61e7836fcf80d95d8e25c
62571	true	0x0000000000000000000000000000000000000000000000000000000000000040000000000000000000000000ec8b0f7ffe3ae75d7ffab09429e3675bb63503e4000000000000000000000000000000000000000000000000000000000000002b55d398326f99059ff775485246999027b3197955002710ba2ae424d960c26247dd6c32edc70b295c744c43000000000000000000000000000000000000000000	8411	0xfa461e33	0xec8b0f7ffe3ae75d7ffab09429e3675bb63503e4	33487638	0x023b6298e2f9ae728b324757599f2a36e002a55a	2,2	2023-11-14T14:09:14.000Z	5012986669062069815	-6729433036	0xf017fa36f2325521665595c65c39e425fb0240cb4f71f5ecac921445b3ecfd47
67846	true	0x0000000000000000000000000000000000000000000000000000000000000040000000000000000000000000ec8b0f7ffe3ae75d7ffab09429e3675bb63503e4000000000000000000000000000000000000000000000000000000000000002b55d398326f99059ff775485246999027b3197955002710ba2ae424d960c26247dd6c32edc70b295c744c43000000000000000000000000000000000000000000	8411	0xfa461e33	0xec8b0f7ffe3ae75d7ffab09429e3675bb63503e4	33492815	0x023b6298e2f9ae728b324757599f2a36e002a55a	2,2	2023-11-14T18:28:23.000Z	1841828550687867556	-2492975271	0x6f8f4d929fcf0162e6ada8ab68d61bf6dfd08a4f925b7c9fcedaefdd6a62dfea

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

UniversalRouter_execute_function

UniversalRouter_execute2_function

UniversalRouter_uniswapV3SwapCallback_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​UniversalRouter_execute_function

​UniversalRouter_execute2_function

​UniversalRouter_uniswapV3SwapCallback_function

Tables

UniversalRouter_execute_function

UniversalRouter_execute2_function

UniversalRouter_uniswapV3SwapCallback_function