uniswap_v3_optimism

Tables

Factory_PoolCreated_event

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

Columns

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

Sample Data

in_fee	address	in_pool	removed	in_token0	in_token1	block_number	in_tickSpacing	block_timestamp	transaction_hash
10000	0x1f98431c8ad98523631ae4a59f267346ea31f984	0x0d46f55d01641d4494000da094a1473dca42f363	false	0x6fd9d7ad17242c41f7131d257212c54a0e816691	0x7f5c764cbc14f9669b88837ca1490cca17c31607	1837684	200	2022-01-02T02:10:30.000Z	0x5e9c0e8bd25fbdc50322a63bfc871a0f936615e16f9053545cf14eda7d202dfb
500	0x1f98431c8ad98523631ae4a59f267346ea31f984	0x6728e31a231d7d9244aa6bf2fa3a7415a9bdd235	false	0x4200000000000000000000000000000000000006	0x8f1cd6aa58f6135252492fea9754afae0e7c8da7	76354451	10	2023-02-23T18:03:29.000Z	0xb9f057282f9c6a475a6dd8b0684373b6e86cf8bbd413160386bbec5a22ec2fb5
3000	0x1f98431c8ad98523631ae4a59f267346ea31f984	0x6f652a057dd7430a466c7450f8fb3be411de8746	false	0x4200000000000000000000000000000000000006	0xbed310ea89029d19a8a59a44ff9a17392f39cc6f	76321471	60	2023-02-23T16:00:57.000Z	0xc51cd3392ff1a1bb6bb561e1971361920b41da732160f73797ea754740edeaf9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_optimism.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
0x03af20bdaaffb4cc0a521796a223f7d85e2aac31	false	0xc36442b4a4522e871399cd717abdd847ab11fe88	0	0	0	0	2073910	83580	83640	2022-01-07T21:58:24.000Z	0xc544c506019437f6ef1c4d1b19b7e70a3939022f8a2b78fb311dc288f5d8f106
0x85149247691df622eaf1a8bd0cafd40bc45154a9	false	0xc36442b4a4522e871399cd717abdd847ab11fe88	15504746129804	0	274425973230247047	875999999	2039636	-887270	887270	2022-01-07T07:10:53.000Z	0xc1d21f17a8a8c4cd571a9df5831ba0397f1e7ba47e247aec457078817213bd0b
0xc64f9436f8ca50cdcc096105c62dad52faeb1f2e	false	0xdfcaebe8f6ea5e022befafae8c6cdae8d4e1094b	14464218012903237936	3	10649128029565152	0	2051238	106620	109920	2022-01-07T12:53:56.000Z	0xca29fbbf8bb1d461ce2a568f2c6067faf13de6f83243d7fd1a8a91e585283391

Example Query

Query with partition filter

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

Pool_Collect_event

Concentrated liquidity position fee collection events from Uniswap V3 compatible decentralized exchanges. Records position owner, recipient, collected token amounts, and tick range boundaries for tracking earned trading fees and position management activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	log_index	in_amount0	in_amount1	block_number	in_recipient	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0xc858a329bf053be78d6239c4a4343b8fbd21472b	false	0xc36442b4a4522e871399cd717abdd847ab11fe88	3	8888693301077136	20466464	3165257	0xc36442b4a4522e871399cd717abdd847ab11fe88	-198310	-196600	2022-02-03T13:21:45.000Z	0x026c7781188266810ccd4d582f55f1d98b7108f48e82118221a65b2254e96273
0x85149247691df622eaf1a8bd0cafd40bc45154a9	false	0xc36442b4a4522e871399cd717abdd847ab11fe88	3	25209415815807268	0	3174778	0xc36442b4a4522e871399cd717abdd847ab11fe88	-192830	-190010	2022-02-03T18:50:11.000Z	0xdef387cf9cabb96e61461504058784969187b7b24f265652404ed6814b055381
0x0392b358ce4547601befa962680bede836606ae2	false	0x83beefb4ca39af649d03969b442c0e9f4e1732d8	6	691334202092125	1161232989563927066	3174099	0x83beefb4ca39af649d03969b442c0e9f4e1732d8	-887220	887220	2022-02-03T18:14:59.000Z	0x6dac235ae5d681a1cf066fea5f199054e7fb684d83d732f2891b3256f696339c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_optimism.Pool_Collect_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
0xbf16ef186e715668aa29cef57e2fd7f9d48adfe6	false	1902030	0xab36427a6a0ef1442b871e63974a13ba9ecf3e83	443	19020294178	74203527	0xab36427a6a0ef1442b871e63974a13ba9ecf3e83	2023-02-14T03:23:15.000Z	0xb8bcc7de87cb68168a13ea9f75c39befe8ce97cb4ed90f6d482cf917906eae18
0xbf16ef186e715668aa29cef57e2fd7f9d48adfe6	false	181576	0x11ba5ac369a2e7ad44bab98b83433fd2329d3070	22	1815754869	74382214	0x11ba5ac369a2e7ad44bab98b83433fd2329d3070	2023-02-14T23:47:50.000Z	0x3762ab5b03fee837b07d88ac66f82ec82de3ac7176b785416eb3b6e1e78cacb2
0xbf16ef186e715668aa29cef57e2fd7f9d48adfe6	false	3320321	0x11ba5ac369a2e7ad44bab98b83433fd2329d3070	22	33203204235	74341758	0x11ba5ac369a2e7ad44bab98b83433fd2329d3070	2023-02-14T16:38:30.000Z	0x93c86eb6ba327c4ffe013f586388c982110dec256c596c9f0c6b7c6722e703ef

Example Query

Query with partition filter

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

Pool_Mint_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	in_amount	in_sender	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x2e80d5a7b3c613d854ee43243ff09808108561eb	false	0xc36442b4a4522e871399cd717abdd847ab11fe88	70150872296497644384	0xc36442b4a4522e871399cd717abdd847ab11fe88	3	37775783947869174	199999999999999996674	1947966	81660	83280	2022-01-05T11:36:57.000Z	0x399f2f9c39d9d10cab022ee3d2e79651dd0c3789323da47edee2920694bd692b
0xf334f6104a179207ddacfb41fa3567feea8595c2	false	0xc36442b4a4522e871399cd717abdd847ab11fe88	480957766661299624	0xc36442b4a4522e871399cd717abdd847ab11fe88	4	5000000000000000	46264074662365027090	1971281	-887200	887200	2022-01-05T21:28:05.000Z	0xc9113b092bd292afb351d06719a28455b49d161522a5e2cbb30bc734ba133194
0x535541f1aa08416e69dc4d610131099fa2ae7222	false	0xc36442b4a4522e871399cd717abdd847ab11fe88	2599529163353145907	0xc36442b4a4522e871399cd717abdd847ab11fe88	2	10000000000000000	0	1952901	62160	63960	2022-01-05T14:12:16.000Z	0x44cc4e215a0821b8ec3b5404aa68e907db98e76047f1106bc0070e4463b1c9c7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_optimism.Pool_Mint_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
0x6168ec836d0b1f0c37381ec7ed1891a412872121	52658	false	0xc758b7795361e6aa13154c31583f038ea99766b1	30	331354	-64023265	13734351	3607531385	0xc758b7795361e6aa13154c31583f038ea99766b1	2022-07-03T05:15:16.000Z	1102246166498094148289014909539	0x06b559eee47999c1f923977028a07c627aa9e12c70889213fea1967b58b2c943
0x85149247691df622eaf1a8bd0cafd40bc45154a9	-206695	false	0xe592427a0aece92de3edee1f18e0157c05861564	3	-1200011645080821488	1268235783	13741976	526115474733755927	0x837483786099e6ce8f1549dd596cd0975fb6e515	2022-07-03T08:25:08.000Z	2575101497584551166873684	0x09576e1ac48d2e833f0cef5aef678f6b28fa2f50a70b64fb8c0ae672109ec1b7
0x2f449bd78a72b18f8758ac38c3ff8dcb094416f6	-40770	false	0xbd7a3b7dbeb096f0b832cf467b94b091f30c34ec	2	1185583946283425167835	-20051514713027708029	13777159	2255554047143386930197269	0x82ac2ce43e33683c58be4cdc40975e73aa50f459	2022-07-03T22:32:40.000Z	10318691319273952314294718160	0x10ef052272a8a4b518e10c6acae9219b1e0802e3aa46384967e609af41eae081

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_optimism.Pool_Swap_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_Flash_event

Pool_Mint_event

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_Swap_event

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event