sushiswap_v3_fantom

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	block_number	in_tickSpacing	block_timestamp	transaction_hash
10000	0x7770978eed668a3ba661d51a773d3a992fc9ddcb	0xeeb2b1c50a18abed97aab64012b2dbfab44a96c4	false	0x6b4c0b19bf0dfeb102d5fd702af1f1fb4063664a	0x74b23882a30290451a17c44f4f05243b6b58c76d	65419413	200	2023-07-09T07:10:21.000Z	0xce24f96f3b5627150a9b8ee1fb452450e89fe2b2e818415e6bbe75859c9304db
10000	0x7770978eed668a3ba661d51a773d3a992fc9ddcb	0x11e637f5b41115a63dcca46db40ca012e5a427f8	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0xee8eaec73babe18568b07eab1c882d647441ddad	65418786	200	2023-07-09T06:54:30.000Z	0x2a0c30a32fe308c42cca0617290f427e58459b85b4eeeb204d764e5bda7baa68
10000	0x7770978eed668a3ba661d51a773d3a992fc9ddcb	0xee49d9caa34ef1089981f81c20e6ec690c62ab09	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0xa03fdc5bfccab61d4f419f0df03f311c0e36d7e4	65418976	200	2023-07-09T06:59:26.000Z	0x4e27094ec57699247be216c334abe9ce6cc37cd7262c73604c05766c09a9221c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_fantom.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
0x5fc14f7b1ae82f209429b271209692a49279e515	false	0x10c19390e1ac2fd6d0c3643a2320b0aba38e5baa	29139991555368210086266	9	4678419254273369066834	4143750921630706059770	65260531	-32000	-20200	2023-07-07T04:09:39.000Z	0xa7eb5ee7f8780e4944b0c337caa3bbdd06e2815a8cdb814101cc808a0c4bd0b6
0xee378f50d3f81b03168293c5aa2171002202774c	false	0x10c19390e1ac2fd6d0c3643a2320b0aba38e5baa	54805662203264700025523618	32	1822170517007207005336685084	11924224256553588346983	65268150	-124400	-120800	2023-07-07T06:17:35.000Z	0xb998670d6c999101ed6dc086e46fa7018095571ca870dbb9e38160ef9e6501d7
0x20289a7c3dcde76d7d1720fe35654006e2cc5c57	false	0x10c19390e1ac2fd6d0c3643a2320b0aba38e5baa	13142569518687978024085	0	13321758216836688811879	634012477728429906561	65268180	-34020	-24000	2023-07-07T06:17:59.000Z	0xc29255891bdf5e9d6c5691ebcd820cf7305f6974403ccd72583e1bc6a9c3bca2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_fantom.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
0x944f2bc8250ed258782da74feb747ff3413d76ad	false	0x10c19390e1ac2fd6d0c3643a2320b0aba38e5baa	38	68106184917378991895	1940069070475747363902697713	68209423	0xc3755c50ef8f5408fd8f22be53743ecff2d2b444	163400	179200	2023-09-15T13:18:50.000Z	0xc4d0fa4ebb0988d9f2f723bf935d111c2efe2749107e34c2512ce46d188827d5
0xb3b31b6568503fc84c548443230d10b03fa8ec89	false	0x10c19390e1ac2fd6d0c3643a2320b0aba38e5baa	44	1951163451061990730	5721279689770406740	66338195	0x10c19390e1ac2fd6d0c3643a2320b0aba38e5baa	-23000	23000	2023-07-27T01:58:56.000Z	0x5918f791f4a77d56fcbaad96f7cca54ed584632a27daac34ec3ea14ecc1137c8
0x19951794d5974c82f293c868f91e747c9943342c	false	0x10c19390e1ac2fd6d0c3643a2320b0aba38e5baa	8	32996005	79643978866595857619	66986790	0xdd76696d5bf57b53e177b477127724ab67e20534	-887272	887272	2023-08-14T20:09:08.000Z	0x2aa698ca8af1a4d460811ee8ca1c92aea3e945e83c4643338b6c1e12b6bfa650

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_fantom.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
0x9a7a00acd9289ce7668976418ff11cbe44b9d004	false	0xcd03e2e276f6eedd424d41314437531f665187b9	2	213138141364209039	184695317712888739	102702563	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2025-01-15T00:06:43.000Z	0x1246d1ee6dfd79ac22642ddc2f37764cddfadc8b697647156f2329e6c5f73c5b
0xe471424bf8bba2aa936df8e63485ebe22d81e400	false	0xcd03e2e276f6eedd424d41314437531f665187b9	5	122967914465714105	95030	102702563	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2025-01-15T00:06:43.000Z	0x1246d1ee6dfd79ac22642ddc2f37764cddfadc8b697647156f2329e6c5f73c5b
0xdb60b823a3bc60b9e59136511b7535facef2eab4	false	0xcd03e2e276f6eedd424d41314437531f665187b9	17	70503897126370293464	10133474552291521732	99599415	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2024-12-09T18:58:19.000Z	0xd0a6aabe3598b6cb98e6c8c0a143cc2e0ee5fc6861cce8f449f85efde03e19c0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_fantom.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
0x689ee85b4f4ceb7fc83c31131fcd40b1d8e7ae0e	false	25321893781283145111	0x375f1f2ed586f2ade1b90c796bfcdb52d69d604f	17	2532189378128314511058	84175032	0x375f1f2ed586f2ade1b90c796bfcdb52d69d604f	2024-07-01T09:39:25.000Z	0x08cceb5761ee8e6be821325a349d7fcc2e575873a0f13ff78e294aa6e41cdfd2
0x689ee85b4f4ceb7fc83c31131fcd40b1d8e7ae0e	false	25252524255405815610	0x375f1f2ed586f2ade1b90c796bfcdb52d69d604f	43	2525252425540581560971	89654083	0x375f1f2ed586f2ade1b90c796bfcdb52d69d604f	2024-08-22T18:44:45.000Z	0x143439e481db50f836e0945c2e2fe8898f419e7b6f56474b755806f6b634d3c1
0x689ee85b4f4ceb7fc83c31131fcd40b1d8e7ae0e	false	20874434026088430150	0x375f1f2ed586f2ade1b90c796bfcdb52d69d604f	9	2087443402608843014969	89653816	0x375f1f2ed586f2ade1b90c796bfcdb52d69d604f	2024-08-22T18:40:16.000Z	0xa2579109d22438bf3e534c1d1c1e85217bf3d25f4e00381256d42dedf46f177d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_fantom.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
0x08d9e6174eb841953db867a04b40c42277eda685	false	0x10c19390e1ac2fd6d0c3643a2320b0aba38e5baa	44246610356958527198381	0x10c19390e1ac2fd6d0c3643a2320b0aba38e5baa	4	1626626123196113541	500000000000074095111739899	66884851	-25000	197400	2023-08-11T22:06:06.000Z	0xc2b04d748365b505e34d70dbf0b49444bec2a7225f276505ef597ae5e19862b9
0x090ea68df581626d471e13fcc9a6a6e0d94b30b9	false	0x10c19390e1ac2fd6d0c3643a2320b0aba38e5baa	3045275700988984	0x10c19390e1ac2fd6d0c3643a2320b0aba38e5baa	3	3124221203152234265271	5218489	63506956	-344700	-342960	2023-06-03T01:04:59.000Z	0x223fe7019a1a415a297989d3212e3e7378b5b9eda3bb96c026374147881cf60d
0x3663f329d809d49c977856e2f5e8443fd03aaeb2	false	0x10c19390e1ac2fd6d0c3643a2320b0aba38e5baa	1018168352189964362850	0x10c19390e1ac2fd6d0c3643a2320b0aba38e5baa	3	2855315212347393103686	529949177534978609	63506943	-87660	-86100	2023-06-03T01:04:37.000Z	0x7b73328632f13e13cdef0fd9492f69c5020c48be3e437fdef09af3b7a4811c34

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_fantom.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
0xa9659cffd904f003e33b16e812e310e22f638436	false	6	114002578	2025-07-22T01:35:12.000Z	0x080ea04550342d85bfc5ddcaef509fe62b6a515554aec8d76159c628f2c584cd	4	4
0x0fa67b5ddd561122a98f05adfb6107a601d62139	false	3	114002578	2025-07-22T01:35:12.000Z	0x080ea04550342d85bfc5ddcaef509fe62b6a515554aec8d76159c628f2c584cd	4	4
0x27cbdb86b59bee293f1369e44e2112aea3be52ad	false	4	114002578	2025-07-22T01:35:12.000Z	0x080ea04550342d85bfc5ddcaef509fe62b6a515554aec8d76159c628f2c584cd	4	4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_fantom.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
0x37216637e92ff3fd1aece7f39eb8d71fc2545b9b	284534	false	0x3e603c14af37ebdad31709c4f848fc6ad5bec715	3	-4386	10000000000000000	59116084	30737454111104470	0x23defc2ca207e7fbd84ae43b00048fb5cb4db5b2	2023-04-05T07:40:26.000Z	119442096779179468335219165314000062	0x5b55cd2a95941de403d86c65a5226adc4d0c571e01c816b18024007807d17c05
0x37216637e92ff3fd1aece7f39eb8d71fc2545b9b	284534	false	0x3e603c14af37ebdad31709c4f848fc6ad5bec715	3	-438681	999999999999999999	59116014	30737454111104470	0x23defc2ca207e7fbd84ae43b00048fb5cb4db5b2	2023-04-05T07:39:13.000Z	119442071080734261650133559497516638	0xf37a5872ff410d80e5962083821982b559f1dd2164207f8faa81e9cc21aa855f
0x6a6a73b094bce695c08c7df81cd65644968357f9	55	false	0x2214a42d8e2a1d20635c2cb0664422c528b6a432	77	-35152050	35260716	63113897	13749455352	0x0a80c53afc6de9dfb2017781436bfe5090f4acb4	2023-05-26T10:39:30.000Z	79448203616923883422026778310	0x0651bf825dfd382bd79283d0b9fde6ceef50bc3c42505ea236a8cd3e1e49b5db

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_fantom.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	0x7770978eed668a3ba661d51a773d3a992fc9ddcb	0x69fc28f102833969449ec9ce35c2b265c62f3949	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0x82f0b8b456c1a451378467398982d4834b6829c1	0	65332722	200	2023-07-08T03:12:21.000Z	0x3a8d836841818fa52a7460c730f283ec33f6c193cb7ae5fa14675bacbabba06e
3000	0x7770978eed668a3ba661d51a773d3a992fc9ddcb	0x21ef913a4d3dc9d773d19d254c93300170c03fac	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	0	65353558	60	2023-07-08T09:58:57.000Z	0xa32558d023d7c2896e85b7f324221b59f9968f7e7c6168cdc57871373252bf1c
10000	0x7770978eed668a3ba661d51a773d3a992fc9ddcb	0x238683fa7b9dab35eb177adb0fe74a1333c93702	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	1	67909013	200	2023-09-06T13:18:11.000Z	0xa8f95d58cd7dc7cdbeba37dd8e512b427ce55229c9d364b2ba805f913be28eec

Example Query

Query with partition filter

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