sushiswap_v3_ethereum

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	0xbaceb8ec6b9355dfc0269c18bac9d6e2bdc29c4f	0xda6aa607a2a51f25bcbdf98c0923be28d96c42d3	false	0x50327c6c5a14dcade707abad2e27eb517df87ab5	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	206	17511182	60	2023-06-19T03:40:59.000Z	0x090f7bd075ae995433216acc37efb6662c2208f0a99b12cdd59be6fc643d9414
100	0xbaceb8ec6b9355dfc0269c18bac9d6e2bdc29c4f	0x84b2f2d7e1577d6eebbb2239157cd2d644959ba3	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	512	17521759	1	2023-06-20T15:20:11.000Z	0x158d23629879741b905c116b1c6f8c5f0045c5dd8617f980978bd28921a97f10
3000	0xbaceb8ec6b9355dfc0269c18bac9d6e2bdc29c4f	0x622933c7c880392fac548d7bb994ec826043adc4	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xcaef937ac9a63668460efb0ea92b109bba2fc1ed	257	18423507	60	2023-10-24T23:51:35.000Z	0x82bf4a78e99d09f902ba2a1b7b5b7a8b88458220da86af22e6392cd45ae41037

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_ethereum.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
0xf954d40c0c18e707c69318a9e3bd6230d4d56a11	false	0x2214a42d8e2a1d20635c2cb0664422c528b6a432	1409436416293403252	361	9458975207970282861	210013343718263026	17657828	-887220	887220	2023-07-09T18:07:59.000Z	0xe82585868a0f50a0644c85c171bd79b047aa644efc06de99bd0b6f68695832ee
0x87c7056bbe6084f03304196be51c6b90b6d85aa2	false	0x2214a42d8e2a1d20635c2cb0664422c528b6a432	69940511734157344646494	146	398923470504326744508311	14811848171651549038	17652550	-80040	-77580	2023-07-09T00:18:11.000Z	0x460034841d05f8273df616ac882ab159bed736cbf98489b02226c88082b58900
0xb3ccf99930023e800b2d27fe3ff15f1db01d51ce	false	0x2214a42d8e2a1d20635c2cb0664422c528b6a432	15261354357921265285	158	377274012780953022	593364314522033541640	17658556	-184260	138180	2023-07-09T20:35:47.000Z	0xb70aca5ae0678252a73bfb58fb5486b8ec8b724868667ce9b3bbb714933b7ba8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_ethereum.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
0xfa6e8e97ececdc36302eca534f63439b1e79487b	false	0x6b75d8af000000e20b7a7ddf000ba900b4009a80	164	152762655959	56178453192	18247477	0x6b75d8af000000e20b7a7ddf000ba900b4009a80	52	53	2023-09-30T08:57:59.000Z	0xc606a2b4dfce1ad02dcf90454e60c56d16cca5442dc4a19ac9b1300835d5014d
0x763d3b7296e7c9718ad5b058ac2692a19e5b3638	false	0x2214a42d8e2a1d20635c2cb0664422c528b6a432	185	20716126999	98282718458732616525	18246643	0x2214a42d8e2a1d20635c2cb0664422c528b6a432	194700	202920	2023-09-30T06:09:59.000Z	0x8717d8f1969c7359be9cc62129c431203d6a0830afa3977ce0cc204bf94c1f3b
0xfa6e8e97ececdc36302eca534f63439b1e79487b	false	0x2214a42d8e2a1d20635c2cb0664422c528b6a432	121	79710622	80304228	18246158	0xa626bd40a8c88f59a4cf9b1821a7bd71fad96285	-5	8	2023-09-30T04:32:47.000Z	0x01da93e39168b90ca1533d0e978e04ef9b4bacdacb834bd5a60733ea8b91e94c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_ethereum.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
0x0691f5bd1e12f483acf2e32dc922bb82f1ee7d69	false	0xcd03e2e276f6eedd424d41314437531f665187b9	1427	10773600	174281449862142410959	23651978	0xdbeca8fb948c42634256609bce5a3768c9b3e9eb	2025-10-25T04:05:47.000Z	0x99b90b585382c78c51d3f330bf184a6bfcf8778d3b8d52f14f1e29a5565313ff
0x0143b80d682d2b6fb8945f47b7d199841ab8184c	false	0xcd03e2e276f6eedd424d41314437531f665187b9	412	277209929769304076504	15747579	23784393	0xdbeca8fb948c42634256609bce5a3768c9b3e9eb	2025-11-12T16:39:47.000Z	0x38d395936cc30922319cbae7911d86bc51ea59f897f9a5a80af03f2e5c294e06
0x0143b80d682d2b6fb8945f47b7d199841ab8184c	false	0xcd03e2e276f6eedd424d41314437531f665187b9	178	323187272752243926156	16654576	23780649	0xdbeca8fb948c42634256609bce5a3768c9b3e9eb	2025-11-12T04:05:35.000Z	0x96da81a95b59ded5d86091f69193894293a455d1fe77fa63af8ea5c605e14def

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_ethereum.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
0x4bd3cf2b49ebaf57c95cc1ad8ddd83baa1126835	false	759422181979728000	0	0x2cc2eb22e945f17637ce2163999aa6bfa3cb68f5	75	75942218197972800000	0	19284030	0x2cc2eb22e945f17637ce2163999aa6bfa3cb68f5	2024-02-22T15:27:11.000Z	0x24116bffbb48a17504e1cc4d571b46b90e335eb107e1863a83d95d4283afbd0e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_ethereum.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
0xc6c57b16412e9a4e980d3c30f41b4f0dfd8845ed	false	0x2214a42d8e2a1d20635c2cb0664422c528b6a432	27469466006343742112547	0x2214a42d8e2a1d20635c2cb0664422c528b6a432	259	675741218181441737578033665	1000000000000000000	17679886	-247400	46000	2023-07-12T20:35:35.000Z	0x1456fab0b369a0bc0215997fd1736e00f07abd1e9bf709e1f2614276332ae509
0x135796322ed29933d71baa51e53b7a4bcfb5e4e6	false	0x2214a42d8e2a1d20635c2cb0664422c528b6a432	72811589668440302486	0x2214a42d8e2a1d20635c2cb0664422c528b6a432	165	99715884212526282225479	50000000000000000	18095574	-216000	-76000	2023-09-09T01:30:35.000Z	0xed6d21391e7ece77994119774c365e95a1d59ea3a474956f2db10d9d1bfdb290
0xfdfff5fba010d08138d12279bf2578a3c14df048	false	0x2214a42d8e2a1d20635c2cb0664422c528b6a432	484469127028928746	0x2214a42d8e2a1d20635c2cb0664422c528b6a432	133	17045625672252116023	13769534750856799	18099439	-887272	887272	2023-09-09T14:30:59.000Z	0xf7b242813e4b0284860645a5b6d60e1f3af83d50332cac2b05df63621a34fe4a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_ethereum.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
0xa8db21b12794747f8775359cd416311e3fd3313f	false	184	22305398	2025-04-19T20:20:35.000Z	0x4009e9f827cfae095a59dd195150f1f49610834d5b80d7d34620b6edf32e0523	4	4
0x0ccb04d2a8b412b5a43df351ae6c5792b513b007	false	178	22305398	2025-04-19T20:20:35.000Z	0x4009e9f827cfae095a59dd195150f1f49610834d5b80d7d34620b6edf32e0523	4	4
0x7503f92ae26cfd8b260b9dcd5e0306af36190a68	false	183	22305398	2025-04-19T20:20:35.000Z	0x4009e9f827cfae095a59dd195150f1f49610834d5b80d7d34620b6edf32e0523	4	4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_ethereum.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
0xfa6e8e97ececdc36302eca534f63439b1e79487b	-51	false	0x827179dd56d07a7eea32e3873493835da2866976	61	19978751120	-19920056430	17627271	8382761854631	0xe139ab520c71c6dd7df0af0015c2773002742c0c	2023-07-05T11:05:59.000Z	79026398149359397117663291959	0xcd387b9203b8c3d72b9d85345ec20533b276535202fb0444f3a59574b585ee62
0xfa6e8e97ececdc36302eca534f63439b1e79487b	-14	false	0x6b75d8af000000e20b7a7ddf000ba900b4009a80	36	79341924033	-79286189728	17627271	61880184427580	0x6b75d8af000000e20b7a7ddf000ba900b4009a80	2023-07-05T11:05:59.000Z	79174984918620373167854839631	0xa664035d096e26507062b003f6e4e129bfa6a44571446b909de14d2bc7ea406a
0xfa6e8e97ececdc36302eca534f63439b1e79487b	-3	false	0x6b75d8af000000e20b7a7ddf000ba900b4009a80	27	-1872626116	1872395516	17629204	149107265370019	0x3fa5db0910afc2a1e6de45039ea217410fb8641d	2023-07-05T17:35:59.000Z	79219820311915643023565405109	0x00d71494a3e78cdb859ff3f5ed9d2f261f8a343c3fa14fed38911558dc2f8ae2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_ethereum.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	0xbaceb8ec6b9355dfc0269c18bac9d6e2bdc29c4f	0xf1cac03319873169012621ef545fa33090217516	false	0x5a1de1f27beb27c9fe4e0ecbf2fe4e51fff3d8d6	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	387	17958511	60	2023-08-20T21:02:35.000Z	0x0e2aa2e9cb63cd69362d3cf1ebc7c3a4cb774268dd9903eab0200c91388b6ef4
100	0xbaceb8ec6b9355dfc0269c18bac9d6e2bdc29c4f	0xfdfff5fba010d08138d12279bf2578a3c14df048	false	0x9d409a0a012cfba9b15f6d4b36ac57a46966ab9a	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	222	17337268	1	2023-05-25T16:12:59.000Z	0xe38d2b83fbf467a319c9c57fb6f48723603ad682b35b9b2cddb37b9a417dac8d
10000	0xbaceb8ec6b9355dfc0269c18bac9d6e2bdc29c4f	0x98420b1afdb2353fe5c77f20d8f541b4dbd18aec	false	0x9bf1d7d63dd7a4ce167cf4866388226eeefa702e	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	244	17335302	200	2023-05-25T09:33:59.000Z	0x27ddfb6a913f75827d3df18c70d3aa4c43c71b6646e5fcd76cabe8d173073a6a

Example Query

Query with partition filter

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