aerodrome_v1_base

Tables

BribeVotingReward_NotifyReward_event

Bribe reward notifications from Aerodrome decentralized exchange (DEX) on Base, recording token incentives distributed to liquidity pool voters per epoch. Used for analyzing voting incentive campaigns and gauge reward distributions 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_from	removed	in_epoch	in_amount	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xb0b88ca338f183d2fbabab0f75ba3c90424131d9	0xd818b9f7cb4090047d26c51e63c9cb1b5e12886a	false	1698278400	27173000000000000000000	0x26f3901ac8a79c50fb0d8289c74f0d09adc42e29	4	6005469	2023-11-01T00:58:05.000Z	0xcfdbcdd59005d6168d7cc2c727b0d6643c77b5e6a142f7fb3f3eb413aa5a20c5
0x1bee27670a1facac1b59143a387740223a203604	0xd818b9f7cb4090047d26c51e63c9cb1b5e12886a	false	1698278400	54347000000000000000000	0x26f3901ac8a79c50fb0d8289c74f0d09adc42e29	9	6005436	2023-11-01T00:56:59.000Z	0x9dcba65ae083c7d100d498f1b15dcb88437337b086bc81e1c335a8d737dd009c
0xe6742fae461ecaf4c6dbd3eb0e3e482bcb2c5567	0x51f0c4d693820ead25f573e243f4895c57a2276f	false	1698278400	25000000000000000000000	0x2dad3a13ef0c6366220f989157009e501e7938f8	17	6025935	2023-11-01T12:20:17.000Z	0x7f89e0ef596b78c4e513f9ecf7bd4ddb476a1e6940ec5ae8675546579effb32c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aerodrome_v1_base.BribeVotingReward_NotifyReward_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_stable`	`BOOL`	Boolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_anon4`	`STRING`	Sequential identifier for the liquidity pool pair created by the factory contract. String-encoded integer value.

Sample Data

address	in_pool	removed	in_anon4	in_stable	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x420dd381b31aef6683db6b902084cb0ffece40da	0x9ad08a62baac4608695a710ace8dca66f3c9f06a	false	293	false	0x4200000000000000000000000000000000000006	0xca68ad4ee5c96871ec6c6dac2f714a8437a3fe66	41	6888949	2023-11-21T11:47:25.000Z	0x603a4f414489c59e19f86c6f7d2001acc4022e789beb15e1ee13c71ad4cd30f2
0x420dd381b31aef6683db6b902084cb0ffece40da	0xf4784435aad798c86c5074e8481cbf5b99d9a089	false	137	false	0x4200000000000000000000000000000000000006	0x8be49607832a299fa33ee837038418ad0223333e	48	3965445	2023-09-14T19:37:17.000Z	0xe3950e598fbcb306720b897739119912acca088e87f6d92f3b80289609c8a5d5
0x420dd381b31aef6683db6b902084cb0ffece40da	0xf5a5a87911a8260898916f61a965caea507ccf24	false	135	false	0x27dcb425c7005dd7558f9583797eda39a8d70abd	0x4200000000000000000000000000000000000006	19	3956893	2023-09-14T14:52:13.000Z	0x0704c9f4521d079761c918c8c62736e00bf723b58930f45d03c81eb0aede9d13

Example Query

Query with partition filter

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

Gauge_ClaimRewards_event

Reward distribution events emitted when users claim accrued incentives from liquidity mining gauges. Records the claimer address, reward token contract, and claimed amount for tracking protocol incentive flows.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xc01e2ff20501839db7b28f5cb3ed2876fea3d6b1	0x04806550b12c5558c6a4b0e5ee0926b23c8e8223	false	772868870343868023905	515	5201922	2023-10-13T10:33:11.000Z	0x02d44f073a36fb85185003c7d3401fa4c13e245d856da0f79724e161bbee7f1d
0xc01e2ff20501839db7b28f5cb3ed2876fea3d6b1	0x04806550b12c5558c6a4b0e5ee0926b23c8e8223	false	489928033012765971059	513	5204507	2023-10-13T11:59:21.000Z	0x3a35df16b9dbb78b4e92386aa91333c7f61c59710ae39eb8eb87e7fba62e3b16
0xc01e2ff20501839db7b28f5cb3ed2876fea3d6b1	0x04806550b12c5558c6a4b0e5ee0926b23c8e8223	false	540953438725650653490	526	5218905	2023-10-13T19:59:17.000Z	0x2b48d9d31c1029e4cc118326f94ac03ad63861c8b01c64167118c91d7fa8085b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aerodrome_v1_base.Gauge_ClaimRewards_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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the 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

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x4d5bbce91d9bf7434bf358c1199c8a9c33303787	0x0b25c51637c43decd6cc1c1e3da4518d54ddb528	false	0x4d5bbce91d9bf7434bf358c1199c8a9c33303787	25	53973321669125163921	48286397	4748626	2023-10-02T22:43:19.000Z	0x5f1832241802aec54e348fb241333a9fe1be5d1150ca62799021b9feb1673bb5
0x4d5bbce91d9bf7434bf358c1199c8a9c33303787	0x3fc28bfac25fc8e93b5b2fc15efbbd5a8aa44efe	false	0x4d5bbce91d9bf7434bf358c1199c8a9c33303787	15	2230422235823	2410214923	4724088	2023-10-02T09:05:23.000Z	0xbc3d94c6dc526a931ae5d6b8d0d4d3cfa13ad8f043b6c83a53b57b834391090e
0x4d5bbce91d9bf7434bf358c1199c8a9c33303787	0x3fc28bfac25fc8e93b5b2fc15efbbd5a8aa44efe	false	0x4d5bbce91d9bf7434bf358c1199c8a9c33303787	37	2350218258298	2539183499	4736858	2023-10-02T16:11:03.000Z	0xc8f6dacfb00562de5ce9dc9ebed086e0e28098293e71ee3105cdfe7c6a6ea56d

Example Query

Query with partition filter

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

Pool_Claim_event

Fee claim events from Aerodrome V1 liquidity pools on Base, recording when liquidity providers withdraw accumulated trading fees in token0 and token1. Used for analyzing fee generation, liquidity provider returns, and pool revenue distribution.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	block_number	in_recipient	block_timestamp	transaction_hash
0x2223f9fe624f69da4d8256a7bcc9104fba7f8f75	false	0x6d2a624cae3d6574903db145ee0bf921a202325d	8	34334680890744	4998828	0x6d2a624cae3d6574903db145ee0bf921a202325d	2023-10-08T17:43:23.000Z	0xb6d3eeb35ca0d8b67cf743b36a5f9f8936258a1a4ba9067411c269bacab10fa8
0x2223f9fe624f69da4d8256a7bcc9104fba7f8f75	false	0xeea174486776bac738861be5e864bacbcbdada23	19	3908287055249134	4990544	0xeea174486776bac738861be5e864bacbcbdada23	2023-10-08T13:07:15.000Z	0x2a485084cffa0f6db15fa6c92d8bde45f54fb142411133e2f14b31b7c5a9c7b0
0x2223f9fe624f69da4d8256a7bcc9104fba7f8f75	false	0x36bac71a12d2398994e7e224e2f66ab8b46dae3b	22	8389178587668	4983445	0x36bac71a12d2398994e7e224e2f66ab8b46dae3b	2023-10-08T09:10:37.000Z	0xda73f0b34bd4376d324d3337b31f54b6a1ff1afaeea52e2e2f33e6968e5a4e59

Example Query

Query with partition filter

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

Pool_Fees_event

Fee collection events from Aerodrome V1 liquidity pools on Base, recording token0 and token1 amounts collected by the protocol from each pool. Used for analyzing protocol revenue generation and fee accrual patterns across different 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xb905d9195019778cfbaa4e9ed90df3fc5871cd9a	false	0x01ce4be3631746d157a09a53cf23c2a43578b84c	6	0	297489	9570322	2024-01-22T13:26:31.000Z	0x9bc95f78ff3996c6233085a5df659facec7a0a59935fd62cd0dfbbbf92d970d2
0x1a3b6d3389e0e0e7ee3f5c43867d6961fc98341b	false	0x01ce4be3631746d157a09a53cf23c2a43578b84c	15	9205782618992	0	9552146	2024-01-22T03:20:39.000Z	0x91e40012108a58b1d98560dee3fed0902d7dc6784a14e7eaf73cf273196751f5
0xa491f60dcbd14121cae9d7eba3d73ee8d4ab4a6c	false	0x01ce4be3631746d157a09a53cf23c2a43578b84c	24	1105634149036321	0	9549843	2024-01-22T02:03:53.000Z	0xf46b53fc9731702d17994d4bce317ef21444ba433bbff9b083a265d2b9c6ae41

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aerodrome_v1_base.Pool_Fees_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_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x0b25c51637c43decd6cc1c1e3da4518d54ddb528	false	0xcf77a3ba9a5ca399b7c97c74d54e5b1beb874e43	7	538900000000000000000	447600383	5961274	2023-10-31T00:24:55.000Z	0xbc3c24517cbe1727fd8d5e61982769a6aea5750b399f10eb4929cfb6691842d0
0x0b25c51637c43decd6cc1c1e3da4518d54ddb528	false	0xcf77a3ba9a5ca399b7c97c74d54e5b1beb874e43	7	120375198630672302643	101570467	5964260	2023-10-31T02:04:27.000Z	0x4b88da747164a6b2a81537aa9fdaf9c01da966dfef1d596b34d94f3088d10156
0x0b25c51637c43decd6cc1c1e3da4518d54ddb528	false	0xcf77a3ba9a5ca399b7c97c74d54e5b1beb874e43	8	3019252466756035805184	2510929701	5963924	2023-10-31T01:53:15.000Z	0xc2871e401aa86abd539f0a7c8710315c512bedfa61bb81aba04d7873d02124da

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aerodrome_v1_base.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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount0In	in_amount1Out	block_timestamp	transaction_hash
0xad2a93c62373c5d4d77c253dd3fc72a7e3090f3e	0x688f778c51db4d990bf1abaf8d33fd95e48c6641	false	0xcf77a3ba9a5ca399b7c97c74d54e5b1beb874e43	14	10066475	562295030842417171671	127114236902867291934	2024-02-03T01:04:57.000Z	0x59abbd34c7029996859aaede41c90f3fb8744879d8a553ec4752cb510b9ea77f
0xc8b1487c06bc8680305f952c9d78bc54c7e018fd	0xf89042057d079debe2a65a1a899e48e0e825105f	false	0x45aa5359e755386710285cb8d5ffd7c9583672f0	6	10099243	6708812224649365	5101540021235571808547	2024-02-03T19:17:13.000Z	0xbc5f0165af50fe20621f985dee5069481b938d259e66e37ecb4db8fa6bae6c89
0xb556ee2761f5d2887b8f35a7dda367abd20503bf	0x2d25e0514f23c6367687de89bd5167dc754d4934	false	0xcf77a3ba9a5ca399b7c97c74d54e5b1beb874e43	44	10076715	583018256000448	16975560029582266323	2024-02-03T06:46:17.000Z	0x640fa96a743655fffac2680621a54775d23e4a3d7f7c02e962bfc070bd66472e

Example Query

Query with partition filter

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

Pool_Sync_event

Liquidity pool reserve balance updates from Aerodrome V1 AMM (Automated Market Maker) on Base chain. Used for tracking pool composition changes and calculating real-time token prices from reserve ratios.

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_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x80218eea7490d4a7c48b7a98a2d6373246eb25b1	false	27	562079501957463915	168373888076296017531019605	3867136	2023-09-12T13:00:19.000Z	0x84cd5df61dad08766a92c15bfb76491c75ce0fc6d6aa27121d563e4a3cc5cea9
0x6eab8c1b93f5799dadf2c687a30230a540dbd636	false	23	3398869250974682958727178	2974334272408	3867648	2023-09-12T13:17:23.000Z	0x1c494631aeb2ac5283823c7e22332feec02522ef59ad06fa2938a7422bf15d3a
0x5f45e48f9c053286ce9ca08db897f8b7eb3f7992	false	20	280214318827726380001	213458994240470218165	3867904	2023-09-12T13:25:55.000Z	0x978bfe0ad83f2b48b849f030f6fa4a981d3091b211c3a5cb921853d0b1d7b01d

Example Query

Query with partition filter

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

Pool_Transfer_event

Liquidity pool token transfer events emitted when LP (Liquidity Provider) tokens are minted, burned, or transferred between addresses. Contains sender, recipient, and token amount for tracking pool share ownership and liquidity position 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x92b2ea322c96745498273187e0c9d9d8005eaba5	0x0b25c51637c43decd6cc1c1e3da4518d54ddb528	0x0000000000000000000000000000000000000000	false	189116001680	34	9381195	2024-01-18T04:22:17.000Z	0x0b24c62ae00e055c151479edea3b9d24a7b7a4a7ac088188bb650ff4dfe4fb8a
0xeae066c25106006fb386a3a8b1698a0cb6931c1a	0x0b25c51637c43decd6cc1c1e3da4518d54ddb528	0x92b2ea322c96745498273187e0c9d9d8005eaba5	false	189116001680	40	9381195	2024-01-18T04:22:17.000Z	0x0b24c62ae00e055c151479edea3b9d24a7b7a4a7ac088188bb650ff4dfe4fb8a
0xeae066c25106006fb386a3a8b1698a0cb6931c1a	0x0b25c51637c43decd6cc1c1e3da4518d54ddb528	0x92b2ea322c96745498273187e0c9d9d8005eaba5	false	632646921809	86	9414741	2024-01-18T23:00:29.000Z	0x0a6ba275bb6c6471746ff95e30d8bec992c00580554e507b867f949c3bd61e14

Example Query

Query with partition filter

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

Voter_GaugeCreated_event

Gauge creation events emitted when new liquidity mining gauges are deployed for liquidity pools in vote-escrowed token (veToken) protocols. Links pool addresses to their corresponding gauge contracts and associated reward distribution mechanisms for governance-driven liquidity incentives.

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_poolFactory`	`STRING`	Contract address of the pool factory that created the liquidity pool associated with this gauge. This is the Aerodrome factory contract responsible for deploying pool contracts on Base.
`in_votingRewardsFactory`	`STRING`	Contract address of the factory that deploys voting rewards contracts for this gauge on Base. Always 0x45ca74858c579e717ee29a86042e0d53b252b504 in this dataset.
`in_gaugeFactory`	`STRING`	Contract address of the factory that deployed the gauge contract for this liquidity pool. This address is consistent across all gauge creation events, indicating a single factory deploys all gauges in the Aerodrome system.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_bribeVotingReward`	`STRING`	Contract address of the voting reward distribution contract for bribes associated with this gauge. Users who vote for this gauge through the Voter contract can claim bribe rewards from this contract address.
`in_feeVotingReward`	`STRING`	Contract address of the fee-based voting reward distributor for this gauge. Hex-encoded, 0x-prefixed 40-character address created alongside the gauge to distribute trading fees to voters.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_gauge	log_index	in_creator	block_number	in_poolFactory	block_timestamp	in_gaugeFactory	transaction_hash	in_feeVotingReward	in_bribeVotingReward	in_votingRewardsFactory
0x16613524e02ad97edfef371bc883f2f5d6c480a5	0x67c247ea8ac79cba228d0fd9ec3c884c9dc58271	false	0x3d71e08d283e275a6dcee6436002c0348413abb8	8	0x7c415789bfd497264adecac1bec5ac56d88f7872	4994592	0x420dd381b31aef6683db6b902084cb0ffece40da	2023-10-08T15:22:11.000Z	0x35f35ca5b132cadf2916bab57639128eac5bbcb5	0xf525687d7c60f8aa112b99b74a9a40c71ade2b1ed4a12007e6322e394b2fa6b5	0xe08a47322304a5988daf9486c7c46de8c2261ab1	0xc890cd746bcef1c8fc3703481685ccb358d323f9	0x45ca74858c579e717ee29a86042e0d53b252b504
0x16613524e02ad97edfef371bc883f2f5d6c480a5	0x23084f461e37d6009faefa5778ecb253bb72169d	false	0x0a1278f47317a1313369dc466f5e42ab766c46eb	28	0xd3a31c6f99dbacf7eb9f0906bf1a038874eef294	4983491	0x420dd381b31aef6683db6b902084cb0ffece40da	2023-10-08T09:12:09.000Z	0x35f35ca5b132cadf2916bab57639128eac5bbcb5	0xf4c74f0ace8d08f9effe49ca3d48bd061a7e0f776bc39b61ce7272823e00d333	0x98b510b0c4cfcd25a4c195a82f1f20578cbc970b	0x36e5d096fd479d469120d021bb793c26cf28e57d	0x45ca74858c579e717ee29a86042e0d53b252b504
0x16613524e02ad97edfef371bc883f2f5d6c480a5	0xded5d28998f2b9796ba587f6ae39d4be11967209	false	0x3d7da85886dcb807d502bbf4b7b469c58e4efa39	0	0x02e0c302380aa679189d9caa349a0da5a6a19108	4973899	0x420dd381b31aef6683db6b902084cb0ffece40da	2023-10-08T03:52:25.000Z	0x35f35ca5b132cadf2916bab57639128eac5bbcb5	0x0cfeba9027603a1a2d821c0a01bb2b614f11ceb5a919df1d3ad7918196cf429e	0x70c37882b82896597aa3ec630acbe1bc4d6c889f	0x461f64e54f1babf31a589da5fbe28520b013c3ba	0x45ca74858c579e717ee29a86042e0d53b252b504

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

BribeVotingReward_NotifyReward_event

Factory_PoolCreated_event

Gauge_ClaimRewards_event

Pool_Burn_event

Pool_Claim_event

Pool_Fees_event

Pool_Mint_event

Pool_Swap_event

Pool_Sync_event

Pool_Transfer_event

Voter_GaugeCreated_event

​Tables

​BribeVotingReward_NotifyReward_event

​Factory_PoolCreated_event

​Gauge_ClaimRewards_event

​Pool_Burn_event

​Pool_Claim_event

​Pool_Fees_event

​Pool_Mint_event

​Pool_Swap_event

​Pool_Sync_event

​Pool_Transfer_event

​Voter_GaugeCreated_event

Tables

BribeVotingReward_NotifyReward_event

Factory_PoolCreated_event

Gauge_ClaimRewards_event

Pool_Burn_event

Pool_Claim_event

Pool_Fees_event

Pool_Mint_event

Pool_Swap_event

Pool_Sync_event

Pool_Transfer_event

Voter_GaugeCreated_event