velodrome_v3_optimism

Tables

CLPool_Burn_event

Liquidity removal events from Velodrome V3 concentrated liquidity (CL) pools on Optimism, capturing withdrawn liquidity amounts and tick ranges when positions are burned. Used for analyzing liquidity provider withdrawal patterns and position management strategies.

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_tickUpper	block_timestamp	transaction_hash
0xfd5f39c74e63f1dace336350afdf11e85bbd56f4	false	0x416b433906b1b72fa758e166e239c43d68dc6f29	179352936010994	70	15542484200	2391047926	121946162	2	2024-06-27T12:25:01.000Z	0xbee02c50a527b2ab93f3ad049b4b5a817d4a31e7823772b71ba82f458330ee20
0x2fa71491f8070fa644d97b4782db5734854c0f6f	false	0x416b433906b1b72fa758e166e239c43d68dc6f29	207464059960754	13	3663233602	6709408445	121926138	1	2024-06-27T01:17:33.000Z	0x5e4c1e264348bdaff2cad4a5e08d2c946c567c28794982bfb836d333f13137ce
0xfd5f39c74e63f1dace336350afdf11e85bbd56f4	false	0x416b433906b1b72fa758e166e239c43d68dc6f29	105736539198229	51	10572596660	0	121962359	2	2024-06-27T21:24:55.000Z	0x041bf30a6d3ef992a617e41734622b11b8b8a4402d7d223349fd1456f0772537

Example Query

Query with partition filter

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

CLPool_Collect_event

Fee collection events from Velodrome V3 concentrated liquidity (CL) pools on Optimism, recording token amounts withdrawn by liquidity providers from specific tick ranges. Used for analyzing LP profitability and fee generation across different price ranges.

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	block_number	in_recipient	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x3c01ec09d15d5450fc702dc4353b17cd2978d8a5	false	0x416b433906b1b72fa758e166e239c43d68dc6f29	15	394722	122977290	0x03354437f81ae7ae5569f63ba3b4a1325dd12e69	276301	276308	2024-07-21T09:15:57.000Z	0x28c759d1580e5c99d99c68aecdad5249f17af552007c65ab562aebc77e355477
0x3c01ec09d15d5450fc702dc4353b17cd2978d8a5	false	0x416b433906b1b72fa758e166e239c43d68dc6f29	12	10003990858	122979226	0x03354437f81ae7ae5569f63ba3b4a1325dd12e69	276301	276308	2024-07-21T10:20:29.000Z	0x03d99283961a3058fe942757272ebed029462dcd3a84a2dd2023d193613f7c69
0x3c01ec09d15d5450fc702dc4353b17cd2978d8a5	false	0x15d715c142169bf93bc6c8c670c208dc3acce17e	1	0	122979205	0x03354437f81ae7ae5569f63ba3b4a1325dd12e69	276301	276308	2024-07-21T10:19:47.000Z	0xc41d348aa9458ef636a539fa5123adc384029368e3e800169eb560151aa94db0

Example Query

Query with partition filter

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

CLPool_CollectFees_event

Fee collection events from Velodrome V3 concentrated liquidity (CL) pools on Optimism. Records trading fee withdrawals with token amounts and recipient addresses for tracking liquidity provider earnings and pool economics.

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_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	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0xbafb44286c5ecafb1f26a6649e15c49fc1c49882	false	80	139224069434437404	459112239911566391841	122226428	0xa561da1dcd64cdb52049398900de36f0205a31a2	2024-07-04T00:07:13.000Z	0xb09e81cc3cfa8730072d469fb32f42f534c1ab5115d6e6f6a534ab25c176c792
0x3c01ec09d15d5450fc702dc4353b17cd2978d8a5	false	148	563947778	477196886883612194907	122226428	0x15d715c142169bf93bc6c8c670c208dc3acce17e	2024-07-04T00:07:13.000Z	0xb09e81cc3cfa8730072d469fb32f42f534c1ab5115d6e6f6a534ab25c176c792
0x173cdc71e29d5cffa6d090ad99f555a24b8831f9	false	198	442242666	1387342070864953130	122226428	0x41160e66fcaa10cbb148ace60bc2a22d609ec519	2024-07-04T00:07:13.000Z	0xb09e81cc3cfa8730072d469fb32f42f534c1ab5115d6e6f6a534ab25c176c792

Example Query

Query with partition filter

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

CLPool_Flash_event

Flash loan events from Velodrome V3 concentrated liquidity (CL) pools on Optimism, recording borrowed amounts and fees paid for both tokens in the pool. Used for analyzing arbitrage activity, MEV strategies, and flash loan utilization patterns across Velodrome 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_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
0xbf30ff33cf9c6b0c48702ff17891293b002dfea4	false	2953435239207	0x7bf845dc4717b2c1e1f90bdb9833539b0639fca0	9	29534352392060928	122169396	0x7bf845dc4717b2c1e1f90bdb9833539b0639fca0	2024-07-02T16:26:09.000Z	0xfa24a9d1aee3b69683771093ffcde2e1bcef3df4187e9cb1d4f69905351b2801
0xbf30ff33cf9c6b0c48702ff17891293b002dfea4	false	29961158421958	0x7bf845dc4717b2c1e1f90bdb9833539b0639fca0	11	299611584219578368	122184397	0x7bf845dc4717b2c1e1f90bdb9833539b0639fca0	2024-07-03T00:46:11.000Z	0x60b1784ec6ca6032e9a9e355601a9343cfde4a2074323005ae52cc353cddcf47
0xbf30ff33cf9c6b0c48702ff17891293b002dfea4	false	104097909834	0x7bf845dc4717b2c1e1f90bdb9833539b0639fca0	11	1040979098337280	123505455	0x7bf845dc4717b2c1e1f90bdb9833539b0639fca0	2024-08-02T14:41:27.000Z	0x274b162d25d7526cff6ccf5ec7c0119e15417870174e2d00408754f19331bd25

Example Query

Query with partition filter

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

CLPool_Mint_event

Liquidity provision events from Velodrome V3 concentrated liquidity (CL) pools on Optimism, capturing LP positions added with token amounts, price ranges (tick bounds), and ownership data. Used for analyzing liquidity depth, LP strategy patterns, and pool composition 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_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
0x1737275d53a5ca5dac582a493aa32c85ba2cfad3	false	0x416b433906b1b72fa758e166e239c43d68dc6f29	77639558383577854781	0x416b433906b1b72fa758e166e239c43d68dc6f29	7	10039156091	13249829229853580678909	121619308	276321	276327	2024-06-19T22:49:53.000Z	0xaaa637f19175d2366fe959821a6080a75ce12c13c964249ec56e9e82fa7db492
0x173cdc71e29d5cffa6d090ad99f555a24b8831f9	false	0x416b433906b1b72fa758e166e239c43d68dc6f29	2661230956999935	0x416b433906b1b72fa758e166e239c43d68dc6f29	58	1783297375	7512067261523065429	121621145	217600	219400	2024-06-19T23:51:07.000Z	0x58f03f50328dc699b9f6818d1315459dd91f37064bbbd5ab78c51eb0e4c2c628
0x23b6489b26eff4d10c4c6fd2820264e6ec8035e6	false	0x416b433906b1b72fa758e166e239c43d68dc6f29	33736530642827778	0x416b433906b1b72fa758e166e239c43d68dc6f29	724	188868571	3526270866504609730669	121586599	309200	310200	2024-06-19T04:39:35.000Z	0x9aff2601989b8478024532423af28c1ab924f87300741d576621715515fd3e9d

Example Query

Query with partition filter

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

CLPool_Swap_event

Swap events from Velodrome V3 concentrated liquidity (CL) pools on Optimism, capturing token amounts, price movement (sqrtPriceX96), tick changes, and liquidity state for each trade. Used for analyzing AMM trading activity, price impact, and liquidity utilization patterns.

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
0x2fa71491f8070fa644d97b4782db5734854c0f6f	0	false	0x4bf3e32de155359d1d75e8b474b66848221142fc	18	970937980	-970863060	123257659	24403406637403025	0x0025500c6a6bcaebde159db6a307f4d38503a079	2024-07-27T21:01:35.000Z	79229065743265852281742405797	0x67cf9a0d158d57f40696a528fcf8b25ec4d28a6a31130f2965869624afe67bd1
0x8ac2f9dac7a2852d44f3c09634444d533e4c078e	276382	false	0x4bf3e32de155359d1d75e8b474b66848221142fc	63	-5041404	5071429049953211522	123245242	731986043783756035894	0x01f00b86b3734bf1f353c32aa978bcf7df5d2c1d	2024-07-27T14:07:41.000Z	79459765660236806467647985577619370	0x8146395baef274bd825fbac83b3ed19e75e3e567a1204f27b375e0d782f0f88f
0x3c01ec09d15d5450fc702dc4353b17cd2978d8a5	276313	false	0x4bf3e32de155359d1d75e8b474b66848221142fc	2628	65037714	-64961136352818083243	123236289	1854370476193363249664	0x02a6faadc8fdacf8bf99951b3c6303ef19168149	2024-07-27T09:09:15.000Z	79185463914799429190272797690241882	0x09a2bde944c00a9f0cf7012cacf3cee2148c20a81cb24d014f1c36fea6147c81

Example Query

Query with partition filter

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

CLPoolFactory_PoolCreated_event

Pool creation events from Velodrome V3 concentrated liquidity (CL) factory on Optimism, recording new liquidity pool deployments with token pairs and tick spacing configuration. Used to track DEX pool launches and identify new trading pairs.

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

address	in_pool	removed	in_token0	in_token1	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
0xcc0bddb707055e04e497ab22a59c2af4391cd12f	0xfa587a571e0c3ded248599aa2f46917af600736f	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	0xeb466342c4d449bc9f53a865d5cb90586f405215	1	121999037	1	2024-06-28T17:47:31.000Z	0xd2ddd72c2f20eee6c6ca063cdb9dce31e7223ec6e67e78803a5688aeb2292ec7
0xcc0bddb707055e04e497ab22a59c2af4391cd12f	0x63f86da9be2d9f504342bdd1e02b3296cf1549ea	false	0x1ec50880101022c11530a069690f5446d1464592	0xb9243c495117343981ec9f8aa2abffee54396fc0	22	122258352	1	2024-07-04T17:51:21.000Z	0xfa5acbc62810d9723c3264587f962823efec13b1ad4cfd5a799131e0084eda80
0xcc0bddb707055e04e497ab22a59c2af4391cd12f	0xfd5f39c74e63f1dace336350afdf11e85bbd56f4	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	0x73cb180bf0521828d8849bc8cf2b920918e23032	26	121614257	1	2024-06-19T20:01:31.000Z	0x0b945eb442b97c98c69bea4237a9f3e83a44c82bf2bd5d4a0cc0f107e679d57b

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

CLPool_Burn_event

CLPool_Collect_event

CLPool_CollectFees_event

CLPool_Flash_event

CLPool_Mint_event

CLPool_Swap_event

CLPoolFactory_PoolCreated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​CLPool_Burn_event

​CLPool_Collect_event

​CLPool_CollectFees_event

​CLPool_Flash_event

​CLPool_Mint_event

​CLPool_Swap_event

​CLPoolFactory_PoolCreated_event

Tables

CLPool_Burn_event

CLPool_Collect_event

CLPool_CollectFees_event

CLPool_Flash_event

CLPool_Mint_event

CLPool_Swap_event

CLPoolFactory_PoolCreated_event