sushiswap_v3_optimism

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	0x9c6522117e2ed1fe5bdb72bb0ed5e3f2bde7dbe0	0x3ce165db549ba82770df195d1562e6ab9ae69795	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	0x7f5c764cbc14f9669b88837ca1490cca17c31607	17	109494282	60	2023-09-13T06:42:21.000Z	0x52d822b145d1104ee9ae47e88fe49ae65c353e4d74d5f44e82acdcf8febe83a5
500	0x9c6522117e2ed1fe5bdb72bb0ed5e3f2bde7dbe0	0xb81ddd9a8eaa2460647018839a1c6e76e6361b51	false	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	2	106187549	10	2023-06-28T17:37:55.000Z	0x366396b17bc49759261517307fa060e144a4903bf95bd3d5e17e6881fc8fc018
500	0x9c6522117e2ed1fe5bdb72bb0ed5e3f2bde7dbe0	0xd20d8bd49b8b48c0631649de5f1607295c85cdf5	false	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	58	106187510	10	2023-06-28T17:36:37.000Z	0x0e0f55e2105e88362ee3064b5fcfe1c2bfd6c15bcb6a29d8f88f62d3de2e990c

Example Query

Query with partition filter

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

MiniChef_Harvest_event

Reward claims from MiniChef staking contracts emitted when users harvest accumulated incentive tokens. Contains pool identifier, user address, and harvested token amount for tracking yield farming rewards across liquidity mining programs.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_pid`	`STRING`	Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_pid	address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0	0xb25157bf349295a7cd31d1751973f426182070d6	0x31040cf47f1ddbb6f4fff492ae9a6e66e7a031e5	false	0	13	114481417	2024-01-06T17:20:11.000Z	0x5759e9dfcb7f4df7d295d12441dc061ff6c9ebde273a37966283ea1c84e70e58
4	0xb25157bf349295a7cd31d1751973f426182070d6	0x75f6a1dd1d6ab72566d400273ff65d38bf7ffd9c	false	0	3	100491440	2023-05-22T14:05:48.000Z	0x2880ed350f0e7664873f6671cfd968408a2e16c9767098ac86c615f73ef594c5
0	0xb25157bf349295a7cd31d1751973f426182070d6	0x8eee675ec0e14643ef9f9a6f714daf30593469ed	false	165061648480700472713	5	100496424	2023-05-22T14:24:37.000Z	0xf5244b1b44130cc45bddc6261937425a0331056dddb2c7b1d7f132550cb22cad

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_optimism.MiniChef_Harvest_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	log_index	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x58b2f113244ddc9332c46af25bc223873e68ff3d	false	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	43	112780317	68700	72300	2023-11-28T08:16:51.000Z	0xa532ef4db44d255e33120ab373e6eddce1da6eb4b7c2ec9d28d93c924b65906d
0x8b3c4271440bc98a085eb6b348243ed3679751a4	false	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	145	112794203	-200580	-199680	2023-11-28T15:59:43.000Z	0x2f9f8b6ffd9a96babeeccaaccef99a4cd836c185b0c02629af3f085a8e33cb07
0x8b3c4271440bc98a085eb6b348243ed3679751a4	false	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	3	112808404	-207000	-196260	2023-11-28T23:53:05.000Z	0xf1c3b9cd9fce6dfeaef3a3c3399a230b25023a50fb4a6c4f39e04acb1c53cbf8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_optimism.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
0x58b2f113244ddc9332c46af25bc223873e68ff3d	false	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	12	1346390458095305151	1173712183225667450948	111330318	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	69000	75960	2023-10-25T18:43:33.000Z	0x8d883da76a296a08df9de8c9004aba095b8760f6c9e5f05c0de35526ddcaea9c
0x8b3c4271440bc98a085eb6b348243ed3679751a4	false	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	17	88596458302658712	172027547	111336659	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	-202740	-200220	2023-10-25T22:14:55.000Z	0x4a4de22e98e370673560a173874710ea990b3789ca4e0944adbc2e24d4431468
0x8b3c4271440bc98a085eb6b348243ed3679751a4	false	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	143	89591604109376903	164464285	111313806	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	-202860	-200160	2023-10-25T09:33:09.000Z	0x7ef5fefdd78b95b5d8b08a24dcc19830ca9f291d5d0b645a8dcaa9a88d953aec

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_optimism.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
0x28d6f3f5f8f1bc5040e5f46865a376992dfb9fc8	false	0xcd03e2e276f6eedd424d41314437531f665187b9	292	10767	13078989	143941631	0xdbeca8fb948c42634256609bce5a3768c9b3e9eb	2025-11-18T16:07:19.000Z	0x4a448b9613222a83ebb0e2c7987ceee6f0a2e2656f60cf601742ff4ec507e32e
0x28d6f3f5f8f1bc5040e5f46865a376992dfb9fc8	false	0xcd03e2e276f6eedd424d41314437531f665187b9	69	25251	15964816	143920083	0xdbeca8fb948c42634256609bce5a3768c9b3e9eb	2025-11-18T04:09:03.000Z	0x174b2154104f1cff6895f43f382edefaf24fc868b0ca503e2f8801d31c5bba17
0x689a850f62b41d89b5e5c3465cd291374b215813	false	0xcd03e2e276f6eedd424d41314437531f665187b9	72	6530477792652364	23351	143920083	0xdbeca8fb948c42634256609bce5a3768c9b3e9eb	2025-11-18T04:09:03.000Z	0x174b2154104f1cff6895f43f382edefaf24fc868b0ca503e2f8801d31c5bba17

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_optimism.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_sender	log_index	in_amount0	block_number	in_recipient	block_timestamp	transaction_hash
0xe2b25295192f9bb6990393b4136047a6dce774ac	false	290065573164	0x7bf845dc4717b2c1e1f90bdb9833539b0639fca0	11	2900655731638272	124317074	0x7bf845dc4717b2c1e1f90bdb9833539b0639fca0	2024-08-21T09:35:25.000Z	0x5e78b1f526443e9ca421f373322335e89f56f388749f29e7787980b1e793688e
0xe2b25295192f9bb6990393b4136047a6dce774ac	false	32445121115	0x7bf845dc4717b2c1e1f90bdb9833539b0639fca0	8	324451211149312	124315405	0x7bf845dc4717b2c1e1f90bdb9833539b0639fca0	2024-08-21T08:39:47.000Z	0xdaeefa9ca2cb61ef4d426dd32fd98e862f285d41662ec3e9383ccb9720ad045c
0xe2b25295192f9bb6990393b4136047a6dce774ac	false	204363103871	0xdd8eb3f4735d0e898171326efed1e2f978a2b745	22	2043631038701610	123660738	0xdd8eb3f4735d0e898171326efed1e2f978a2b745	2024-08-06T04:57:33.000Z	0xc22726b559f91aed52c286c07a560b7962984623c9abc3252151243faa52328d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_optimism.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
0x2cfef48a147eff929a5525c9eb507d7f6ead270f	false	0xf0d27de0b2a55e06359426075ed05033dc363319	6662557404764597	0xf0d27de0b2a55e06359426075ed05033dc363319	22	29359568	30466121804697488696	108217030	276240	276420	2023-08-14T17:07:17.000Z	0xcaeea6eb96beb08a6b529a1cb025a9fcdd30d8d127f5a82d28c9c6918b8ea6bf
0x58b2f113244ddc9332c46af25bc223873e68ff3d	false	0xa53aaf9ae5d872675c99b20a9146ae2018d23dcc	4591101261919526909375	0xa53aaf9ae5d872675c99b20a9146ae2018d23dcc	32	7395009300747619080	19675921037041722519818	108222339	68400	72180	2023-08-14T20:04:15.000Z	0xe62d7152bb6e5992007c94334beaeca346b18b72e54382bd56633956c6e27d3f
0x921087d13798b5c29356ccf31d0225373e29731e	false	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	47807462303439762827	0x1af415a1eba07a4986a52b6f2e7de7003d82231e	26	382509090745501	99999999999999883575981	108213944	87000	154000	2023-08-14T15:24:25.000Z	0x21fc5c73ed1c087fcb62ad922348d1297a9cce1b795f3a4990747dbc33e113c1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_optimism.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
0xf4f03abc1211008214953150e428e9a3f7538607	false	76	138548957	2025-07-16T20:11:31.000Z	0x69d1de986a51d5b0600116bf184d984b76e8d97fb47a24d3dfac288312b19741	4	4
0x407fba59a5ba55edf9bfa51aaae1c839a77b24da	false	74	138548957	2025-07-16T20:11:31.000Z	0x69d1de986a51d5b0600116bf184d984b76e8d97fb47a24d3dfac288312b19741	4	4
0xb3d2c04c7d0c9044350de5109af7bd783e8efbe1	false	75	138548957	2025-07-16T20:11:31.000Z	0x69d1de986a51d5b0600116bf184d984b76e8d97fb47a24d3dfac288312b19741	4	4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_optimism.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
0x79e11ef350d7c73925f8d0037c2dd1b8ced41533	-201095	false	0x4fab1b3b53bcd1273932c2240a3019309d9fa420	4	196622103026864704	-365218483	93883574	1748475269919022	0x47029bc8f5cbe3b464004e87ef9c9419a48018cd	2023-04-24T14:42:57.000Z	3407189108217696879452633	0x576d3fc32f20a0a844d3157c2a1c1f13e35c4e82ecfc39bf077c804935c88847
0x79e11ef350d7c73925f8d0037c2dd1b8ced41533	-201197	false	0x4fab1b3b53bcd1273932c2240a3019309d9fa420	4	209746391928806496	-385724324	93904585	1748475269919022	0x9056eb7ca982a5dd65a584189994e6a27318067d	2023-04-24T16:50:31.000Z	3389710891621677652244866	0x685047a57613ec72f3d02a4cc4afbb23757c15d03384a49f4477d29cded9c0d3
0x79e11ef350d7c73925f8d0037c2dd1b8ced41533	-200899	false	0x4fab1b3b53bcd1273932c2240a3019309d9fa420	10	-162730314752986352	305821411	93684017	1748475269919022	0x4fab1b3b53bcd1273932c2240a3019309d9fa420	2023-04-24T01:18:35.000Z	3440698305244842544052362	0xd5af2f20ba4dcb743ef7a0e75a9d2a070d144b149728b09972db685b35ed1754

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_optimism.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
10000	0x9c6522117e2ed1fe5bdb72bb0ed5e3f2bde7dbe0	0x945b196763c76dd7a8b21a765c93afae109b7e43	false	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	0	97472237	200	2023-05-11T15:53:16.000Z	0x6eb5f0d3537378153e973a494c882b04acc9f84d61be49d017c44f9a69b0887a
3000	0x9c6522117e2ed1fe5bdb72bb0ed5e3f2bde7dbe0	0x3c7638904ccab972453694779d7c2b954eed69a2	false	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	0	100158838	60	2023-05-21T09:16:30.000Z	0x36cbc3f74fe0d7256277609398becfef6b95aa48282a0aabd0ea5676414f988c
3000	0x9c6522117e2ed1fe5bdb72bb0ed5e3f2bde7dbe0	0x65ce6275bfe4f1596c86a06ce6201d6648d02e65	false	0x4200000000000000000000000000000000000006	0x76fb31fb4af56892a25e32cfc43de717950c9278	15	115032686	60	2024-01-19T11:35:49.000Z	0xe894fcb3d9e9bbb1671ece8e8fc111ed921b67bbd940fad171b1cc7ccc8e2e79

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

MiniChef_Harvest_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

​MiniChef_Harvest_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

MiniChef_Harvest_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