Skip to main content

Tables

Factory_PoolCreated_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_token0STRINGContract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_token1STRINGContract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_feeSTRINGFee 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_tickSpacingINT64Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_feeaddressin_poolremovedin_token0in_token1log_indexblock_numberin_tickSpacingblock_timestamptransaction_hash
30000x1f984000000000000000000000000000000000030xa26c5a72856f3830a7c65cb9d1d3462a625c34b4false0x42000000000000000000000000000000000000060x521b0bf8ee6267e651989b53f953c37d39f801d2011050967602025-03-12T17:08:46.000Z0xbe23826cc78adc0c200d6d89081f99c6eca3aca2ee71b28d1c7aabed580d1589
30000x1f984000000000000000000000000000000000030x30e2bc1c34a9e288a3c7523a775b0b7f3fa1c7b4false0x32246eb82b698773aeb481068a22b847dc6a0ed60x4200000000000000000000000000000000000006011050631602025-03-12T17:03:10.000Z0x8e4158453dbfd026518a3a28cb4a14cb276ba5a1d135eb3e0c5e4178a45ca405
100000x1f984000000000000000000000000000000000030x190a857a959767b0349cda4595427af5d139eabffalse0x1293bf5ae486dfd60a969675d566bed962b972ba0x42000000000000000000000000000000000000064110270482002025-03-12T10:30:07.000Z0xef879d5478194540577831b01c11d40b93c1824a888316200eed5316072dd33d
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_unichain.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower 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_tickUpperINT64Upper 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_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerin_amountlog_indexin_amount0in_amount1block_numberin_tickLowerin_tickUpperblock_timestamptransaction_hash
0x65081cb48d74a32e9ccfed75164b8c09972dbcf1false0x0000000000000dededdd16227aa3d836c575319489375699949384042319431297652270142560151953602001602025-04-18T19:26:14.000Z0x85ec7de72f4c6f711f6a7e77c7b2e7e22bec9b116ba0944e06600b1da71e3024
0x65081cb48d74a32e9ccfed75164b8c09972dbcf1false0x0000000000000dededdd16227aa3d836c575319412459445461574880287465251241663429142555251960801984802025-04-18T19:18:04.000Z0x06a52ab9c9e33a2c0ff6645ce78d680853beb1084bcb5d9e6b404a5246e18dd4
0x65081cb48d74a32e9ccfed75164b8c09972dbcf1false0x0000000000000dededdd16227aa3d836c575319412018904759257450287465251241662984142555251968001992002025-04-18T19:18:04.000Z0x06a52ab9c9e33a2c0ff6645ce78d680853beb1084bcb5d9e6b404a5246e18dd4
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_unichain.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower 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_tickUpperINT64Upper 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_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerlog_indexin_amount0in_amount1block_numberin_recipientin_tickLowerin_tickUpperblock_timestamptransaction_hash
0x65081cb48d74a32e9ccfed75164b8c09972dbcf1false0x0000000000000dededdd16227aa3d836c575319440379789398175520112453460x000ec408a89688b5e5501c6a60ef18f13db40f061974001976402025-03-14T23:08:25.000Z0x66d6a417a867501d5886f4f8b90b024c4fa7daea60cabb589e26859eb4ed69f9
0x65081cb48d74a32e9ccfed75164b8c09972dbcf1false0x0000000000000dededdd16227aa3d836c57531942116756341311622557817713655112004740x000ec408a89688b5e5501c6a60ef18f13db40f061948801996802025-03-14T10:40:33.000Z0x0583d53ebfef3f9aeeb44d246062c457744d31b44a2abc18b8f84c9419dc3fe0
0x65081cb48d74a32e9ccfed75164b8c09972dbcf1false0x0000000000000dededdd16227aa3d836c575319417126125565833227636633569112004740x000ec408a89688b5e5501c6a60ef18f13db40f061953602001602025-03-14T10:40:33.000Z0x0583d53ebfef3f9aeeb44d246062c457744d31b44a2abc18b8f84c9419dc3fe0
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_unichain.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_unichain.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_paid0STRINGAmount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
in_paid1STRINGAmount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
addressremovedin_paid0in_paid1in_senderlog_indexin_amount0in_amount1block_numberin_recipientblock_timestamptransaction_hash
0x65081cb48d74a32e9ccfed75164b8c09972dbcf1false2000x7f74e5a74f1ce5eb9e7595479ed22606e2c0da0d28400000105913860x7f74e5a74f1ce5eb9e7595479ed22606e2c0da0d2025-03-07T09:29:05.000Z0x9fc4dc0d94e77af43f7eb55340b08aaa49f36e704a7496794f9f232936e19029
0xc673d5164103357a7537c36438a6326776a14bbdfalse10485760000000x7f74e5a74f1ce5eb9e7595479ed22606e2c0da0d1510485760000000000105728160x7f74e5a74f1ce5eb9e7595479ed22606e2c0da0d2025-03-07T04:19:35.000Z0x58a1559126040a00e673be814f84738ecbe092a47718960b1f59f942f1ae6bd2
0xc673d5164103357a7537c36438a6326776a14bbdfalse10485760000000x7f74e5a74f1ce5eb9e7595479ed22606e2c0da0d4810485760000000000106155970x7f74e5a74f1ce5eb9e7595479ed22606e2c0da0d2025-03-07T16:12:36.000Z0xd68caebf64f646722a850cd4468c0da5d4082990f908e69c9ca10e70a202d18b
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_unichain.Pool_Flash_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Mint_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower 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_tickUpperINT64Upper 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_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerin_amountin_senderlog_indexin_amount0in_amount1block_numberin_tickLowerin_tickUpperblock_timestamptransaction_hash
0x65081cb48d74a32e9ccfed75164b8c09972dbcf1false0x0000000000000dededdd16227aa3d836c5753194261929883957950x0000000000000dededdd16227aa3d836c575319470109999999999996343109307641929601977602025-03-11T07:45:23.000Z0x5af509a8083081ad774a0e889225c60baf68bda790b1998c65efc758ea4f5fe5
0x65081cb48d74a32e9ccfed75164b8c09972dbcf1false0x0000000000000dededdd16227aa3d836c5753194852841777899130x0000000000000dededdd16227aa3d836c575319430196768288531978740109411651960801984802025-03-11T10:38:44.000Z0xd8febd028f436d5704bf125aaafac2036651494adfb7e4e74e995ccbf7de6b51
0x65081cb48d74a32e9ccfed75164b8c09972dbcf1false0x0000000000000dededdd16227aa3d836c57531941175426232522590x0000000000000dededdd16227aa3d836c5753194481309411534605200375403459109755401960802008802025-03-11T20:11:39.000Z0xc7a11de9d0922e7a476917c389ab7a271854a1e019d1144f0e36f6206e82c435
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_unichain.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_feeProtocol0OldINT64Previous protocol fee for token0. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
in_feeProtocol1OldINT64Previous protocol fee for token1. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
in_feeProtocol0NewINT64New protocol fee for token0. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.
in_feeProtocol1NewINT64New protocol fee for token1. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_unichain.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_sqrtPriceX96STRINGSquare 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_liquiditySTRINGTotal liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
in_tickINT64Current 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.
addressin_tickremovedin_senderlog_indexin_amount0in_amount1block_numberin_liquidityin_recipientblock_timestampin_sqrtPriceX96transaction_hash
0xa9c6669de2c04c2adb22ac7a65d75b47fee30e3550723false0xef740bf23acae26f6492b10de645d6b98dc8eaf3812609523940485464-20000000000000000009916807354791187451112692680x2531b2ff6a7f08c6ab12c29d1b394788f819deb12025-02-27T14:06:06.000Z10006001358441619476743944213240xe71ad6ebd6a21c480749c87c2ff093f99f809c27912d619b605712b1e4302333
0x836e5e9db1ae239b699a00878f2d3b09a6ade0e7-41317false0x7b9a0eaca74e0aca1bd52b3071af18d856d95424686467554867762938905606-1378891739411513009083994550236117613233078501806677840x7b9a0eaca74e0aca1bd52b3071af18d856d954242025-02-27T22:04:21.000Z100403137660919673419500166830xcb4d1cfcbca869e15ce43abc1c6ad6fd6fbd79c9c13fc2cbf410025c476b9cf3
0xa9c6669de2c04c2adb22ac7a65d75b47fee30e3550812false0xef740bf23acae26f6492b10de645d6b98dc8eaf34436042427893773-694802313275088719916600354791187451112692680x8aef08330aae3be2f963774f96f8e72d899b318e2025-02-27T14:02:39.000Z10050663213254561428241627070330xf5e7c02eb4b4c718b2538b2659caae4a9efa4e6dfdc7ded22f496e364a6ac69f
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_unichain.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100