uniswaplabs_v3_ethereum

Tables

UniswapXDutchOrderReactor_Fill_event

Order fill events from UniswapX Dutch auction protocol on Ethereum, recording completed swaps with swapper address, filler address, order hash, and nonce. Used for analyzing UniswapX trading activity, filler competition, and order execution 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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_filler`	`STRING`	Address of the entity that fulfilled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
`in_swapper`	`STRING`	Address of the user who initiated the swap order on UniswapX. This is the original order creator whose tokens are being exchanged through the Dutch auction mechanism.
`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_filler	log_index	in_swapper	block_number	in_orderHash	block_timestamp	transaction_hash
0x6000da47483062a0d734ba3dc7576ce6a0b645c4	false	1993352217462191048146457777812992760694900912840742524539315360240479964672	0x0ca24498339bcb6890eb8a8e216179c06a2d58cf	60	0x4ea2fb1dccb4a385d401e55684dac36e58034ce8	18151628	0x0ec0c4797356bef8cf6e77f5756e26ab5324b2378b6d54185194860375b7d937	2023-09-16T22:24:11.000Z	0xffb6dc2293ab4f22cc9bb1c3c0f98d6d9e76a44ea0308b1f416cf02802ab4729
0x6000da47483062a0d734ba3dc7576ce6a0b645c4	false	1993353340093437484243842712175106165774375969705321802547809617917239652608	0x2008b6c3d07b061a84f790c035c2f6dc11a0be70	417	0x93632628516a47cbf059db47426ff83e0969ec74	18145938	0x00a9afac3301db2c270ce80e30e8ff0594b0bad510e4a89c7a9ff5bf2281e235	2023-09-16T03:06:11.000Z	0x654c2bca2126e4fe4ca3c6e0badff362844971a511603b265f9edde0bcf8fbc6
0x6000da47483062a0d734ba3dc7576ce6a0b645c4	false	1993351660471720943006214545425737672641199287954899926374971010470084178688	0x2008b6c3d07b061a84f790c035c2f6dc11a0be70	193	0x0b191138ac36d9544a463e980048cab89addffab	18145302	0xa67454c69178822a1afb2e1a306bdced479b82aa7bea4a236f65d99aaba89e91	2023-09-16T00:57:11.000Z	0xff871d39be297cc1afdadc48e76576e8d21884aa77658c3e19533d7703806a63

Example Query

Query with partition filter

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

UniversalRouter_collectRewards_function

Function calls to collectRewards on Uniswap’s UniversalRouter contract on Ethereum, capturing reward collection transactions with gas metrics and execution status. Used for analyzing user reward claims and router usage 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`	`INT64`	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_looksRareClaim`	`STRING`	Input parameter containing the claim data structure for LooksRare NFT marketplace rewards. Null when the collectRewards function call does not involve LooksRare claims.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash	in_looksRareClaim
363528	0	false	3242	0x709a1cc2	0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	18146237	0xfe5a00b3caad9a8f1c4437398070ec91f9edb617		2023-09-16T04:06:35.000Z	0x503e02f444fe6ee23d4a6b0b07e5ac953901d02c3ee8f883fa77524d096e7ad3

Example Query

Query with partition filter

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

UniversalRouter_execute_function

Transaction-level records of Uniswap V3 UniversalRouter execute function calls on Ethereum, capturing routing commands, ETH values, and execution status. Used for analyzing failed transactions, gas consumption patterns, and routing behavior across Uniswap’s swap aggregation infrastructure.

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`	`INT64`	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	value	status	gas_used	in_inputs	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
325352	2600000000000000000	false	126006	[]	0x24856bc3	0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	17502027	0x3511f837687ff7272a39a231cac1452ad71141fa	2023-06-17T20:52:11.000Z	0x56cb6fe907361f1c781f1f9b35baba9662aa659871789e283bdf1211d3c67237
165999	0	false	37400	[]	0x24856bc3	0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	17501777	0xc90c94774234bd1d5b6950f64a70f0c167806853	2023-06-17T20:01:35.000Z	0x725669f7f20f54bae1f03c2126d2a2b4454bb3a087bdf26f8efbfeca4ea98f91
133581	100000000000000000	false	104733	[]	0x24856bc3	0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	17501747	0xc90c94774234bd1d5b6950f64a70f0c167806853	2023-06-17T19:55:35.000Z	0xc485e66d7c162f80b663009091ad5290fa898f178fc010346e028043908fd0c1

Example Query

Query with partition filter

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

UniversalRouter_execute2_function

Uniswap V3 UniversalRouter execute2 function call data on Ethereum, capturing batch swap and liquidity commands with encoded inputs and execution deadlines. Used for analyzing complex multi-step transactions and MEV activity through Uniswap’s routing infrastructure.

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`	`INT64`	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	value	status	gas_used	in_inputs	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
239507	0	false	233929	[]	0x3593564c	0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	17986144	0xdefc89b6c1e437705080ce2edbb3f6993d515a33	2023-08-24T17:47:23.000Z	0x45c7ce9dc273f322a28f481a10ee00eac4fac95e41f88a90c6cdbb5653874f13
212546	100000000000000000	false	170504	[]	0x3593564c	0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	17986144	0x76c1ea18e7b13a96dc517f51ef36f7b7a63cdffb	2023-08-24T17:47:23.000Z	0xca35b2f912a70656dd13f7a51b3c06c0c3827d9e55d751c65d8078f51ad9e76c
517605	0	false	434626	[]	0x3593564c	0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	17986398	0x90a92d6b87c1aa535ad713596b7f2524141824d1	2023-08-24T18:38:35.000Z	0x1fd92fea95c36e5dbe0158a13caabf4f0145fe0fb28f7186a226fe0dbb8c5cca

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

UniswapXDutchOrderReactor_Fill_event

UniversalRouter_collectRewards_function

UniversalRouter_execute_function

UniversalRouter_execute2_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​UniswapXDutchOrderReactor_Fill_event

​UniversalRouter_collectRewards_function

​UniversalRouter_execute_function

​UniversalRouter_execute2_function

Tables

UniswapXDutchOrderReactor_Fill_event

UniversalRouter_collectRewards_function

UniversalRouter_execute_function

UniversalRouter_execute2_function