uniswap_v3_celo

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
10000	0xafe208a311b21f13ef87e33a90049fc17a7acdec	false	4	13916355	200	2022-07-07T02:31:36.000Z	0x21cd0e2e7f504d56b78b474756c4c1f08ec0bffb54a9a5b98338f5c94cb48028
3000	0xafe208a311b21f13ef87e33a90049fc17a7acdec	false	3	13916355	60	2022-07-07T02:31:36.000Z	0x21cd0e2e7f504d56b78b474756c4c1f08ec0bffb54a9a5b98338f5c94cb48028
500	0xafe208a311b21f13ef87e33a90049fc17a7acdec	false	2	13916355	10	2022-07-07T02:31:36.000Z	0x21cd0e2e7f504d56b78b474756c4c1f08ec0bffb54a9a5b98338f5c94cb48028

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celo.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	log_index	in_newOwner	in_oldOwner	block_number	block_timestamp	transaction_hash
0xafe208a311b21f13ef87e33a90049fc17a7acdec	false	111	0x5ee2ba07742d9276b2f51ee4ad949016b7f164c1	0x885b67395c102f5cd58d593a2a5eaac43b204dbf	14011818	2022-07-12T15:07:11.000Z	0xe1c7de152089a45005c9defb262e1ddba6d7d1cb85a3b3f7ea9f113f597c2b18
0xafe208a311b21f13ef87e33a90049fc17a7acdec	false	1	0x885b67395c102f5cd58d593a2a5eaac43b204dbf	0x0000000000000000000000000000000000000000	13916355	2022-07-07T02:31:36.000Z	0x21cd0e2e7f504d56b78b474756c4c1f08ec0bffb54a9a5b98338f5c94cb48028
0xafe208a311b21f13ef87e33a90049fc17a7acdec	false	4	0x0eb863541278308c3a64f8e908bc646e27bfd071	0x5ee2ba07742d9276b2f51ee4ad949016b7f164c1	21165468	2023-08-31T15:30:23.000Z	0xa4e2f1aa3cf4d457e0238cd9afdb4ad7ebe96bc19238dfac079b82eebd5542e9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celo.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
10000	0xafe208a311b21f13ef87e33a90049fc17a7acdec	0xf3f18350598ea58d1803b436c332469ee8e09d1d	false	0x471ece3750da237f93b8e339c536989b8978a438	0xc15c0c629d52a2434949f3213ac5626737fd8801	9	23884467	200	2024-02-05T00:18:50.000Z	0xa9d80cee8cb0c7750fea1ed01390e74b80320d00e77dd3ec283a680e16afe59f
100	0xafe208a311b21f13ef87e33a90049fc17a7acdec	0x1aa2f83357150f811b1010c00020abe1462feb01	false	0x48065fbbe25f71c9282ddf5e1cd6d6a887483d5e	0xb55a79f398e759e43c95b979163f30ec87ee131d	301	35302673	1	2025-05-14T06:17:11.000Z	0x30c6244fd2cfd67ef7e82ed4b08095fc53cc51bcfe19290690390179dc830253
100	0xafe208a311b21f13ef87e33a90049fc17a7acdec	0x04feae0d4a3d0051397ee09314dad768a37fb539	false	0x48065fbbe25f71c9282ddf5e1cd6d6a887483d5e	0xc45ecf20f3cd864b32d9794d6f76814ae8892e20	101	35302587	1	2025-05-14T06:15:45.000Z	0x42114def9263e724233fa49b30c54b2a25a428646860949a389edc6a66bf142e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celo.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	log_index	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x079e7a44f42e9cd2442c3b9536244be634e8f888	false	0x3d79edaabc0eab6f08ed885c05fc0b014290d95a	20	22446393	-9000	-5100	2023-11-13T18:36:10.000Z	0x6f7ecf0ef5e6aafedc22441b222e916c6b87472ebf50d82e2f8bbfddb4a6cda1
0x079e7a44f42e9cd2442c3b9536244be634e8f888	false	0x3d79edaabc0eab6f08ed885c05fc0b014290d95a	0	22445893	-7320	-3000	2023-11-13T17:54:30.000Z	0xba11f2609588216248eef67581983b580802f43f3655405d41d40a965452853a
0x079e7a44f42e9cd2442c3b9536244be634e8f888	false	0x3d79edaabc0eab6f08ed885c05fc0b014290d95a	5	22446430	-6000	0	2023-11-13T18:39:15.000Z	0x98455cf3e479109a9427b8433281e682e7b737e6b7c18dbc203b19990bf37275

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celo.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
0x05efb437e4e97efea6450321eca8d7585a731369	false	0x3d79edaabc0eab6f08ed885c05fc0b014290d95a	47	2191512778325503182	698027328941671213	25849370	0x032da64e0dd1f3024a638664faf7382f6bbccb80	-1800	0	2024-05-28T17:38:38.000Z	0x6f8ad847d78f5deefedab23ff9e87ec48bda0ca0b190226160901dc2ea031a86
0x079e7a44f42e9cd2442c3b9536244be634e8f888	false	0x3d79edaabc0eab6f08ed885c05fc0b014290d95a	32	97909121683741482	71158473964225591	25850235	0x4ce2974b9aa126d524bd5f2f48ef30e34285bc75	-8400	-1080	2024-05-28T18:50:43.000Z	0x2afaa12a22f8cd1e6084d7e2a0a9713ebd51f86a31a88e708ddf88ae8953cdf7
0x079e7a44f42e9cd2442c3b9536244be634e8f888	false	0x3d79edaabc0eab6f08ed885c05fc0b014290d95a	36	248850049832052613	169329692126418379	25849271	0x8aab811b1be8106c9be280559496733b818a5b52	-3780	4080	2024-05-28T17:30:23.000Z	0x73700f71e1b1716a5fc5f7f50b1617a5e023bfc09d6921eb8c61c0483f3a0d34

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celo.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_celo.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_sender	log_index	in_amount0	block_number	in_recipient	block_timestamp	transaction_hash
0x5dc631ad6c26bea1a59fbf2c2680cf3df43d249f	false	5559820	0x6e93c385bc71ca366348b6f0d16f440369c5d17e	384	55598191244	28145527	0x6e93c385bc71ca366348b6f0d16f440369c5d17e	2024-10-08T15:05:12.000Z	0x890ef707f4f7e1200b94afd08c1bf0a05290ee0e69a74807b649b3c42867c99f
0x2d70cbabf4d8e61d5317b62cbe912935fd94e0fe	false	73736985091499315	0x7e609286e1135c7c665786232b5eaf41165c8ccd	238	737369850914993144837	28151394	0x7e609286e1135c7c665786232b5eaf41165c8ccd	2024-10-08T23:14:07.000Z	0x5c9fb2a48fea5820b3d99903a36191088f096d2cf301b1ef37100afc0b1e0019
0x2d70cbabf4d8e61d5317b62cbe912935fd94e0fe	false	278256491743594698	0x75e0489258c76d57db4f5e6d0644792e69e2d953	296	2782564917435946976653	28148411	0x75e0489258c76d57db4f5e6d0644792e69e2d953	2024-10-08T19:05:32.000Z	0x231616e47294f7c862c0e391cc61b4a8daab4b64638a639eff8d078908746299

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celo.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
0x9491d57c5687ab75726423b55ac2d87d1cda2c3f	false	10	21583271	2023-09-24T19:48:39.000Z	0x6755da0385449263e8da14a771fc002f81ec8fdb15e761336cc93a9af5131900	1000	121
0xea3fb6e3313a2a90757e4ca3d6749efd0107b0b6	false	14	21583964	2023-09-24T20:46:24.000Z	0x5963eabf7ee08a614deaa9072b9dcd19a3fe7961f8e718c9d6aa2f0b75c07bc3	1000	1
0x3dbdcf5f88ae4fb08218cbe622187b02e70f3097	false	18	21583982	2023-09-24T20:47:54.000Z	0x1b6b9e9af3fa0a393e25b81ef3da8936704d1a1f6acbd1dc5dd66584a964641f	1000	1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celo.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
0x62995e98b2a945f147fe90d92017cb9fd6713bee	-256804	false	11	15186685	2022-09-19T15:29:14.000Z	210247277118087033192658	0xa029ee24b1923c54ff01fe378b5cf968486cd8bfdb69392e402a985dd95edc88
0xd0d3778680b0b41f34ec186504c58d3a3a095861	-73706	false	4	14165445	2022-07-22T13:03:53.000Z	1988172898704837298767711266	0x64ee2b0c7b0a062d8886a379254576919d637bef032ad01652b9f896cc6d1b2e
0xf63b45b8b2a40f7063e1d2de8bb0832de561a032	115135	false	37	14170632	2022-07-22T20:16:08.000Z	25054131037751093162929900172930	0xf01453910782a2e62642ad8c8a30adfedba420d0618f5eb1ab77d85c74838221

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celo.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_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0xd80d28850bebe6208433c298334392bc940b4fc7	false	0x044ef06f0b4464d341f143170b334531dbc5c39f	26806412851336255	0x044ef06f0b4464d341f143170b334531dbc5c39f	48	274328288688798	39120803	-887272	-91646	2025-06-27T10:52:41.000Z	0xaaadbe40bebff975b99d51a4fb5d4059f8369fadd25aa8304cb10241c4773d2d
0xd80d28850bebe6208433c298334392bc940b4fc7	false	0x044ef06f0b4464d341f143170b334531dbc5c39f	3277061808192387643	0x044ef06f0b4464d341f143170b334531dbc5c39f	44	1133135037277971	39099092	-92021	-91344	2025-06-27T04:50:50.000Z	0xc06d1c44e2d2857f7fd14ce5894ae643422e5bfe636c58f0e63514f3fbd4adac
0xd80d28850bebe6208433c298334392bc940b4fc7	false	0x044ef06f0b4464d341f143170b334531dbc5c39f	3853168671906262542	0x044ef06f0b4464d341f143170b334531dbc5c39f	17	1339285832761321	39091473	-91917	-91240	2025-06-27T02:43:51.000Z	0x7776032cb01135660e219384f19cd6370cc41f4edfbbcae6f856812b5080a91b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celo.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_celo.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
0xe7897065c71026fe0ff105bd2641c369d9ffa157	16496	false	0x5615cdab10dc425a742d643d949a7f474c01abc4	12	10389167079711075967	-54016664847081765795	15645797	110716181821661523676001	0x8de3c3891268502f77db7e876d727257dec0f852	2022-10-16T05:09:38.000Z	180753309852119140507776118904	0x2ed8c448d74a4bd30491654d409cb6ee5ed02dd7cea784bf2d819724c9675a12
0xbd0f6f34baa3c1329448a69bab90111a20756f01	47603	false	0x5615cdab10dc425a742d643d949a7f474c01abc4	80	-20012900468060216	2343619359767601647	15649090	1121401771164821124816747	0x0fa14cf4501cc9b2172487fbe863aa236b961320	2022-10-16T09:44:03.000Z	856082709292757427703545341850	0x4b34c1b6dacb5225d5ae8bc2145319629382f34b967c88c6571a1d19adeee4d8
0xbd0f6f34baa3c1329448a69bab90111a20756f01	47603	false	0x5615cdab10dc425a742d643d949a7f474c01abc4	33	-40089988341750120	4694758132254453198	15652797	1121401771164821124816747	0x0fa14cf4501cc9b2172487fbe863aa236b961320	2022-10-16T14:52:58.000Z	856083039987071118164317478847	0x9ddeb67ab4ce2c209806f0dae618720f63cf0923d39e03a6572f1d3ce5241064

Example Query

Query with partition filter

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