aerodrome_v3_base

Tables

CLPool_Burn_event

Liquidity removal events from Aerodrome V3 concentrated liquidity (CL) pools on Base, capturing position burns with token amounts withdrawn and tick range parameters. Used for tracking LP exit activity and analyzing liquidity depth changes across 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_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	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x9be60b89d29613da9e5163a9f4ed9cc3738d59dc	false	0x827922686190790b37229fd06084350e74485b72	0	274	0	18729330	-338800	-338000	2024-08-21T13:46:47.000Z	0x9de366ae11815338aaf62286da2ca7e363ee7e227e8ce07e639a40861ae2ec92
0x9be60b89d29613da9e5163a9f4ed9cc3738d59dc	false	0x827922686190790b37229fd06084350e74485b72	0	183	0	18717928	-338400	-337600	2024-08-21T07:26:43.000Z	0x510f55cdf0a395ba7130a31375ecfb495e66393832e1dd16cfc123b1ccf00497
0x9be60b89d29613da9e5163a9f4ed9cc3738d59dc	false	0x827922686190790b37229fd06084350e74485b72	150257474191476481	86	63684421808780011428345	18705151	-337600	-337200	2024-08-21T00:20:49.000Z	0x057d4f71e327ff8e9292a2640b64ba12468024461316d45d70de0fc8243aeebc

Example Query

Query with partition filter

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

CLPool_Collect_event

Fee collection events from Aerodrome V3 concentrated liquidity pools on Base, recording token amounts withdrawn by liquidity providers from specific tick ranges. Used for analyzing LP earnings, fee accrual patterns, and position management behavior.

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
0xb2cc224c1c9fee385f8ad6a55b4d94e92359dc59	false	0x827922686190790b37229fd06084350e74485b72	274	15485713154654452	4212764	28997392	0x00000000c733a397f38271c2eb4ca56193b769cb	-202800	-202200	2025-04-16T06:15:31.000Z	0xf3e41c00348aec27d4ebeb4d1e316b9a54beeb27800ea4c0c22bb5741c769e8b
0xb2cc224c1c9fee385f8ad6a55b4d94e92359dc59	false	0x827922686190790b37229fd06084350e74485b72	95	34834456599449595	707328	28996025	0x00000000c733a397f38271c2eb4ca56193b769cb	-202700	-201900	2025-04-16T05:29:57.000Z	0x22035ec9b8b82692bb24598210ff55f1575f4ed8351c3d79d4a0d01920c614d1
0x56b92e5b391dbfb8b8028ac95a4b97f52ffeb416	false	0x827922686190790b37229fd06084350e74485b72	398	92029083545832306	1507595041988047332956	29014231	0x00000000c733a397f38271c2eb4ca56193b769cb	75700	77700	2025-04-16T15:36:49.000Z	0x77597ddd6a4cd3b620d647aec7873cf1344dc940917b931978316be86b15e8a3

Example Query

Query with partition filter

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

CLPool_CollectFees_event

Fee collection events from Aerodrome V3 concentrated liquidity (CL) pools on Base, recording amounts of both tokens withdrawn by liquidity providers. Used for tracking LP earnings, protocol revenue distribution, and liquidity provider profitability 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_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
0x06c522a75a0413269fae5069ff9b93d65c7c4b57	false	369	40057184701658396	5963415263244861007343613	37194130	0x266f44f2bde17b7a45489dfb0727fe37451a50cf	2025-10-23T00:00:07.000Z	0x0374612745b307c7e6e6dd7579cb56d58a8044ca5bb9d1cddf238211f161a2d4
0xb6b777577a05d85ffca7d9ebc7476fb344b92445	false	315	18850601451799242	10139097900501719314734	37194130	0x9c590e540b6d2b602565d00eb47023a2ea66f4e0	2025-10-23T00:00:07.000Z	0x1ac7dcdea98d9c83acab75cac518739980c31d2e3460bae5c80e143ea8c549f1
0xc200f21efe67c7f41b81a854c26f9cda80593065	false	265	6002608710495060051740	1193023570182167193	37194130	0xbda319bc7cc8f0829df39ec0fff5d1e061ffadf7	2025-10-23T00:00:07.000Z	0x1ac7dcdea98d9c83acab75cac518739980c31d2e3460bae5c80e143ea8c549f1

Example Query

Query with partition filter

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

CLPool_Flash_event

Flash loan events from Aerodrome V3 concentrated liquidity pools on Base, capturing borrowed amounts (amount0/amount1) and fees paid (paid0/paid1) for arbitrage and MEV analysis. Used for tracking flash loan activity patterns and fee generation across 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
0x82321f3beb69f503380d6b233857d5c43562e2d0	false	37187942938099	0x8cf73e65343a50eff0d50f5a75cdf1e86c1e6633	440	9390894681338106	34773903	0x8cf73e65343a50eff0d50f5a75cdf1e86c1e6633	2025-08-27T23:25:53.000Z	0x7a23e7b4607ba7f69417fa3131b1bfb33ff01f7294457a90102bd9c94072f357
0xbba4bca62dc6ac976b160f4f513e517d3326759f	false	1631047196315047	0x8cf73e65343a50eff0d50f5a75cdf1e86c1e6633	551	326209439263009280	34762819	0x8cf73e65343a50eff0d50f5a75cdf1e86c1e6633	2025-08-27T17:16:25.000Z	0x3c23a2ae34789838dfe6bff103e729345a0fe87a99e02763fa8d7faa5e811c32
0xbba4bca62dc6ac976b160f4f513e517d3326759f	false	928096898871346	0x8cf73e65343a50eff0d50f5a75cdf1e86c1e6633	886	185619379774269120	34750793	0x8cf73e65343a50eff0d50f5a75cdf1e86c1e6633	2025-08-27T10:35:33.000Z	0x142a1be5fc218368c8102027210fa1cb9a5b2cc4892422ab8ddbbba2541193b9

Example Query

Query with partition filter

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

CLPool_Mint_event

Liquidity provision events from Aerodrome V3 concentrated liquidity (CL) pools on Base, capturing mint actions with token amounts, tick ranges, and position owner details. Used for analyzing liquidity provider behavior, position sizing, and capital efficiency in Uniswap V3-style automated market makers.

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
0xe2b3aa806e56603a244bfc111c9474f7dedd03db	false	0x827922686190790b37229fd06084350e74485b72	1168025550734556	0x827922686190790b37229fd06084350e74485b72	358	50363691438860382540	78753	36934426	-375800	-375600	2025-10-16T23:43:19.000Z	0xc90c4381365e61184701c1ff1e8c3a656a9fa5ae7cd6e78b67690bf495ae2c7a
0xe2b3aa806e56603a244bfc111c9474f7dedd03db	false	0x827922686190790b37229fd06084350e74485b72	43874426014920174	0x827922686190790b37229fd06084350e74485b72	500	1891806264411690973064	2958191	36934545	-375800	-375600	2025-10-16T23:47:17.000Z	0x7114adc94c4750708b539d4a051e96264c9fbfbc570a8d16d51fad795a801e1e
0xe2b3aa806e56603a244bfc111c9474f7dedd03db	false	0x827922686190790b37229fd06084350e74485b72	66463550429815687	0x827922686190790b37229fd06084350e74485b72	242	2865818940067936969556	4481241	36934599	-375800	-375600	2025-10-16T23:49:05.000Z	0xb3164f10add880c900cb9b629bcc81f4e48c2e2b5b6485b2827b69a9b19e2664

Example Query

Query with partition filter

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

CLPool_Swap_event

Swap events from Aerodrome V3 concentrated liquidity pools on Base, capturing token exchanges with amounts, price impacts (sqrtPriceX96), and tick movements. Used for analyzing DEX trading activity, price discovery, and liquidity utilization across Aerodrome’s Uniswap V3-style 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_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
0x016df91005f30039c9f1a89b44db5e8c60613603	64979	false	0x1b2b6ce813b99b840fe632c63bca5394938ef01e	74	-2266347896516609	1507893363583844764	24030479	76368076241477045107305	0x000010036c0190e009a000d0fc3541100a07380a	2024-12-22T06:51:45.000Z	2040866916461649829134065959436	0x13e779b54e4a121c06d161d3593de1785c1555d5358c6a3424a5300aabe762cf
0x016df91005f30039c9f1a89b44db5e8c60613603	64821	false	0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	356	-1046402723756238799	685085433817088058985	24021822	68136735001929520008197	0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	2024-12-22T02:03:11.000Z	2024886303391452598690456871417	0xc45c4aee3e46d7c2870905ca37e9db9c5604dc32242c2097440cfb8e46e40e3b
0x016df91005f30039c9f1a89b44db5e8c60613603	65017	false	0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	229	-4714845796584467	3149015682700997198	24042263	77721664594558059780218	0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	2024-12-22T13:24:33.000Z	2044779574742994876136048131966	0xcc9c7694cf2cbb6d810dde8230a2778394559bd15baa84e85ab70f93dc241cb0

Example Query

Query with partition filter

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

CLPoolFactory_PoolCreated_event

Pool creation events from Aerodrome V3 concentrated liquidity (CL) factory contract on Base. Records new liquidity pool deployments with token pairs, pool addresses, and tick spacing configuration for tracking DEX pool launches and liquidity structure.

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
0x5e7bb104d84c7cb9b682aac2f3d509f5f406809a	0xb0eda9aba91188dd4ab725ccbbda1f2e68f788d6	false	0x63503cf5b650e83acda65505dc76ba2afec20330	0xc0d3700000987c99b3c9009069e4f8413fd22330	190	27264702	2000	2025-03-07T03:39:11.000Z	0x13e7fba1f0ee3be88dda5999a74fa6d83974a37c052f982d269ca1056b4c67c6
0x5e7bb104d84c7cb9b682aac2f3d509f5f406809a	0x6beeabc2faa68d87dffddd1fb78621e8a601f080	false	0x269cae7dc59803e5c596c95756faeebb6030e0af	0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42	248	35415218	1	2025-09-11T19:43:03.000Z	0x1bc1bcb9a0bcfaeeb5bf3dfb96297efe9378d00be1f067cec721fa6364573695
0x5e7bb104d84c7cb9b682aac2f3d509f5f406809a	0x8407a9fd14aa29749cad6e5b3b1c3989ba2f389f	false	0x4200000000000000000000000000000000000006	0x9089397444ef32f1777d2a9d0c0886592c8ef449	351	35412086	2000	2025-09-11T17:58:39.000Z	0xccbd669c5627cc792887137655d0347094e0ea6cb2d1221d1f0e86ca6d57746d

Example Query

Query with partition filter

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

Overview

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

Tables

CLPool_Burn_event

CLPool_Collect_event

CLPool_CollectFees_event

CLPool_Flash_event

CLPool_Mint_event

CLPool_Swap_event

CLPoolFactory_PoolCreated_event