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
5000x1f98431c8ad98523631ae4a59f267346ea31f9840x71442bbef4b6d1876d2bb1ad481844a7757581cafalse0x82af49447d8a07e3bd95bd0d56f35241523fbab10xde903e2712288a1da82942dddf2c20529565ac3002253818102021-10-15T16:35:31.000Z0x7690c099412f1205a9876b243da3e93b3d7fc14c3b4498e2871421b103e4e7e2
5000x1f98431c8ad98523631ae4a59f267346ea31f9840xeed3f636e0878cbb968a05fbad77769f52538760false0x6146520ad1cf3feb064ae8496448215e476617490x82af49447d8a07e3bd95bd0d56f35241523fbab1059267009102023-02-09T01:50:42.000Z0xebaf52871c61d88b089a4d1beb9fe9525d9f6635a0c519691745aa75f589d05d
5000x1f98431c8ad98523631ae4a59f267346ea31f9840xbefd6d83daa3bffb236de28abbad902d8737ad0dfalse0x437b47c21d70f517358170cd118f6acb11c3aa4c0x82af49447d8a07e3bd95bd0d56f35241523fbab1059310403102023-02-09T05:23:10.000Z0x19d7b42404457807330f5b4215631276d76bf7c39ae05ad605ae916fdc2e8fdf
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_arbitrum.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
0x00765cdf4caa7cf0df556eeb7144c73e046988f3false0xc36442b4a4522e871399cd717abdd847ab11fe88000083734010-276400-2736002023-04-24T07:43:25.000Z0x8b7f2c344c4c410ad3bb20b0873e5a284d4cc96607ee27cefff506e629024417
0x00765cdf4caa7cf0df556eeb7144c73e046988f3false0xc36442b4a4522e871399cd717abdd847ab11fe88090083921469-276400-2736002023-04-24T20:42:50.000Z0xd5c3d152305479956dd7739094adba3ebecb34a3ac796fa2e2e3e9443203c8c0
0x00765cdf4caa7cf0df556eeb7144c73e046988f3false0xc36442b4a4522e871399cd717abdd847ab11fe880110083794061-276400-2736002023-04-24T11:52:50.000Z0x5ff5459c2237d994bb8a84d8931c87981915c01bb8e0633622815729789dee2f
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_arbitrum.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
0x13398e27a21be1218b6900cbedf677571df42a48false0xc36442b4a4522e871399cd717abdd847ab11fe885249954292499999586366610x125c459df3e8454b3c90462f5078c34182bd1312-8872708872702022-03-26T11:29:03.000Z0x3243b4ece2a37240cbd129f4223f25a09d9a98ba9bb027ff32928862e2f22e2c
0x149e36e72726e0bcea5c59d40df2c43f60f5a22dfalse0xc36442b4a4522e871399cd717abdd847ab11fe884179922629691302493332972686326880xc36442b4a4522e871399cd717abdd847ab11fe882557802577602022-03-26T09:39:13.000Z0x4be7c52b79a257eef39b431bf5ed55d96ba2628f29443216092c0129250ce083
0x17c14d2c404d167802b16c450d3c99f88f2c4f4dfalse0xc36442b4a4522e871399cd717abdd847ab11fe8854749999997822307814855744086608370xc36442b4a4522e871399cd717abdd847ab11fe88-202740-1888802022-03-26T22:15:09.000Z0x0547312c5a061bbc6110124409cd697d3d3184be63047443185d639220719807
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_arbitrum.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_arbitrum.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
0x8c9d230d45d6cfee39a6680fb7cb7e8de7ea8e71false010x2dd9440ec264af225aaf66d691b0b73e9425a1818011330776460x2dd9440ec264af225aaf66d691b0b73e9425a1812023-09-21T05:05:36.000Z0x6f9b49e38130c9032b83b25b5cc45651fb8dc06d3079c8a3bf4f8002e9801696
0x8c9d230d45d6cfee39a6680fb7cb7e8de7ea8e71false010x2dd9440ec264af225aaf66d691b0b73e9425a1818011330793390x2dd9440ec264af225aaf66d691b0b73e9425a1812023-09-21T05:13:02.000Z0xffefb5258a4ebafe71a3cdf987c62b974b981bd9725381bf8454c4d183bb53bc
0x8c9d230d45d6cfee39a6680fb7cb7e8de7ea8e71false010x2dd9440ec264af225aaf66d691b0b73e9425a1818011331120810x2dd9440ec264af225aaf66d691b0b73e9425a1812023-09-21T07:31:06.000Z0x929d330e1072056c44c6123d0742a094ca8483926497afffee357d5fd9668c3a
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_arbitrum.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
0x02643ea06e160344dd670da34afdab165208e80ffalse0xc36442b4a4522e871399cd717abdd847ab11fe883340608675711252050xc36442b4a4522e871399cd717abdd847ab11fe887519476198415682495669049489514947599113817919-158820-1449002023-07-22T14:07:18.000Z0x8312723d273fd73a1d1cc0956a561c17a3c5e6e8fa05c3cf74d40cf801208c61
0x02c79a7e3d8a9cb773cd5f69be00a64f48308508false0xc36442b4a4522e871399cd717abdd847ab11fe8824659951066500xc36442b4a4522e871399cd717abdd847ab11fe8848135326350990113916999-42600-418002023-07-22T21:13:33.000Z0xf6f892718f17392d4259d79f9e167bef86c741a8ec411175667cfb67dbcdac98
0x030571cda878781cdbbe669d63aa87d9d7371ca1false0xc36442b4a4522e871399cd717abdd847ab11fe886769440518393665811970xc36442b4a4522e871399cd717abdd847ab11fe8848912999999999999999923264812194857144077113927386-7000-40002023-07-22T22:00:29.000Z0x1ba27d21c1fba474470399d44cb556216da1ef0014c03d5a8d8f00a82f8d276d
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_arbitrum.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_arbitrum.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
0x31479e98952ae0ff9e9f3dda930a8c264cb16608-887272false0x68b3465833fb72a70ecdf485e0e4c7bd8665fc4531290180351868480702339-1059886591265047674647018300x68b3465833fb72a70ecdf485e0e4c7bd8665fc452022-12-15T21:01:26.000Z42951287400xf7ee790e3d3f3c219c2e4ca0a1d89639ab4f4c86881a54bee59f732d4b5df99a
0xa85546a6d7075be236c858fc689c8b8b9eea8d14-887272false0xe592427a0aece92de3edee1f18e0157c058615641122032824128288759-1100584958386544626443300x14e204199b15c6a954bcec2dd9e887922e1d69c02022-12-15T04:25:30.000Z42951287400xcbaa0e84d3197c42cae2ec64db47ceaeb1a2209f303b8be622b8e354aef3f7e9
0xa85546a6d7075be236c858fc689c8b8b9eea8d14-887272false0xe592427a0aece92de3edee1f18e0157c058615641140120361083249751-2016494765001604627502400x59b9f3b355eed35a15174dcadbe71f92f13c50102022-12-15T05:20:56.000Z42951287400x50d0d5e582ad1982219aa4c67b34b8281da64d61159ea3a5670baaafb62ba59a
Query with partition filter
SELECT *
FROM `tt-contracts.uniswap_v3_arbitrum.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100