uniswap_v3_base

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
500	0x33128a8fc17869897dce68ed026d694621f6fdfd	false	1	1371680	10	2023-07-16T18:38:27.000Z	0xedb18fb5d0bc873e137e19663251b3d1a3a9e276b095ca8bcf1ef4480c016f65
10000	0x33128a8fc17869897dce68ed026d694621f6fdfd	false	3	1371680	200	2023-07-16T18:38:27.000Z	0xedb18fb5d0bc873e137e19663251b3d1a3a9e276b095ca8bcf1ef4480c016f65
3000	0x33128a8fc17869897dce68ed026d694621f6fdfd	false	2	1371680	60	2023-07-16T18:38:27.000Z	0xedb18fb5d0bc873e137e19663251b3d1a3a9e276b095ca8bcf1ef4480c016f65

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_base.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
0x33128a8fc17869897dce68ed026d694621f6fdfd	false	0	0x31fafd4889fa1269f7a13a66ee0fb458f27d72a9	0x7ac7499f3754b65cf9089db328ef51151a78ec00	1371724	2023-07-16T18:39:55.000Z	0xa49f1704cd4bb0398d75e123fa2dc280adfc1e7a47c5fbfd44038c2e1f9d24c0
0x33128a8fc17869897dce68ed026d694621f6fdfd	false	0	0x7ac7499f3754b65cf9089db328ef51151a78ec00	0x0000000000000000000000000000000000000000	1371680	2023-07-16T18:38:27.000Z	0xedb18fb5d0bc873e137e19663251b3d1a3a9e276b095ca8bcf1ef4480c016f65

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_base.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	0x33128a8fc17869897dce68ed026d694621f6fdfd	0x30ebb6f706e18a366cc6bf601241d17315ff80a4	false	0x06d190a355c77dc73d35416913f089935c2ea770	0x4200000000000000000000000000000000000006	4	3019485	1	2023-08-23T22:05:17.000Z	0x498a0d9a079550bdaccf117eed27526134ab96ef56915abfe615862916eaa42e
500	0x33128a8fc17869897dce68ed026d694621f6fdfd	0x630a3ceb28278a153fd5a8973c24eb38f7054dd4	false	0x64b88c73a5dfa78d1713fe1b4c69a22d7e0faaa7	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	56	3007493	10	2023-08-23T15:25:33.000Z	0x536a1b76ec4159354d149e784733bdb700ec97cd29485035d7947194144ff951
500	0x33128a8fc17869897dce68ed026d694621f6fdfd	0x77c48cd9dfff344d95333c7cc4fcfe4581b184de	false	0x4200000000000000000000000000000000000006	0xf8f52453f9c47575fc34c85f46758481e4449a12	2	3014368	10	2023-08-23T19:14:43.000Z	0x443f11cc535365582c3eda894f1107229888191f21d72b40cfe6430e26d91ed3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_base.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	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x0595a125ea6517a2247576688c153ac8e84b50d5	false	0x03a520b32c04bf3beef7beb72e919cf822ed34f1	139429049132972833	1	134782515689412293	10755917332622066	8118205	-9200	16200	2023-12-19T22:42:37.000Z	0x0b613db90a739198922253570589138efa69cba14ea7100cdc85f72cc8687eaa
0x0595a125ea6517a2247576688c153ac8e84b50d5	false	0x03a520b32c04bf3beef7beb72e919cf822ed34f1	365275611426364755	5	132749214688281612	11686424205546506	8119332	-7400	-400	2023-12-19T23:20:11.000Z	0xc38b51a206e81b55fd28766397307b66770b7952ecb3a821aba8d56590767c27
0x0595a125ea6517a2247576688c153ac8e84b50d5	false	0x03a520b32c04bf3beef7beb72e919cf822ed34f1	0	8	0	0	8106748	-100000	60000	2023-12-19T16:20:43.000Z	0x75a07c257fa9874a425bc9139cd329a3c1e4eba57781509a7cedb596b24b71ac

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_base.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
0xde550073df4514614cb3c342d71c885e100a8110	false	0x03a520b32c04bf3beef7beb72e919cf822ed34f1	11	1585441	10150426074	10150002	0x3761b94d95b9cf1751a3e55239c94834628aa487	-200	0	2024-02-04T23:29:11.000Z	0x2bcbc57cffec41d0e44b4738915bc7ac78446dbb5e06cce245a249b604ceb667
0x7fe91f69adf6151a38e206a293f1935d8e562721	false	0x03a520b32c04bf3beef7beb72e919cf822ed34f1	52	39957349573217	14664403808051741194	10142193	0x03a520b32c04bf3beef7beb72e919cf822ed34f1	120600	134400	2024-02-04T19:08:53.000Z	0x8029ba338a0d4741e00090bcc3fc9ffde11d9ae696f7af413e4f8fd7e3b8e8c2
0x20ce087a26e01b7af59fcf7befd81507b0794ada	false	0x03a520b32c04bf3beef7beb72e919cf822ed34f1	144	306065375760121422	2890334191502531082189747724	10132753	0x03a520b32c04bf3beef7beb72e919cf822ed34f1	230000	230400	2024-02-04T13:54:13.000Z	0x9e47debd036aeef988b7fc64928fc452109750a6f22811d591cc90efd742ea28

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_base.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_base.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
0x4c36388be6f416a29c8d8eee81c771ce6be14b18	false	675000000000000	0x1669f766a7193c301aadddfe9092d3cd633c028c	38	1350000000000000000	5336837	0x1669f766a7193c301aadddfe9092d3cd633c028c	2023-10-16T13:30:21.000Z	0xf06a40ac0fc432db9b5e45dc85bf471299e51f1644237d66a352006c41b9578f
0x4c36388be6f416a29c8d8eee81c771ce6be14b18	false	675000000000000	0x1669f766a7193c301aadddfe9092d3cd633c028c	18	1350000000000000000	5337389	0x1669f766a7193c301aadddfe9092d3cd633c028c	2023-10-16T13:48:45.000Z	0x56256c4e5f626445574a01d6ae6a5fcee637974269b24158e255b891e138dc32
0x4c36388be6f416a29c8d8eee81c771ce6be14b18	false	2025000000000000	0x1669f766a7193c301aadddfe9092d3cd633c028c	59	4050000000000000000	5337205	0x1669f766a7193c301aadddfe9092d3cd633c028c	2023-10-16T13:42:37.000Z	0xb86bd76278e56cc4445ac15360671272ea8bb152428c58b47875939017770e46

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_base.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
0x22f9623817f152148b4e080e98af66fbe9c5adf8	false	14	3241884	2023-08-29T01:38:35.000Z	0x8c6cecce856700b81981e525e35f04518a98b0faac597f4dd82d17d18aba143e	7	1
0x10648ba41b8565907cfa1496765fa4d95390aa0d	false	3	2291948	2023-08-07T01:54:03.000Z	0x7056acac8c4e4ea108142e950d8a3c66a80991f2548c5f3b69bd5a907287be23	60	1
0x9e37cb775a047ae99fc5a24dded834127c4180cd	false	17	3291184	2023-08-30T05:01:55.000Z	0x6fe2fb52f5ee6efff20062eb7283eeb7df87cd149091a4d17f013305cd0e5496	100	1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_base.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
0xce8f33472334f94789e5d04caceebd64b6255bd3	-219283	false	1	3085443	2023-08-25T10:43:53.000Z	1372296032082318455464567	0x212a5e0d02d4ba5cb92e623f98405b5d68e9a4ede89aa1ae807a7051c082f601
0xa14bfa5a320209e5fe19fcbc8b6339cd3bee5dc2	-161190	false	23	3071129	2023-08-25T02:46:45.000Z	25052911542910170730777872	0x4e3c84eefc8b0603cec6d13772f18b922387ff060a867c294171554a29526c64
0x77d3ae9d679098e1af614f6cd09ceaabf89fdf68	-69082	false	19	3068267	2023-08-25T01:11:21.000Z	2505290050365003892876723467	0x27e62ece10241f672eae6f0f88d33897a525686fb05419ac4a38db97714fc9c5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_base.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
0x00bcec1526dae1e170a53017b8775a93b7810d7c	false	0x03a520b32c04bf3beef7beb72e919cf822ed34f1	5615752158417442872	0x03a520b32c04bf3beef7beb72e919cf822ed34f1	7	50120200484206900	49999999999999999826	9957705	63420	76680	2024-01-31T12:39:17.000Z	0x39ea0fa4f3432322f9ae23f49dbf97087a53b76bab98b6999d01b86409e56a09
0x018046b1d182f7c0978c07610e1173c8e11913fd	false	0xefb70692aecccf490ec508b165ea7098a8fcbe1f	698237185856076	0xefb70692aecccf490ec508b165ea7098a8fcbe1f	14	55364804178334505	436899694	9974832	-169840	-169450	2024-01-31T22:10:11.000Z	0xc9c5f176059bceb6029cff095088855f81fe3bdb6618b837069e068101fe8848
0x018046b1d182f7c0978c07610e1173c8e11913fd	false	0xcdc98c2dc2712dcdb94184d9cc40e5a9a1dd76b6	8881767006998	0xcdc98c2dc2712dcdb94184d9cc40e5a9a1dd76b6	83	1141014872267029	59784413	9969705	-170280	-169080	2024-01-31T19:19:17.000Z	0xffe3d94aa7b1e06bef2454cfa2b18b0b25abe846d66f79c5c9e121f3cc3339d0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_base.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_base.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
0x0de3e61a2259a629e7b513ed567ca533f757cbde	-199373	false	0x170100a288dc3d7e83fea20441f98166b15b6df0	47	-3743023220098	8139	7475565	13113016523	0x170100a288dc3d7e83fea20441f98166b15b6df0	2023-12-05T01:41:17.000Z	3713399701499576260385728	0x6f92fef95083d133719b87db9511d4b4cf4534fbb14af970a70f62771deee8f6
0xb4cb800910b228ed3d0834cf79d697127bbb00e5	-199280	false	0x24549fc74b3076a962624a26370ed556c467f74c	19	5000000000000	-11273	7487556	14039107647	0x987bfbe33c9cf18caa665b792db66339a9c16d32	2023-12-05T08:20:59.000Z	3730708457732905681896805	0xa3668a55861b4e9144bed9bf72831e55b932ac33bf9b20241481f8c1e58a3ced
0x53ba76436138c4344613294d06195908a33dcca1	-199266	false	0x24549fc74b3076a962624a26370ed556c467f74c	8	25000000000000	-56622	7477158	58491465037	0x24549fc74b3076a962624a26370ed556c467f74c	2023-12-05T02:34:23.000Z	3733321949547438773087927	0x1ea4dab26a7cdf65df5181c73662203c9159c3ca7aa39c876785777b9e8d0d86

Example Query

Query with partition filter

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