etherex_v3_linea - Token Terminal Docs

Tables

ClGaugeFactory_FeeCollectorChanged_event

Event log tracking fee collector address changes in the Etherex v3 CL (Concentrated Liquidity) Gauge Factory on Linea. Records old and new fee collector addresses for monitoring protocol treasury and fee routing updates.

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_newFeeCollector`	`STRING`	Address of the new fee collector contract after a fee collector update. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldFeeCollector`	`STRING`	Address of the previous fee collector contract before a fee collector update. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFeeCollector	in_oldFeeCollector
0x499aed38bdafd972e1cd2926d2b9088547dd8fcb	false	6	21719263	2025-08-07T05:39:24.000Z	0xe8b1579697c0e8611235f02632d8b505caa3ad0d31652911fd7c0f4cc2319772	0x532c15d1803f565ad37b77f5b20d9e3a4254e0f3	0x51a2a0b162d27254e30473b7072d95f4b37f21a1

Example Query

Query with partition filter

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

ClGaugeFactory_GaugeCreated_event

Gauge deployment events from Etherex V3 concentrated liquidity (CL) gauge factory on Linea, linking liquidity pools to their reward distribution contracts. Used to track liquidity mining program initialization and pool incentive setup.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_gauge	log_index	block_number	block_timestamp	transaction_hash
0x499aed38bdafd972e1cd2926d2b9088547dd8fcb	0xceecf8c29f04d0cd99801de1fa628e776f928ea6	false	0x57d5b72a505d7a48e4fc6e727ffb6b5e97148db1	44	21920417	2025-08-11T23:10:47.000Z	0x9ab6c1954b17b8bed6d3712c7edf8adb7f3d549cfaf9476b428d0f489704dd58
0x499aed38bdafd972e1cd2926d2b9088547dd8fcb	0x90e8a5b881d211f418d77ba8978788b62544914b	false	0x640f551d349f199710b89fe1a209ad75499eb520	9	21719553	2025-08-07T05:49:19.000Z	0x2a914671bdf614d7972dadd1e29fce21634c9868a23014ba56534fd06a02266d
0x499aed38bdafd972e1cd2926d2b9088547dd8fcb	0x35521ec62d91375ac9510d1feefe254b4b582ea0	false	0x9d13bdb9f78307565415bb0dc46733803b9689f5	11	21712378	2025-08-07T01:43:36.000Z	0x6568312051a3a64a26301267ea9fe6552c1f1847a37341037bd53e9d42903bb9

Example Query

Query with partition filter

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

ClGaugeFactory_VoterChanged_event

No description available.

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_newVoter`	`STRING`	-
`in_oldVoter`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Factory_PoolCreated_event

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

Columns

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

Sample Data

in_fee	address	in_pool	removed	in_token0	in_token1	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
100	0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	0x29f447a167f53afd5f4269e8b713eb340f5636bc	false	0xc93b315971a4f260875103f5da84cb1e30f366cc	0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f	6	21696811	1	2025-08-06T16:31:14.000Z	0x582cd59a7910709cd28f6a6d48e6d2aa4c844f435b674899a57ba5f441f849f3
100	0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	0x2cabe621645b2722b46b768e08f25e483f6a8faa	false	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f	2	21706548	1	2025-08-06T22:18:22.000Z	0x433f0e72ec4a43251516f41e05a9ad82928cc21b075fb97ac1d6384e7b099e43
500	0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	0x17383d80043eb46472306c1bf603e305fbc4cb0f	false	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f	16	21706342	10	2025-08-06T22:10:41.000Z	0xe80176dc253b925cb3ab879470471ee1b010afaedea8489372e7f3f28e77ec48

Example Query

Query with partition filter

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

FeeDistributorFactory_createFeeDistributor_function

Factory function call records for creating new FeeDistributor contracts on Etherex V3 (Linea), capturing the deployed distributor address and designated fee recipient. Used to track fee distribution infrastructure deployment and identify protocol participants receiving trading fees.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_feeRecipient`	`STRING`	Address designated to receive fees collected from the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	out_anon0	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_feeRecipient	transaction_hash
3615495	true	1369604	0x119294951aa94a099a058f7c962f81bbc1219308	0x062e631e	0xfde48794f3ea7f26cd2b00f078366455b1e6b7bf	21920417	0x942117ec0458a8aa08669e94b52001bd43f889c1	0,0,0,0,3	2025-08-11T23:10:47.000Z	0x532c15d1803f565ad37b77f5b20d9e3a4254e0f3	0x9ab6c1954b17b8bed6d3712c7edf8adb7f3d549cfaf9476b428d0f489704dd58
5393403	true	1369626	0xec6271e42c18245e48b9b5af34c7864a91029f56	0x062e631e	0xfde48794f3ea7f26cd2b00f078366455b1e6b7bf	21995412	0x942117ec0458a8aa08669e94b52001bd43f889c1	0,0,0,0,3	2025-08-13T17:16:20.000Z	0xa564587e93d50cfac81bee8b5ee0a3d85b70d683	0x2b7cf4461b51e753165bcd81be03347ee03a64e889111e2da3657924d27c4dec
117125	false	78083		0x062e631e	0xfde48794f3ea7f26cd2b00f078366455b1e6b7bf	21716808	0xcafc58de1e6a071790efbb6b83b35397023e1544		2025-08-07T04:15:23.000Z	0x532c15d1803f565ad37b77f5b20d9e3a4254e0f3	0x5bb5c2ce880d2da6f2632b9a93b545400ffba0e64e197e383e22469930adefae

Example Query

Query with partition filter

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

GaugeV3_Bribe_event

No description available.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_period`	`STRING`	Numeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

GaugeV3_ClaimRewards_event

Reward claim events from Etherex V3 gauge contracts on Linea, tracking periodic token distributions to liquidity providers by position hash. Used for analyzing reward accrual patterns and LP incentive distribution across DeFi positions.

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_period`	`STRING`	Numeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.
`in__positionHash`	`STRING`	Unique identifier hash representing a specific liquidity position in the GaugeV3 contract for which rewards are being claimed. Hex-encoded, 0x-prefixed 64-character string used to track individual staking positions across multiple reward claims.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	in_period	in_reward	log_index	in_receiver	block_number	block_timestamp	in__positionHash	transaction_hash
0x06389a1942dd864e7b5013aa6242b1341a5b533d	false	10328796350062271282	2903	0xefd81eec32b9a8222d1842ec3d99c7532c31e348	7	0x05e43985a506a52fdab33fd81036152092c3d779	22500820	2025-08-25T17:21:24.000Z	0x2cc6d286f7f5a47c39516880cb778b95b50d34e11258591721f8721b54c8d00c	0x33955492fcf54430866712a1cdedf763052b8a136a578bebf7eaec691472e44d
0x06389a1942dd864e7b5013aa6242b1341a5b533d	false	2665292805544459660	2903	0xefd81eec32b9a8222d1842ec3d99c7532c31e348	1	0x05e43985a506a52fdab33fd81036152092c3d779	22506855	2025-08-25T20:49:12.000Z	0x69bce0c1db8cd324b387c8f2d82bf169f14bb2dcaa52a4e0732228e42a3f9e38	0x6afb195527d7d92ca24b59aa0685c50035cc55fd9698be248ca5cd638cc1a1f0
0x06389a1942dd864e7b5013aa6242b1341a5b533d	false	4406451253304450094	2903	0xefd81eec32b9a8222d1842ec3d99c7532c31e348	1	0x05e43985a506a52fdab33fd81036152092c3d779	22472260	2025-08-25T01:00:26.000Z	0xa3613919c0fe8bd36a931afaf84cc61682b46301ccd36b2d70fa648cbb70517d	0x28ac02a7af7119bf33cb8d5dfb3d9959fc6d50ec9cfb55248b61352bea3f89f3

Example Query

Query with partition filter

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

GaugeV3_NotifyReward_event

Reward distribution events from Etherex V3 liquidity gauge contracts on Linea, recording token rewards allocated to gauge addresses per voting period. Used for tracking incentive distributions and analyzing reward flows across different 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_period`	`STRING`	Numeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.

Sample Data

address	in_from	removed	in_amount	in_period	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x131477df62837097ec4c795d39cc1f059426ee58	0xde4b22eb9f9c2c55e72e330c87663b28e9d388f7	false	59498298196165287866071	2902	0xefd81eec32b9a8222d1842ec3d99c7532c31e348	21	22013504	2025-08-14T03:27:45.000Z	0x745e655e90e33c0bb8d96a8a04b17246e35767ce876dce7ae92ecbe139fb4725
0x95b07e2774657738f7f0d5c5490dfebae057446a	0x942117ec0458a8aa08669e94b52001bd43f889c1	false	6178196640597788899	2902	0xefd81eec32b9a8222d1842ec3d99c7532c31e348	255	22007324	2025-08-14T00:00:27.000Z	0xcf8a368557146b5c76202883e6528b31e721b7663cc82d5f6b8a99a647298ff2
0x8e019479d6165797b800073d5275bc36ec9d0268	0x942117ec0458a8aa08669e94b52001bd43f889c1	false	25214631921477533142625	2902	0xefd81eec32b9a8222d1842ec3d99c7532c31e348	182	22007324	2025-08-14T00:00:27.000Z	0xcf8a368557146b5c76202883e6528b31e721b7663cc82d5f6b8a99a647298ff2

Example Query

Query with partition filter

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

GaugeV3_RewardAdded_event

RewardAdded event logs from Etherex V3 gauge contracts on Linea, capturing when reward tokens are added to liquidity mining gauges. Used for tracking incentive programs and reward token distributions across different gauge contracts.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x57d5b72a505d7a48e4fc6e727ffb6b5e97148db1	false	0x5217ab28ece654aab2c68efedb6a22739df6c3d5	40	21920417	2025-08-11T23:10:47.000Z	0x9ab6c1954b17b8bed6d3712c7edf8adb7f3d549cfaf9476b428d0f489704dd58
0x57d5b72a505d7a48e4fc6e727ffb6b5e97148db1	false	0xefd81eec32b9a8222d1842ec3d99c7532c31e348	42	21920417	2025-08-11T23:10:47.000Z	0x9ab6c1954b17b8bed6d3712c7edf8adb7f3d549cfaf9476b428d0f489704dd58
0x57d5b72a505d7a48e4fc6e727ffb6b5e97148db1	false	0xb1afd04774c02ae84692619448b08ba79f19b1ff	41	21920417	2025-08-11T23:10:47.000Z	0x9ab6c1954b17b8bed6d3712c7edf8adb7f3d549cfaf9476b428d0f489704dd58

Example Query

Query with partition filter

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

GaugeV3_RewardRemoved_event

No description available.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.etherex_v3_linea.GaugeV3_RewardRemoved_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
0x67d00a094f9c481222d092363b8badda520986bf	false	0xa04a9f0a961f8fcc4a94bcf53e676b236cbb2f58	0	15	0	0	21959848	-887250	887250	2025-08-12T21:18:59.000Z	0xf1c904d268614844027a0dce5039c30b69f9507cd1e6d68e318256fc68d1a329
0x90e8a5b881d211f418d77ba8978788b62544914b	false	0xa04a9f0a961f8fcc4a94bcf53e676b236cbb2f58	807270489262	2	52919032	12314768688307622	21931149	-887250	887250	2025-08-12T05:15:14.000Z	0x046c22682755c51c447c871bcf91d9fbbe338ea27e335301307ca3e24bb6d11f
0xd643364f9c97bbf76f822b1249570ab0aa4e1044	false	0xa04a9f0a961f8fcc4a94bcf53e676b236cbb2f58	0	6	0	0	21960273	-887200	887200	2025-08-12T21:33:18.000Z	0x0945294d8fe506e7542c205f81e3a53244a95d32d07a5922f3aa57a737f5d178

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.etherex_v3_linea.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
0x67d00a094f9c481222d092363b8badda520986bf	false	0xa04a9f0a961f8fcc4a94bcf53e676b236cbb2f58	22	963138311626541	2270407191369069	22387366	0x97d37e8b619cf4c6145da456766ca4fa157292d3	-887250	887250	2025-08-23T00:05:13.000Z	0x04d67a41c7bec06d69c64051d4824a74b2f921ded0a18a65e4dece988d23802d
0x9628b1b2af4c8b5ffa9188003516331d99cdc715	false	0xa04a9f0a961f8fcc4a94bcf53e676b236cbb2f58	15	7665876147232790	152262911197	22400564	0x421cc7b6224accb6c12280e3b697c65d9d60ad70	-887200	-45600	2025-08-23T07:38:46.000Z	0x7f8a6e6dce796830f9f5e62ce805f5b3bb2e11b1e9e31870534e3dfa8a7d721c
0xd643364f9c97bbf76f822b1249570ab0aa4e1044	false	0xa04a9f0a961f8fcc4a94bcf53e676b236cbb2f58	17	59195419498065729637421	1473230106583329	22413614	0x65de75ce24349b1ff4b2902922f433166021d445	-887200	887200	2025-08-23T14:59:31.000Z	0x058a11e0fb65933a8d5fb7d7a844b3e7398d67b0ffef239161769680fcb49b4e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.etherex_v3_linea.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_paid1	in_sender	log_index	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0xd5e04ba35908d7bf5bd2ead7e3e14d21df07dc01	false	3711990127817	0x2423273054d7daa416ff77da5ca2dedad744f58c	19	1613908751224447	22913538	0x2423273054d7daa416ff77da5ca2dedad744f58c	2025-09-04T15:11:40.000Z	0xe144fc7d0f43015b93a74d849929c1eca23d9af741d05a830660b7dc9b832df3
0xd5e04ba35908d7bf5bd2ead7e3e14d21df07dc01	false	12729409619371	0x2423273054d7daa416ff77da5ca2dedad744f58c	33	6699689273353142	22891789	0x2423273054d7daa416ff77da5ca2dedad744f58c	2025-09-04T03:02:13.000Z	0xa700e9422619ea07cbbc3540bd41e45c5a0eb0dc2163258cc17240a6d95d78d4
0xd5e04ba35908d7bf5bd2ead7e3e14d21df07dc01	false	15324712674118	0x2423273054d7daa416ff77da5ca2dedad744f58c	32	4788972710661782	22911690	0xd4c69bcd53aaf29fcb47c47b81c172d72fae62bb	2025-09-04T14:09:48.000Z	0xc65a6ada9f463ffabc4d127459822eab26b5b8cf63b8766f15aee52901fe5b40

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.etherex_v3_linea.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
0x3186fa80e4c36d0714b0578f51c45a76a7ba11cc	false	0xa04a9f0a961f8fcc4a94bcf53e676b236cbb2f58	5393648598423601356516	0xa04a9f0a961f8fcc4a94bcf53e676b236cbb2f58	151	83648903697355943031586	8141965611051224	23017063	-156600	-156400	2025-09-07T03:32:17.000Z	0x29512efc3292f4aa3dae1dd6dd8560a7f229d855256906c165c3147dcd2aaf6e
0x3186fa80e4c36d0714b0578f51c45a76a7ba11cc	false	0xa04a9f0a961f8fcc4a94bcf53e676b236cbb2f58	670109017682095058362	0xa04a9f0a961f8fcc4a94bcf53e676b236cbb2f58	77	8178065792571623110830	1365093135593069	23022405	-156600	-156400	2025-09-07T06:42:54.000Z	0x85ef4daea5f857ab7719dff717248fe8565198c1521646c8ddee59e3701d4fbf
0x3186fa80e4c36d0714b0578f51c45a76a7ba11cc	false	0xa04a9f0a961f8fcc4a94bcf53e676b236cbb2f58	575033157416942218687	0xa04a9f0a961f8fcc4a94bcf53e676b236cbb2f58	75	7017752142080449613224	1171412106411429	23022433	-156600	-156400	2025-09-07T06:43:50.000Z	0x3ab1fa9f43f1e7c0dbc02155877bb3247bf82e6e02f3561a10dacadc46d6f087

Example Query

Query with partition filter

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

Pool_SetFeeProtocol_event

Protocol fee configuration change events emitted when liquidity pool fee parameters are updated. Records old and new fee protocol values for both tokens in the pool, tracking governance-initiated fee structure modifications.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_feeProtocol0Old`	`INT64`	Previous protocol fee for token0. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
`in_feeProtocol1Old`	`INT64`	Previous protocol fee for token1. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
`in_feeProtocol0New`	`INT64`	New protocol fee for token0. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.
`in_feeProtocol1New`	`INT64`	New protocol fee for token1. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_sqrtPriceX96`	`STRING`	Square root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_tick`	`INT64`	Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.

Sample Data

address	in_tick	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	in_recipient	block_timestamp	in_sqrtPriceX96	transaction_hash
0xe5e765ae9bc8bf39beba2c3f5bb3be7fa5676fbd	276323	false	0x85974429677c2a701af470b82f3118e74307826e	3	3117902234	-3116563287056899664686	23036167	235846653072721901254561	0x008c59ae43b473ba5a18a6fb3dc8cbf67b1eff12	2025-09-07T14:30:18.000Z	79226995341771947944986504906523569	0x9f53a82b800c33d5867b6644614cc5af7de40d1bf079e5078c75584cb72cc200
0xe5e765ae9bc8bf39beba2c3f5bb3be7fa5676fbd	276323	false	0x85974429677c2a701af470b82f3118e74307826e	9	3200231481	-3198856899455785229086	23036198	235846653072721901254561	0x008c59ae43b473ba5a18a6fb3dc8cbf67b1eff12	2025-09-07T14:31:20.000Z	79226991873375255624482632167987304	0xc2509280625ee79567aaafb98f22e26b67bd7ffce08f7dad2cc942c67b7ea135
0xe5e765ae9bc8bf39beba2c3f5bb3be7fa5676fbd	276323	false	0x85974429677c2a701af470b82f3118e74307826e	8	-3200851695	3202038062000000000000	23036229	235846653072721901254561	0x008c59ae43b473ba5a18a6fb3dc8cbf67b1eff12	2025-09-07T14:32:22.000Z	79226994141683873524567625581224353	0xa18c02e8649f2d09995504cbe700308bf800e575900185bbad78b64cb6314be3

Example Query

Query with partition filter

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

PoolFactory_FeeAdjustment_event

Fee adjustment events from EthereX v3 liquidity pools on Linea, recording when pool trading fees are updated by the factory contract. Useful for tracking fee tier changes and protocol governance decisions affecting specific pool addresses.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

address	in_pool	removed	in_newFee	log_index	block_number	block_timestamp	transaction_hash
0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	0x893e58e142df9e07c4aed7753440b807ffff8170	false	1000	4	21772758	2025-08-08T11:38:07.000Z	0x01636bc165df35d8f085b19e25b03aa2ff61f7556ba29629d291eb7bfcf02834
0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	0xc0cd56e070e25913d631876218609f2191da1c2a	false	1000	11	21759431	2025-08-08T04:11:05.000Z	0x119c267095d0bdb5643375052642597b41625f621feda1f6d57f7101c6f20ad7
0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	0xd5e04ba35908d7bf5bd2ead7e3e14d21df07dc01	false	1000	3	21770006	2025-08-08T10:05:07.000Z	0x158fa27fb631e04aa6816386dcc8711c79bc73c9d9336fad61fc48258a91a38e

Example Query

Query with partition filter

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

PoolFactory_FeeCollectorChanged_event

Fee collector address update events from the Etherex V3 protocol’s pool factory contract on Linea. Tracks administrative changes to the address that receives protocol fees, useful for monitoring fee routing and governance actions.

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_oldFeeCollector`	`STRING`	Address of the previous fee collector contract before a fee collector update. Hex-encoded, 0x-prefixed, 42-character string.
`in_newFeeCollector`	`STRING`	Address of the new fee collector contract after a fee collector update. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFeeCollector	in_oldFeeCollector
0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	false	15	21716187	2025-08-07T03:53:36.000Z	0x37197ff4cca41cf49142a7e7a0ead93ea197d8693b46f339eee83bf74d7fba7b	0x532c15d1803f565ad37b77f5b20d9e3a4254e0f3	0x51a2a0b162d27254e30473b7072d95f4b37f21a1
0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	false	7	21436112	2025-07-29T21:09:02.000Z	0xcdfa076620fc312eb6411e13a0c36f10b8ea2f97a1bed97f5600fb8e52ca2547	0x51a2a0b162d27254e30473b7072d95f4b37f21a1	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

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

PoolFactory_SetFeeProtocol_event

Protocol fee configuration change events from Etherex V3 PoolFactory contract on Linea. Tracks historical adjustments to protocol fee rates (measured in basis points) for analyzing fee policy changes and protocol revenue 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_feeProtocolOld`	`STRING`	Previous protocol fee configuration value before the update. Integer representing the fee percentage allocated to the protocol from trading fees.
`in_feeProtocolNew`	`STRING`	Updated protocol fee configuration value being set. Integer representing the fee percentage allocated to the protocol from trading fees.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_feeProtocolNew	in_feeProtocolOld
0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	false	11	21254948	2025-07-25T01:42:24.000Z	0x21afac7ffc23ef9d06017178649cb62f9effe4e2837d757ea0782ec80ca819e2	50000	0

Example Query

Query with partition filter

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

PoolFactory_SetPoolFeeProtocol_event

Protocol fee configuration change events from Etherex V3 liquidity pools on Linea. Tracks updates to pool-level fee parameters for analyzing protocol revenue adjustments and governance actions.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_feeProtocolOld`	`STRING`	Previous protocol fee configuration value before the update. Integer representing the fee percentage allocated to the protocol from trading fees.
`in_feeProtocolNew`	`STRING`	Updated protocol fee configuration value being set. Integer representing the fee percentage allocated to the protocol from trading fees.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash	in_feeProtocolNew	in_feeProtocolOld
0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	0x90e8a5b881d211f418d77ba8978788b62544914b	false	9	21719646	2025-08-07T05:52:25.000Z	0xad1b11799032506c8518340ee41ced6a82409d783595986a14c47aadb35c8206	1000000	1000000
0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	0xd5e04ba35908d7bf5bd2ead7e3e14d21df07dc01	false	12	21720340	2025-08-07T06:15:33.000Z	0xe7fba38dd2ee39ba0bcbd286656e4d66f11a9a06cadc4cad0013d78cb745644b	1000000	1000000
0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	0x3186fa80e4c36d0714b0578f51c45a76a7ba11cc	false	11	21720340	2025-08-07T06:15:33.000Z	0xe7fba38dd2ee39ba0bcbd286656e4d66f11a9a06cadc4cad0013d78cb745644b	1000000	1000000

Example Query

Query with partition filter

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

PoolFactory_TickSpacingEnabled_event

TickSpacingEnabled events from Etherex V3 PoolFactory contract on Linea, recording enabled fee tier and tick spacing pairs for liquidity pool creation. Used to track available pool configuration options and protocol governance 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_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`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.

Sample Data

in_fee	address	removed	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
3000	0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	false	8	21254948	50	2025-07-25T01:42:24.000Z	0x21afac7ffc23ef9d06017178649cb62f9effe4e2837d757ea0782ec80ca819e2
100	0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	false	5	21254948	1	2025-07-25T01:42:24.000Z	0x21afac7ffc23ef9d06017178649cb62f9effe4e2837d757ea0782ec80ca819e2
10000	0xae334f70a7fc44fcc2df9e6a37bc032497cf80f1	false	9	21254948	100	2025-07-25T01:42:24.000Z	0x21afac7ffc23ef9d06017178649cb62f9effe4e2837d757ea0782ec80ca819e2

Example Query

Query with partition filter

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

REX33_ClaimedIncentives_event

No description available.

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_feeDistributors`	`ARRAY<STRING>`	Array of fee distributor contract addresses from which incentives were claimed. Hex-encoded, 0x-prefixed, 42-character strings.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

REX33_Compounded_event

No description available.

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_oldRatio`	`STRING`	Previous ratio value before the state change. Numeric string representation in wei (18 decimal places).
`in_newRatio`	`STRING`	Updated ratio value after the state change. Numeric string representation in wei (18 decimal places).
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

REX33_Deposit_event

No description available.

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_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

REX33_Entered_event

No description available.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol 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.
`in_ratioAtDeposit`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

REX33_Exited_event

No description available.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__outAmount`	`STRING`	-
`in_ratioAtWithdrawal`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

REX33_Rebased_event

No description available.

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_oldRatio`	`STRING`	Previous ratio value before the state change. Numeric string representation in wei (18 decimal places).
`in_newRatio`	`STRING`	Updated ratio value after the state change. Numeric string representation in wei (18 decimal places).
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

REX33_SwappedBribe_event

No description available.

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_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenIn`	`STRING`	Contract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

REX33_Unlocked_event

No description available.

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__ts`	`STRING`	Timestamp when the data was ingested into the system. Unix epoch time in seconds, stored as a string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

REX33_UpdatedIndex_event

No description available.

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__index`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

REX33_Withdraw_event

No description available.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. 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_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

VoteModule_ClaimRewards_event

Reward claim events from EthereX v3 governance VoteModule on Linea, recording when users withdraw their accumulated voting rewards. Useful for analyzing governance participation incentives and reward distribution patterns across voter addresses.

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
0xedd7cbc9c47547d0b552d5bc2be76135f49c15b1	0x67b87c5eb551f9beb2b9d29af28cf22bfcb43952	false	556038978979638032	5	22798687	2025-09-01T21:48:04.000Z	0x313cac44847bd6344432e7cc31f614250f7edad096760cd62342119607a7913d
0xedd7cbc9c47547d0b552d5bc2be76135f49c15b1	0x932951390dda96536217ac6ea8941f54ea90a30a	false	365804235079282032	5	22782228	2025-09-01T12:14:44.000Z	0xdb94bf098b14e6509f33894e6529b4930951642aa7351295be16ba5bd78d05da
0xedd7cbc9c47547d0b552d5bc2be76135f49c15b1	0xab58779cec2b82a75ffd103fdc88d7e3adb13468	false	182902110480340645246	5	22802150	2025-09-01T23:59:53.000Z	0xa834a468ec1a50466a89189cef4cde5ce895f5787a5fd82d8ff055ee3130616b

Example Query

Query with partition filter

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

VoteModule_Deposit_event

Deposit events from Etherex V3 VoteModule contract on Linea, recording token deposits with depositor addresses and amounts in wei. Used for tracking governance participation and voting power accumulation in the Etherex protocol.

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
0xedd7cbc9c47547d0b552d5bc2be76135f49c15b1	0x4a1655bba47a6fbd3b86d5c91314b97629301a57	false	101507610026522328846	1	22206097	2025-08-18T16:58:37.000Z	0x4cde296218e10446cf5f6532a082708ae3c305da9a9f553115e5620facccde2c
0xedd7cbc9c47547d0b552d5bc2be76135f49c15b1	0xf7d6b097e1e212269e0b6ba00939f3a34869c34c	false	153530202008267201545	1	22210058	2025-08-18T19:14:13.000Z	0xb18e84ffdcf2f68badfeea867679062948c2efc6db917a49b9a370bebc22e5cb
0xedd7cbc9c47547d0b552d5bc2be76135f49c15b1	0xce11d6a53cb9527cca0237b0b7a1f4133739b13d	false	101991358258681473409	1	22195452	2025-08-18T10:55:47.000Z	0x08e1b3a64e60ab4cbb4b146909388b0c275410a3afef8e07cf421f93677caa61

Example Query

Query with partition filter

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

VoteModule_NotifyReward_event

Reward notification events from Etherex V3’s VoteModule contract on Linea, capturing reward distributions with sender addresses and token amounts. Used for tracking governance incentive flows and reward distribution patterns in the protocol’s voting system.

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
0xedd7cbc9c47547d0b552d5bc2be76135f49c15b1	0xc93b315971a4f260875103f5da84cb1e30f366cc	false	191957654445687670690548	42	22596070	2025-08-28T00:08:55.000Z	0x89eca6b2085527f7f53d27255764ff664f19a7efe18d8e111370096d89a05049
0xedd7cbc9c47547d0b552d5bc2be76135f49c15b1	0xc93b315971a4f260875103f5da84cb1e30f366cc	false	2520274777311857563161661	24	22007813	2025-08-14T00:16:45.000Z	0x341a998e1a1dd6a7a08238e1522c67c93facc2d7efb2929ac6708e9cd7049682
0xedd7cbc9c47547d0b552d5bc2be76135f49c15b1	0xc93b315971a4f260875103f5da84cb1e30f366cc	false	114525307832470843632090	54	22886387	2025-09-04T00:00:15.000Z	0x43f56948ed9869e0f26cd806676495f2e9a9eda59029272e6eace568234b0a71

Example Query

Query with partition filter

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

VoteModule_Withdraw_event

Withdrawal events from Etherex v3’s VoteModule contract on Linea, tracking token removals with user addresses and withdrawal amounts. Used for analyzing governance participation outflows and voting token liquidity 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_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
0xedd7cbc9c47547d0b552d5bc2be76135f49c15b1	0x9032ceeef231fe3bdcda63805bdf80b496ceb209	false	174668242095029038429	4	22210262	2025-08-18T19:21:23.000Z	0xcc6884d4de024100c3604341d5771c3d8c3695f1afc151eb9fe2bcc91cea1987
0xedd7cbc9c47547d0b552d5bc2be76135f49c15b1	0x4daf8ce9d729ca4f121381ec4b22123627c1c004	false	1166098297371043033018	4	22206022	2025-08-18T16:56:07.000Z	0xf87afeca2bdb0232ecebdce910655f403f46dcae0365be547e54ec43c6c8ff2b
0xedd7cbc9c47547d0b552d5bc2be76135f49c15b1	0x0eaa8e74a4ab0db986bacd48d92787919588ea1c	false	1000000000000000000	5	22195724	2025-08-18T11:04:53.000Z	0xe3680e4d3c1b1a9edc10ddd5283fc38d0f6b958cf80109d4b5c389a3856ce541

Example Query

Query with partition filter

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

Voter_claimIncentives_function

Function call logs for claimIncentives on Etherex V3 Voter contract on Linea, capturing users claiming trading fee incentives and rewards from specified fee distributor contracts and token addresses.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in__feeDistributors`	`ARRAY<STRING>`	Array of fee distributor contract addresses for claiming incentives or rewards. Each element is a hex-encoded, 0x-prefixed, 42-character string.
`in__tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Each element is a hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	status	gas_used	signature	in__tokens	to_address	block_number	from_address	block_timestamp	transaction_hash	in__feeDistributors
346068	true	104774	0x307f38fa	[]	0x942117ec0458a8aa08669e94b52001bd43f889c1	24092584	0x487295618a9072093e63f03e7c26c17be7eb4693	2025-10-03T08:35:44.000Z	0xe555717cf282b99a0e77aa7af798691e60eba5c9645a60f0fe545435b04cbd45	[]
207288	true	127079	0x307f38fa	[]	0x942117ec0458a8aa08669e94b52001bd43f889c1	24112350	0xd1fc48777a7a13d51e0eca886d9c03c516c15888	2025-10-03T20:26:07.000Z	0x92e36680ce89c36a00cbd5f7e988bbbcafbef3448ad7fc2d9008935c936655c9	[]
138192	true	127079	0x307f38fa	[]	0x942117ec0458a8aa08669e94b52001bd43f889c1	24098992	0x696fa99c4e826b7c13610a294362aeaec3934c5c	2025-10-03T12:30:43.000Z	0xa776f2519a156aef796ed77b8868b652bba833440495978c1576335ebf9bbf22	[]

Example Query

Query with partition filter

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

Voter_claimLegacyIncentives_function

Function call records for claiming legacy incentives from Etherex v3 Voter contract on Linea. Tracks claimLegacyIncentives executions with fee distributor and token parameters for analyzing incentive claim 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in__feeDistributors`	`ARRAY<STRING>`	Array of fee distributor contract addresses for claiming incentives or rewards. Each element is a hex-encoded, 0x-prefixed, 42-character string.
`in__tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Each element is a hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	status	gas_used	signature	in__tokens	to_address	block_number	from_address	block_timestamp	transaction_hash	in__feeDistributors
691496	true	608520	0xbb7041c2	[]	0x942117ec0458a8aa08669e94b52001bd43f889c1	25687206	0xf6ed81d5e9f61dd1ea21e96ae1d660ecc388ae4f	2025-11-15T18:34:43.000Z	0x36a3b8a1a68887a2219f0498c59dd55553e468fd4ba2323d138fb9c5a5bf99af	[]
980189	true	571653	0xbb7041c2	[]	0x942117ec0458a8aa08669e94b52001bd43f889c1	25668337	0x9979c0f7778c3fc09f9026115fcb1b7f0dde60e9	2025-11-15T04:53:43.000Z	0x7e68b9911ed14e6a2f7faa8ad0d38ab96b12945e2e5df4c692b82e97ea34c69a	[]
1334273	true	800447	0xbb7041c2	[]	0x942117ec0458a8aa08669e94b52001bd43f889c1	25672973	0x85172ae486468688ba6eed505e55103ec5e25dda	2025-11-15T08:28:03.000Z	0x54a699ae78ab987b3867f59dd8af1b5987cc48cded9c69b9a84bc65cd72f84cc	[]

Example Query

Query with partition filter

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

Voter_claimRewards_function

Reward claim transactions from Etherex V3 voting contract on Linea, where users collect accumulated incentives from liquidity gauge voting. Useful for tracking voter reward distribution patterns and participation in vote-escrowed tokenomics systems.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__gauges`	`ARRAY<STRING>`	Array of gauge contract addresses for claiming rewards. Each element is a hex-encoded, 0x-prefixed, 42-character string.
`in__tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Each element is a hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	status	gas_used	signature	in__gauges	in__tokens	to_address	block_number	from_address	block_timestamp	transaction_hash
158432	true	86873	0x20b1cb6f	[]	[]	0x942117ec0458a8aa08669e94b52001bd43f889c1	21867842	0x6957d2139d29e7db7913ac21e813f2a561e47ac8	2025-08-10T17:23:00.000Z	0x30cf1825f12323eee89483bcca2ed8534524ac42b899df43baeafc1e2b5649ac
105621	true	92473	0x20b1cb6f	[]	[]	0x942117ec0458a8aa08669e94b52001bd43f889c1	21866055	0x2ec703a921754d9947284a9672426d6a78170e5d	2025-08-10T16:22:41.000Z	0x54b3ea07a9bb8f6519cdce8731bfd3c1563f6837d463b9680a4b181fc10e07de
105621	true	92473	0x20b1cb6f	[]	[]	0x942117ec0458a8aa08669e94b52001bd43f889c1	21854323	0x98f660b49f5bcf21a7fe263e9cc3da55f48b828c	2025-08-10T09:50:12.000Z	0x41368509576ff23b42bf4f1d1f1d95b696104b91729cd1d50d31e2bc696eb3b5

Example Query

Query with partition filter

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

Voter_Deposit_event

No description available.

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_lp`	`STRING`	Liquidity pool contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_gauge`	`STRING`	Contract address of the gauge contract. 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Voter_DistributeReward_event

Reward distribution events emitted when a Voter contract allocates tokens to gauge contracts. Records the sender address, target gauge contract, and token amount distributed for liquidity mining 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_gauge`	`STRING`	Contract address of the gauge contract. 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	removed	in_gauge	in_amount	in_sender	log_index	block_number	block_timestamp	transaction_hash
0x942117ec0458a8aa08669e94b52001bd43f889c1	false	0xba7e1e45c35629d33dbae852eaf912045b656cb3	197422227200314087741724	0x565f818fde36a487f894aea816138a45e2a55c05	78	22596002	2025-08-28T00:06:39.000Z	0x8ee5fab6cc7afdb6bf588d48d57779a7d7738245eaf3ef887b2839677f342c0e
0x942117ec0458a8aa08669e94b52001bd43f889c1	false	0x57d5b72a505d7a48e4fc6e727ffb6b5e97148db1	7997313088344194522797	0x565f818fde36a487f894aea816138a45e2a55c05	256	22596002	2025-08-28T00:06:39.000Z	0x8ee5fab6cc7afdb6bf588d48d57779a7d7738245eaf3ef887b2839677f342c0e
0x942117ec0458a8aa08669e94b52001bd43f889c1	false	0x72c85114c2bf46a1748061c374b29f03230363b5	104799751057122691892536	0x565f818fde36a487f894aea816138a45e2a55c05	205	22596002	2025-08-28T00:06:39.000Z	0x8ee5fab6cc7afdb6bf588d48d57779a7d7738245eaf3ef887b2839677f342c0e

Example Query

Query with partition filter

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

Voter_EmissionsRatio_event

Emissions ratio adjustment events from the Etherex V3 Voter contract on Linea, tracking changes to token emission distribution parameters. Records the caller address and both old and new ratio values for analyzing governance-controlled emission rate modifications.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldRatio`	`STRING`	Previous ratio value before the state change. Numeric string representation in wei (18 decimal places).
`in_newRatio`	`STRING`	Updated ratio value after the state change. Numeric string representation in wei (18 decimal places).

Sample Data

address	removed	in_caller	log_index	in_newRatio	in_oldRatio	block_number	block_timestamp	transaction_hash
0x942117ec0458a8aa08669e94b52001bd43f889c1	false	0x0000000000000000000000000000000000000000	3	0	0	21609440	2025-08-04T04:13:27.000Z	0xf2445bded5c17e33f5348b09b6d4c169b86b87e5d3f2d345fc88db3b2c9e405c

Example Query

Query with partition filter

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

Voter_EmissionsRedirected_event

Emissions redirection events from Etherex V3 Voter contract on Linea, tracking when token emissions are rerouted between liquidity gauges. Used for analyzing governance decisions and liquidity mining strategy changes in the protocol’s incentive distribution system.

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_sourceGauge`	`STRING`	Contract address of the gauge from which emissions are being redirected. Hex-encoded, 0x-prefixed 40-character string representing the original gauge contract on Linea.
`in_destinationGauge`	`STRING`	Contract address of the gauge receiving redirected emissions in the Etherex V3 voting system. Hex-encoded, 0x-prefixed 40-character string representing the destination gauge on Linea chain.

Sample Data

address	removed	log_index	block_number	in_sourceGauge	block_timestamp	transaction_hash	in_destinationGauge
0x942117ec0458a8aa08669e94b52001bd43f889c1	false	12	21719553	0x640f551d349f199710b89fe1a209ad75499eb520	2025-08-07T05:49:19.000Z	0x2a914671bdf614d7972dadd1e29fce21634c9868a23014ba56534fd06a02266d	0x640f551d349f199710b89fe1a209ad75499eb520
0x942117ec0458a8aa08669e94b52001bd43f889c1	false	14	21712378	0x9d13bdb9f78307565415bb0dc46733803b9689f5	2025-08-07T01:43:36.000Z	0x6568312051a3a64a26301267ea9fe6552c1f1847a37341037bd53e9d42903bb9	0x9d13bdb9f78307565415bb0dc46733803b9689f5
0x942117ec0458a8aa08669e94b52001bd43f889c1	false	15	21717861	0x760403e69f8b263aa07ed9534aa67be161e8b502	2025-08-07T04:52:06.000Z	0x21a1eac8db7ed2a4914048c9061308337337d457f6feb5569531a3690d669a19	0x760403e69f8b263aa07ed9534aa67be161e8b502

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.etherex_v3_linea.Voter_EmissionsRedirected_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_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.
`in_feeDistributor`	`STRING`	Contract address of the fee distributor associated with the gauge. Hex-encoded, 0x-prefixed, 42-character string.
`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_gauge	log_index	in_creator	block_number	block_timestamp	transaction_hash	in_feeDistributor
0x942117ec0458a8aa08669e94b52001bd43f889c1	0x59ec66c141906012a4e17b63e2c60358c4d00f25	false	0x1e1cfd7c2aca4a77da31119a1f7a4caecf80999a	50	0x683035188e3670fda1def2a7aa5742dea28ed5f3	21995412	2025-08-13T17:16:20.000Z	0x2b7cf4461b51e753165bcd81be03347ee03a64e889111e2da3657924d27c4dec	0xec6271e42c18245e48b9b5af34c7864a91029f56
0x942117ec0458a8aa08669e94b52001bd43f889c1	0x8418e91cf8cbf7dd37b6492e23bec75d0f4d81d8	false	0x6df5636b18ad6c1d8087fe1d6d58109309da98b5	8	0x683035188e3670fda1def2a7aa5742dea28ed5f3	21713571	2025-08-07T02:24:20.000Z	0x70bf183218f841ae9a1b79b6c48d3d96b1a9d79ea83d8dfe95ca97aef37f29bd	0x124778a8399f914fa2e31a87c6951082e7808435
0x942117ec0458a8aa08669e94b52001bd43f889c1	0x90e8a5b881d211f418d77ba8978788b62544914b	false	0x640f551d349f199710b89fe1a209ad75499eb520	13	0x683035188e3670fda1def2a7aa5742dea28ed5f3	21719553	2025-08-07T05:49:19.000Z	0x2a914671bdf614d7972dadd1e29fce21634c9868a23014ba56534fd06a02266d	0xe949d829a2b9c4eeb61796fb9f6f7424a2097d3b

Example Query

Query with partition filter

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

Voter_GaugeKilled_event

Event logs recording the deactivation of gauge contracts from voting eligibility. Contains the gauge address that was removed from the active reward distribution set.

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_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_gauge	log_index	block_number	block_timestamp	transaction_hash
0x942117ec0458a8aa08669e94b52001bd43f889c1	false	0x2d3d068d80999a238283e5072ac898f3b8a8a4a7	143	23171087	2025-09-10T21:01:57.000Z	0x8e5d35565594fe9e36d14a4d1dfea34d2b6d665636c789663687a75ee87486bd
0x942117ec0458a8aa08669e94b52001bd43f889c1	false	0xb9dd7c8a93b6658cf7b07c716bd1a3af7943ba3d	11	23162491	2025-09-10T16:14:04.000Z	0xbeab9c023c122a83b63e6cd5fe8bb1af70c55d93fb22812fd2d3029fbdb0b0e5
0x942117ec0458a8aa08669e94b52001bd43f889c1	false	0x4b3d68471d1444e6890778eca47727bdd7d9e0e9	18	23525858	2025-09-19T10:20:01.000Z	0x3833fb09fac6e689afd768566cbb55db776ae98a6065b275670bee9f2f7154f8

Example Query

Query with partition filter

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

Voter_GaugeRevived_event

Emitted events when liquidity mining gauges are revived in the Etherex V3 voting system on Linea. Tracks gauge reactivation with contract addresses and removal status for monitoring governance decisions on reward 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_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_gauge	log_index	block_number	block_timestamp	transaction_hash
0x942117ec0458a8aa08669e94b52001bd43f889c1	false	0xb9dd7c8a93b6658cf7b07c716bd1a3af7943ba3d	24	23525976	2025-09-19T10:23:57.000Z	0x935e1a556a4274da0cd7138fc7af950ea546607299c236dcc16f2c51daf2070d

Example Query

Query with partition filter

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

Voter_NotifyReward_event

Reward distribution events emitted when tokens are allocated to voting gauges in Decentralized Exchange (DEX) voter contracts. Records the sender address, reward token contract, and token amount distributed to incentivize liquidity provision and governance participation.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. 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	removed	in_amount	in_reward	in_sender	log_index	block_number	block_timestamp	transaction_hash
0x942117ec0458a8aa08669e94b52001bd43f889c1	false	4200000000000000000000000	0xefd81eec32b9a8222d1842ec3d99c7532c31e348	0x0b6d3b42861ee8abfcaac818033694e758ecc3eb	63	22007314	2025-08-14T00:00:07.000Z	0xd231b6b0aac67d34e4fb82097ef5fce3766777bc362d19d404c532dc203c56b9
0x942117ec0458a8aa08669e94b52001bd43f889c1	false	5035800000000000000000000	0xefd81eec32b9a8222d1842ec3d99c7532c31e348	0x0b6d3b42861ee8abfcaac818033694e758ecc3eb	15	22596002	2025-08-28T00:06:39.000Z	0x8ee5fab6cc7afdb6bf588d48d57779a7d7738245eaf3ef887b2839677f342c0e
0x942117ec0458a8aa08669e94b52001bd43f889c1	false	4230072000000000000000000	0xefd81eec32b9a8222d1842ec3d99c7532c31e348	0x0b6d3b42861ee8abfcaac818033694e758ecc3eb	50	22886387	2025-09-04T00:00:15.000Z	0x43f56948ed9869e0f26cd806676495f2e9a9eda59029272e6eace568234b0a71

Example Query

Query with partition filter

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

Voter_Voted_event

Governance voting events recording weight allocation to liquidity pools or gauges. Contains voter address, target pool, and voting power in wei-denominated values for tracking vote distribution in vote-escrowed token systems.

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_weight`	`STRING`	Voting power or gauge weight allocated to a pool or account. Numeric string representation of wei-denominated value.
`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_owner	in_weight	log_index	block_number	block_timestamp	transaction_hash
0x942117ec0458a8aa08669e94b52001bd43f889c1	0x90e8a5b881d211f418d77ba8978788b62544914b	false	0x03e08c78ac6d6a553f03d46a8154c482487cd6f6	1871455847089855661609	3	22425486	2025-08-23T21:51:25.000Z	0x57bc31b32b697940c2d6440f26a6b903838978cb4ca9a1b4af8382fbd04af02c
0x942117ec0458a8aa08669e94b52001bd43f889c1	0xeacd56565ab642fb0dc2820b51547fe416ee8697	false	0x03e08c78ac6d6a553f03d46a8154c482487cd6f6	935727923544927830804	5	22425499	2025-08-23T21:51:58.000Z	0xe6f1cb2eaa17aa41cd6aa6551148fbe04bd7ea6029a5688cbb05203f3a79bf56
0x942117ec0458a8aa08669e94b52001bd43f889c1	0x90e8a5b881d211f418d77ba8978788b62544914b	false	0x03e08c78ac6d6a553f03d46a8154c482487cd6f6	935727923544927830804	3	22425499	2025-08-23T21:51:58.000Z	0xe6f1cb2eaa17aa41cd6aa6551148fbe04bd7ea6029a5688cbb05203f3a79bf56

Example Query

Query with partition filter

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

Voter_Withdraw_event

No description available.

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_lp`	`STRING`	Liquidity pool contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_gauge`	`STRING`	Contract address of the gauge contract. 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​ClGaugeFactory_FeeCollectorChanged_event

​ClGaugeFactory_GaugeCreated_event

​ClGaugeFactory_VoterChanged_event

​Factory_PoolCreated_event

​FeeDistributorFactory_createFeeDistributor_function

​GaugeV3_Bribe_event

​GaugeV3_ClaimRewards_event

​GaugeV3_NotifyReward_event

​GaugeV3_RewardAdded_event

​GaugeV3_RewardRemoved_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_SetFeeProtocol_event

​Pool_Swap_event

​PoolFactory_FeeAdjustment_event

​PoolFactory_FeeCollectorChanged_event

​PoolFactory_SetFeeProtocol_event

​PoolFactory_SetPoolFeeProtocol_event

​PoolFactory_TickSpacingEnabled_event

​REX33_ClaimedIncentives_event

​REX33_Compounded_event

​REX33_Deposit_event

​REX33_Entered_event

​REX33_Exited_event

​REX33_Rebased_event

​REX33_SwappedBribe_event

​REX33_Unlocked_event

​REX33_UpdatedIndex_event

​REX33_Withdraw_event

​VoteModule_ClaimRewards_event

​VoteModule_Deposit_event

​VoteModule_NotifyReward_event

​VoteModule_Withdraw_event

​Voter_claimIncentives_function

​Voter_claimLegacyIncentives_function

​Voter_claimRewards_function

​Voter_Deposit_event

​Voter_DistributeReward_event

​Voter_EmissionsRatio_event

​Voter_EmissionsRedirected_event

​Voter_GaugeCreated_event

​Voter_GaugeKilled_event

​Voter_GaugeRevived_event

​Voter_NotifyReward_event

​Voter_Voted_event

​Voter_Withdraw_event

Tables

ClGaugeFactory_FeeCollectorChanged_event

ClGaugeFactory_GaugeCreated_event

ClGaugeFactory_VoterChanged_event

Factory_PoolCreated_event

FeeDistributorFactory_createFeeDistributor_function

GaugeV3_Bribe_event

GaugeV3_ClaimRewards_event

GaugeV3_NotifyReward_event

GaugeV3_RewardAdded_event

GaugeV3_RewardRemoved_event

Pool_Burn_event

Pool_Collect_event

Pool_Flash_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event

PoolFactory_FeeAdjustment_event

PoolFactory_FeeCollectorChanged_event

PoolFactory_SetFeeProtocol_event

PoolFactory_SetPoolFeeProtocol_event

PoolFactory_TickSpacingEnabled_event

REX33_ClaimedIncentives_event

REX33_Compounded_event

REX33_Deposit_event

REX33_Entered_event

REX33_Exited_event

REX33_Rebased_event

REX33_SwappedBribe_event

REX33_Unlocked_event

REX33_UpdatedIndex_event

REX33_Withdraw_event

VoteModule_ClaimRewards_event

VoteModule_Deposit_event

VoteModule_NotifyReward_event

VoteModule_Withdraw_event

Voter_claimIncentives_function

Voter_claimLegacyIncentives_function

Voter_claimRewards_function

Voter_Deposit_event

Voter_DistributeReward_event

Voter_EmissionsRatio_event

Voter_EmissionsRedirected_event

Voter_GaugeCreated_event

Voter_GaugeKilled_event

Voter_GaugeRevived_event

Voter_NotifyReward_event

Voter_Voted_event

Voter_Withdraw_event