sushiswap_v3_polygon

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.

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	0x917933899c6a5f8e37f31e19f92cdbff7e8ff0e2	0x9fb25d291db66d22a72c52c5d24f11d71448a891	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x7f8f138a7384cb58ff646a3d346cf2794885a070	128	69576491	1	2025-03-27T20:45:50.000Z	0x90181a5c6282be9bdf53139fdb27ea44b581b477ec5990cc9ca99a2ebd398b9b
3000	0x917933899c6a5f8e37f31e19f92cdbff7e8ff0e2	0x836241cc28f28554172676234780bf070f0399ee	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x4abac6f83a0869d03ce8748f86d30ee47d1ac366	425	69567912	60	2025-03-27T15:41:22.000Z	0x10a9a0b8470c69a07e0f8a1bfcfaf8ec2c08a72c5d3d6a0cdb2083ef696725d2
10000	0x917933899c6a5f8e37f31e19f92cdbff7e8ff0e2	0x94a0a695bd669a868aebbe33492ec833dd6d5cec	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x690fad8144943979d3a8e74b5e9d64bb9d35986b	199	69574074	200	2025-03-27T19:19:36.000Z	0x4959e4a707ce31efb041bad8744235ca29ae5acc5f976a0a061dbee37f0fe28d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_polygon.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
0x1b0585fc8195fc04a46a365e670024dfb63a960c	false	0xb7402ee99f0a008e461098ac3a27f4957df89a40	1186889095096	276	13234884	9034955330952708	44055934	194100	207960	2023-06-18T15:13:56.000Z	0xd854ad680ecc2c5c306c1fc9e8b6864e617f3bd52803ab61d41844b15ccf21ef
0x1b0585fc8195fc04a46a365e670024dfb63a960c	false	0xb7402ee99f0a008e461098ac3a27f4957df89a40	2039167953462	147	23614005	15046888537918090	44055579	194400	208260	2023-06-18T15:01:22.000Z	0x3ec8df3c346af9ed31b68785e4cb91f5dcc9b339a720ed5e4804395c8edf5e7d
0x1b0585fc8195fc04a46a365e670024dfb63a960c	false	0x3361bf42cca22dc5fe37c7bd2c6a7284db440dfc	18888267275509	87	46486000	18269130248639964	44060180	200880	202920	2023-06-18T17:49:52.000Z	0xcf8d25a923dcbb7b118526899d6bc99c69076c6042a6c4e872be94a022e5061d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_polygon.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
0x1b0585fc8195fc04a46a365e670024dfb63a960c	false	0x3361bf42cca22dc5fe37c7bd2c6a7284db440dfc	191	1678846207	774550032340234866	45581229	0x3361bf42cca22dc5fe37c7bd2c6a7284db440dfc	200580	201360	2023-07-27T13:34:53.000Z	0x346f591d7c3583a40823450d8892db7cce79dc97321a941d1f50b4c62af640c0
0x1b0585fc8195fc04a46a365e670024dfb63a960c	false	0xb7402ee99f0a008e461098ac3a27f4957df89a40	377	266764238	178806598143040859	45575216	0x215462dc79523ac795216e1baa27586840fa9382	198960	201660	2023-07-27T09:59:50.000Z	0x0a73b68de55931bcea14d632c56ed155c085057a9f338bac35fa3bed982a3050
0x21988c9cfd08db3b5793c2c6782271dc94749251	false	0xb7402ee99f0a008e461098ac3a27f4957df89a40	310	537391859703766585	330457	45582577	0xbd1d6155bbb0af642fe05d2d218a04d0adee8afc	-279650	-279380	2023-07-27T14:23:11.000Z	0x15394dfab5d4f2096baf8915657b33202f7804f08e1c9aac084a8c337843071b

Example Query

Query with partition filter

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

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x28046815133d169295c7959fdb496eea08380564	false	0xcd03e2e276f6eedd424d41314437531f665187b9	28	819743	2510003833077390597	69287390	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2025-03-20T16:53:52.000Z	0x6f4aa4e962caf9da37bb31b879e584315c139234de1851a37224983e52c616ff
0x8bbda11b9549ad89373369dfeb6655ad9d57eeb3	false	0xcd03e2e276f6eedd424d41314437531f665187b9	40	406520	1258285859001846994325	69287390	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2025-03-20T16:53:52.000Z	0x6f4aa4e962caf9da37bb31b879e584315c139234de1851a37224983e52c616ff
0x615ad032220e5df9368423c686191953a32ccc9d	false	0xcd03e2e276f6eedd424d41314437531f665187b9	34	6951020141923466755	14168807093646487117838	69287390	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2025-03-20T16:53:52.000Z	0x6f4aa4e962caf9da37bb31b879e584315c139234de1851a37224983e52c616ff

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_polygon.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_paid1	in_sender	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0xb33a9c4ff43d331f05a27a5995b0d6904bee6308	false	0	3393886819155	0xd99c08ebec42a0395d86194f5521d0ed05591532	41	0	33938868191543649	78705653	0xd99c08ebec42a0395d86194f5521d0ed05591532	2025-11-07T11:49:31.000Z	0xd7af4732b1583004d21ba4165c69423a57b5b10f85b449dfbbd8eda28aceb566
0x74255cc2142b337a93ac88f3c32ceb95b5a99934	false	803070497029082	0	0x4770663fd162a9ff10219dd9f569b8af5a0e0ae8	191	267690165676360440	0	73537604	0xf2a3555584c6e20b288094b137f670472ec1bb9c	2025-07-03T18:58:32.000Z	0x096bdbc69d9a29d252a7179adfb2efe4aff7086e5d1515712d4cb0bd40618926
0xb33a9c4ff43d331f05a27a5995b0d6904bee6308	false	0	1703866924932292	0x4f80b1bd8a1562e3bc7798d49c39bf2b065439cb	24	0	17038669249322917696	75608034	0x4f80b1bd8a1562e3bc7798d49c39bf2b065439cb	2025-08-24T18:54:03.000Z	0xf599fd3303e62d64850bc298d4e8598bee50e2749ab1185a697e182803052060

Example Query

Query with partition filter

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

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
0xaabfa6dc0541033c1a2eb685f358d0ea937bb026	false	0x695cbb8e330e4decbcc54bd0b92cb656a1dc6a03	655090656554504118	0x695cbb8e330e4decbcc54bd0b92cb656a1dc6a03	306	5459992557945613590391454	9842561367	62547834	-360200	-340600	2024-10-02T16:16:22.000Z	0xff0cb7e7fab1aa2c9dad6afd864be45921dd291a7244188d996552c6c059b393
0xaabfa6dc0541033c1a2eb685f358d0ea937bb026	false	0x695cbb8e330e4decbcc54bd0b92cb656a1dc6a03	651022579187109459	0x695cbb8e330e4decbcc54bd0b92cb656a1dc6a03	373	5434352655017591798470708	9870391923	62527617	-359800	-340200	2024-10-02T04:15:51.000Z	0x29729fd2966dccb96d05e430a620ea6eac32a11f8f2bc17b8f9d99e9a78b8c8e
0x21988c9cfd08db3b5793c2c6782271dc94749251	false	0x89e895c79fc74f53cb13ee880e38a31149e7802b	4950713284586618	0x89e895c79fc74f53cb13ee880e38a31149e7802b	628	822648065640619040482	40811279	62548292	-286480	-284070	2024-10-02T16:32:36.000Z	0xda59ae9d3770903d491ffe885392eae907b736cef269f0904de58474f7da61f8

Example Query

Query with partition filter

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

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_feeProtocol0New	in_feeProtocol1New
0xdc0c62884e7fd5af17afec09791f98cafb343873	false	35	68266919	2025-02-23T08:03:26.000Z	0xd2effdea9132da84e090b3cd31079364ca04ce8d96a868c89d83d7343b856065	4	4
0xf154320d66ea29fb725f59df313cd82c960a076c	false	36	68266919	2025-02-23T08:03:26.000Z	0xd2effdea9132da84e090b3cd31079364ca04ce8d96a868c89d83d7343b856065	4	4
0xd35383d1f20d0f8731fef36d9b3fbcc5cf5f8548	false	34	68266919	2025-02-23T08:03:26.000Z	0xd2effdea9132da84e090b3cd31079364ca04ce8d96a868c89d83d7343b856065	4	4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_polygon.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
0x21988c9cfd08db3b5793c2c6782271dc94749251	-281273	false	0x0a6e511fe663827b9ca7e2d2542b20b37fc217a6	254	842515051756433040195	-515691199	43918364	141939669943679399	0xee6b1939c10fdc9902b00915d6de004fa516c41b	2023-06-14T23:18:20.000Z	61862718940106885360351	0x94ccc7d79e6b650f465030e480d84e32c409d94d58fa69366a2f40e55f59a743
0x21988c9cfd08db3b5793c2c6782271dc94749251	-281253	false	0xce6314f881c05f64c89b0f6520c0286f0ac91f8f	303	202028737871067665817	-123486352	43915105	141939669943679399	0x1f1e4c845183ef6d50e9609f16f6f9cae43bc9cb	2023-06-14T21:00:52.000Z	61924655563704011354898	0x6eeb7ee580e3c23a6f9ff930252bd37f3c1ff7f2c99c8c7d72bcbee95715bc6a
0x21988c9cfd08db3b5793c2c6782271dc94749251	-281228	false	0x7fa6377f78b587c71f7e24176d7a65c12fba76b2	388	-426208019064292134279	260577328	43918364	153334653271381121	0x7fa6377f78b587c71f7e24176d7a65c12fba76b2	2023-06-14T23:18:20.000Z	62002479650595364478581	0xb7fdb1bc3174714e00946252efb5aec9fa9085ea0b00b2ed3c91ab58cb27eaef

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_polygon.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

V3Factory_PoolCreated_event

Uniswap V3 factory pool creation events emitted when new concentrated liquidity pools are deployed, containing token pair addresses, fee tier, tick spacing, and the deployed pool contract address. Used for tracking DEX pool deployments and liquidity pool registry construction.

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	0x917933899c6a5f8e37f31e19f92cdbff7e8ff0e2	0x8c50cc280a261b8012b2bdf42a8bc6225f8ec935	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0xb72c0b461d5077466b2e45b296b797f3fd2bd6c0	305	45300624	1	2023-07-20T10:41:42.000Z	0x332567fb8bdd2237d3344d84337cceed043421026ca79af99f043b08e50a72ac
10000	0x917933899c6a5f8e37f31e19f92cdbff7e8ff0e2	0xdbb9529a09a7985c27d160b07aa9aab23921bc49	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x7d3bbbd25915e37b2d45d8918ca027f3e469a3e8	287	45310689	200	2023-07-20T16:43:08.000Z	0x304e3351fca18473991f72d4699fd8ac875605b28f8f119245f4ca22d4c7a45c
10000	0x917933899c6a5f8e37f31e19f92cdbff7e8ff0e2	0x32a3b09fcfbeeedf66c947b4f796aa58fdbdfb0c	false	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	0xd41cbd667ad10ab83198f40ec6ac97190309178b	178	45317081	200	2023-07-20T20:34:05.000Z	0x71411f963628ddcba6efad6520e06d79391b556f847cb4883ca1f7bcfd76c9be

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_polygon.V3Factory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event

V3Factory_PoolCreated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_CollectProtocol_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_SetFeeProtocol_event

​Pool_Swap_event

​V3Factory_PoolCreated_event

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event

V3Factory_PoolCreated_event