pendle_v1_berachain

Tables

GaugeController_ReceiveVotingResults_event

Event emitted when the Pendle GaugeController contract receives voting results, containing arrays of market addresses and their corresponding PENDLE token reward amounts for a specific time period. Used for tracking liquidity mining incentive distributions across Pendle markets.

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_wTime`	`STRING`	Unix timestamp representing the voting period end time. Integer value stored as string, in seconds since epoch.
`in_markets`	`ARRAY<STRING>`	Array of market contract addresses receiving voting allocations. Each address is hex-encoded, 0x-prefixed, and 42 characters long.
`in_pendleAmounts`	`ARRAY<STRING>`	Array of PENDLE token amounts allocated to each market. String-encoded integers representing token quantities in wei (smallest unit, 18 decimals).

Sample Data

address	removed	in_wTime	log_index	in_markets	block_number	block_timestamp	in_pendleAmounts	transaction_hash
0x704478dd72fd7f9b83d1f1e0fc18c14b54f034d0	false	1761782400	53	[“0x158c7d15f5ebc0f9412ed5a2997dfaaa06ea349d”,“0xe8563736c77254d470a1244c1beab7e96662b579”,“0x850a9f099de3081fe88f8be6207492c52754acb5”]	12437022	2025-10-30T00:04:41.000Z	[“559834477301973850371”,“3835822294826774988”,“81030745884425435764”]	0x088ccbedfc1a3d4241ebca1d1d3028450abe41f5302127213edd0fe8efdc80ef
0x704478dd72fd7f9b83d1f1e0fc18c14b54f034d0	false	1744848000	28	[“0xbfc42d9cb3358603e4804ac9ab54159fd5a85098”,“0xd8079e0929d67390067529974b116212903cac69”,“0x0651c3f8ba59e312529d9a92fcebd8bb159cbaed”,“0x31ed9f16c7bbc26ae3404b14abc68adc7611b1a6”,“0x227d4a2e5734b500fa0bed940e4df54bdda25636”,“0x34634a7bbe5a3c234b931c79d4cc6785c5dd54c4”,“0x5200c9900436f649b4659dfc79213837dcccaab1”,“0xd8f42a92a0e2995eee9aed66d630de00a9b49e22”]	3800569	2025-04-17T00:05:33.000Z	[“2890535598098346256”,“68284523699819357320”,“2747020999108487041”,“4808579574381128125”,“2498689589549284636213”,“23832292956482798644”,“21401388162713871790”,“1273208196435937257”]	0x044804b354329b26779c0b8351b7ed21591dd9af7f23f34fccfea280b3be8adc
0x704478dd72fd7f9b83d1f1e0fc18c14b54f034d0	false	1762387200	35	[“0x158c7d15f5ebc0f9412ed5a2997dfaaa06ea349d”,“0xe8563736c77254d470a1244c1beab7e96662b579”,“0x850a9f099de3081fe88f8be6207492c52754acb5”]	12686349	2025-11-06T00:03:35.000Z	[“597939978240000196260”,“6151726082830382982”,“291769609967728199151”]	0x9e7a7798a1fff95c70eb27e3f6fe07e45d2083521295b3c8197d78ada77ca8e5

Example Query

Query with partition filter

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

LimitRouter_OrderFilledV2_event

Limit order execution events from Pendle protocol’s LimitRouter contract capturing maker-taker trades involving Yield Tokens (YT). Records order hash, type, fee amounts, notional volume, and net input/output flows for order book 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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_orderType`	`INT64`	Enumerated order type classification. Integer identifier representing the specific type of order or limit being executed within the protocol.
`in_YT`	`STRING`	Contract address of the Yield Token (YT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_netInputFromMaker`	`STRING`	Net input amount received from the order maker in the Pendle limit order execution. Numeric string representation of token quantity in smallest denomination.
`in_netOutputToMaker`	`STRING`	Net output amount sent to the order maker in the Pendle limit order execution. Numeric string representation of token quantity in smallest denomination.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
`in_notionalVolume`	`STRING`	Total trading volume amount for the order execution. Numeric string representation of token quantity in smallest denomination.
`in_maker`	`STRING`	Address of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
`in_taker`	`STRING`	Address of the order taker who filled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_YT	address	removed	in_maker	in_taker	in_token	log_index	block_number	in_feeAmount	in_orderHash	in_orderType	block_timestamp	transaction_hash	in_notionalVolume	in_netOutputToMaker	in_netInputFromMaker
0xbe79df1762891a043198f886dbbf2ff1729ef030	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0xc3e0e42e114eb5b9fc2eadac824b62d8baa89533	0x888888888889758f76e7103c6cbf23abbf58f946	0xac03caba51e17c86c921e1f6cbfbdc91f8bb2e6b	157	11318363	114264648125814270	0xf13594e547412246e674a46354abe419cfbc9ce64fbe16f4d46ce1f7c6c6d06f	2	2025-10-04T02:36:03.000Z	0xfe07b45ed9731e44201a0521c62aa2e1ebb1eb02bcfa49710ca1e0e9b875e92b	24168824152700602301	29292776292978365825	4749396680587313717
0xbe79df1762891a043198f886dbbf2ff1729ef030	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0x95979e554d77a7d40941bf46f408fd34ff23908f	0x888888888889758f76e7103c6cbf23abbf58f946	0xac03caba51e17c86c921e1f6cbfbdc91f8bb2e6b	175	11318363	98219809188084977	0xc35ac027fb043057fee17102f5d0c935927ff29d8a5d35e8eb55040bc5623c9c	2	2025-10-04T02:36:03.000Z	0xfe07b45ed9731e44201a0521c62aa2e1ebb1eb02bcfa49710ca1e0e9b875e92b	20775080792834815427	25179536674524646216	4082494834379343819
0xbe79df1762891a043198f886dbbf2ff1729ef030	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0xf5cc8caf56bdbb6f6f68ea05053ef85155f21355	0x888888888889758f76e7103c6cbf23abbf58f946	0xac03caba51e17c86c921e1f6cbfbdc91f8bb2e6b	179	11318363	71420726900234198	0xf10f1e6e267b37a2ef2e76bbdec762d4930923fea9552693df4d5499ccf7644c	2	2025-10-04T02:36:03.000Z	0xfe07b45ed9731e44201a0521c62aa2e1ebb1eb02bcfa49710ca1e0e9b875e92b	15106640746919230309	18309349480224934787	2968594126256914235

Example Query

Query with partition filter

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

MarketFactoryV5_CreateNewMarket_event

Pendle V5 market creation events emitted when a new AMM (Automated Market Maker) market is deployed for trading Principal Tokens (PT). Contains market address, PT address, and AMM initialization parameters including anchor, scalar root, and fee rate root values.

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_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_PT`	`STRING`	Contract address of the Principal Token (PT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_scalarRoot`	`STRING`	Scalar root parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
`in_initialAnchor`	`STRING`	Initial anchor parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
`in_lnFeeRateRoot`	`STRING`	Natural logarithm of the fee rate root parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.

Sample Data

in_PT	address	removed	in_market	log_index	block_number	in_scalarRoot	block_timestamp	in_initialAnchor	in_lnFeeRateRoot	transaction_hash
0xdc9b87e5efd6ca2beaa33dde9c544e1e98345de4	0x8a09574b0401a856d89d1b583ee22e8cb0c5530b	false	0x0651c3f8ba59e312529d9a92fcebd8bb159cbaed	6	2766640	21471686911004932129	2025-03-24T10:47:25.000Z	1076716440748663439	9950330853168082	0xc28ebfe3ef4f8d5c7ef32d08714fd6b1f66dd82fd8915aeef9eca631eb027207
0x2719e657ec3b3cbe521a18e640ca55799836376f	0x8a09574b0401a856d89d1b583ee22e8cb0c5530b	false	0xd8079e0929d67390067529974b116212903cac69	44	2766348	17331467545679133266	2025-03-24T10:37:47.000Z	1086608839120135735	9950330853168082	0xfd94afb2692295cc286de557e7e50ecb5ad3c98350964bc109f7d08b5c551dc1
0x6fa48156a2e843e0a90b70a1defc8ef868815270	0x8a09574b0401a856d89d1b583ee22e8cb0c5530b	false	0x158c7d15f5ebc0f9412ed5a2997dfaaa06ea349d	78	8422124	81475542025785870505	2025-07-30T07:40:03.000Z	1012318311012231673	1998002662673056	0xbc696586e3a04dcd6177f5a3fc3f51e4e11a9caa6306f084c6c7dba549e653cd

Example Query

Query with partition filter

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

MarketV5_Mint_event

Liquidity provision events from Pendle V5 markets recording the minting of LP (Liquidity Provider) tokens in exchange for PT (Principal Token) and SY (Standardized Yield) token deposits. Tracks liquidity additions to yield trading pools with receiver addresses and token quantities consumed.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_netLpMinted`	`STRING`	Net amount of liquidity provider (LP) tokens minted in the transaction. String-encoded integer representing the token quantity in its smallest unit.
`in_netSyUsed`	`STRING`	Net amount of Standardized Yield (SY) tokens consumed in the mint operation. String-encoded integer representing the token quantity in its smallest unit.
`in_netPtUsed`	`STRING`	Net amount of Principal Token (PT) consumed in the mint operation. String-encoded integer representing the token quantity in its smallest unit.

Sample Data

address	removed	log_index	in_receiver	block_number	in_netPtUsed	in_netSyUsed	in_netLpMinted	block_timestamp	transaction_hash
0x850a9f099de3081fe88f8be6207492c52754acb5	false	123	0x3a97a1c3123fd8246d4c42b22d95ba18174706f0	12874708	858105444314635694	9864716240353843605	5794649809432078821	2025-11-10T08:42:13.000Z	0x3226c34a51a1bb6d570360b096b7a4257da71d7233928f56d7a74f9841070bb8
0x850a9f099de3081fe88f8be6207492c52754acb5	false	128	0x3f0daf611cb872ebcf36070fa42a7c1855b6814b	12874907	5847112647325807129	67221258948140143078	39486411690250820541	2025-11-10T08:48:51.000Z	0x7836f51120b1547ec5744501d4bb4656f74f0e3a6018e6ed9ab7b4d3797d42af
0x850a9f099de3081fe88f8be6207492c52754acb5	false	120	0x4fe93ebc4ce6ae4f81601cc7ce7139023919e003	12882072	13979817654243392	158496035720779177	93198511905875315	2025-11-10T12:47:41.000Z	0x5b6a693466cc5843467bf9a9737a89f3c0a0657676d4c58797bae2251106348c

Example Query

Query with partition filter

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

MarketV5_Swap_event

Pendle V5 market swap events recording exchanges between Principal Tokens (PT) and Standardized Yield (SY) tokens. Contains net token flows, protocol fees, and reserve allocations for yield trading activity 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_caller`	`STRING`	Address that initiated or requested the contract function call. 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_netPtOut`	`STRING`	Net amount of Principal Token (PT) transferred in the swap or burn operation. Positive values indicate PT received by the user, negative values indicate PT provided by the user to the pool.
`in_netSyOut`	`STRING`	Net amount of Standardized Yield (SY) token transferred in the swap or burn operation. Positive values indicate SY received by the user, negative values indicate SY provided by the user to the pool.
`in_netSyFee`	`STRING`	Amount of Standardized Yield (SY) token collected as protocol fee from the swap transaction. Numeric string representing token amount in smallest denomination.
`in_netSyToReserve`	`STRING`	Amount of Standardized Yield (SY) token allocated to the protocol reserve from the swap transaction. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	in_caller	log_index	in_netPtOut	in_netSyFee	in_netSyOut	in_receiver	block_number	block_timestamp	transaction_hash	in_netSyToReserve
0x0651c3f8ba59e312529d9a92fcebd8bb159cbaed	false	0x888888888889758f76e7103c6cbf23abbf58f946	63	5080382977169105068	1301097483382085	-4984151456919314659	0x0651c3f8ba59e312529d9a92fcebd8bb159cbaed	6892898	2025-06-26T02:37:07.000Z	0xbce063aecb32940d28d21fd5c788922bfce7d164efba61a7b04175eba9a06b43	1040877986705668
0x0651c3f8ba59e312529d9a92fcebd8bb159cbaed	false	0x888888888889758f76e7103c6cbf23abbf58f946	147	348757605120973492761	88702254415554558	-342208468458604765153	0x0651c3f8ba59e312529d9a92fcebd8bb159cbaed	6921839	2025-06-26T18:00:35.000Z	0x582898124c4997484d720aa2a0aa58749662ab0c329d1b73a9f75f255c12bd97	70961803532443646
0x0651c3f8ba59e312529d9a92fcebd8bb159cbaed	false	0x888888888889758f76e7103c6cbf23abbf58f946	289	101921509102587223305	25990699364756820	-99999999999999844528	0x285e6e07ce1bcd84cc9b6f2ef661de222899eb23	6910833	2025-06-26T12:08:44.000Z	0x09064caee0fae7eabb2bf2e044e347f7af8182433a2657fa55f11d9bc3d2e17b	20792559491805456

Example Query

Query with partition filter

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

SYv5_Deposit_event

Deposit events from Pendle V5 Standardized Yield (SY) contracts recording token deposits and corresponding SY token minting. Contains caller address, input token address, deposited amount, and SY tokens received for tracking yield-bearing asset conversions.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. 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_amountDeposited`	`STRING`	Quantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
`in_amountSyOut`	`STRING`	Quantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.

Sample Data

address	removed	in_caller	log_index	in_tokenIn	in_receiver	block_number	in_amountSyOut	block_timestamp	transaction_hash	in_amountDeposited
0x9acc60f915dfcd190d270fc92567ae71776bd320	false	0x888888888889758f76e7103c6cbf23abbf58f946	12	0x0555e30da8f98308edb960aa94c0db47230d2b9c	0xbfc42d9cb3358603e4804ac9ab54159fd5a85098	9562729	2853115	2025-08-24T18:10:16.000Z	0xe008edd679a30c12670f572cbc21709a3f654f9da5021d81d7c3769ed1e059f0	2861825
0x40ae6da2d92aa3dcb7f8d7a7209fd12bdfcb7c85	false	0x888888888889758f76e7103c6cbf23abbf58f946	57	0x211cc4dd073734da055fbf44a2b4667d5e5fe5d2	0x648f599be3fac91f42e1730d96fa83ce246ac75d	9552987	284102966414816	2025-08-24T12:57:32.000Z	0x822cba0df3db2968000bab8c4eca4db161553287741bda06a9971d594164d8ec	284102966414816
0x40ae6da2d92aa3dcb7f8d7a7209fd12bdfcb7c85	false	0x888888888889758f76e7103c6cbf23abbf58f946	27	0x211cc4dd073734da055fbf44a2b4667d5e5fe5d2	0x648f599be3fac91f42e1730d96fa83ce246ac75d	9552948	284945223585601	2025-08-24T12:56:18.000Z	0x1c3ab62b63379e5adf19a77ea94bf686f3e9bc29fbb7b168a7a107288a5be658	284945223585601

Example Query

Query with partition filter

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

YieldContractFactoryV5_CreateYieldContract_event

Emitted when Pendle protocol’s YieldContractFactoryV5 creates a new yield contract, recording the deployed Principal Token (PT), Yield Token (YT), and Standardized Yield (SY) token addresses along with expiration timestamp. Used for tracking yield tokenization contract deployments across yield-bearing assets.

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_SY`	`STRING`	Contract address of the Standardized Yield (SY) token in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`in_PT`	`STRING`	Contract address of the Principal Token (PT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_YT`	`STRING`	Contract address of the Yield Token (YT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_PT	in_SY	in_YT	address	removed	in_expiry	log_index	block_number	block_timestamp	transaction_hash
0x1f6b050f8770716e8d5b5c771ecbbe4ba581d594	0xc61c866b6fdc36f88ec368b969c6d7cb810cafa9	0x7cda39768b382969a0e3295bde73eb863c3feff7	0x2bea6bfd8fbff45aa2a893eb3b6d85d10efcc70e	false	1774483200	50	10910263	2025-09-24T15:52:43.000Z	0xb18a34bcc7066290adf085c4b16b5b0a7f30173c61032cfedd2c330525dab548
0x8e376d1eb0ef4dfd5deff6370a0c8160dad4d1ef	0x193b2f36957f7e9e498758bbf182273bc145bb92	0xc4c94cfde286a13d9af76a4972c109ed77b0972f	0x2bea6bfd8fbff45aa2a893eb3b6d85d10efcc70e	false	1766016000	50	10888426	2025-09-24T03:44:49.000Z	0x7480f6503fbd16f880c917e56f6c1b7e8e430945e1388e75eb35c4f8d1be9d27
0xd8711f912e52a78d0ddd13fca2555700c31d61f4	0x9e88f2990c48315dace55ffda9950fc287362109	0xcb623b3f6f216e36a599228b2921ace0ea499d0d	0x2bea6bfd8fbff45aa2a893eb3b6d85d10efcc70e	false	1761782400	77	3434908	2025-04-08T14:19:49.000Z	0xc0af014607193fcbc53e610a8b7265c3868a7d705e86b2f91f3dfc82b3ae9431

Example Query

Query with partition filter

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

YTv5_CollectInterestFee_event

Interest fee collection events emitted by Pendle V1 YT (Yield Token) contracts. Records accrued interest fees captured from yield-bearing positions, denominated in the underlying token’s smallest unit.

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_amountInterestFee`	`STRING`	Amount of interest fee collected in the CollectInterestFee event. String representation of an integer value denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_amountInterestFee
0x648f599be3fac91f42e1730d96fa83ce246ac75d	false	98	8951599	2025-08-11T01:57:05.000Z	0x41c5f705bcc108cf1806b4ccaada3494316e7fdabffbee1725360294df03705f	3089558656452631
0x648f599be3fac91f42e1730d96fa83ce246ac75d	false	101	8991301	2025-08-11T23:20:04.000Z	0xd689f8db33cbdeb1c57abefe03a4d4c789543d97feaa2a8795faa42e34a5a6d0	397420355767042898
0x648f599be3fac91f42e1730d96fa83ce246ac75d	false	3	8966455	2025-08-11T09:58:13.000Z	0xf01b2735e1bfaf96d3c87f0ec896c452ac61fe1065e8cc577bf1019359419876	236911467261417691

Example Query

Query with partition filter

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

YTv5_CollectRewardFee_event

Reward fee collection events emitted by Pendle V5 Yield Token (YT) contracts when protocol fees are extracted from accrued rewards. Contains the reward token address and collected fee amount for protocol revenue 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_rewardToken`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountRewardFee`	`STRING`	Amount of reward fee collected from the yield token contract. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	log_index	block_number	in_rewardToken	block_timestamp	transaction_hash	in_amountRewardFee
0x99c354ef4a8f85a5ff22d0e74db10f1c736ccab4	false	70	12866201	0xfcbd14dc51f0a4d49d5e53c2e0950e0bc26d0dce	2025-11-10T03:58:39.000Z	0x8452210bf877620113f4019366975a82dfaaa9a3f9a5cf8f3e25cdfc08b74e77	0
0x99c354ef4a8f85a5ff22d0e74db10f1c736ccab4	false	74	12866201	0x4f3c10d2bc480638048fa67a7d00237a33670c1b	2025-11-10T03:58:39.000Z	0x8452210bf877620113f4019366975a82dfaaa9a3f9a5cf8f3e25cdfc08b74e77	0
0x99c354ef4a8f85a5ff22d0e74db10f1c736ccab4	false	73	12866201	0x6969696969696969696969696969696969696969	2025-11-10T03:58:39.000Z	0x8452210bf877620113f4019366975a82dfaaa9a3f9a5cf8f3e25cdfc08b74e77	56623595061931720

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

GaugeController_ReceiveVotingResults_event

LimitRouter_OrderFilledV2_event

MarketFactoryV5_CreateNewMarket_event

MarketV5_Mint_event

MarketV5_Swap_event

SYv5_Deposit_event

YieldContractFactoryV5_CreateYieldContract_event

YTv5_CollectInterestFee_event

YTv5_CollectRewardFee_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​GaugeController_ReceiveVotingResults_event

​LimitRouter_OrderFilledV2_event

​MarketFactoryV5_CreateNewMarket_event

​MarketV5_Mint_event

​MarketV5_Swap_event

​SYv5_Deposit_event

​YieldContractFactoryV5_CreateYieldContract_event

​YTv5_CollectInterestFee_event

​YTv5_CollectRewardFee_event

Tables

GaugeController_ReceiveVotingResults_event

LimitRouter_OrderFilledV2_event

MarketFactoryV5_CreateNewMarket_event

MarketV5_Mint_event

MarketV5_Swap_event

SYv5_Deposit_event

YieldContractFactoryV5_CreateYieldContract_event

YTv5_CollectInterestFee_event

YTv5_CollectRewardFee_event