uniswap_v3_bob

Tables

Factory_FeeAmountEnabled_event

Factory contract events emitted when a new fee tier is enabled for pool creation in Uniswap V3. Records the fee amount in basis points and corresponding tick spacing parameter for concentrated liquidity pools.

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_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.

Sample Data

in_fee	address	removed	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
100	0xcb2436774c3e191c85056d248ef4260ce5f27a9d	false	0	5188284	1	2024-08-09T21:22:35.000Z	0x2d767a0a8eaae2d5f19d303590aa94d365b793bdf2b52a1fccc966d8ff2f83db
10000	0xcb2436774c3e191c85056d248ef4260ce5f27a9d	false	3	5188280	200	2024-08-09T21:22:27.000Z	0xef700f46f56e1146cf3275f51332411e4d39b34059526ec1c65b6016fb85eac9
3000	0xcb2436774c3e191c85056d248ef4260ce5f27a9d	false	2	5188280	60	2024-08-09T21:22:27.000Z	0xef700f46f56e1146cf3275f51332411e4d39b34059526ec1c65b6016fb85eac9

Example Query

Query with partition filter

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

Factory_OwnerChanged_event

Factory contract ownership transfer event emitted when administrative control changes from one address to another. Records old owner, new owner, and block metadata for governance and access control tracking.

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_oldOwner`	`STRING`	Address of the previous owner before an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.
`in_newOwner`	`STRING`	Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_newOwner	in_oldOwner	block_number	block_timestamp	transaction_hash
0xcb2436774c3e191c85056d248ef4260ce5f27a9d	false	0xa683c66045ad16abb1bce5ad46a64d95f9a25785	0xe75358526ef4441db03ccaeb9a87f180fae80eb9	5625436	2024-08-20T00:14:19.000Z	0xdbf6cf9877ac996798a66e155b3c44126bf1f9c98b0fdf1db91ba4ffd8cfad57
0xcb2436774c3e191c85056d248ef4260ce5f27a9d	false	0xe75358526ef4441db03ccaeb9a87f180fae80eb9	0x1e97cd6b8ce5052b3faee512c04f93a967c4c0e4	5189024	2024-08-09T21:47:15.000Z	0x7a50f5ec0204c59d6db7767f2aa074f8028ef6db22c14bd9dc17a827b7d8ae95
0xcb2436774c3e191c85056d248ef4260ce5f27a9d	false	0x1e97cd6b8ce5052b3faee512c04f93a967c4c0e4	0x0000000000000000000000000000000000000000	5188280	2024-08-09T21:22:27.000Z	0xef700f46f56e1146cf3275f51332411e4d39b34059526ec1c65b6016fb85eac9

Example Query

Query with partition filter

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

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	0xcb2436774c3e191c85056d248ef4260ce5f27a9d	0xf1bb28a6f9c4cb93e9a77c9365d1e4ef4c67d493	false	0x6c851f501a3f24e29a8e39a29591cddf09369080	0xe75d0fb2c24a55ca1e3f96781a2bcc7bdba058f0	4	9423031	1	2024-11-15T22:00:49.000Z	0x9ede1d59a373444cfcf0bd918d06981cd0d23b587126c5adca395cf811f2db57
100	0xcb2436774c3e191c85056d248ef4260ce5f27a9d	0xa118db3925db63a2fd50505e8033cd4911cfe588	false	0x03c7054bcb39f7b2e5b2c7acb37583e32d70cfa3	0xcc0966d8418d412c599a6421b760a847eb169a8c	0	13645484	1	2025-02-21T15:49:15.000Z	0x8457d391b9f759719e08c099898e87da7397108ecfa99f8ef4084353b5a841bb
3000	0xcb2436774c3e191c85056d248ef4260ce5f27a9d	0xfb1f4a509a6636874230d1709a68decbdba2dbc8	false	0x78fea795cbfcc5ffd6fb5b845a4f53d25c283bdb	0xe75d0fb2c24a55ca1e3f96781a2bcc7bdba058f0	0	7316608	60	2024-09-28T03:46:43.000Z	0x254cce885c787b7f6b4ea12f545e685dd183f19d5a8903405e76766addb9c1e1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_bob.Factory_PoolCreated_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	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0xb091ed2491a179a9f14a34f88587cd08195e592c	false	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	177283131044533627796	441137363855667013	444126999999999999	7253514	-50	50	2024-09-26T16:43:35.000Z	0xd90465bea6518f64a32a12678cea934a5a90273980370b0a4df15a2c95473618
0x566b9414c8733c14a96b8a21ca47711972f99d1a	false	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	20018513	49958	50003	7260327	-50	50	2024-09-26T20:30:41.000Z	0x239ef10c81628cd6dbb5ab680cc517ce71f0928fb711e053ce33fe14a0311324
0x566b9414c8733c14a96b8a21ca47711972f99d1a	false	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	53464943960	53306051	129498	7261102	0	20	2024-09-26T20:56:31.000Z	0xc8eb1a04e9092cb6debdbd7a1bd57899e3d57e2b44f107b0bcff7353f85ed085

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_bob.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
0xf1bb28a6f9c4cb93e9a77c9365d1e4ef4c67d493	false	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	5	2554169555029994326506	1163643947	13159843	0x3fa332824ea18f6400b4713722e9bff815e89ccc	-276345	-276344	2025-02-10T10:01:13.000Z	0x9735aa66e1a01aa0eb344b1329ab0a51b1579e1e222b7ffbdf7df085b4004f39
0xf1bb28a6f9c4cb93e9a77c9365d1e4ef4c67d493	false	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	4	814108125178506121921	1270310058	13145329	0x4325a7f125eeaff9409181d3f793101fe3b1d4a8	-276345	-276344	2025-02-10T01:57:25.000Z	0x507a3d934672151b7c3d5c1d3eb7ebea41ef6e7666d052a5d024903f4b99617a
0xf1bb28a6f9c4cb93e9a77c9365d1e4ef4c67d493	false	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	4	2509144199812419180103	1208488189	13179343	0x3fa332824ea18f6400b4713722e9bff815e89ccc	-276345	-276344	2025-02-10T20:51:13.000Z	0x8520d98b4916571026af5224ce7e52cf78bf20b49b1c56f585ec6befbb971c85

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_bob.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_paid0	in_paid1	in_sender	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x0905a1a1848d034b51667127ef94e15378294b29	false	13728034381250	0	0x23bd42e5cc8706765a2cbb6c385a5a1350615d4f	23	137280343812494451	0	12666910	0x23bd42e5cc8706765a2cbb6c385a5a1350615d4f	2025-01-30T00:10:07.000Z	0x231612a889edafa34626070d7e3d68a48736e3b68c4c0e420aef5fd7f38abcdd
0x2ece0e4b20ab662a9fc222a391b3ccb9ebf0485d	false	0	105	0x14005dc1ca1e6730cb9378b67fac42b9de54d8fc	18	0	1046470	14691094	0x14005dc1ca1e6730cb9378b67fac42b9de54d8fc	2025-03-17T20:42:55.000Z	0x9c583d8fe155e8a8a6aad1f4a350bc32f0afe8f94d88499597b1079d77b327f5
0x45bfa70e8f387da47ffe3dec447bc16f0b9a6261	false	36	0	0x23bd42e5cc8706765a2cbb6c385a5a1350615d4f	21	354485	0	12207205	0x23bd42e5cc8706765a2cbb6c385a5a1350615d4f	2025-01-19T08:46:37.000Z	0x0219ed5586954078519412bbf245db6552c3eb2065083b0a39b28fe123fc1373

Example Query

Query with partition filter

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

Pool_IncreaseObservationCardinalityNext_event

Uniswap V3 pool event emitted when the observation array cardinality limit is increased, recording the old and new maximum number of price observations the pool can store. Used for tracking oracle capacity expansions that enable longer time-weighted average price (TWAP) calculations.

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_observationCardinalityNextOld`	`STRING`	Previous maximum number of price observations the Uniswap V3 pool could store before the increase. String-encoded integer value representing the cardinality limit prior to the update.
`in_observationCardinalityNextNew`	`STRING`	Updated maximum number of price observations the Uniswap V3 pool can store. String-encoded integer value representing the new cardinality limit after the increase.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_observationCardinalityNextNew	in_observationCardinalityNextOld
0x54b4c87dba6480267688250693f4c1936f5e8c92	false	1	13655605	2025-02-21T21:26:37.000Z	0x24a9ceb0b7d84c5d0025651f155014b6d713e8822bfdbc07e3fa04a73c17fa25	1000	1
0x45bfa70e8f387da47ffe3dec447bc16f0b9a6261	false	1	13655599	2025-02-21T21:26:25.000Z	0x4641cb218d7dce6e2a948d58bc3add0c896c7a654f7c1b319d312bb6d4332bff	1000	1
0x576bd0c49e3ae7f93e02eba466afa8838fac2f60	false	1	13655592	2025-02-21T21:26:11.000Z	0x6a05e89ef4d8962b4a88e5d5682eab73ac2c59a1538af07440dfbc1a537a8a47	1000	1

Example Query

Query with partition filter

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

Pool_Initialize_event

Concentrated liquidity pool initialization event emitted when a pool contract is first created and seeded with a starting price. Records the initial sqrtPriceX96 (square root price encoded as Q64.96 fixed-point) and tick index that define the pool’s starting exchange rate between token0 and token1.

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_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_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	log_index	block_number	block_timestamp	in_sqrtPriceX96	transaction_hash
0x1b1d12994de8cce1af014fe389103d001e43473d	0	false	1	15084880	2025-03-26T23:29:07.000Z	79228162514264337593543950336	0x1c9f7e377f78673487054849bdd5c6ba4433b0760d9ef8104259a981e5dbc47a
0x58cb35e720673baef12f3060000c65e865fb2565	0	false	1	9128848	2024-11-09T02:34:43.000Z	79228162514264337593543950336	0xe70a55294472e1868c4dd42f311760c68827f4a45f87bb32782e29045afb2236
0x4a1df9716147b785f3f82019f36f248ac15dc308	230270	false	1	6685745	2024-09-13T13:17:57.000Z	7922816251426433759354395033600000	0x421f253a4cb5605cc596efed70c21923284d52dc449f9fc39f47190de763a219

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_bob.Pool_Initialize_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	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x02f57b2e4d310f3cf432fafa8d0d780ee920467c	false	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	72464630405103	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	3	7521999999999907	51992985	10793344	-193620	-193260	2024-12-17T15:17:55.000Z	0x015dd0538ffc78f5a85da5f407e3e5a7d018785833f5cbb4b2528f2e73ae11a2
0x0905a1a1848d034b51667127ef94e15378294b29	false	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	562971420235659381	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	5	660923506360890	717474015714130	10777959	-14	35	2024-12-17T06:45:05.000Z	0x3b759f5ac6fb804e4a58277015e8aa3226dc2ca3489fc30e310f9c8c70d81ce7
0x2ece0e4b20ab662a9fc222a391b3ccb9ebf0485d	false	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	11176957386	0x743e03cceb4af2efa3cc76838f6e8b50b63f184c	3	50214005	131105636	10768642	-228	98	2024-12-17T01:34:31.000Z	0x484798933472438306589a7a9dc74a4c6a00f964ed1624c170c8ef3b20ccdbbf

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_bob.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
0x9a3b17a2e2daf54ce80f2f4b2c8440902be715de	200617	false	0x346239972d1fa486fc4a521031bc81bfb7d6e8a4	10	-8168388	4223702220906490	14692479	10490694143344090	0x05853e7243dabffb277378f29725a3aebf439bdf	2025-03-17T21:29:05.000Z	1798910047724123383380791156824147	0x02f0670fba86f71042374c18c8c73954a9c21387cc063296050793a6890afb5f
0x9a3b17a2e2daf54ce80f2f4b2c8440902be715de	200617	false	0x0000000000459b25fd76c6a06029dc7bd00e5f37	2	-237236	122672589615689	14692761	10490694143344090	0x5ee6b4d740e816c0eb2038f30411db4cdcbbaceb	2025-03-17T21:38:29.000Z	1798911724354292641598230434994791	0xc64bbbc116db057be36ee79f27d0168a25fb15f82dd30d0db8e805e22ad137e7
0x9a3b17a2e2daf54ce80f2f4b2c8440902be715de	200617	false	0x346239972d1fa486fc4a521031bc81bfb7d6e8a4	3	-1933	1000000000000	14692765	10490694143344090	0x6956f74c9efdba65a3d5f94286110251bb2e5e3f	2025-03-17T21:38:37.000Z	1798911731883868563591697783932693	0xa221c4adda59be98aa82168bdec161431eb4a0b014d92998888560a215913292

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_FeeAmountEnabled_event

Factory_OwnerChanged_event

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_IncreaseObservationCardinalityNext_event

Pool_Initialize_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_FeeAmountEnabled_event

​Factory_OwnerChanged_event

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_CollectProtocol_event

​Pool_Flash_event

​Pool_IncreaseObservationCardinalityNext_event

​Pool_Initialize_event

​Pool_Mint_event

​Pool_SetFeeProtocol_event

​Pool_Swap_event

Tables

Factory_FeeAmountEnabled_event

Factory_OwnerChanged_event

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_IncreaseObservationCardinalityNext_event

Pool_Initialize_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event