sushiswap_v3_gnosis

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
3000	0xf78031cbca409f2fb6876bdfdbc1b2df24cf9bef	0xe26d5614e5f91bc5d24fdf4947ea61ed9557d752	false	0x4b1e2c2762667331bc91648052f646d1b0d35984	0x82dfe19164729949fd66da1a37bc70dd6c4746ce	10	28567344	60	2023-06-21T14:58:40.000Z	0xe227fef33d17624dd5e690c240fcbfc7c482c2f8fa9447621a75184fc342521b
500	0xf78031cbca409f2fb6876bdfdbc1b2df24cf9bef	0xf072b4758c6e795bee555cc2f6d20cdacee8b1f9	false	0x4b1e2c2762667331bc91648052f646d1b0d35984	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	9	28858767	10	2023-07-09T07:06:35.000Z	0x97627e01d43df84decf3880ffa8dd05a685960009ad0fab48f46fce6af6e1497
100	0xf78031cbca409f2fb6876bdfdbc1b2df24cf9bef	0x782d7cf58666b0dd3e84fe57707408621e3bdd04	false	0x82dfe19164729949fd66da1a37bc70dd6c4746ce	0xe0d0b1dbbcf3dd5cac67edaf9243863fd70745da	39	28358945	1	2023-06-08T23:43:55.000Z	0xa1749b1e35d9292b4f4399b0ccdf91605ca950d37f29504100fcdca72a7e674d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_gnosis.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
0xa86e60ce1a56acc3c23769a523fc476c0a0c7bec	false	0xab235da7f52d35fb4551afba11bfb56e18774a65	82189261067205242994	19	1503037880759911946217	4494281029935161492	29840502	-887272	887272	2023-09-06T15:45:20.000Z	0xe9a9d35614541ec217c6380631343eaaba10a05df336b9318421b2fa4ce25d80
0x5fa192d5c3ee926e04489322631d4a1e554bf3a6	false	0xab235da7f52d35fb4551afba11bfb56e18774a65	19657820975104914763	7	6270599245517074091	5172536713079538702	29718170	-6000	7800	2023-08-30T07:08:00.000Z	0xb4a39eea108a3089c561c9adf7d6e287edeed7b6e57c1fdd3939cbc73cbd8e1e
0x5fa192d5c3ee926e04489322631d4a1e554bf3a6	false	0xab235da7f52d35fb4551afba11bfb56e18774a65	0	40	0	0	29542994	200	1400	2023-08-19T18:37:15.000Z	0x6b1543c261b9132df12ac463d851533970fb1ba9f60560d8e93ad89f6cf8a1df

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_gnosis.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
0x2aca1e3c378551363ed055e66612fc66259e49f3	false	0xab235da7f52d35fb4551afba11bfb56e18774a65	27	19999999999999855307	0	29955474	0x59fb16c10c52ce120e513f232af141901ad18d9b	-276300	-274500	2023-09-13T14:07:45.000Z	0xf3af34c2d64e1d93bbb8000aa683210a61722e937c7572a66f949988ce94efd7
0x5fa192d5c3ee926e04489322631d4a1e554bf3a6	false	0xab235da7f52d35fb4551afba11bfb56e18774a65	21	10072276753763888429	784825770583617622	29953825	0xab235da7f52d35fb4551afba11bfb56e18774a65	-200	1200	2023-09-13T11:44:00.000Z	0x7b2762f812ad1cbc8753bb9a5c6680a5cf43ae0175c8aa81369b290ecd37e1d2
0xe9ee62b3387cba7ed143e8645e5c26232a5a6337	false	0xab235da7f52d35fb4551afba11bfb56e18774a65	9	77058246297313969160	5348366661821492703	29953732	0xab235da7f52d35fb4551afba11bfb56e18774a65	-120	1380	2023-09-13T11:36:05.000Z	0x66f59e49326ab41ea231c8801987d645a90fd1f960f1dfbaaa06070ad3ba1b51

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_gnosis.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
0x0b43767603653fcd9476d664d25c58b109214f03	false	0xcd03e2e276f6eedd424d41314437531f665187b9	39	13230000	661500	38706015	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2025-02-23T08:26:35.000Z	0x32fb4e4b9daedcda3156b764058d277afd3514d88debdb9f6a5d1e6cba7691dc
0xd7bb3dff2a5a7ac5d2150f161514d866b6c960e8	false	0xcd03e2e276f6eedd424d41314437531f665187b9	42	2188143372012598552	3149768	38706015	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2025-02-23T08:26:35.000Z	0x32fb4e4b9daedcda3156b764058d277afd3514d88debdb9f6a5d1e6cba7691dc
0xd7bb3dff2a5a7ac5d2150f161514d866b6c960e8	false	0xcd03e2e276f6eedd424d41314437531f665187b9	34	147811370731870106	1815363	35982949	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2024-09-13T16:54:40.000Z	0xca3da0980279e34bf086e7b636839198e3189de968de9c6268dbb86c67b378c1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_gnosis.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
0xf5e270c0d97f88efb023a161b9fcc5d0c7ad0b70	false	51200	0	0x96c4793f6909822c2cdab4bebd611f6c1b66eaca	55	512000000	0	35488389	0x96c4793f6909822c2cdab4bebd611f6c1b66eaca	2024-08-15T02:06:40.000Z	0x16cfa4d6c3bd55bca9a48612d316c155ac59f8b0871a74c38e5bf2393967cdd5
0xf5e270c0d97f88efb023a161b9fcc5d0c7ad0b70	false	0	20971520000000000	0x96c4793f6909822c2cdab4bebd611f6c1b66eaca	231	0	209715200000000000000	35499169	0x96c4793f6909822c2cdab4bebd611f6c1b66eaca	2024-08-15T17:58:20.000Z	0x9d6f24e6e8eb1a483a7415637eef32d8031168f5ab5a7838c7bc4575ceff0e10
0xf5e270c0d97f88efb023a161b9fcc5d0c7ad0b70	false	0	51200000000000000	0x96c4793f6909822c2cdab4bebd611f6c1b66eaca	44	0	512000000000000000000	35494991	0x96c4793f6909822c2cdab4bebd611f6c1b66eaca	2024-08-15T11:50:55.000Z	0xaae13851383a8f1b4b79a64dd7d460263d7b50176394aa13a1e4b3e002832cb2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_gnosis.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
0xf5e270c0d97f88efb023a161b9fcc5d0c7ad0b70	false	0xab235da7f52d35fb4551afba11bfb56e18774a65	21620818829041	0xab235da7f52d35fb4551afba11bfb56e18774a65	10	10200	11414288832165776	28191272	276313	276333	2023-05-29T19:59:05.000Z	0x8029c934b69ab1ea26e13fb2ae373b4d36278b968cbcd442dd03b5bcfdf602c8
0xf5e270c0d97f88efb023a161b9fcc5d0c7ad0b70	false	0xab235da7f52d35fb4551afba11bfb56e18774a65	165930974920	0xab235da7f52d35fb4551afba11bfb56e18774a65	6	10800	0	28191933	317104	330968	2023-05-29T20:58:55.000Z	0x54ef949e1bb1dea5f881a0f9a0bba0c3bf6d456e691669031c5ebd81e2ab8c3b
0xe9ee62b3387cba7ed143e8645e5c26232a5a6337	false	0xab235da7f52d35fb4551afba11bfb56e18774a65	1550509317418229850	0xab235da7f52d35fb4551afba11bfb56e18774a65	84	600678834832036641	1587999999999999998	30145930	-138180	10620	2023-09-25T09:49:25.000Z	0xc9f281b1c859f2c2bbaf82e70093584c203f95b434371af88dbae3cecab36e3f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_gnosis.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
0xa637e131cbe1bc2af9388559e18aa6ed4425828e	false	100	38378787	2025-02-03T20:42:30.000Z	0x27aee346072ffb0a72cf82a518443917c53f9c646c7ca107805d50f3d231d7ba	4	4
0x5c045392502c0b371f52386e8ce31829218bdf14	false	98	38378787	2025-02-03T20:42:30.000Z	0x27aee346072ffb0a72cf82a518443917c53f9c646c7ca107805d50f3d231d7ba	4	4
0x39c3dee55e7cfb678e53402b9596acdb3f3baa05	false	97	38378787	2025-02-03T20:42:30.000Z	0x27aee346072ffb0a72cf82a518443917c53f9c646c7ca107805d50f3d231d7ba	4	4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_gnosis.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
0x5447d85ecbe719ca98f62bc356f3c77bc4a48c90	-10	false	0x6cd74fe6114620e7be7c80a22c9669d7e208c0c7	30	-2002090	2000000	29574341	12164437858	0x6cd74fe6114620e7be7c80a22c9669d7e208c0c7	2023-08-21T15:55:20.000Z	79189347721084630349634158814	0xb2dbddd40b68abd71302ebf9c106296939b2c9739390f7a999475cd71568be66
0x5447d85ecbe719ca98f62bc356f3c77bc4a48c90	-7	false	0x6cd74fe6114620e7be7c80a22c9669d7e208c0c7	31	-2001431	2000000	29574838	12164437858	0x6cd74fe6114620e7be7c80a22c9669d7e208c0c7	2023-08-21T16:37:45.000Z	79202372612267072182970504440	0x47aab446691ae8d86dc499d4fb65a0968e0350815ff6762120355e8f22d00607
0x5447d85ecbe719ca98f62bc356f3c77bc4a48c90	-8	false	0x6cd74fe6114620e7be7c80a22c9669d7e208c0c7	6	-4004075	4000000	29569161	12164437858	0x6cd74fe6114620e7be7c80a22c9669d7e208c0c7	2023-08-21T08:26:35.000Z	79196896959674384799181705461	0x316aea3d9c57a55627c0f50b17766f1367bb0d025d005538e61c68409dd092d6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_gnosis.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
3000	0xf78031cbca409f2fb6876bdfdbc1b2df24cf9bef	0x2aca1e3c378551363ed055e66612fc66259e49f3	false	0x4b1e2c2762667331bc91648052f646d1b0d35984	0x4ecaba5870353805a9f068101a40e0f32ed605c6	22	28444961	60	2023-06-14T05:30:25.000Z	0x8e47b22ed5875f6b2396ce8a24455ca532a874b8ffe28f2f00bf6f161c72aa82
10000	0xf78031cbca409f2fb6876bdfdbc1b2df24cf9bef	0x5fa192d5c3ee926e04489322631d4a1e554bf3a6	false	0x4b1e2c2762667331bc91648052f646d1b0d35984	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	57	28489251	200	2023-06-16T21:55:30.000Z	0xca094f83a27520d523d71e6fb22c0621926afc2bc6dafcc04550fa0c226d335a
100	0xf78031cbca409f2fb6876bdfdbc1b2df24cf9bef	0x114e7384d5b650489944c83fcd1e90ab02c454b5	false	0xcb444e90d8198415266c6a2724b7900fb12fc56e	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	21	29453640	1	2023-08-14T07:39:35.000Z	0x05ff031b4862b8283d3a8550737d28587f65fe670e260790ae261be5cf52d93d

Example Query

Query with partition filter

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