equalizer_v1_fantom

Tables

BribeV2_NotifyReward_event

Bribe reward distribution events from Equalizer V1 decentralized exchange (DEX) on Fantom, tracking token incentives deposited by external accounts to specific bribe contracts per epoch. Used for analyzing liquidity mining incentive programs and vote-escrowed governance reward mechanisms.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_from	removed	in_epoch	in_amount	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x997f91a200b89357a7c8e7b9edcc7d9cec6e4738	0xa064b34dc0aeef23e48b400dc4b0a3f940b55865	false	1679529600	200000000000000000	0x3fd3a0c85b70754efc07ac9ac0cbbdce664865a6	1	58564567	2023-03-28T11:40:13.000Z	0xb0838a0e3b9257d26a3efe0a14f4bbe57ed81c89a9d52ed56052ab648e060873
0x468444675db9d1bc5109c6fab4b36f53fb639046	0xf1ed146da5a7b21eaf3ea0f1db54c8ac25f1c585	false	1679529600	766544610	0x74b23882a30290451a17c44f4f05243b6b58c76d	24	58538253	2023-03-28T02:46:02.000Z	0x8b0a35f225066b323184a964916bdc1f678113e21245401b5374f120c468a7ca
0x468444675db9d1bc5109c6fab4b36f53fb639046	0xf1ed146da5a7b21eaf3ea0f1db54c8ac25f1c585	false	1679529600	6612144881321	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	21	58538253	2023-03-28T02:46:02.000Z	0x8b0a35f225066b323184a964916bdc1f678113e21245401b5374f120c468a7ca

Example Query

Query with partition filter

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

ExternalBribeV1_NotifyReward_event

External bribe reward notifications from Equalizer V1 DEX (Decentralized Exchange) on Fantom, recording token incentives added to voting gauges by epoch. Used for analyzing liquidity mining incentive distribution and protocol bribing strategies.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_from	removed	in_epoch	in_amount	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x16bfea4dc3d64584ec925944a3d95d2460c8dc6c	0x0fe1aa632a2837239f218e3efad21e8018a9f4ef	false	1671667200	1680454225877341417	0xbf60e7414ef09026733c1e7de72e7393888c64da	76	52866037	2022-12-26T01:54:19.000Z	0xceebc8cebe08bb2144c5b568201234810dfad918d1345ccaabd47f81a676ca4e
0x8cbd61c1a8d8d772b19a38802e9b13e6b6abaa35	0x74293a57d7f6b9f6c5580ce50aae3f10a0a09c56	false	1671667200	1200000000000000000000	0x3fd3a0c85b70754efc07ac9ac0cbbdce664865a6	11	52905731	2022-12-26T23:15:12.000Z	0xd54ea0a5df52413c49240abfc6484afce32224be6df293b4963813515e1bdc6c
0x241a488a879b8a1c44a2cfa15bf8e38b85ae467e	0x74293a57d7f6b9f6c5580ce50aae3f10a0a09c56	false	1671667200	2800000000000000000000	0x3fd3a0c85b70754efc07ac9ac0cbbdce664865a6	8	52905690	2022-12-26T23:14:12.000Z	0x38ec232af71f8f3922ad72fa95d032bfe2169281fdf4c3738b6433c3087e6db2

Example Query

Query with partition filter

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

InternalBribeV1_NotifyReward_event

Bribe reward notifications from Equalizer V1 DEX (decentralized exchange) on Fantom, recording reward token distributions to liquidity pool incentive contracts. Tracks reward amounts, token addresses, and source accounts for analyzing protocol incentive mechanisms and vote-escrowed tokenomics.

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.

Sample Data

address	in_from	removed	in_amount	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x76bc35a1bb2789b5ba8f05f77d69232893614227	0xd1ee0dc8ae761a0900ecd3b629dfa6c3cee99eed	false	454633397218029233977	0x3fd3a0c85b70754efc07ac9ac0cbbdce664865a6	15	55179545	2023-02-06T04:57:07.000Z	0xe47ec75e1ef3fcfb97fc483e3e00e8b01819f9b242d9b92da0951a4e7628a194
0x76bc35a1bb2789b5ba8f05f77d69232893614227	0xd1ee0dc8ae761a0900ecd3b629dfa6c3cee99eed	false	9378916614586670766449	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	12	55179545	2023-02-06T04:57:07.000Z	0xe47ec75e1ef3fcfb97fc483e3e00e8b01819f9b242d9b92da0951a4e7628a194
0x8fce6295e314b1f4e2cab03e98a7ba8faa86a942	0x046352e3370564323bd0fb3dfac1bb80179de1fb	false	2847193480465231	0xf43cc235e686d7bc513f53fbffb61f760c3a1882	39	55920643	2023-02-16T13:46:33.000Z	0x0c14e99323b61d6dbbe37b3086ac913cceb2f4a6d0e26186945ed3c8e9aeb631

Example Query

Query with partition filter

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

Pair_Burn_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in automated market maker (AMM) pools.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x0912ff276dc3de2ca041dd0eefaf6e89297244db	0x783a3fb9f88df5a89fb3a5e595254fa8f7b97b48	false	0x1a05eb736873485655f29a37def8a0aa87f5a447	66	1224865	499562985325990408	66672231	2023-08-06T02:00:45.000Z	0xd455abc5135be189328bb6fec51d6a8ae6eeb42e63f7f7e3cbd76f1ede273081
0x0912ff276dc3de2ca041dd0eefaf6e89297244db	0xffe9c27f0a12dabe5c5bd46d144a5c0140725566	false	0x1a05eb736873485655f29a37def8a0aa87f5a447	43	830788099683623836	7436155322478524	66672230	2023-08-06T02:00:41.000Z	0x35ca4e7856efe0c58634203f1d17ea00f45ccbfc198faa880ae108cb61d0c44c
0x0912ff276dc3de2ca041dd0eefaf6e89297244db	0x0272a69b9f7d12489e0e0c756cd645e538a00dde	false	0x1a05eb736873485655f29a37def8a0aa87f5a447	53	310684302352576491	500211472932979641	66672324	2023-08-06T02:04:10.000Z	0x92347d577e2073859624f465236cbb6d79969df16596cee4672163bc1fa43c6c

Example Query

Query with partition filter

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

Pair_Claim_event

Claim events from liquidity pool pair contracts recording amounts of both tokens withdrawn by liquidity providers. Tracks sender address, recipient address, and claimed amounts in smallest token denomination for both token0 and token1.

Columns

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

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x3d6c56f6855b7cc746fb80848755b0a9c3770122	false	0x3d6991085ab1ae3926cb96f25684c40a364b6856	70	1685114344035858	85114590980336	51442930	0x3d6991085ab1ae3926cb96f25684c40a364b6856	2022-11-25T20:18:23.000Z	0x3b0dd1a1eb3cc9bb531aa579037ae19a8af11b2ee6faaf4f6b2cf0a2271306a0
0x3d6c56f6855b7cc746fb80848755b0a9c3770122	false	0xd08cfbbdd9a2fee11bbdfa2430b5e94b02726062	15	0	1682564860007320	51408705	0xd08cfbbdd9a2fee11bbdfa2430b5e94b02726062	2022-11-25T02:01:52.000Z	0x2b3f9d82708528514425ee072e437828838585ff08e9ed9a4d1f25990931dfe7
0x3d6c56f6855b7cc746fb80848755b0a9c3770122	false	0x0815edf1b6b10b8ced00a5e58634ec563197fa12	10	0	31704500025123	51446350	0x0815edf1b6b10b8ced00a5e58634ec563197fa12	2022-11-25T22:40:16.000Z	0xed87aab300beca7f27bd3c6b63ce37676668e55e29e079c305de98bcc8efdc51

Example Query

Query with partition filter

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

Pair_Fees_event

Trading fee collection events from Automated Market Maker (AMM) liquidity pairs recording fee amounts in both token0 and token1 denominations. Used for tracking protocol revenue and liquidity provider earnings across decentralized exchange pools.

Columns

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

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xe3bd349bdb8203c15426b2d273f57568e658f843	false	0x1a05eb736873485655f29a37def8a0aa87f5a447	256	981595092024539877	0	53925408	2023-01-17T13:04:00.000Z	0x3a7cee45a9f55733caf314664e7d4096f59356414cf78b77a0bdc4410ddee533
0x3d6c56f6855b7cc746fb80848755b0a9c3770122	false	0x1a05eb736873485655f29a37def8a0aa87f5a447	256	0	12656717580976403	53912465	2023-01-17T04:54:02.000Z	0xffc8e235022a012d7b30a8bdba50609fdb66c2f0151a65e8d06b9b685064f9a2
0x7547d05dff1da6b4a2ebb3f0833afe3c62abd9a1	false	0x1a05eb736873485655f29a37def8a0aa87f5a447	256	0	16683459701665473	53911716	2023-01-17T04:20:39.000Z	0x9a743c60b6fa4f59727a638eec03420254ca10a01bf0bf0c0477a8062309b94e

Example Query

Query with partition filter

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

Pair_Mint_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool operations.

Columns

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

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x0272a69b9f7d12489e0e0c756cd645e538a00dde	false	0x2aa07920e4ecb4ea8c801d9dfece63875623b285	29	861867564792124267	1880082980395199798	64015176	2023-06-13T00:36:25.000Z	0xee7b00cb6858b10f5b95336209f339a9bdac781ceb0fe7677cf6c7ca073db268
0x0272a69b9f7d12489e0e0c756cd645e538a00dde	false	0x2aa07920e4ecb4ea8c801d9dfece63875623b285	34	777246768204521925	1653224269118719898	64061312	2023-06-13T20:07:58.000Z	0xda45efb360a3689b7b490a3d2c200b0424517cf302f05806892e3c1b549e8565
0x0272a69b9f7d12489e0e0c756cd645e538a00dde	false	0x2aa07920e4ecb4ea8c801d9dfece63875623b285	48	894698967301053911	1941300508246676314	64027687	2023-06-13T07:10:00.000Z	0x7c3bf7613b727e9a3e42009e9fa103bb484af8e6694e8f425f42f796c4ed1780

Example Query

Query with partition filter

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

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.

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

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount0In	in_amount1Out	block_timestamp	transaction_hash
0x043285eb4a37a24de4177ac2c456db25ae427288	0x3d6c56f6855b7cc746fb80848755b0a9c3770122	false	0x1a05eb736873485655f29a37def8a0aa87f5a447	45	52801438	60000000000000000000	16565277431014359160	2022-12-24T16:15:55.000Z	0x7c9daf2541b1662bf5b9a4dcdf461896ab35709cc67983cd7f6fd16f49385d4a
0x11e32758c32c3089a1e8653705e5c1618757fb1d	0x3d6c56f6855b7cc746fb80848755b0a9c3770122	false	0x93db5caa459f5945937bf26eed76116b319c1dc0	5	52772463	6184847953330241536	1304926764361095892	2022-12-24T01:43:50.000Z	0x4f21a7856b0a79ff1db8e5cc36149b5e3ab597e918a94d5eeae2caade46fdf12
0x11e32758c32c3089a1e8653705e5c1618757fb1d	0x3d6c56f6855b7cc746fb80848755b0a9c3770122	false	0x93db5caa459f5945937bf26eed76116b319c1dc0	12	52782087	8429074056868520960	1857519660615801737	2022-12-24T06:08:29.000Z	0x8cfd3f359d25a470805acbaa082b79d91ab0b1595bd0cec1f4c52a44a363807f

Example Query

Query with partition filter

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

Pair_Sync_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x0272a69b9f7d12489e0e0c756cd645e538a00dde	false	14	244714323666934980887587	530530780277599406729770	63314504	2023-05-30T05:20:48.000Z	0x921f149794a73127d7fdfcf637ea3d8789023745a4d78e5967e95affcd77b097
0x0272a69b9f7d12489e0e0c756cd645e538a00dde	false	11	249276262925715094480257	520830796654865251306630	63337223	2023-05-30T18:54:28.000Z	0x16de86a1d28e8bf40af010173db29385c9b878e5189438aacce306404957ec08
0x0272a69b9f7d12489e0e0c756cd645e538a00dde	false	58	246190790990956905746668	527358204213797915200312	63334067	2023-05-30T16:53:24.000Z	0x5e1623078edfd4f101e46ea0e50c3415802e59233b908c4c0bf8142319960746

Example Query

Query with partition filter

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

Pair_Transfer_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading pairs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xd93bab51cd83881ce1228650b9798ee8fc3e746c	0x0272a69b9f7d12489e0e0c756cd645e538a00dde	0x0000000000000000000000000000000000000000	false	160126770478984766	52	53250319	2023-01-05T02:51:41.000Z	0x64c98be651ff8867990a09549f1c8b3e1e07b0a94fd15f94c56014b91167edda
0xb0f9069babb65f104acdbf9e1fc521f3f1870d5a	0x0272a69b9f7d12489e0e0c756cd645e538a00dde	0xd93bab51cd83881ce1228650b9798ee8fc3e746c	false	160126770478984766	0	53250396	2023-01-05T02:54:17.000Z	0x102d322bb5d3c8ff22ba57a9fbaeda3e3932cf61d57acf330456601e15de4429
0xb0f9069babb65f104acdbf9e1fc521f3f1870d5a	0x0272a69b9f7d12489e0e0c756cd645e538a00dde	0xaf79312eb821871208ac76a80c8e282f8796964e	false	314983972322582644	0	53249485	2023-01-05T02:26:02.000Z	0x788ee246574229bd0309d9d04055ca92f68fd28feaecb29aa41d33d6feb7b451

Example Query

Query with partition filter

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

PairFactory_PairCreated_event

Event logs emitted when a new liquidity pool pair is created by a DEX (Decentralized Exchange) factory contract. Records the deployed pair contract address, constituent token addresses, and creation metadata for tracking protocol liquidity expansion.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_stable`	`BOOL`	Boolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_anon4`	`STRING`	Sequential identifier for the liquidity pool pair created by the factory contract. String-encoded integer value.

Sample Data

address	in_pair	removed	in_anon4	in_stable	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0xc6366efd0af1d09171fe0ebf32c7943bb310832a	0x11a0779ea92176298b7a2760ae29fc9ce1ad47b4	false	163	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0xe47d957f83f8887063150aaf7187411351643392	2	56751432	2023-03-01T21:34:31.000Z	0x381cb0ec29450353fe797560e25b134e6f1fb2f666b0499523e68bd6677af3c5
0xc6366efd0af1d09171fe0ebf32c7943bb310832a	0x628e61164d16e08812b3a1421b4a0be734ec4842	false	161	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0xae45a827625116d6c0c40b5d7359ecf68f8e9afd	2	56700236	2023-03-01T00:30:43.000Z	0x1be3344ff729d8a111580c0635560ac90cc608ba73b35c1f625ac33b24c35b4e
0xc6366efd0af1d09171fe0ebf32c7943bb310832a	0xcae2974bb2cb0e6856e623602dab5cdbffa88efb	false	162	false	0x88888a335b1f65a79ec56a610d865b8b25b6060b	0xf04a45b429eb5930a85884141c530147db0f609e	40	56733220	2023-03-01T14:12:34.000Z	0x766f1d6ae836986df40d1e7d407c6679dda4ae128185191fe4680aa29bafb6a4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.equalizer_v1_fantom.PairFactory_PairCreated_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_internal_bribe`	`STRING`	Contract address of the internal bribe contract associated with the gauge. Hex-encoded, 0x-prefixed, 42-character string.
`in_external_bribe`	`STRING`	Contract address of the external bribe contract 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_external_bribe	in_internal_bribe
0x4bebeb8188aef8287f9a7d1e4f01d76cbe060d5b	0xe81b869cd412955a1817859ad654a3e443482d58	false	0x6690e59a687bb5f516818f4270bcdfa8edcf3bd0	19	0x28aa4f9ffe21365473b64c161b566c3cdead0108	52499024	2022-12-18T07:01:17.000Z	0xb697e6419941d6a36dcba294d33fa85e5443baee4598babcdaaf47e866462eb9	0x2fe8c277f619427874b4c91af8e187734f0ec87e	0x90621fd558f27c72ecce531dc29c14954b69aa80
0x4bebeb8188aef8287f9a7d1e4f01d76cbe060d5b	0x68ca64cabbb3d40dbb0de37101a8c0b701f66fd6	false	0xcf220317513475efda09b2fa7f0fcaaef794440a	4	0x28aa4f9ffe21365473b64c161b566c3cdead0108	54848334	2023-02-01T13:23:02.000Z	0x6ee70fec2f4438c0973123cf7d80c45e64ee6356aeb916bd25dc0e242523fbe6	0x90d977c51855a53f9a60532338d77ac54b3c9982	0x9d07c1a6b6d1e00e4efc703dbcb9c5e13fcb45d4
0x4bebeb8188aef8287f9a7d1e4f01d76cbe060d5b	0x2c6bdb1b22a3bc17e5fe5761097471f4b877f8ad	false	0x56638ef659e4962e5d0d465b0ecfccd8c5531921	4	0x4d98fda16cb133f5dbf5ff688a2e7ba2f88bcb8a	56772144	2023-03-02T05:08:19.000Z	0xdc63f7ba21a2f53016ce4d4db0778b012fcf6cc6ee0fa42885d33337b37b99dd	0x021ef5500206b0a63bf970e5cc697801e4e27606	0x677b2371ce7a383ceea8280e9cbf70ed93309ab6

Example Query

Query with partition filter

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

VoterV1_GaugeCreated_event

Gauge creation events from Equalizer V1 DEX (decentralized exchange) voter contract on Fantom, recording when new liquidity pool gauges are deployed with associated internal and external bribe contracts. Used to track gauge deployment history and analyze voter incentive structures across 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_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_internal_bribe`	`STRING`	Contract address of the internal bribe contract associated with the gauge. Hex-encoded, 0x-prefixed, 42-character string.
`in_external_bribe`	`STRING`	Contract address of the external bribe contract 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_external_bribe	in_internal_bribe
0x4bebeb8188aef8287f9a7d1e4f01d76cbe060d5b	0xf1c6038c498c7f550d78720421d4e24fe3c63eb2	false	0x445d1481b9e31e2005673bd7c5f02077d02f72c4	59	0xa2ef1b69e232b759429472208b1055486a45ff8e	50911214	2022-11-15T08:20:19.000Z	0x90d849d1d06dd02b083dbc7312d025a19dbc7369b279fd158dc287471a31f79c	0xe990fa3bdd99a8649650a47ebe369dee12116d04	0xa3bfa0b78b653c56d511300e6d2427e444ee93f8
0x4bebeb8188aef8287f9a7d1e4f01d76cbe060d5b	0x0b4b1e0325a7150468f724bca3de2deb92519846	false	0x1821aa4c624f646d0826fb9823e20ff63132be4f	5	0xa064b34dc0aeef23e48b400dc4b0a3f940b55865	50911301	2022-11-15T08:23:24.000Z	0x9da2179468358975ce7b7d8a4d4da965a6ccb612a82fda15b60094af074eab40	0xa84008296b8fdf34b0bd3a37c7c9c46afb34de31	0xdf7c91d561bf045dd1b2e328496fc09c12561056
0x4bebeb8188aef8287f9a7d1e4f01d76cbe060d5b	0x9b99bbe1ebd7415dbc859e35161a451698c5d331	false	0x046352e3370564323bd0fb3dfac1bb80179de1fb	91	0xa064b34dc0aeef23e48b400dc4b0a3f940b55865	50907656	2022-11-15T06:24:14.000Z	0x5a18b799b9c26211c89c9c30ffc810cdbb1a9f320c5c435aef23045cabe4b3dc	0xcc47121470a89a2f0d03c8d364fd2bf58f882191	0x8fce6295e314b1f4e2cab03e98a7ba8faa86a942

Example Query

Query with partition filter

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

VoterV2_GaugeAndBribeCreated_event

Gauge and bribe contract deployment events from Equalizer DEX (decentralized exchange) v1 on Fantom, recording when new liquidity pool incentive mechanisms are created. Links pools to their gauge contracts, bribe contracts, reward tokens, and creator addresses for analyzing vote-escrowed tokenomics and liquidity mining programs.

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.
`in_bribe`	`STRING`	Contract address of the bribe contract associated with the gauge or pool. 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_gaugeRewards`	`ARRAY<STRING>`	Contract addresses of tokens distributed as rewards to liquidity gauge stakers. Array field containing one or more token addresses, commonly including the platform’s native token (0x3fd3…865a6 in samples).
`in_allowedRewards`	`ARRAY<STRING>`	Array of contract addresses for tokens whitelisted as eligible bribe reward options for this gauge. Typically includes the protocol’s native token and other accepted reward tokens.

Sample Data

address	in_pool	removed	in_bribe	in_gauge	log_index	in_creator	block_number	block_timestamp	in_gaugeRewards	transaction_hash	in_allowedRewards
0xe3d1a117df7dcac2eb0ac8219341bad92f18dac1	0x3c4beb9a8d83c888d28f3cef37e4fff662cae9d7	false	0x333fef28365ed34e06407b0a0753cc9ff3145909	0x2ff532ac6b969bd6942d24bd44483888acf17fbe	15	0xc424c343554afd6cd270887d4232765850f5e93f	65684114	2023-07-13T01:30:25.000Z	[“0x3fd3a0c85b70754efc07ac9ac0cbbdce664865a6”]	0xbf1d7efd35865d867694c0e4690f16ff20912a74c07c0fa310762bc2f753c31b	[“0x1b6382dbdea11d97f24495c9a90b7c88469134a4”,“0x28a92dde19d9989f39a49905d7c9c2fac7799bdf”,“0x3fd3a0c85b70754efc07ac9ac0cbbdce664865a6”]
0xe3d1a117df7dcac2eb0ac8219341bad92f18dac1	0xa51c62c70571007254f0094c0bbf287472b8dfdb	false	0x999202c5980cf6444e8eccbc5064edf0302e59f5	0x14faefd25b492933b80203f04e8b87fee3139d4b	7	0x22385cfa0943dbe0cde77b3a081346796afc58f4	65696239	2023-07-13T07:26:37.000Z	[“0x3fd3a0c85b70754efc07ac9ac0cbbdce664865a6”]	0xbdff0ae3a207c858594963144044939fc8cf4d21a68e48845a71459c824186cc	[“0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83”,“0xdc301622e621166bd8e82f2ca0a26c13ad0be355”,“0x3fd3a0c85b70754efc07ac9ac0cbbdce664865a6”]
0xe3d1a117df7dcac2eb0ac8219341bad92f18dac1	0x4a3df59efab96edf1f79b4427d4916767cd906e5	false	0xfc5bfa46dcd8de8bdddb27c92f109f6c6a90458d	0xd02326b2e28e581ab40e32e819fe4f3c8d27cd3a	7	0xa064b34dc0aeef23e48b400dc4b0a3f940b55865	65708814	2023-07-13T13:32:25.000Z	[“0x3fd3a0c85b70754efc07ac9ac0cbbdce664865a6”]	0x99d85ec5b1e74eef980724eff32215b4f69e8757c9854a3674e5227a903a65f9	[“0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83”,“0xd226392c23fb3476274ed6759d4a478db3197d82”,“0x3fd3a0c85b70754efc07ac9ac0cbbdce664865a6”]

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

BribeV2_NotifyReward_event

ExternalBribeV1_NotifyReward_event

InternalBribeV1_NotifyReward_event

Pair_Burn_event

Pair_Claim_event

Pair_Fees_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairFactory_PairCreated_event

Voter_GaugeCreated_event

VoterV1_GaugeCreated_event

VoterV2_GaugeAndBribeCreated_event

​Tables

​BribeV2_NotifyReward_event

​ExternalBribeV1_NotifyReward_event

​InternalBribeV1_NotifyReward_event

​Pair_Burn_event

​Pair_Claim_event

​Pair_Fees_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

​PairFactory_PairCreated_event

​Voter_GaugeCreated_event

​VoterV1_GaugeCreated_event

​VoterV2_GaugeAndBribeCreated_event

Tables

BribeV2_NotifyReward_event

ExternalBribeV1_NotifyReward_event

InternalBribeV1_NotifyReward_event

Pair_Burn_event

Pair_Claim_event

Pair_Fees_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairFactory_PairCreated_event

Voter_GaugeCreated_event

VoterV1_GaugeCreated_event

VoterV2_GaugeAndBribeCreated_event