sushiswap_v3_bsc

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	0x126555dd55a39328f69400d6ae4f782bd4c34abb	0xea560ca47f9f29b9c61871a5a059ed10664cdbfc	false	0x947950bcc74888a40ffa2593c5798f11fc9124c4	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	133	29339873	60	2023-06-23T01:52:30.000Z	0xf2645bd90ca04d52a162b74b2087bac2bf63cdfc3c9d1d3548374e414c52083e
10000	0x126555dd55a39328f69400d6ae4f782bd4c34abb	0xc9a924422012087bbb93438c932bae19a99bf552	false	0x1613957159e9b0ac6c80e824f7eea748a32a0ae2	0x2170ed0880ac9a755fd29b2688956bd959f933f8	145	32972349	200	2023-10-27T15:04:36.000Z	0xfd5ecc10e41039a00a2a442d41e6f0f07015ae774d74d02440f384481ec0b483
10000	0x126555dd55a39328f69400d6ae4f782bd4c34abb	0xe019ad53ecff61c2540026a972eb3f191df4071e	false	0x0cbd6fadcf8096cc9a43d90b45f65826102e3ece	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	159	28133102	200	2023-05-12T02:00:58.000Z	0x98bf69a20b1f32493ffc235fb94d887a806514a72b21a601c1e11c5d45a0934f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_bsc.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
0x6e6f1953fd057d334a8d56b76bffb45d67a7a596	false	0xf70c086618dcf2b1a461311275e00d6b722ef914	19311240512447483362	199	50463622511245528562	500559137011579085	29075587	-64920	-51000	2023-06-13T20:57:30.000Z	0xa4badc7ac7ff8615704091f23918713804294a3fd4aee44399e796749085ee4f
0xe40fe0b23ca46b6c7a883d85536857cf9fe87c21	false	0xf70c086618dcf2b1a461311275e00d6b722ef914	60136675373052	96	529611476379	5652094323530810	29078626	44220	140460	2023-06-13T23:29:42.000Z	0x04d3fade4f4703a653f87e043b1b1d2375a1608a4d783134477cb4708b87a576
0xc0e2792774b2f602f74f6056ed95ab958d253823	false	0x570057ec7dcf62bbf4fec43fcc38489b881878b8	35328289202881437815	138	61747217633283856061	638512008109090548	31049092	-59580	-50930	2023-08-21T14:38:33.000Z	0x3bfca38ee74bb4c8c366cccccf8e15bebfa0cde946f6ab5c2aa0abdc09ef579d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_bsc.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
0x69c737cfc0998c744c0965e5d24f574fff86e1a6	false	0xe6d6d551e1e575600d78dde7cd8f94c9de66d8ec	110	96905410316329440	1421152859634363859	30761987	0xe6d6d551e1e575600d78dde7cd8f94c9de66d8ec	19800	20700	2023-08-11T14:37:17.000Z	0xba51191783a098c5fca676b38cf9433b1441ca1192c55757d68472ea8c7b946f
0xc0e2792774b2f602f74f6056ed95ab958d253823	false	0x570057ec7dcf62bbf4fec43fcc38489b881878b8	23	107434543002791352612	435128863661348071	30762183	0x570057ec7dcf62bbf4fec43fcc38489b881878b8	-57770	-51890	2023-08-11T14:47:13.000Z	0xbbf39668e6a91e5aeee84d58240d2b233efa5451edd935e5f25b1b66bb4f596c
0xc0e2792774b2f602f74f6056ed95ab958d253823	false	0xf70c086618dcf2b1a461311275e00d6b722ef914	70	0	3199999999999999	30756951	0x30000450c27d9fc2a009a8828d94ae52f674395f	-57450	-57440	2023-08-11T10:25:04.000Z	0xb76460a56eca2af0a79f6800314f67aa07f97406f167770196d397f18cb5eb5c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_bsc.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
0x038ebba96937d741391b5750bccbf18c2b673940	false	0xcd03e2e276f6eedd424d41314437531f665187b9	556	36353637427390437689	36351160562372080648	62848349	0xdbeca8fb948c42634256609bce5a3768c9b3e9eb	2025-09-29T08:41:25.000Z	0x5834d75137135a8d60fdb0544d03d7f00018111c191de079c66c2ac24b8d7208
0x13869d64ed4c7dd1c263aa92d5982cae54b85c8f	false	0xcd03e2e276f6eedd424d41314437531f665187b9	559	30736784937300440374	31017658382048579468	62848349	0xdbeca8fb948c42634256609bce5a3768c9b3e9eb	2025-09-29T08:41:25.000Z	0x5834d75137135a8d60fdb0544d03d7f00018111c191de079c66c2ac24b8d7208
0x451c311bd4c8bd2f2d48bf7282586a19084962c6	false	0xcd03e2e276f6eedd424d41314437531f665187b9	565	129392317	3045321172948613925365	62848349	0xdbeca8fb948c42634256609bce5a3768c9b3e9eb	2025-09-29T08:41:25.000Z	0x5834d75137135a8d60fdb0544d03d7f00018111c191de079c66c2ac24b8d7208

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_bsc.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
0xe019ad53ecff61c2540026a972eb3f191df4071e	false	0xe6fc0da8ab0a4fd2a9852658412470980aa7aa6c	9859707289287976670	0xe6fc0da8ab0a4fd2a9852658412470980aa7aa6c	250	54897646305607560420	200497220096900724	29757028	-86200	-63600	2023-07-07T14:32:49.000Z	0xed9a58aa21658c335e8f967f7f02e1e419d338344e11c0a9ad0e8209ba84de1a
0x69c737cfc0998c744c0965e5d24f574fff86e1a6	false	0xe6d6d551e1e575600d78dde7cd8f94c9de66d8ec	585626968703810817	0xe6d6d551e1e575600d78dde7cd8f94c9de66d8ec	21	6218239389545345	57758769836731559	29757166	20040	21360	2023-07-07T14:39:44.000Z	0xfe2eda124d3f78f07bd8639c9f287c3dd73e42d817ceb029124ea68f338f7762
0xc0e2792774b2f602f74f6056ed95ab958d253823	false	0x570057ec7dcf62bbf4fec43fcc38489b881878b8	31168361732516274862	0x570057ec7dcf62bbf4fec43fcc38489b881878b8	321	59247123648400379191	298120773484760960	29757574	-57800	-51980	2023-07-07T15:00:09.000Z	0x6c4c08e6f3beb4a5b04a2a8333beaa4be3965e69a50b6d13da3933649e6e3010

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_bsc.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
0x2db0ee9f6d3692175306839bf53d269c034937cd	false	150	42911380	2024-10-07T15:13:13.000Z	0xb84517a042ca9b2485436203816f4040f9e691dd76db0be3ab466a42af0f295d	4	4
0x474ee7ecd39189d9c46b67fc563b8fdef00058c6	false	417	65300841	2025-10-20T16:06:48.000Z	0x74fc976a1baef45348d5bd22fba58bc9f46e8575bd84ee4464fcfedb70f3182b	4	4
0xb0c85714f84fc0e0b597b18ee91f70d10b63cd4a	false	134	50938239	2025-06-05T19:22:23.000Z	0x299a88c92baef2b2443d728cda96b92a00e267f21bbc0a7460f0c300dd798e65	4	4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_bsc.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
0x4d9f3667dda86078ac4b5d80ca524c365877ffc4	-385966	false	0xaa91b76fdbbfccdf164b69e98904e9377ffe3ff7	291	-212739305194976014192096773570512	3232927884679113	29054901	5853754977081480163829856	0xaa91b76fdbbfccdf164b69e98904e9377ffe3ff7	2023-06-13T03:41:05.000Z	329727938467028087724	0x610a109e7668138bb402c4370895fe16af9bccd95e9a4a0374eb6a15f1fc5ee4
0x038ebba96937d741391b5750bccbf18c2b673940	20	false	0x400d75dab26bbc18d163aea3e83d9ea68f6c1804	1757	-3911623507696031079	3919300000000000000	29068188	17003969666809792564855	0x1c525dfce395b9f07e5d7f382b7a352cfb437f03	2023-06-13T14:47:09.000Z	79311031345071257122585888530	0xc29daf9c62bf4622c32f45570b91f930a9a7e092aaa817f0e482f8b605929ee6
0x038ebba96937d741391b5750bccbf18c2b673940	-10	false	0x400d75dab26bbc18d163aea3e83d9ea68f6c1804	229	9698336000000000000	-9693629210662109560	29057388	17003969666809792564855	0x6330805978089e3d93309694e55a6270e637c04d	2023-06-13T05:45:39.000Z	79190315457244560366681570141	0x0de00039fc2107799ce1f64a9258b4481c1c277cde0060119cffc9645f73751e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_bsc.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
500	0x126555dd55a39328f69400d6ae4f782bd4c34abb	0x13869d64ed4c7dd1c263aa92d5982cae54b85c8f	false	0x55d398326f99059ff775485246999027b3197955	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	129	28471410	10	2023-05-23T20:25:24.000Z	0x453d507c9fb09a11d35b93c85f3bec74617753590c3bdf79c29c530c9ced4ef2
3000	0x126555dd55a39328f69400d6ae4f782bd4c34abb	0xe4b826e59da0bc52bcfe02d3955dd37f736645e7	false	0x55d398326f99059ff775485246999027b3197955	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	189	28471329	60	2023-05-23T20:21:21.000Z	0x46d583213fa46f6a2060fa6bae1ccef11cbc70d8e678b20e18de8c6286747723
100	0x126555dd55a39328f69400d6ae4f782bd4c34abb	0x264c1eafada2fc355f9bab5b16c9e8a6dc1ff015	false	0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3	0x55d398326f99059ff775485246999027b3197955	116	28471695	1	2023-05-23T20:39:42.000Z	0xc675012961b7e873bdf52407eda4f51dfea312fa0bc4d4f28eefbc51e61f261e

Example Query

Query with partition filter

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