sushiswap_v3_arbitrum

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	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	0xe9ca9f5eab9aa18ee5662e5d70b7537f862d3ec1	false	0x716926017edd4d390cfed6e2d821e21d33954b9a	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0	190621355	1	2024-03-15T12:06:47.000Z	0x69719bf096a0c486c1fd3c6e1ea761e15718cbaf236cd466fdadb378190ee044
10000	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	0xd37f85f9ca30c276322d8f8cf3ee462b701c04e9	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xf28db483773e3616da91fdfa7b5d4090ac40cc59	0	186078896	200	2024-03-01T17:09:56.000Z	0xdeb2cd1be7a3891daf1e3fe50f642a9138b70264c40ce24f2ca5077ef264492d
3000	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	0x7e039fc42a52d717e79288d58742a41c7bd2b742	false	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0xf97f4df75117a78c1a5a0dbb814af92458539fb4	2	186098364	60	2024-03-01T18:33:41.000Z	0x343b85450a45b35f268e5208fe8c2e199adf46ffb03a177dd39546ca60b8adad

Example Query

Query with partition filter

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

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
0x00043186a1f34aea3bbf254e90530c9fb7fbb8c3	false	0x3a690c8b9f821150c2cc5e47ee74a74dda0e3bf5	2297159039158	1	205017274591725561598	25738	265521086	-753600	134000	2024-10-19T17:59:30.000Z	0x7c7ee86d3fa19a17341e495c20b797b3588a2aa2022a28dcd67e2304bc114c05
0x1048dbc1f7737a6680ff2819b0a3b7df4c1402b2	false	0xf0cbce1942a68beb3d1b73f0dd86c8dcc363ef49	0	25	0	0	265418883	484	498	2024-10-19T10:52:01.000Z	0x11c25e0369f74dbd0b91e5e66ce78347fdaf48c41aee526589445fc164642f09
0x1048dbc1f7737a6680ff2819b0a3b7df4c1402b2	false	0xf0cbce1942a68beb3d1b73f0dd86c8dcc363ef49	0	8	0	0	265444910	485	495	2024-10-19T12:40:51.000Z	0x13854450beb76ca20a78010fee9e4c33de90d68527270c812d3aaf2275909498

Example Query

Query with partition filter

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

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
0x15e444da5b343c5a0931f5d3e85d158d1efc3d40	false	0x01476fcca94502267008119b83cea234dc3fa7d7	4	3222914870858969187	1343801506	159662476	0x01476fcca94502267008119b83cea234dc3fa7d7	-199710	-198030	2023-12-13T09:12:49.000Z	0x6be324581c04e6955d7454b05eabfdd3dc169872694ec59d626d9df9ce602106
0x15e444da5b343c5a0931f5d3e85d158d1efc3d40	false	0x60b32fd699623ead58ae911660012dc3475ba0a7	34	4021799532	6	159719432	0x60b32fd699623ead58ae911660012dc3475ba0a7	-201210	-196820	2023-12-13T13:17:57.000Z	0xc1cf26c8012469c4551831ea019b8de8a3faac6568682df40f0b0d0acdaf00b5
0x15e444da5b343c5a0931f5d3e85d158d1efc3d40	false	0x61c4daa8f7009cc39b3e7a9b8bd722413c29e676	20	32940799999690579669	0	159595158	0x61c4daa8f7009cc39b3e7a9b8bd722413c29e676	-199510	-198770	2023-12-13T04:15:25.000Z	0x0132cbcd1b995b10011c524777c00997283d10ff308173e4c048f9d579f29a3c

Example Query

Query with partition filter

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

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
0xe6ea93ba4ae9ee6520e55affebbdb38ed6c233a4	false	0xcd03e2e276f6eedd424d41314437531f665187b9	22	3188331547117314024043	17443846	274267295	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2024-11-14T04:41:43.000Z	0x0a401537504c010f9700540284f6172dbf2754efaaed04bea89cda98cbe1c543
0xcda3b7bec56dbb562453231f142f63d3b00f8eb3	false	0xcd03e2e276f6eedd424d41314437531f665187b9	10	22483916	23183137	274267295	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2024-11-14T04:41:43.000Z	0x0a401537504c010f9700540284f6172dbf2754efaaed04bea89cda98cbe1c543
0xf3eb87c1f6020982173c908e7eb31aa66c1f0296	false	0xcd03e2e276f6eedd424d41314437531f665187b9	34	1515429252480198381	4663205364	274267295	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2024-11-14T04:41:43.000Z	0x0a401537504c010f9700540284f6172dbf2754efaaed04bea89cda98cbe1c543

Example Query

Query with partition filter

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

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
0x99543bf98ca1830aa20d3eb12c1b9962f8eadc11	false	0	28231409330126156	0xf238d4353246948ecdc3f3252ae939fe5234e145	12	0	56434587250922185000	248421525	0xf238d4353246948ecdc3f3252ae939fe5234e145	2024-08-30T22:24:42.000Z	0x9a96bbb1009f2c697bbf68a43089d28bbfab29916588a4bac69731a812736b3c
0xf3eb87c1f6020982173c908e7eb31aa66c1f0296	false	149086155016	0	0xf238d4353246948ecdc3f3252ae939fe5234e145	15	298023223876953	0	287250487	0xf238d4353246948ecdc3f3252ae939fe5234e145	2024-12-22T00:28:48.000Z	0x4102369e934c6242e7b3a0bfd44c0ed045d8dc500c606fac8bb70deb17080c7c
0xf3eb87c1f6020982173c908e7eb31aa66c1f0296	false	2027571708218	0	0xf238d4353246948ecdc3f3252ae939fe5234e145	33	4053115844726562	0	287511999	0xf238d4353246948ecdc3f3252ae939fe5234e145	2024-12-22T18:41:28.000Z	0xe6b4397b5da71ea5602d665c7780920c58f8bf42ac833c2eab4c7d1b3059ec60

Example Query

Query with partition filter

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

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
0x15e444da5b343c5a0931f5d3e85d158d1efc3d40	false	0x01476fcca94502267008119b83cea234dc3fa7d7	7225628944003456	0x01476fcca94502267008119b83cea234dc3fa7d7	12	4719461498213788766	1897123110	117078290	-201320	-200630	2023-08-01T11:59:45.000Z	0xac4d20566530157ff997c091a6d64176cd8afa1e432aa19235cd6d8634868219
0x15e444da5b343c5a0931f5d3e85d158d1efc3d40	false	0xd4b32d9c5bf600f55c84ff110347546ee546e39b	472349047989	0xd4b32d9c5bf600f55c84ff110347546ee546e39b	8	267426318675520	508350	116999144	-201710	-200710	2023-08-01T06:25:35.000Z	0x7091732a3ee13b8d3d9def8669eeccc0b5084ac1a99090350c3e48ed775c147e
0x15e444da5b343c5a0931f5d3e85d158d1efc3d40	false	0xf0cbce1942a68beb3d1b73f0dd86c8dcc363ef49	618868767287770	0xf0cbce1942a68beb3d1b73f0dd86c8dcc363ef49	4	41726517752200912	69033135	117025906	-201230	-201120	2023-08-01T08:18:23.000Z	0x963c7746fcce676a3e6ba60f0a7a19f1fd6db2910a939b84a26bbe2126e9bc00

Example Query

Query with partition filter

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

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
0x31e11707e2816228a88626bcf96445568d5351f4	false	4	283061129	2024-12-09T18:37:53.000Z	0x61b2a4732c15f5d0c17be5d20daf066467451fec6ce5939861293a38017017b0	4	4
0x066323494b7cba715ecddfeaf68b082d83eff5d6	false	1	283061129	2024-12-09T18:37:53.000Z	0x61b2a4732c15f5d0c17be5d20daf066467451fec6ce5939861293a38017017b0	4	4
0xec9d135a8d404cbc528f8a92115b9d67e26cf6ea	false	8	283061129	2024-12-09T18:37:53.000Z	0x61b2a4732c15f5d0c17be5d20daf066467451fec6ce5939861293a38017017b0	4	4

Example Query

Query with partition filter

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

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
0xcda3b7bec56dbb562453231f142f63d3b00f8eb3	19	false	0xfc506aaa1340b4dedffd88be278bee058952d674	13	-52032	52162	100081535	111462036419	0x50bbe17bda4440b8bd02a2bf9cc80143fe2f3c0c	2023-06-11T14:08:24.000Z	79306199163264226323892791594	0xa7c4fe66030727b453c81e3e631e8d29d9e2ece3cfa08a102e80fda758288b39
0xcda3b7bec56dbb562453231f142f63d3b00f8eb3	-2	false	0xfc506aaa1340b4dedffd88be278bee058952d674	3	81000000	-81003624	99989294	111462036419	0x7dd7c3366c8415c5cef494b707c45cc1e3b57e9e	2023-06-11T07:44:15.000Z	79220966904948157680886206801	0x9d6b39fc5d8d87a58253fbe50c7c5d42924fdef175c95723acf793d69203f0d1
0xcda3b7bec56dbb562453231f142f63d3b00f8eb3	12	false	0xfc506aaa1340b4dedffd88be278bee058952d674	25	-39866862	39923344	99986444	111462036419	0x7dd7c3366c8415c5cef494b707c45cc1e3b57e9e	2023-06-11T07:32:21.000Z	79278625430760862256004808689	0xd3e5c1e9c13014571f64089fe7344ca7d5e1fe37c98f46108a1a17366b8df1a9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_arbitrum.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	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	0x675229d22e57549911a5847b210a5bcedc1ae12f	false	0x912ce59144191c1204e64559fe8253a0e49e6548	0xe3cc16144feb3fc00a23803568986ffa6585c96e	1	107912293	60	2023-07-04T21:12:26.000Z	0xb3dd67f775f5fd652797d55064707a5deef16c29ea2f6562357eebc62c05b1b2
3000	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	0xcd915286ed3c98a5b3d49f61c2845ab5b8038800	false	0x60b42e0de164d18fe6822c115daf2e0f18867ae7	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0	124922592	60	2023-08-25T19:30:24.000Z	0xb3762e306d58c0344362cecada32b2c730f3912268853f4c8c9fe8beb892b55d
3000	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	0xb2f78049914692f210fa930e77930a624a459c12	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x8f14c3bc1e51bad62006ebbe2801f124fe781dd5	8	124777203	60	2023-08-25T09:19:15.000Z	0xcf07620a081e420205e69335f80cb69cce75daacd5db23a378736711eba593d3

Example Query

Query with partition filter

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