uniswap_v3_blast

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	0x792edade80af5fc680d96a2ed80a44247d2cf6fd	false	3	400903	200	2024-03-05T04:07:01.000Z	0x5fab23b4bbd2136cc0f7de89dc55d33a06edf8ce5785ef1d9f21e970a1d2a5e9
500	0x792edade80af5fc680d96a2ed80a44247d2cf6fd	false	1	400903	10	2024-03-05T04:07:01.000Z	0x5fab23b4bbd2136cc0f7de89dc55d33a06edf8ce5785ef1d9f21e970a1d2a5e9
3000	0x792edade80af5fc680d96a2ed80a44247d2cf6fd	false	2	400903	60	2024-03-05T04:07:01.000Z	0x5fab23b4bbd2136cc0f7de89dc55d33a06edf8ce5785ef1d9f21e970a1d2a5e9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_blast.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
0x792edade80af5fc680d96a2ed80a44247d2cf6fd	false	0	0x2339c0d23b60739b3e5abf201f05903d24a26c77	0x0f9347b60003436fe54d77bc87419a88c9833bab	400958	2024-03-05T04:08:51.000Z	0x4b7ebf18436c86afdc1570d4a296e5155f81db74a916561b66d99650f4089e3d
0x792edade80af5fc680d96a2ed80a44247d2cf6fd	false	0	0x0f9347b60003436fe54d77bc87419a88c9833bab	0x0000000000000000000000000000000000000000	400903	2024-03-05T04:07:01.000Z	0x5fab23b4bbd2136cc0f7de89dc55d33a06edf8ce5785ef1d9f21e970a1d2a5e9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_blast.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	0x792edade80af5fc680d96a2ed80a44247d2cf6fd	0xf0d53e64960f5cf6b974315b18819955ec18ddb6	false	0x23fda00bbe4786d78a9f22c2f5c3a11090cb442a	0x4300000000000000000000000000000000000004	18	7549930	200	2024-08-17T15:47:55.000Z	0xc91d011f337b6e5480768ff2dd0f2a46f2f24851696ab4d6e87cf7af7d1bd995
10000	0x792edade80af5fc680d96a2ed80a44247d2cf6fd	0x54f78e2c087c4f01b3f7367e0efa49364b83ee80	false	0x3d3ff40460c076d595c555ef12cfaf060f7a310e	0x4300000000000000000000000000000000000004	43	7540024	200	2024-08-17T10:17:43.000Z	0xdec9ea993be65b404ca797d59b3fc0b02cd08368579c6b9bb4fab19de472a586
10000	0x792edade80af5fc680d96a2ed80a44247d2cf6fd	0x8f496d8e36b8c293d4d8e950c68f5a3957c05243	false	0x3f144125c1ff083290d488496dc1341e62723624	0x4300000000000000000000000000000000000004	16	7539836	200	2024-08-17T10:11:27.000Z	0xf1f5231a1a6676a462e0ea09f7e1c81ec9c75eeb5d0758c97da4422bfdb7438e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_blast.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
0xf5a23bdd36a56ede75d503f6f643d5eaf25b1a8f	false	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	2601216539733256	3	7776449306879766	2057310601829	11149862	-80820	-78810	2024-11-08T23:45:39.000Z	0x8fec3422d26eed5521ecc8b2b5f55dd8c106732f745a52e10dbec85ff34b1d6c
0xf5a23bdd36a56ede75d503f6f643d5eaf25b1a8f	false	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	112272143352678970	8	149878276625638419	0	11149862	-79810	-79310	2024-11-08T23:45:39.000Z	0x8fec3422d26eed5521ecc8b2b5f55dd8c106732f745a52e10dbec85ff34b1d6c
0xf5a23bdd36a56ede75d503f6f643d5eaf25b1a8f	false	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	2779945863478047	9	8307898262658548	2195577125803	11128242	-80690	-78680	2024-11-08T11:44:59.000Z	0x0122de4033690836c545714adf55ce123aaff874bb654a83cf1dfe1ca0be5415

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_blast.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
0xf5a23bdd36a56ede75d503f6f643d5eaf25b1a8f	false	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	43	89463677043778	29229251589930	9528362	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	-78620	-78120	2024-10-02T10:55:39.000Z	0x93a7ffbee75cccb3887509af6b757237aedd696c89cb17eba1cbe677b5e99747
0xf5a23bdd36a56ede75d503f6f643d5eaf25b1a8f	false	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	38	19251121682167730	7806536542418	9528362	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	-79120	-77110	2024-10-02T10:55:39.000Z	0x93a7ffbee75cccb3887509af6b757237aedd696c89cb17eba1cbe677b5e99747
0xf5a23bdd36a56ede75d503f6f643d5eaf25b1a8f	false	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	33	0	0	9528362	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	-887270	887270	2024-10-02T10:55:39.000Z	0x93a7ffbee75cccb3887509af6b757237aedd696c89cb17eba1cbe677b5e99747

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_blast.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_blast.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
0x99bdb2c42ef0ed1e9a11af5fdd966b09bc2960bf	false	538188401261	0x29184fd4f1b58fa41b471f02ad2109494706004c	11	5381884012604357	5824867	0x29184fd4f1b58fa41b471f02ad2109494706004c	2024-07-08T17:25:49.000Z	0x078f15fb0be8bef02fff41258b376bcb42539d8cdd7ca137dc984088395eaf9f
0x99bdb2c42ef0ed1e9a11af5fdd966b09bc2960bf	false	3242380020653	0x29184fd4f1b58fa41b471f02ad2109494706004c	11	32423800206524439	5815829	0x29184fd4f1b58fa41b471f02ad2109494706004c	2024-07-08T12:24:33.000Z	0x9a40be2f1b78e3c5fe4302ae5ce9fca97b086f02bd8722dc197b2136b0b533a6
0x99bdb2c42ef0ed1e9a11af5fdd966b09bc2960bf	false	303560626368	0x29184fd4f1b58fa41b471f02ad2109494706004c	11	3035606263671530	5796403	0x29184fd4f1b58fa41b471f02ad2109494706004c	2024-07-08T01:37:01.000Z	0xfcf34a9a310d77568f66e9d65becd5c1ca166dff94f3bb006b756dd554c6ffb8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_blast.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
0xf5a23bdd36a56ede75d503f6f643d5eaf25b1a8f	false	6	1634097	2024-04-02T17:13:29.000Z	0x93633ba97fe11e52fddf1dcfa7f9e918217a4b6bb84cee270cfb92411dcfa715	901	601
0xf5a23bdd36a56ede75d503f6f643d5eaf25b1a8f	false	18	1634082	2024-04-02T17:12:59.000Z	0x512d3dfdcba522dbad931e9304faf1657ea165100b91e8371ac78444cfdab3c4	301	1
0xf5a23bdd36a56ede75d503f6f643d5eaf25b1a8f	false	22	1634089	2024-04-02T17:13:13.000Z	0x3f9d8f1b66c4584bbd63168293c65f2fa6f4d5b43dce67c13373695b7d82373f	601	301

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_blast.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
0x73c7244351dd6d7234a5d6efd2d2b2d35dacf15e	-91065	false	11	10667286	2024-10-28T19:39:47.000Z	834720487725035753950589079	0xfee68ca3b22bb2858616b47e82025e9ca6ee95d19790216e0d7337710552d3b7
0xe35b935915abc08d7519d8adb588a8367431f5fe	91064	false	11	10641565	2024-10-28T05:22:25.000Z	7520004393919240427432298151936	0x4fa78765024731a8aa9f0926e240b7fdd73a61f78f7b6ada20a0247f9ef43e41
0x12030e8d8323b7618672f3d8ae0c022ab78f971e	91064	false	11	10667274	2024-10-28T19:39:23.000Z	7520004393919240427432298151936	0xe5fedf2b0072cf98f414164fd56e1615a29567c1687d2055aa1e1aa05b9ee126

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_blast.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
0xf5a23bdd36a56ede75d503f6f643d5eaf25b1a8f	false	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	151342967137669300861	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	23	210280902352225955129	0	2523482	-80610	-80110	2024-04-23T07:19:39.000Z	0x216d46d75e5b3a962e387057c481548265a296f77034e04854614828820d402f
0xf5a23bdd36a56ede75d503f6f643d5eaf25b1a8f	false	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	314919356018999572895	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	21	871686717834759201588	273231913679851525	2523482	-81620	-79610	2024-04-23T07:19:39.000Z	0x216d46d75e5b3a962e387057c481548265a296f77034e04854614828820d402f
0xf5a23bdd36a56ede75d503f6f643d5eaf25b1a8f	false	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	332064434150399390835	0x4909a1beae48656f3662bfef2b1b56e10fd0ab16	31	464854453871800329005	0	2545102	-80760	-80260	2024-04-23T19:20:19.000Z	0x6fc6f884c2628693e9ed12150ed2a05f34e872c68c423e6ec54cd429b61bebd3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_blast.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_blast.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
0xf52df2cde73228cc058abfe88f3801dcddf885eb	-261962	false	0x082fd5830101d851ce31725b3fcdc20cb5e8987d	80	-729630954637790	3050	8000295	229050683275	0x082fd5830101d851ce31725b3fcdc20cb5e8987d	2024-08-28T02:00:05.000Z	162461035574727426148645	0x2a767b94d6e5218f0b2fb28b7e48cad2f4c79bd70f3b5c7e2f69f25eee9cc445
0xf52df2cde73228cc058abfe88f3801dcddf885eb	-262092	false	0x79049ebe535d38b7b3cfb3c3f4951f0f44289aac	12	1824319117639730	-7692	7999325	229050683275	0x79049ebe535d38b7b3cfb3c3f4951f0f44289aac	2024-08-28T01:27:45.000Z	161406738613501835580779	0x7971edc56162d2a087d0db9c98928b21fb4938d04f0761825ecd3ed8f54c54ff
0xe6ab136f0aa84e198f828a1e2b6d62974458a2fe	-246280	false	0x549feb8c9bd4c12ad2ab27022da12492ac452b66	18	585927816683192860	-11864566	8027108	386388315448265	0xdb88cb1b11d1656a8407cd5e3e6d381d9008e7a1	2024-08-28T16:53:51.000Z	355841294509004656934411	0x4d8ee0c279e55fab649b0f9f35ac84b3b8f3cb2b5b65861844f4a56ed60a32de

Example Query

Query with partition filter

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