uniswap_v3_bsc

Tables

Factory_createPool_function

Function call data for liquidity pool creation through factory contracts, including token pair addresses, fee tiers, and the resulting pool address. Used for tracking DEX (Decentralized Exchange) pool deployments and factory contract interactions.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_tokenA`	`STRING`	Contract address of the first token in a token pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenB`	`STRING`	Contract address of the second token in a token 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.
`out_pool`	`STRING`	Contract address of the newly created Uniswap V3 liquidity pool on BSC. Null when the pool creation transaction fails (status=false).

Sample Data

gas	in_fee	status	gas_used	out_pool	in_tokenA	in_tokenB	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
21183	3000	false			0x3ee2200efb3400fabb9aacf31297cbdd1d435d47	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	0xa1671295	0xdb1d10011ad0ff90774d0c6bb92e5c5c8b4461f7	26629743	0x7b8a01b39d58278b5de7e48c8449c9f4f5170613	0,1	2023-03-20T13:42:01.000Z	0x9f1b7947da0f606b3694b12996f8fe28401f3f3d9caedfe0f66377905234058d
2073370	10000	false	2042695		0x60322971a672b81bcce5947706d22c19daecf6fb	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	0xa1671295	0xdb1d10011ad0ff90774d0c6bb92e5c5c8b4461f7	26614123	0x7b8a01b39d58278b5de7e48c8449c9f4f5170613	0,1	2023-03-20T00:32:51.000Z	0x43223e7cdb018b3a1e9e8a514df83ce18de39d9d67ae7589c7c19252952d222b
6060970	10000	true	4595696	0x5010f023e03271bf67ca63a6955e5c0eff3d130c	0x0cf8e180350253271f4b917ccfb0accc4862f262	0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82	0xa1671295	0xdb1d10011ad0ff90774d0c6bb92e5c5c8b4461f7	26616492	0x7b8a01b39d58278b5de7e48c8449c9f4f5170613	0,1	2023-03-20T02:31:32.000Z	0xf7868172cf92acc1d72046389219a9e711db1e6ea18314d7ce7ff98bd1a49200

Example Query

Query with partition filter

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

Factory_FeeAmountEnabled_event

Factory contract events emitted when a new fee tier is enabled for pool creation in Uniswap V3. Records the fee amount in basis points and corresponding tick spacing parameter for concentrated liquidity pools.

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_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.

Sample Data

in_fee	address	removed	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
500	0xdb1d10011ad0ff90774d0c6bb92e5c5c8b4461f7	false	261	26324014	10	2023-03-09T19:53:14.000Z	0xbfe5cdcb2a4346934430a39eb4bb683f9d8d2145d9d96edfab6b06cf51f3abfb
3000	0xdb1d10011ad0ff90774d0c6bb92e5c5c8b4461f7	false	262	26324014	60	2023-03-09T19:53:14.000Z	0xbfe5cdcb2a4346934430a39eb4bb683f9d8d2145d9d96edfab6b06cf51f3abfb
10000	0xdb1d10011ad0ff90774d0c6bb92e5c5c8b4461f7	false	263	26324014	200	2023-03-09T19:53:14.000Z	0xbfe5cdcb2a4346934430a39eb4bb683f9d8d2145d9d96edfab6b06cf51f3abfb

Example Query

Query with partition filter

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

Factory_PoolCreated_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_fee	address	in_pool	removed	in_token0	in_token1	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
100	0xdb1d10011ad0ff90774d0c6bb92e5c5c8b4461f7	0x8619cf621fef4b433ab2cfb3a1f4cf47469964de	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0xcce81e8202edde259d88269409e48597f80cff83	182	28650453	1	2023-05-30T01:52:06.000Z	0xdf9ecdf2655c7d62d9179eb02ae93593a692a88cc4f1c3d2b83b5fe28a9c55ba
100	0xdb1d10011ad0ff90774d0c6bb92e5c5c8b4461f7	0xe420b47a9924191cf82b8ade54a05f454bafe656	false	0x25471ab2c22703b286e271079b5fe89cf2a280b2	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	242	28674263	1	2023-05-30T21:44:11.000Z	0x1de962b4656683d20dd8a617c24134df415b10b6459bc29c788caa62f7e6f7d9
500	0xdb1d10011ad0ff90774d0c6bb92e5c5c8b4461f7	0x3f38a1748d0ce83cdb5ff7fbeec6d8a331cb95ee	false	0x08372555176c83f9d9c8a62785076cf461c70d05	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	187	28675150	10	2023-05-30T22:28:38.000Z	0x18ccec86b5cb2145e65633754b66f55f1faa89c84de103cb512fd1692d43ed0e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_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
0x5bf1cf153c102a79d9e18b7fb7c79ba57fa70d0c	false	0x00000000d4e7e5023db80d08b9d93e6468e1000d	8576755967082535533302	37	3618464330591650623092948	20329271259351629881	28860056	-887270	887270	2023-06-06T08:56:37.000Z	0xbbeedfbbc1777e8f144ecb3dd2bf23f85ebfc5964b1fed76f4adb317b05c1247
0x5bf1cf153c102a79d9e18b7fb7c79ba57fa70d0c	false	0x00000000d4e7e5023db80d08b9d93e6468e1000d	694717233333685378197	93	212386254146995353871545	2272425945027375408	28866720	-887270	887270	2023-06-06T14:31:28.000Z	0x5c623be638c596585ea2b2fc1aca207e5b9c43b746065b5b23775e375b046759
0x5bf1cf153c102a79d9e18b7fb7c79ba57fa70d0c	false	0x00000000d4e7e5023db80d08b9d93e6468e1000d	7719080370374281979971	293	2622176826518117437497581	22723182190354802656	28866710	-887270	887270	2023-06-06T14:30:58.000Z	0xb2310dae156518e9abda329b851c41ca015442d1209f758969cefefd87b0e8e7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_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
0xa054937d1c683aa204a0474a9d0a2f9e2bbfde2f	false	0x7b8a01b39d58278b5de7e48c8449c9f4f5170613	247	80808051391891478	163483926450102132	30672686	0x0f3ccca8b0f60861835d82a057e75aa249223187	-200	0	2023-08-08T11:57:37.000Z	0xaa5327c74a1849e63ac708b2e40bbaa41bed497d5c61c6b53b7f8e36a85b2508
0x7fe20c1b2c726b2384f44dde3ca91ee430650d09	false	0x7b8a01b39d58278b5de7e48c8449c9f4f5170613	528	342983378580788983101	25995780004423545854	30671509	0x1139043e780a331ad6d7f47106e8290b9f8c696e	12400	13200	2023-08-08T10:58:46.000Z	0x122371878d80943d9a392b2e0e095aec798dfeaecd33a78ff5c3aab3fd11d81f
0x2c3c320d49019d4f9a92352e947c7e5acfe47d68	false	0x7b8a01b39d58278b5de7e48c8449c9f4f5170613	120	966801699387619120	7611322611296375064211	30682455	0x20140481d0644b4d86f1ed287d22bfbdc6868f55	-15	-12	2023-08-08T20:06:47.000Z	0xa897fb4cb0b823557857f74b1889a2c5c87833519b52c641def532e44fb8783d

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

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

address	removed	in_paid1	in_sender	log_index	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x5157e9c772359ec90f237e0735710bbc57ab3aa1	false	51766318789144	0x36786c66116f2fa0b52246bcf9d2f9e982d44b03	155	517663187891438930	29773409	0x36786c66116f2fa0b52246bcf9d2f9e982d44b03	2023-07-08T04:14:22.000Z	0x31b6a336ff8b3653c2b25c6f9888756da397e744133d14b3804048800a0fb6db
0x2224a1c14c3a34b48e51e9e01e74823395eb7a63	false	100091307850	0x7ecdc5da73e3d5b97d1b7af2a5aee737a4eece9c	156	1000913078493416	28922746	0x7ecdc5da73e3d5b97d1b7af2a5aee737a4eece9c	2023-06-08T13:19:43.000Z	0xcba27781c18eca1c2aabb07b01ba6e748c655682bb963735ba006ed0af6bae75
0x2c3c320d49019d4f9a92352e947c7e5acfe47d68	false	100000000000000	0x7ecdc5da73e3d5b97d1b7af2a5aee737a4eece9c	139	1000000000000000000	28921319	0x7ecdc5da73e3d5b97d1b7af2a5aee737a4eece9c	2023-06-08T12:08:18.000Z	0xb4100e31d26781ca886d22aa7fc42529be2cc1d6662e05d6f49ab81d71e5d72f

Example Query

Query with partition filter

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

Pool_IncreaseObservationCardinalityNext_event

Uniswap V3 pool event emitted when the observation array cardinality limit is increased, recording the old and new maximum number of price observations the pool can store. Used for tracking oracle capacity expansions that enable longer time-weighted average price (TWAP) calculations.

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_observationCardinalityNextOld`	`STRING`	Previous maximum number of price observations the Uniswap V3 pool could store before the increase. String-encoded integer value representing the cardinality limit prior to the update.
`in_observationCardinalityNextNew`	`STRING`	Updated maximum number of price observations the Uniswap V3 pool can store. String-encoded integer value representing the new cardinality limit after the increase.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_observationCardinalityNextNew	in_observationCardinalityNextOld
0x2c3c320d49019d4f9a92352e947c7e5acfe47d68	false	65	27309073	2023-04-13T09:59:42.000Z	0x512085e613cd7057d637cd9831da82922cc0a7bfc812896788e39e1a3d067cbc	18	1
0x6fe9e9de56356f7edbfcbb29fab7cd69471a4869	false	127	27846063	2023-05-02T02:28:27.000Z	0xaa72917b9b7841ef50cd9c630713750fd580f35d648c64f91323ecb3aafdfd5c	18	1
0xc98f01bf2141e1140ef8f8cad99d4b021d10718f	false	119	27846014	2023-05-02T02:26:00.000Z	0x9148f9390ee91f7d962f49b6a6a87ce07c6db671a8864e4693350f869adaa19c	18	1

Example Query

Query with partition filter

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

Pool_Initialize_event

Concentrated liquidity pool initialization event emitted when a pool contract is first created and seeded with a starting price. Records the initial sqrtPriceX96 (square root price encoded as Q64.96 fixed-point) and tick index that define the pool’s starting exchange rate between token0 and token1.

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_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_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	log_index	block_number	block_timestamp	in_sqrtPriceX96	transaction_hash
0x8e9156e218c6c7ad054cb4573d2fa79379effec4	-161190	false	465	27806089	2023-04-30T17:07:36.000Z	25052911542910170730777872	0xcaf646b92b826b25d18a47f6c6971c7167212c8b7008142193b77844c46c3e79
0xb5c2a8caeca63e77f226bcbae2583805b2e23c69	-161190	false	253	27797662	2023-04-30T10:05:48.000Z	25052911542910170730777872	0x06f68f197c40d17f941ee39c5e1e77d787e62fcb726ed9a73a5e013412ea8ed9
0x56b0648d7c748ba533414e2cee9051ebdac10687	-87000	false	79	27812880	2023-04-30T22:47:41.000Z	1022805465839096774045881611	0x3b308189e3a1dd2ae4973768871843879ee3c3fc173e1b2bad5be36d96a1a353

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_bsc.Pool_Initialize_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
0xc98f01bf2141e1140ef8f8cad99d4b021d10718f	false	0x02c09ae73cc26c0de3b2ae644a4fa54bb1fdcebd	200204218163305612867000671	0x02c09ae73cc26c0de3b2ae644a4fa54bb1fdcebd	316	28859765461903355852765	21184004506240526097827	27055893	2	7	2023-04-04T12:40:23.000Z	0x9efce9b7e3b829344665384db40ba0d6b27e5096aff6473856e57461edf63b73
0x508acf810857fefa86281499068ad5d19ebce325	false	0x2dec27f9df8aa20b49b6d5d6ed9d53239b89c4e4	13443186961372697338961	0x2dec27f9df8aa20b49b6d5d6ed9d53239b89c4e4	84	553360646222630981355902	2933696017498025859	27054674	-121600	-117600	2023-04-04T11:38:23.000Z	0xefa493102a706ef7ea8f328f52d3970cfd159ff94037c55c4be7a3eae8f847f6
0x508acf810857fefa86281499068ad5d19ebce325	false	0x3a4ea286af31ca181f1757cf7edbd4355f0360b5	10515357124283979769	0x3a4ea286af31ca181f1757cf7edbd4355f0360b5	19	31382162450616847178	51139543995522	27054681	-118000	-117800	2023-04-04T11:38:44.000Z	0x9c8d5db0cc3e3d7dbfda38d9d267eff2b176b5f7df28df812c60f189e79d7dbd

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_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
0x3af8aa62aac8441359929f2e40e6e3d8c5099941	-887272	false	0x3bba049f9e5c7a88dd4c8ab8d75d97bebf21da77	113	973103962172008888458	-8166475595369458398	29236290	0	0x6321b57b6fdc14924be480c54e93294617e672ab	2023-06-19T11:15:23.000Z	4295128740	0xf6076893e6c7035b44adc53ae8f767bc06ba4aa1c99f1522ab50ab0213eea9df
0xda6a499820e29997e8a8f305dc896829ed6ab4c8	-347683	false	0x44563591b38a9b9ee61639ae882af1e21309728c	207	775771640151508368381	-616014	29223718	139128433899349475	0x44563591b38a9b9ee61639ae882af1e21309728c	2023-06-19T00:43:48.000Z	2235766509668825464985	0xe84e4d5300550f0dbb73db16d984a9a18c14a08a6240e30c38465bda89188a85
0xda6a499820e29997e8a8f305dc896829ed6ab4c8	-347680	false	0x96794f03b3114f50b892b0dec79d753658c931ee	106	-756007900227021666882	603937	29231951	139128433899349475	0x6613e746d065bc0062dc68cd8fe85c5d48aa53a6	2023-06-19T07:37:49.000Z	2236109396137226403914	0xc928006348f44c2da96ee2a6475246dde6868ee71fdeb16f600a724f6d7b06bf

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_createPool_function

Factory_FeeAmountEnabled_event

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_IncreaseObservationCardinalityNext_event

Pool_Initialize_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_createPool_function

​Factory_FeeAmountEnabled_event

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_CollectProtocol_event

​Pool_Flash_event

​Pool_IncreaseObservationCardinalityNext_event

​Pool_Initialize_event

​Pool_Mint_event

​Pool_SetFeeProtocol_event

​Pool_Swap_event

Tables

Factory_createPool_function

Factory_FeeAmountEnabled_event

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_IncreaseObservationCardinalityNext_event

Pool_Initialize_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event