uniswap_v3_ethereum

Tables

Factory_PoolCreated_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.

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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_fee	address	in_pool	removed	in_token0	in_token1	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
100	0x1f98431c8ad98523631ae4a59f267346ea31f984	0x2a5d24e8927577b7eedb96449b79a380a6bdd008	false	0x0ef9dc2e6f43b5ef5aff536507edcd8bd55eb31b	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	219	13902439	1	2021-12-29T20:33:37.000Z	0xb08fd78fe53e6f5ceef6a9fd7ced70e50c473bbfcae6a6cb8943637a1b821d49
3000	0x1f98431c8ad98523631ae4a59f267346ea31f984	0xa826fa3f97e0c07395f15c97f3e55f628283e6b9	false	0x0ee8820f8bccf5e0da82c6a60853ab74be9b4c6e	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	440	13898878	60	2021-12-29T07:26:43.000Z	0x5988f0dedaf867e389961bb786f7808432d3375d9de7a646a3cfa1837d1d1f13
3000	0x1f98431c8ad98523631ae4a59f267346ea31f984	0x1686c1c53b67d285ffaf524bd01b2d4f709d258f	false	0x9ceb36379c83d781c04d1eb19bb4e6a1689f6ff2	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	82	13897993	60	2021-12-29T04:16:42.000Z	0xfd029930c0c5126f41c4aad5316e191cc173b78d7582d87b6bac89712246b309

Example Query

Query with partition filter

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

NonfungiblePositionManager_burn_function

Uniswap V3 liquidity position NFT (Non-Fungible Position Manager) burn function calls on Ethereum, recording when LPs permanently destroy position tokens after removing all liquidity. Used for tracking position lifecycle completion and LP exit behavior.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.

Sample Data

gas	status	gas_used	signature	in_tokenId	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
77167	true	66668	0x42966c68	152116	0xc36442b4a4522e871399cd717abdd847ab11fe88	13702953	0x1f40da07d23fb4c71a4268cd05828436bfb261b4	10	2021-11-28T14:39:34.000Z	0xc6dcbdb029e8b74669c9b8c9389519f3b018983dc6b1999ad26cf275071218e4
77167	true	66668	0x42966c68	149052	0xc36442b4a4522e871399cd717abdd847ab11fe88	13705082	0x1f40da07d23fb4c71a4268cd05828436bfb261b4	10	2021-11-28T22:51:42.000Z	0xaf9ec87071e9410729de5a687f67a43bc8cf1eb23bd226931f88d46b641c0a8d
77167	true	66668	0x42966c68	148444	0xc36442b4a4522e871399cd717abdd847ab11fe88	13701023	0x1f40da07d23fb4c71a4268cd05828436bfb261b4	10	2021-11-28T07:17:33.000Z	0xf3d45ad5e9103c9a60b978c87152cd996a45937f2d0d80f1dfe61f3b2c65455b

Example Query

Query with partition filter

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

NonfungiblePositionManager_Collect_event

Fee collection events from Uniswap V3 liquidity positions on Ethereum, emitted when position holders withdraw accumulated trading fees. Contains token amounts, position IDs (NFT tokenId), and recipient addresses for tracking fee earnings and liquidity provider revenue.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	log_index	in_amount0	in_amount1	in_tokenId	block_number	in_recipient	block_timestamp	transaction_hash
0xc36442b4a4522e871399cd717abdd847ab11fe88	false	156	7936379789928607653249	252954375	167286	13821006	0x0026ec57900be57503efda250328507156dac982	2021-12-17T06:27:04.000Z	0x48ea6cf6e3fe1da4529dffc969ae80ea3cb48bd84224bde975feac346394a3e8
0xc36442b4a4522e871399cd717abdd847ab11fe88	false	231	641449278597088068683535	3323572872	161870	13822381	0x062af5c66b8581176411de7ce09f1f7ed30cac37	2021-12-17T11:26:32.000Z	0x50bb6949084392a91c1222a00183bcc512ea22377347c31518bf8871bab7ed0f
0xc36442b4a4522e871399cd717abdd847ab11fe88	false	153	16497035699526247710	15753509	95696	13822056	0x0ac8e78da8d115af5c8c57a2cded11cffd64d0d7	2021-12-17T10:13:34.000Z	0xd48dacb9a9848ae98e4555edb0894a76bcd057adb97c119ed60ef89093db66ac

Example Query

Query with partition filter

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

NonfungiblePositionManager_collect_function

Fee collection transactions from Uniswap V3 liquidity positions on Ethereum, tracking earned trading fees withdrawn by position holders. Contains position ID (tokenId), recipient addresses, and collected amounts in both tokens (amount0/amount1) for analyzing LP profitability and fee harvesting behavior.

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_params`	`STRUCT<tokenId STRING, recipient STRING, amount0Max STRING, amount1Max STRING>`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
`out_amount0`	`STRING`	Amount of token0 returned or withdrawn from the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination.
`out_amount1`	`STRING`	Amount of token1 returned or withdrawn from the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in_params	signature	to_address	out_amount0	out_amount1	block_number	from_address	block_timestamp	transaction_hash
400421	true	259587	{“tokenId”:“323302”,“recipient”:“0xea16545cf2e4c30b38b156cda0972be63ce71d50”,“amount0Max”:“398589324822706760000000000”,“amount1Max”:“117236753317269450”}	0xfc6f7865	0xc36442b4a4522e871399cd717abdd847ab11fe88	398589324822706760000000000	117236753317269450	15613432	0xea16545cf2e4c30b38b156cda0972be63ce71d50	2022-09-25T22:40:35.000Z	0xdae98d7c521ce65700a774b6b4c82a9aba3b2a541b51d071cde483c5613961bb
215516	true	136200	{“tokenId”:“320978”,“recipient”:“0xea16545cf2e4c30b38b156cda0972be63ce71d50”,“amount0Max”:“63007541246”,“amount1Max”:“63007541246438700000000”}	0xfc6f7865	0xc36442b4a4522e871399cd717abdd847ab11fe88	61281206259	63007541246438698349012	15613759	0xea16545cf2e4c30b38b156cda0972be63ce71d50	2022-09-25T23:46:23.000Z	0x16e3b2bbdf15966c4b4952b6f0c309ac5a22df39fcf6cf6df60c5d7852e27a3c
168051	true	136200	{“tokenId”:“310950”,“recipient”:“0xb64df007c167ca403fc6f9b1a4ada2531c66c994”,“amount0Max”:“340282366920938463463374607431768211455”,“amount1Max”:“340282366920938463463374607431768211455”}	0xfc6f7865	0xc36442b4a4522e871399cd717abdd847ab11fe88	86899475590	88525458662420123305970	15607093	0xb64df007c167ca403fc6f9b1a4ada2531c66c994	2022-09-25T01:27:11.000Z	0xf3a3f290acbea8cf07e375e625c31442ba3fed507b024148efb1149a54da6cf7

Example Query

Query with partition filter

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

NonfungiblePositionManager_DecreaseLiquidity_event

Liquidity removal events from Uniswap V3 NFT positions on Ethereum, capturing when liquidity providers decrease their position size. Records the position token ID, liquidity amount removed, and token amounts withdrawn for analyzing LP behavior and position management strategies.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	log_index	in_amount0	in_amount1	in_tokenId	block_number	in_liquidity	block_timestamp	transaction_hash
0xc36442b4a4522e871399cd717abdd847ab11fe88	false	256	0	9999999999	382676	16186314	12562511572	2022-12-14T23:47:11.000Z	0xd4f111175f4ceedfad7fdbe91d3cbe04a042c64fa469489758ca2de502ffe487
0xc36442b4a4522e871399cd717abdd847ab11fe88	false	256	81398545682477388568	137817382814	373978	16180207	11606161837046626	2022-12-14T03:19:23.000Z	0x7c0313249ac4fba506c7404bbbff14ae65f63189d5219c13eed7f95d24e1a64b
0xc36442b4a4522e871399cd717abdd847ab11fe88	false	512	1306681858855517546184	1185600177475070529	311051	16183500	188073124430261787993	2022-12-14T14:22:47.000Z	0xa8b9a20b8134f674184399a88dd786b43a28d1acc420a605bd39a1c63fe67f41

Example Query

Query with partition filter

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

NonfungiblePositionManager_decreaseLiquidity_function

Liquidity removal transactions from Uniswap V3 concentrated liquidity positions on Ethereum, tracking position ID, liquidity amount withdrawn, and token amounts received. Used for analyzing LP exit behavior, position rebalancing patterns, and fee collection activity.

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_params`	`STRUCT<tokenId STRING, liquidity STRING, amount0Min STRING, amount1Min STRING, deadline STRING>`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
`out_amount0`	`STRING`	Amount of token0 returned or withdrawn from the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination.
`out_amount1`	`STRING`	Amount of token1 returned or withdrawn from the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in_params	signature	to_address	out_amount0	out_amount1	block_number	from_address	block_timestamp	transaction_hash
247351	true	139927	{“tokenId”:“434917”,“deadline”:“1676092067”,“liquidity”:“5197383553”,“amount0Min”:“8351204661”,“amount1Min”:“139573791”}	0x0c49ccbe	0xc36442b4a4522e871399cd717abdd847ab11fe88	8360113020	140331487	16603181	0xc36442b4a4522e871399cd717abdd847ab11fe88	2023-02-11T04:38:23.000Z	0x169341bcb824cfa6acc6d84f835ec600aa4ac335236cb2d605036ecfe90d4ec8
242172	true	131213	{“tokenId”:“418985”,“deadline”:“1676085611”,“liquidity”:“5546562287332905144557”,“amount0Min”:“153036865947590345729656”,“amount1Min”:“0”}	0x0c49ccbe	0xc36442b4a4522e871399cd717abdd847ab11fe88	153036865947590345729656	0	16602649	0xc36442b4a4522e871399cd717abdd847ab11fe88	2023-02-11T02:50:47.000Z	0x1fb37282c89684896c9633b1e9e8850b34edd045cd3aca58c41ca431ddfa3321
350978	true	242285	{“tokenId”:“363821”,“deadline”:“1676077007”,“liquidity”:“3136433938008297942”,“amount0Min”:“251192221883886706”,“amount1Min”:“353313108129903364”}	0x0c49ccbe	0xc36442b4a4522e871399cd717abdd847ab11fe88	315643133278582709	446452276350952181	16601938	0xc36442b4a4522e871399cd717abdd847ab11fe88	2023-02-11T00:27:47.000Z	0x5fb85b61fd3127a29d4a24049d9d69f97890193ad413ea9323ad4d44ec799b64

Example Query

Query with partition filter

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

NonfungiblePositionManager_IncreaseLiquidity_event

Liquidity additions to existing Uniswap V3 positions on Ethereum, emitted when users add tokens to their concentrated liquidity ranges. Records token amounts deposited, liquidity units added, and position NFT identifiers for tracking LP activity.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	log_index	in_amount0	in_amount1	in_tokenId	block_number	in_liquidity	block_timestamp	transaction_hash
0xc36442b4a4522e871399cd717abdd847ab11fe88	false	256	45394549999999999999999997	0	542060	17776852	15570890513924114622282687	2023-07-26T11:07:35.000Z	0x465794b7a29ac98eecb00b5ec307ece01c4468e93ec5c88dd19a5449b40ba6a7
0xc36442b4a4522e871399cd717abdd847ab11fe88	false	256	816014113852667529	63720164015313087	538356	17775196	6550151185431704706	2023-07-26T05:34:11.000Z	0xb610f27cc91f9dbad5e117bc6831e44f81883af96978e3296cf27ebf134c9fc2
0xc36442b4a4522e871399cd717abdd847ab11fe88	false	257	9043451529214	2993872236497183637	541408	17780029	63772136837560305	2023-07-26T21:46:35.000Z	0x81c991834a7150e0dc528ce4f99b00bd8c3d4c11ce7cbf66be7d976b000edcdf

Example Query

Query with partition filter

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

NonfungiblePositionManager_increaseLiquidity_function

Function calls to add liquidity to existing Uniswap V3 positions on Ethereum, identified by NFT (non-fungible token) position IDs. Tracks desired and actual token amounts deposited, liquidity minted, and slippage protection parameters for analyzing LP strategy execution.

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_params`	`STRUCT<tokenId STRING, amount0Desired STRING, amount1Desired STRING, amount0Min STRING, amount1Min STRING, deadline STRING>`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
`out_liquidity`	`STRING`	Liquidity units added to the existing Uniswap V3 position after the increase operation completes. Null for failed transactions; otherwise a positive integer representing the delta in position liquidity.
`out_amount0`	`STRING`	Amount of token0 returned or withdrawn from the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination.
`out_amount1`	`STRING`	Amount of token1 returned or withdrawn from the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

gas	value	status	gas_used	in_params	signature	to_address	out_amount0	out_amount1	block_number	from_address	out_liquidity	trace_address	block_timestamp	transaction_hash
261603	0	true	222948	{“tokenId”:“43213”,“deadline”:“1626647668”,“amount0Min”:“20761375033438”,“amount1Min”:“48167931033”,“amount0Desired”:“21216619938855”,“amount1Desired”:“48849760698”}	0x219f5d17	0xc36442b4a4522e871399cd717abdd847ab11fe88	21216619938855	48849760698	12853180	0x52b87a21a4aaa1e1fb2a1d6709ff8192137b0dfa	3532374662623	0,0	2021-07-18T22:08:13.000Z	0xff95cf99ed8bbc5ad71ffc1e3be69b3ca7810f0ae378224c9d0176bd356ee9bb
368365	0	true	130044	{“tokenId”:“52716”,“deadline”:“1626632635”,“amount0Min”:“0”,“amount1Min”:“0”,“amount0Desired”:“51828872800233872352084”,“amount1Desired”:“50000000000”}	0x219f5d17	0xc36442b4a4522e871399cd717abdd847ab11fe88	18923488013718084697139	50000000000	12852180	0x50dccf8f83cce8aa9168637c2ec0114ae934f6d1	528975279663050068	0,26	2021-07-18T18:23:55.000Z	0xabab1391da8c6483cc0b6c15724e8a7e776dc3c61ff4680290d480133f74c6ae
228782	167969107459226710	true	191764	{“tokenId”:“55346”,“deadline”:“1626627089”,“amount0Min”:“50037544”,“amount1Min”:“161332548738468674”,“amount0Desired”:“62527999”,“amount1Desired”:“167969107459226710”}	0x219f5d17	0xc36442b4a4522e871399cd717abdd847ab11fe88	62527999	167969107459226710	12851652	0xc36442b4a4522e871399cd717abdd847ab11fe88	115308438122180	0,0,0	2021-07-18T16:22:49.000Z	0x535e03b301e44e4f8b3302b712efc441e839745e7d2be1f945985225641aca91

Example Query

Query with partition filter

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

NonfungiblePositionManager_mint_function

Liquidity position creation events from Uniswap V3’s NonfungiblePositionManager contract on Ethereum, capturing mint function calls with token pair details, tick ranges, deposited amounts, and resulting NFT position IDs. Used for analyzing liquidity provision behavior and position strategy patterns across trading pairs.

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_params`	`STRUCT<token0 STRING, token1 STRING, fee STRING, tickLower INT64, tickUpper INT64, amount0Desired STRING, amount1Desired STRING, amount0Min STRING, amount1Min STRING, recipient STRING, deadline STRING>`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
`out_tokenId`	`STRING`	Unique identifier of the NFT position minted by this transaction, represented as a numeric string. Each position NFT has a distinct token ID that can be used to track and manage the liquidity position on-chain.
`out_liquidity`	`STRING`	Liquidity amount minted for the new position NFT, denominated in Uniswap V3’s internal liquidity units. Always non-zero for successful mints, typically ranging from millions to quadrillions depending on price range and token amounts.
`out_amount0`	`STRING`	Amount of token0 returned or withdrawn from the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination.
`out_amount1`	`STRING`	Amount of token1 returned or withdrawn from the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

gas	value	status	gas_used	in_params	signature	to_address	out_amount0	out_amount1	out_tokenId	block_number	from_address	out_liquidity	block_timestamp	transaction_hash
631151	232409424179114920	true	521685	{“fee”:“10000”,“token0”:“0x431b366be6069ae62f8121a901c6160b34af7f80”,“token1”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“deadline”:“1677547163”,“recipient”:“0x0057f8a7610a38a15b8d6aa5a03a20901a8b31ba”,“tickLower”:153600,“tickUpper”:166000,“amount0Min”:“4972831610”,“amount1Min”:“230937003021158698”,“amount0Desired”:“5087330851”,“amount1Desired”:“232409424179114920”}	0x88316456	0xc36442b4a4522e871399cd717abdd847ab11fe88	5087330851	232409424179114920	453270	16723207	0xc36442b4a4522e871399cd717abdd847ab11fe88	164443919075395	2023-02-28T00:49:59.000Z	0x1d725db439e984be5e4bf1f1d1e8ac3050534a7d52d5bcd81d2bf1e2eb29b058
615381	19572040444051460484	true	508401	{“fee”:“3000”,“token0”:“0x53c8395465a84955c95159814461466053dedede”,“token1”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“deadline”:“1677576383”,“recipient”:“0x09aa5d591fb7489dfb86be12041ed709d2b9d22c”,“tickLower”:-106920,“tickUpper”:-76560,“amount0Min”:“215235366713081720582527”,“amount1Min”:“19476831126826578407”,“amount0Desired”:“216217152267511166546875”,“amount1Desired”:“19572040444051460484”}	0x88316456	0xc36442b4a4522e871399cd717abdd847ab11fe88	216217152267511166546875	19572040444051460484	453528	16725661	0xc36442b4a4522e871399cd717abdd847ab11fe88	3872117549573829734103	2023-02-28T09:06:47.000Z	0x77f6e3faae59708fba154478b47455a6db9a38d8c532566900574ab941607b56
523125	12941005946558464	true	431547	{“fee”:“10000”,“token0”:“0x64b78325d7495d6d4be92f234fa3f3b8d8964b8b”,“token1”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“deadline”:“1677578363”,“recipient”:“0x0c17144e3fb17a7f6aee82008386f53b498d37cb”,“tickLower”:-108600,“tickUpper”:-76000,“amount0Min”:“304380935020461789855889”,“amount1Min”:“0”,“amount0Desired”:“313790114403546978749587”,“amount1Desired”:“12941005946558464”}	0x88316456	0xc36442b4a4522e871399cd717abdd847ab11fe88	313790114403546978749587	12941005946558464	453550	16725827	0xc36442b4a4522e871399cd717abdd847ab11fe88	1714675126641422138148	2023-02-28T09:40:11.000Z	0x853d2322bfa9142d11b9aa9ea12a1166cc03fd7f4be820aed2d257b0c37f3f17

Example Query

Query with partition filter

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

NonfungiblePositionManager_Transfer_event

Transfer events for Uniswap V3 liquidity position NFTs (Non-Fungible Position Manager) on Ethereum, tracking mints, burns, and ownership changes of tokenized LP positions by tokenId.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.

Sample Data

in_to	address	in_from	removed	log_index	in_tokenId	block_number	block_timestamp	transaction_hash
0x0000e0ca771e21bd00057f54a68c30d400000000	0xc36442b4a4522e871399cd717abdd847ab11fe88	0x0000000000000000000000000000000000000000	false	53	199436	14317034	2022-03-03T23:38:27.000Z	0x4ec732a9275bb206b6549657ed63df0af74fe1ae7cccd31ab45b655cb08abb74
0x00a79a30836a3e30e4aac89644e548916ac82966	0xc36442b4a4522e871399cd717abdd847ab11fe88	0x0000000000000000000000000000000000000000	false	400	199387	14316236	2022-03-03T20:41:28.000Z	0x9b136941a689c1c71e2b9a29bef92a71087aabdf0b47985d72abe6c1a6cad9c1
0x045d3d3bf9ef8ae7bae0e1ee2765349636d90057	0xc36442b4a4522e871399cd717abdd847ab11fe88	0x0000000000000000000000000000000000000000	false	475	199283	14314213	2022-03-03T13:18:38.000Z	0x419271c346b2772fc29a947ff3c4010bb9c1e3d2512130156e0c155b388e1359

Example Query

Query with partition filter

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

Pool_Burn_event

Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL changes.

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_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	in_amount	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x00f59b15dc1fe2e16cde0678d2164fd5ff10e424	false	0xc36442b4a4522e871399cd717abdd847ab11fe88	11879219160519635011284	144	39028214613867519776196	0	12417009	-116000	-115800	2021-05-12T02:51:53.000Z	0x5269c66a70545e30035f3be8b14620ba2a09927fe3a085830a0a795720cc99d6
0x04916039b1f59d9745bf6e0a21f191d1e0a84287	false	0xc36442b4a4522e871399cd717abdd847ab11fe88	315986015899491211	233	1182293316547619	388704880718306662	12418912	23040	29940	2021-05-12T09:48:48.000Z	0x63ba20e219737ea66125069a1370081f9b1ec1a6c4ff451e6ce41509d0e820bf
0x04916039b1f59d9745bf6e0a21f191d1e0a84287	false	0xc36442b4a4522e871399cd717abdd847ab11fe88	3463390838408090125	365	0	2676359154505676192	12417820	25560	29460	2021-05-12T05:49:49.000Z	0x15568bc1b8d37f5f4cbd663e0dee671ef8457828b9db0c489a236ac76c3db3dd

Example Query

Query with partition filter

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

Pool_Collect_event

Concentrated liquidity position fee collection events from Uniswap V3 compatible decentralized exchanges. Records position owner, recipient, collected token amounts, and tick range boundaries for tracking earned trading fees and position management activity.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	log_index	in_amount0	in_amount1	block_number	in_recipient	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x02daa5fdd4b474c13a8d6d141471b87fbd2452cd	false	0x777839b0667f293202e215576021b9d0a80dea96	427	0	0	14694798	0x777839b0667f293202e215576021b9d0a80dea96	56400	63360	2022-05-01T23:09:41.000Z	0xa7d09f4007a019e70c7902dcf982a3815a30f6e7f17f17e9d829d56e149e4eaa
0x02daa5fdd4b474c13a8d6d141471b87fbd2452cd	false	0x777839b0667f293202e215576021b9d0a80dea96	426	0	538105365669249999997320	14694798	0x10dc1d2f35992b28c5160c2f9fc9582735298d78	56400	63360	2022-05-01T23:09:41.000Z	0xa7d09f4007a019e70c7902dcf982a3815a30f6e7f17f17e9d829d56e149e4eaa
0x07a6e955ba4345bae83ac2a6faa771fddd8a2011	false	0xc36442b4a4522e871399cd717abdd847ab11fe88	406	480839827573245155025	556938328	14691330	0x9178331a5337a5e587b5bc9e28b6dd4adca955ca	-281760	-267900	2022-05-01T10:02:38.000Z	0x01f99ffd6b80ca299e20a8cea56d8fa1e10ac5c6e7322e79a0db945d18d5bfa4

Example Query

Query with partition filter

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

Pool_CollectProtocol_event

Protocol fee collection events from concentrated liquidity pools, recording fees withdrawn by the protocol from trading activity. Contains token amounts collected (amount0, amount1), sender address initiating the collection, and recipient address receiving the fees.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x403b1b747b1efb309070436c9ac99bf476f299ea	false	0x5e74c9f42eed283bff3744fbd1889d398d40867d	97	1085885410	10000000000000	24106433	0xf38521f130fccf29db1961597bc5d2b60f995f85	2025-12-27T20:44:23.000Z	0xa80920bea2034bf6c5eab43671f3dbc87f621dafa317f5de9803b914fa2aaffe
0xc7bbec68d12a0d1830360f8ec58fa599ba1b0e9b	false	0x5e74c9f42eed283bff3744fbd1889d398d40867d	262	75069306293947701	222043379	24111994	0xf38521f130fccf29db1961597bc5d2b60f995f85	2025-12-28T15:21:47.000Z	0xa8280a7742d65a5eca79fe3614801dafc64867800d4dbe31a16ae447d9a1b137
0x1d42064fc4beb5f8aaf85f4617ae8b3b5b8bd801	false	0x5e74c9f42eed283bff3744fbd1889d398d40867d	175	10000000000000000	10000000000000	24114929	0xf38521f130fccf29db1961597bc5d2b60f995f85	2025-12-29T01:10:47.000Z	0xf63c88c7f22f3294f7cabbe44c01eb0ca00d9b878288796994cc1496cb794a50

Example Query

Query with partition filter

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

Pool_Flash_event

Flash loan events from liquidity pools recording borrowed amounts and repayment fees for both tokens in the pair. Tracks sender, recipient, borrowed quantities, and actual fees paid for arbitrage and liquidation analysis.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_paid0`	`STRING`	Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
`in_paid1`	`STRING`	Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_paid1	in_sender	log_index	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x3416cf6c708da44db2624d63ea0aaef7113527c6	false	127803	0x1ed9c8bd3dccb85f704a5287444b552f9d5e1a26	306	1278029383	17935524	0x1ed9c8bd3dccb85f704a5287444b552f9d5e1a26	2023-08-17T15:46:59.000Z	0x57899f7734a3de91f131b9d26e86071b0316d8c3d0af009a38116da5bd371680
0x5777d92f208679db4b9778590fa3cab3ac9e2168	false	148159	0xc70e2915f019e27baa493972e4627dbc0ed7a794	65	1481586884	17937442	0xc70e2915f019e27baa493972e4627dbc0ed7a794	2023-08-17T22:13:59.000Z	0x3353d554ccf215e3f74cbb2586082df97e0c62b358157b43be70f25b691c5682
0x5777d92f208679db4b9778590fa3cab3ac9e2168	false	11858	0xc70e2915f019e27baa493972e4627dbc0ed7a794	86	118570148	17936082	0xc70e2915f019e27baa493972e4627dbc0ed7a794	2023-08-17T17:39:47.000Z	0x0dae2a09fe29202bb256d6f51f9dfcccac3df4ab56c3531ef5b9bbe847336af5

Example Query

Query with partition filter

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

Pool_Mint_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	in_amount	in_sender	log_index	in_amount0	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x0254a309f5140d457c0699e2cd0457a692a69cc4	false	0xc36442b4a4522e871399cd717abdd847ab11fe88	219420937152108947	0xc36442b4a4522e871399cd717abdd847ab11fe88	567	1680161567348	13582326	143400	143600	2021-11-09T13:08:47.000Z	0x61cf55618186126282796b0e772a425b08912529cdb39508c0867317400ddd18
0x04916039b1f59d9745bf6e0a21f191d1e0a84287	false	0xc36442b4a4522e871399cd717abdd847ab11fe88	23835675225920717706335	0xc36442b4a4522e871399cd717abdd847ab11fe88	343	26292825434776532819	13579402	19980	20040	2021-11-09T01:56:00.000Z	0x12f03dc65d517063af89b1c75d3d2d62d7011f533af765504bb27a6c02b68e6d
0x04c380e343b0dc42f4c51b7770d71a23621c7dc8	false	0xc36442b4a4522e871399cd717abdd847ab11fe88	1866085069167969	0xc36442b4a4522e871399cd717abdd847ab11fe88	116	408500425899140027268	13582042	-256800	-239400	2021-11-09T12:03:54.000Z	0x462da2953ad1461c8e7cec5b0255d4910fa6786f5f63adc148b7ab9735c300c9

Example Query

Query with partition filter

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

Pool_SetFeeProtocol_event

Protocol fee configuration change events emitted when liquidity pool fee parameters are updated. Records old and new fee protocol values for both tokens in the pool, tracking governance-initiated fee structure modifications.

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_feeProtocol0Old`	`INT64`	Previous protocol fee for token0. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
`in_feeProtocol1Old`	`INT64`	Previous protocol fee for token1. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
`in_feeProtocol0New`	`INT64`	New protocol fee for token0. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.
`in_feeProtocol1New`	`INT64`	New protocol fee for token1. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_feeProtocol0New	in_feeProtocol1New
0x026babd2ae9379525030fc2574e39bc156c10583	false	627	24106404	2025-12-27T20:38:35.000Z	0x000bac7e577d00ea632f59a9e1ef5bf718c64bac43855db2ba9c7bc3feef075e	4	4
0xf98cf0d979cfbb780774f318e3da4f7317af50d7	false	605	24106404	2025-12-27T20:38:35.000Z	0x000bac7e577d00ea632f59a9e1ef5bf718c64bac43855db2ba9c7bc3feef075e	4	4
0x19ae05c1983d970129a61c5dd7d77cad33ace5cf	false	633	24106404	2025-12-27T20:38:35.000Z	0x000bac7e577d00ea632f59a9e1ef5bf718c64bac43855db2ba9c7bc3feef075e	4	4

Example Query

Query with partition filter

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

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_sqrtPriceX96`	`STRING`	Square root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_tick`	`INT64`	Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.

Sample Data

address	in_tick	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	in_recipient	block_timestamp	in_sqrtPriceX96	transaction_hash
0xbc32d18c5c1138094dabeb3b4d5b720db75c823c	56544	false	0x0000000000007f150bd6f54c40a34d7c3d5e9f56	329	8045354	-2291087720	15842964	262442319356	0x0000000000007f150bd6f54c40a34d7c3d5e9f56	2022-10-28T00:23:23.000Z	1338653394790267866763251602449	0x99dd1c8f191c61fca610040f2c69522736e86e3831d4004f917944a20d87b0c9
0x07f3d316630719f4fc69c152f397c150f0831071	-81	false	0x0000000000007f150bd6f54c40a34d7c3d5e9f56	554	1030400005	-1022383506	15845072	1320391048384	0x0000000000007f150bd6f54c40a34d7c3d5e9f56	2022-10-28T07:30:11.000Z	78908433604623007732842120535	0x11fb89597fc083130a613289e4ab5111d880faa61cd2e1bc3c14749f194a282e
0x2f60777945fc351abf9e9e733bc5a52809269dd7	285904	false	0x0000000000007f150bd6f54c40a34d7c3d5e9f56	10	75339	-200728108868644824	15842971	3816823344655	0x0000000000007f150bd6f54c40a34d7c3d5e9f56	2022-10-28T00:24:47.000Z	127907810104369455197367763649457446	0x22b7d579d7b9cc6a57c5da4ae7812e6395f3938d8d7c96d950d59fdda89434e6

Example Query

Query with partition filter

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

UniversalRouter_execute_function

Uniswap V3 UniversalRouter execute function calls on Ethereum containing command sequences and input parameters for multi-step swap operations. Used for analyzing complex routing patterns, MEV activity, and failed versus successful transaction execution across token pairs.

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	status	gas_used	in_inputs	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
391984	false	152309	[]	0x24856bc3	0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b	18308212	0xc71573fff7dd1520d0e2b8e0b67f3c599212fe9a	2023-10-08T20:42:23.000Z	0x169be9a2b508f0bfb30039b367dace4ccfdd53bf6dbcd2d8df6eaf017f1b380d
213641	false	141893	[]	0x24856bc3	0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b	18308215	0xc71573fff7dd1520d0e2b8e0b67f3c599212fe9a	2023-10-08T20:42:59.000Z	0xb32a5b59a05f67111d548197e2499360acc805ba97f3a20399677547e098901c
391984	false	12390	[]	0x24856bc3	0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b	18305051	0xc71573fff7dd1520d0e2b8e0b67f3c599212fe9a	2023-10-08T10:04:35.000Z	0xc77d60c893fc94a81c86fa6b92bd89c3b940b4f055636c27b3c6efcf963d803f

Example Query

Query with partition filter

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

UniversalRouter_execute2_function

Transaction executions through Uniswap V3’s UniversalRouter contract on Ethereum, capturing swap commands, input parameters, deadlines, and gas metrics for analyzing routing patterns and multi-step trade executions.

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	in_commands	in_deadline	block_number	from_address	block_timestamp	transaction_hash
181876	0	true	145274	[“0x00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000007de2900000000000000000000000000000000000000000000000000012e96b9f86ce50800000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002ba0b86991c6218b36c1d19d4a2e9eb0ce3606eb480001f4c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000012e96b9f86ce508”]	0x3593564c	0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b	0x000c	1675989659	16594688	0xcff79041bee307e1bb8895b04f3cfe228ef0e417	2023-02-10T00:11:23.000Z	0x6335d574b5b079cadba8940e737b831a72e720d476fe30e93ccc9c2a19550c8b
642894	0	true	528893	[“0x000000000000000000000000e23311294467654e0cab14cd32a169a41be5ca8e000000000000000000000000ffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000640d18490000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ef1c6e67703c7bd7107eed8303fbe6ec2554bf6b0000000000000000000000000000000000000000000000000000000063e5925100000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000000000000000000000000000000000000000417b894816a832982899a2cb63c854df03b3c9efdeb155a4a0c2029b583b4ca6fb42a0e7e3f16028ae696d6b1f6c82cd75dd826b4902d24f23a4284ae845bbd5cb1b00000000000000000000000000000000000000000000000000000000000000”,“0x000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000096f0da489ac378b000000000000000000000000000000000000000000000000000004cd3ce04b6aeebc00000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000002000000000000000000000000e23311294467654e0cab14cd32a169a41be5ca8e000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“0x000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000004cd3ce04b6aeebc”]	0x3593564c	0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b	0x0a080c	1675989659	16594688	0xb8a05c801275ef45446e02f0ddd992f698b5c5bb	2023-02-10T00:11:23.000Z	0x8653de955d5ec893cf680a1c86e91be16b8527116240f636a3979a6be65164bb
184692	201905663000000000	true	147109	[“0x000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000002cd502179413600”,“0x000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000002cd50217941360000000000000000000000000000000000000000000000012b87f58353570b7e8d00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002bc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20027106b0b3a982b4634ac68dd83a4dbf02311ce324181000000000000000000000000000000000000000000”]	0x3593564c	0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b	0x0b00	1675989059	16594688	0x1631c0c18d61a7df54ccdc0229b259f16935c48a	2023-02-10T00:11:23.000Z	0xde846e96d79183ba4f120b23032a14a22fa0334abce1e3cc4284cf5ad044bb54

Example Query

Query with partition filter

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

UniversalRouter_uniswapV3SwapCallback_function

Callback function executions from Uniswap V3’s UniversalRouter contract on Ethereum, recording token amount deltas (amount0Delta and amount1Delta) when swaps settle between liquidity pools and the router. Used for analyzing swap settlement mechanics and token flow patterns in multi-hop trades.

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_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	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_amount0Delta	in_amount1Delta	transaction_hash
1449	false	0x0000000000000000000000000000000000000000000000000000000000000040000000000000000000000000ef1c6e67703c7bd7107eed8303fbe6ec2554bf6b000000000000000000000000000000000000000000000000000000000000002ba0b86991c6218b36c1d19d4a2e9eb0ce3606eb480001f4c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000	0xfa461e33	0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b	16942212	0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640	2,2	2023-03-30T19:43:47.000Z	512408054	-287572557769195773	0x11d365aa5c01cbe33886f5de6700e3b9c19d38c874ca4b80eccd4d047279312f
2093	false	0x0000000000000000000000000000000000000000000000000000000000000040000000000000000000000000ef1c6e67703c7bd7107eed8303fbe6ec2554bf6b000000000000000000000000000000000000000000000000000000000000002bc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000bb82b591e99afe9f32eaa6214f7b7629768c40eeb39000000000000000000000000000000000000000000	0xfa461e33	0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b	16940484	0x9e0905249ceefffb9605e034b534544684a58be6	1,2	2023-03-30T13:53:59.000Z	-22596817619395	11122429774048341711	0x62e10077582424f115f19ff810539539ee622aa6c95901247968e2bbeb845ba0
4626	false	0x0000000000000000000000000000000000000000000000000000000000000040000000000000000000000000ef1c6e67703c7bd7107eed8303fbe6ec2554bf6b000000000000000000000000000000000000000000000000000000000000002bc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000bb8f21661d0d1d76d3ecb8e1b9f1c923dbfffae4097000000000000000000000000000000000000000000	0xfa461e33	0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b	16942126	0x5b7e3e37a1aa6369386e5939053779abd3597508	7,2	2023-03-30T19:26:35.000Z	1130084544722956284	-6354212700330065371635	0x91ce0afabb81c8aa555454c02a22d831b2ba6a19eae5e604846fe343118fa24e

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

NonfungiblePositionManager_burn_function

NonfungiblePositionManager_Collect_event

NonfungiblePositionManager_collect_function

NonfungiblePositionManager_DecreaseLiquidity_event

NonfungiblePositionManager_decreaseLiquidity_function

NonfungiblePositionManager_IncreaseLiquidity_event

NonfungiblePositionManager_increaseLiquidity_function

NonfungiblePositionManager_mint_function

NonfungiblePositionManager_Transfer_event

Pool_Burn_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event

UniversalRouter_execute_function

UniversalRouter_execute2_function

UniversalRouter_uniswapV3SwapCallback_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PoolCreated_event

​NonfungiblePositionManager_burn_function

​NonfungiblePositionManager_Collect_event

​NonfungiblePositionManager_collect_function

​NonfungiblePositionManager_DecreaseLiquidity_event

​NonfungiblePositionManager_decreaseLiquidity_function

​NonfungiblePositionManager_IncreaseLiquidity_event

​NonfungiblePositionManager_increaseLiquidity_function

​NonfungiblePositionManager_mint_function

​NonfungiblePositionManager_Transfer_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_CollectProtocol_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_SetFeeProtocol_event

​Pool_Swap_event

​UniversalRouter_execute_function

​UniversalRouter_execute2_function

​UniversalRouter_uniswapV3SwapCallback_function

Tables

Factory_PoolCreated_event

NonfungiblePositionManager_burn_function

NonfungiblePositionManager_Collect_event

NonfungiblePositionManager_collect_function

NonfungiblePositionManager_DecreaseLiquidity_event

NonfungiblePositionManager_decreaseLiquidity_function

NonfungiblePositionManager_IncreaseLiquidity_event

NonfungiblePositionManager_increaseLiquidity_function

NonfungiblePositionManager_mint_function

NonfungiblePositionManager_Transfer_event

Pool_Burn_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event

UniversalRouter_execute_function

UniversalRouter_execute2_function

UniversalRouter_uniswapV3SwapCallback_function