pendle_v1_plasma

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
0x7e500c6efbb00fd3227888256e477171a1304721	false	1762992000	17	[“0x18d89b23d2875590c502cd3eac8f448f3ccf9999”,“0xe06c3b972ba630ccf3392cecdbe070690b4e6b55”,“0xfd3eb62302fa3cbc3c7e59e887b92dbbc814285d”,“0x15735f2f53c5cd25a57dff83b11c93eceaf72073”,“0x0d7d9abee602c7f0a242ea7e200e47c372acba84”,“0x0cb289e9df2d0dcfe13732638c89655fb80c2be2”,“0x0d914d47de12766d061c37eac1ad27175b3f2434”,“0x7209d228cd585f4b77a031f7b902f989439ac319”,“0x9d0676ec013cb50b7bf9b291c22b618e9fe86832”,“0xca2d052fcedbf532ca8cef2d3d1d84a041a258f7”,“0x23280356de3a7aec0b0710cd9b902ac8f431368c”,“0x23180d15651fe6e4415ce27b212cf8e5d2deda96”,“0xea9b070db9a823148d6d75d0875c25d5e51436ba”,“0xd5b13c8871a6e337e6492b30a7cac5c7d38737ac”,“0xa2d4dd85c24c73ddc8d815689f5913ec2166402c”]	6061878	2025-11-13T00:06:21.000Z	[“441763032097359619714”,“3658267086278606098357”,“360644936318030032950”,“4119455632732270863016”,“789353972701458216703”,“107633616328639565686”,“67130995376854628804”,“241091639590446413298”,“102848754904392518700”,“2107053768423424880870”,“4619174524042814986”,“6387202982918933981”,“191029397738265107444”,“192692694836947040439”,“120037665140685764650”]	0x4fcf095a04e3659d7647646c9687cdfdc419841b89991eb2281f5800cd23c0ee
0x7e500c6efbb00fd3227888256e477171a1304721	false	1761782400	77	[“0x18d89b23d2875590c502cd3eac8f448f3ccf9999”,“0xe06c3b972ba630ccf3392cecdbe070690b4e6b55”,“0xfd3eb62302fa3cbc3c7e59e887b92dbbc814285d”,“0x15735f2f53c5cd25a57dff83b11c93eceaf72073”,“0x0d7d9abee602c7f0a242ea7e200e47c372acba84”,“0x0cb289e9df2d0dcfe13732638c89655fb80c2be2”,“0x0d914d47de12766d061c37eac1ad27175b3f2434”,“0x7209d228cd585f4b77a031f7b902f989439ac319”,“0x9d0676ec013cb50b7bf9b291c22b618e9fe86832”,“0xca2d052fcedbf532ca8cef2d3d1d84a041a258f7”,“0x23280356de3a7aec0b0710cd9b902ac8f431368c”,“0x23180d15651fe6e4415ce27b212cf8e5d2deda96”]	4853234	2025-10-30T00:04:00.000Z	[“224942333526243431345”,“3833700100561638438847”,“1026231978273572661014”,“3260979953990849960513”,“1475455062811200367707”,“9318005524280969972”,“57633345544668101832”,“509938987210691542516”,“313421644711380842088”,“4832149539679881492942”,“103799014420403213698”,“106457782413976388690”]	0xd9af6c111b97810fddc2786d92b17762ed8a9a9d90edcdeb9804db85c6005658
0x7e500c6efbb00fd3227888256e477171a1304721	false	1763596800	49	[“0x18d89b23d2875590c502cd3eac8f448f3ccf9999”,“0xe06c3b972ba630ccf3392cecdbe070690b4e6b55”,“0xfd3eb62302fa3cbc3c7e59e887b92dbbc814285d”,“0x15735f2f53c5cd25a57dff83b11c93eceaf72073”,“0x0d7d9abee602c7f0a242ea7e200e47c372acba84”,“0x0cb289e9df2d0dcfe13732638c89655fb80c2be2”,“0x0d914d47de12766d061c37eac1ad27175b3f2434”,“0x7209d228cd585f4b77a031f7b902f989439ac319”,“0x9d0676ec013cb50b7bf9b291c22b618e9fe86832”,“0xca2d052fcedbf532ca8cef2d3d1d84a041a258f7”,“0x23280356de3a7aec0b0710cd9b902ac8f431368c”,“0x23180d15651fe6e4415ce27b212cf8e5d2deda96”,“0xea9b070db9a823148d6d75d0875c25d5e51436ba”,“0xd5b13c8871a6e337e6492b30a7cac5c7d38737ac”,“0xa2d4dd85c24c73ddc8d815689f5913ec2166402c”]	6666544	2025-11-20T00:04:07.000Z	[“309012820095270653101”,“5126870226545248584085”,“357746203363380082959”,“4062162168838661766182”,“4150984692450760052924”,“63232690644589850816”,“64855577141113274811”,“260126442055664909243”,“27380451152109032920”,“688620091186669848996”,“9211345463289023973”,“20010778311482342941”,“6782135563314539980”,“18650001859808219945”,“3710570036355566989”]	0x5c8d4fa84c2f55055d0a3e536395c9ae893283beb95978eafa53f3f1df2a4072

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_plasma.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
0x8e05bf8df95134a95d3513d5e0a0030abc39f2a3	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0xb870d56d664f8296810eb565ca83c81e9f746437	0x888888888889758f76e7103c6cbf23abbf58f946	0x0a1a1a107e45b7ced86833863f482bc5f4ed82ef	17	4344879	122965400495309723	0xb161f6252a7abf0a49a5afedbdd94054e2bc6277bb7a6991c8ee92a59411df4c	0	2025-10-24T02:51:25.000Z	0x300fb599e82cbcad105eae5c128e65aa5f38ecab98e19c2697db8c460f637ff6	98238402175377148471	105027879605827124629	98238402175377148471
0x8e05bf8df95134a95d3513d5e0a0030abc39f2a3	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0xc208ec6d0b79cc59d322eb4eb5f069d551bd3c0e	0x888888888889758f76e7103c6cbf23abbf58f946	0x0a1a1a107e45b7ced86833863f482bc5f4ed82ef	59	4358485	8303063600318745	0xb54b1a042eaf2a6cc9751aeafe8ed2e0cffe0a5680c2c09511d0f05f85cb1207	3	2025-10-24T06:38:11.000Z	0x6246036956a544bcbb539a6c79b567b340de777fa89ea5dea1c2a26dc867123d	6640572182432906768	488239364680814995	7128811547113721764
0x8e05bf8df95134a95d3513d5e0a0030abc39f2a3	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0x1c80b0ef76efcec3ec49a2c7a05bffb4a053c569	0x888888888889758f76e7103c6cbf23abbf58f946	0x0a1a1a107e45b7ced86833863f482bc5f4ed82ef	24	4367414	754803535123347540554	0x72a0c659726ba2db8afbb00b54093d4886ee006b40ca54354a4118cc395264bb	2	2025-10-24T09:07:00.000Z	0x23e784f3174ac99769ee67e30181713d74f5498b2c12be4292d090001fd86e75	603345389504876844203704	645193224993268611415327	41847835488391767211623

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_plasma.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
0x9d9f6fab3e2f04313ccca557404fc875674f6c9a	0x28de02ac3c3f5ef427e55c321f73fdc7f192e8e4	false	0xaec826e70d23a1aa97406e6d71ce85f7c244b645	4	1949503	2563586178724715525	2025-09-26T09:23:00.000Z	1113012934592821099	6876303939432157	0xa8fb2e9d3f5e685cd46f2ef45eab0a3c66a30903b72fde5956b32cef49b37ce2
0xffaf49f320b8ae1bb9ea596197040077a3666105	0x28de02ac3c3f5ef427e55c321f73fdc7f192e8e4	false	0x23180d15651fe6e4415ce27b212cf8e5d2deda96	2	4108885	20469891492517648113	2025-10-21T09:18:11.000Z	1049628443874875847	7968169649176873	0xc63a0cb51e189fe8cfb3bc47fbe1465a3b514ba1659fd761c67e9a8192ed60b6
0xcea23ab8fde0b90e4d08eb68e8876e43933721d2	0x28de02ac3c3f5ef427e55c321f73fdc7f192e8e4	false	0xca2d052fcedbf532ca8cef2d3d1d84a041a258f7	2	4107238	17976748709884210927	2025-10-21T08:50:44.000Z	1052003022957654977	9950330853168082	0x9e5f650fdcce0d1fc93c2ad9ff0b435eab52945c11496d4c68b069099c38c4d0

Example Query

Query with partition filter

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

MarketFactoryV6_CreateNewMarket_event

Pendle V6 market creation events emitted when new AMM (Automated Market Maker) liquidity pools are deployed for Principal Token (PT) trading. Contains market address, PT contract reference, and AMM curve parameters including initial anchor, scalar root, and natural logarithm of fee rate root used for yield token pricing.

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
0x54dc267be2839303ff1e323584a16e86cec4aa44	0x84a240fa784e7f03cb99ba3716065961c5d0d531	false	0x4bab3368dedb3398664e845612d189666c6c3f5f	2	8262632	22302040332956929872	2025-12-08T11:28:23.000Z	1044320697199067584	9950330853168082	0xc9749fa627daffdaa193fb21983d3949c47159ffabab230e853d18e725bc766f
0xab509448ad489e2e1341e25cc500f2596464cc82	0x84a240fa784e7f03cb99ba3716065961c5d0d531	false	0x5fa69163085efd4767f24639eb1fb87ed34bbb12	2	8262771	22302053088424335738	2025-12-08T11:30:42.000Z	1044320090814152778	9950330853168082	0x56b00fda7122961b3fd7666370bfb29f7f4c1ed77d9c6f03cf7f75e64e38db05

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_plasma.MarketFactoryV6_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
0x0d7d9abee602c7f0a242ea7e200e47c372acba84	false	12	0x1db12b341cf8d55b909544cf0877f05ed4eb81b6	7402946	388916961397066431291	950469642186985834917	623362176587004616677	2025-11-28T12:40:17.000Z	0x7f44e581c8c72840fc564601b9d933a3d99a1930f4def50be726ed0bf880d5bb
0x0d7d9abee602c7f0a242ea7e200e47c372acba84	false	14	0xf74c487e7d9ffebdcfb3189118d74b0b8591dc83	7383261	27881304188858308753	68151419881122790724	44694625883074674017	2025-11-28T07:12:12.000Z	0xd6dc125cb448be5984716e4595709b00580fcda6f36cf5b37ffa455d9b154bf5
0x0d7d9abee602c7f0a242ea7e200e47c372acba84	false	14	0x50ae8ce687701beedd09dc56bd5e0da3a1160455	7363791	566243569228249812866	1387668741732484131317	909416622897151705333	2025-11-28T01:47:42.000Z	0xcef02605319668d8b979d407d24f9f13c10569876eebce3d762b6fc07e8cdc78

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_plasma.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
0x0cb289e9df2d0dcfe13732638c89655fb80c2be2	false	0x888888888889758f76e7103c6cbf23abbf58f946	9	5676897182	1580063	-5519585498	0x0cb289e9df2d0dcfe13732638c89655fb80c2be2	5645729	2025-11-08T04:15:01.000Z	0x65990265171d72383bfce682cb79b47c8877408f4b2fd2cd4cdee6da32783d8b	1264050
0x0cb289e9df2d0dcfe13732638c89655fb80c2be2	false	0x888888888889758f76e7103c6cbf23abbf58f946	25	883562	244	-859078	0x0cb289e9df2d0dcfe13732638c89655fb80c2be2	5647110	2025-11-08T04:38:02.000Z	0x1da30e6f63acf97f225cd471d0b161b69cf9e8111b1b67037f0764dc023333fd	195
0x0cb289e9df2d0dcfe13732638c89655fb80c2be2	false	0xbbaaf8c4a774c0da0f0b1fca6d01583688f75dec	55	-31227	90	30261	0x5ebe5223831523823528ef0a7edf67d288b1b070	5645736	2025-11-08T04:15:08.000Z	0xc6c8f628762b63c0160968eb0d59282cae6a93e99cbc6baffd7dc73d606fd713	71

Example Query

Query with partition filter

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

MarketV6_Burn_event

Liquidity provider (LP) token burn events from Pendle V6 markets, recording the removal of liquidity and redemption of Principal Tokens (PT) and Standardized Yield (SY) tokens. Contains LP amounts burned, PT and SY outputs, and receiver addresses for tracking liquidity withdrawals and pool exits.

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_receiverSy`	`STRING`	Address of the recipient receiving Standardized Yield (SY) tokens from the burn operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiverPt`	`STRING`	Address of the recipient receiving Principal Tokens (PT) from the burn operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_netLpBurned`	`STRING`	Amount of Liquidity Provider (LP) tokens burned in the liquidity removal operation. Numeric string representation of the token amount in smallest unit.
`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_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.

Sample Data

address	removed	log_index	in_netPtOut	in_netSyOut	block_number	in_receiverPt	in_receiverSy	in_netLpBurned	block_timestamp	transaction_hash
0x4bab3368dedb3398664e845612d189666c6c3f5f	false	8	1245196503593647873329	9034911811121653028117	8637803	0x4bab3368dedb3398664e845612d189666c6c3f5f	0x68930887e1318ef30653a4b7942ab07544ebed4d	3772819286458075737609	2025-12-12T19:41:14.000Z	0x9ab0f61fb525e5fd05513d6654e3ea8a1102087e21e03a434f9703fc638108d6
0x4bab3368dedb3398664e845612d189666c6c3f5f	false	8	3904478294549304119676	28567915223326243574466	8632377	0x4bab3368dedb3398664e845612d189666c6c3f5f	0x68930887e1318ef30653a4b7942ab07544ebed4d	11917578862345136799133	2025-12-12T18:10:48.000Z	0xc3c1b1233807f1456fe842342d5910945a4d0413bd6971d3d64a1ad5145d5fa0
0x4bab3368dedb3398664e845612d189666c6c3f5f	false	8	353061173647634555732	2653555444360971724691	8585187	0x4bab3368dedb3398664e845612d189666c6c3f5f	0x68930887e1318ef30653a4b7942ab07544ebed4d	1103490856432480255906	2025-12-12T05:04:18.000Z	0x6f434ab3149193440bc2b7148e2610d77059c5da7f7649e6c75db21a15be71b1

Example Query

Query with partition filter

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

MarketV6_Mint_event

Pendle V6 market liquidity provision events recording the minting of LP (Liquidity Provider) tokens in exchange for PT (Principal Token) and SY (Standardized Yield) token deposits. Tracks quantities of tokens consumed and LP tokens issued to the receiver address for yield-bearing asset 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_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
0x5fa69163085efd4767f24639eb1fb87ed34bbb12	false	32	0x98fa74aeb7c9e941500fbbe9e7950c179b76a52b	8262771	31974740257734912	138462468257524351	66537970047027082	2025-12-08T11:30:42.000Z	0x56b00fda7122961b3fd7666370bfb29f7f4c1ed77d9c6f03cf7f75e64e38db05
0x4bab3368dedb3398664e845612d189666c6c3f5f	false	32	0x98fa74aeb7c9e941500fbbe9e7950c179b76a52b	8262632	33450867372721162	175340912201688119	76585283175493069	2025-12-08T11:28:23.000Z	0xc9749fa627daffdaa193fb21983d3949c47159ffabab230e853d18e725bc766f
0x5fa69163085efd4767f24639eb1fb87ed34bbb12	false	62	0xa69bfa73f231b999c47bf6e822524313334ce324	8384124	7962360929010523093108	34479971956030889329007	16569308420573228437801	2025-12-09T21:13:15.000Z	0x0501c17e18bdf70634c5ba010c29a48ac73a5d148423ab69827b68ee3d1428b6

Example Query

Query with partition filter

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

MarketV6_Swap_event

Pendle Protocol V6 market swap events recording Principal Token (PT) and Standardized Yield (SY) token exchanges. Contains swap direction (PT/SY amounts with positive for receipts, negative for contributions), protocol fees, reserve allocations, caller and receiver addresses for tracking yield token trading 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_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
0x4bab3368dedb3398664e845612d189666c6c3f5f	false	0x888888888889758f76e7103c6cbf23abbf58f946	10	27830538753311123	6951392443135	-27312653130932759	0x4bab3368dedb3398664e845612d189666c6c3f5f	8456407	2025-12-10T17:17:58.000Z	0xd71e54cd0232875af549f1d7c370faf9044c0e2b2ff564f9a1c8193a288b8a91	5561113954508
0x4bab3368dedb3398664e845612d189666c6c3f5f	false	0x888888888889758f76e7103c6cbf23abbf58f946	8	3212558055248593927	803408840170353	-3152702520230949809	0x4bab3368dedb3398664e845612d189666c6c3f5f	8443448	2025-12-10T13:41:59.000Z	0x9b55ba6df069a61b7b769339d0c8c01f3474c786c6c981968d0d55f73105baf0	642727072136282
0x5fa69163085efd4767f24639eb1fb87ed34bbb12	false	0x888888888889758f76e7103c6cbf23abbf58f946	31	360443107185097907891	74478891209822075	-292269986494760343771	0xad9d7b8180d63d57e0fce365d0dbc8057eac0c1a	8443558	2025-12-10T13:43:49.000Z	0x79cb8b600ea29ab8d18610969e5352a55b45596392a0c779e3b21285ae265778	59583112967857660

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_plasma.MarketV6_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
0xe090d9d417e54116c50e5d5dde1509af91102ec3	false	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	38	0x0a1a1a107e45b7ced86833863f482bc5f4ed82ef	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	7936962	20200628791982733214801	2025-12-04T17:00:33.000Z	0x8edb3e9318bd3db3133b2252cee26ae39b4ed56ae9365031f20a065a64fd6ed1	20200628791982733214801
0xe090d9d417e54116c50e5d5dde1509af91102ec3	false	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	6	0x0a1a1a107e45b7ced86833863f482bc5f4ed82ef	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	7948567	500000000000000000000	2025-12-04T20:13:58.000Z	0x9117d15ca2b60ac750366dedf3df6e87d6430997c97cd36877e48a96dcb73084	500000000000000000000
0xe090d9d417e54116c50e5d5dde1509af91102ec3	false	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	7	0x0a1a1a107e45b7ced86833863f482bc5f4ed82ef	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	7939611	5382000000000000000000	2025-12-04T17:44:42.000Z	0xaed90ae4123f1a36dc86c3449fe26438c88d99dd22d0f01fe163e08b0bbe3baf	5382000000000000000000

Example Query

Query with partition filter

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

SYv6_Deposit_event

Pendle V1 Standardized Yield (SY) token deposit events recording token-to-SY conversions. Tracks caller address, input token contract, deposited amount, and resulting SY tokens received by the designated receiver.

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
0x68930887e1318ef30653a4b7942ab07544ebed4d	false	0x888888888889758f76e7103c6cbf23abbf58f946	14	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	0x2ed473f528e5b320f850d17adfe0e558f0298aa9	8262632	208791779574409281	2025-12-08T11:28:23.000Z	0xc9749fa627daffdaa193fb21983d3949c47159ffabab230e853d18e725bc766f	208791779574409281
0xdb3faad4436e2d133fdab0788332845df9b0abdf	false	0x888888888889758f76e7103c6cbf23abbf58f946	14	0x211cc4dd073734da055fbf44a2b4667d5e5fe5d2	0x2ed473f528e5b320f850d17adfe0e558f0298aa9	8262771	164877812652105454	2025-12-08T11:30:42.000Z	0x56b00fda7122961b3fd7666370bfb29f7f4c1ed77d9c6f03cf7f75e64e38db05	164877812652105454
0x68930887e1318ef30653a4b7942ab07544ebed4d	false	0x888888888889758f76e7103c6cbf23abbf58f946	3	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	0x888888888889758f76e7103c6cbf23abbf58f946	8384038	49600000000000000000000	2025-12-09T21:11:49.000Z	0x05884f006509807674902c9f0a1105da452f941a67df128399010b604893e1cf	49600000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_plasma.SYv6_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
0xa6c55e31154d39bb0aa3ca2ff9f7665bda4e47fc	0xad96c88ec5d39fc5020851075ecb756b2b228060	0x13e695e95601545657caaa7cd62a22fa87b62bdd	0xed0dc8c074255c277bc704d6b096167d7a6e4311	false	1769644800	1	3071057	2025-10-09T08:57:26.000Z	0xf52726f4c4fe91c27741de54a29a9dccd5e99edb9d75bc554732c1e12c27360c
0xa536c9a209c290fd58bb235721c92de75ac4ad71	0xe090d9d417e54116c50e5d5dde1509af91102ec3	0xdb595af89633176a79900c8f63d2f3ed3d7f1c1e	0xed0dc8c074255c277bc704d6b096167d7a6e4311	false	1766016000	10	2208199	2025-09-29T09:16:21.000Z	0xf6d3981cbf9f60f7bc942ad8c1e5373cc1efb337d84fba515e148a1ac1d548c5
0x3a4aac2e8cbac65da238330de6b24bdac7f3a521	0x601afacd8fbdbf44e71201b13d449441621332b9	0x117677beb84bb93e8dadd36950483a59660f3835	0xed0dc8c074255c277bc704d6b096167d7a6e4311	false	1766016000	1	2201111	2025-09-29T07:18:13.000Z	0xa2b482daf0ab140e10b4b424bf19bad7f3ae975968c74c572af30c743c7d084a

Example Query

Query with partition filter

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

YieldContractFactoryV6_CreateYieldContract_event

Event emitted when Pendle protocol’s YieldContractFactoryV6 creates a new yield contract, recording the deployed Principal Token (PT), Yield Token (YT), and Standardized Yield (SY) token addresses along with the contract’s expiration timestamp. Used for tracking new yield token pair deployments 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_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
0xab509448ad489e2e1341e25cc500f2596464cc82	0xdb3faad4436e2d133fdab0788332845df9b0abdf	0xf57bf85a1067bddb44a34152d9a2992882bacce5	0xeaecf59c9da00dacb73c4aaebbba22cf5e5bfd93	false	1775692800	1	8262771	2025-12-08T11:30:42.000Z	0x56b00fda7122961b3fd7666370bfb29f7f4c1ed77d9c6f03cf7f75e64e38db05
0x54dc267be2839303ff1e323584a16e86cec4aa44	0x68930887e1318ef30653a4b7942ab07544ebed4d	0x40acbcbc55d40500fc9d9da8204de972e441f809	0xeaecf59c9da00dacb73c4aaebbba22cf5e5bfd93	false	1775692800	1	8262632	2025-12-08T11:28:23.000Z	0xc9749fa627daffdaa193fb21983d3949c47159ffabab230e853d18e725bc766f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_plasma.YieldContractFactoryV6_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
0xcc4fabf1f3623e4fdd05f119f296169bb56ea3af	false	1	8136577	2025-12-07T00:27:28.000Z	0x87913c44e1bb1394475db1f2f94e67c6cf7ef0830cebf302acd4d63af28b3ed1	0
0x0b47cf5f2dbae10df506d51a1bd0851affe5caae	false	3	8178688	2025-12-07T12:09:19.000Z	0xb29142d05b34156b806849692baf310d2c7db3af709829249b72164dc29e9e75	1679541
0x0b47cf5f2dbae10df506d51a1bd0851affe5caae	false	3	8147209	2025-12-07T03:24:40.000Z	0x4ac02fe08c3c9c510d0429a6616013ddabe0592f0fe364c49e412992f3a00d13	3316242

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_plasma.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

No sample data available.

Example Query

Query with partition filter

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

YTv6_Burn_event

Pendle V6 Principal Yield (PY) token redemption events recording burns of yield-bearing tokens to claim underlying Standardized Yield (SY) tokens. Tracks caller address, receiver address, PY tokens redeemed, and corresponding SY tokens received.

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_amountPYToRedeem`	`STRING`	Quantity of principal yield (PY) tokens being redeemed in the burn operation. 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_receiver	block_number	in_amountSyOut	block_timestamp	transaction_hash	in_amountPYToRedeem
0xf57bf85a1067bddb44a34152d9a2992882bacce5	false	0x888888888889758f76e7103c6cbf23abbf58f946	45	0x5fa69163085efd4767f24639eb1fb87ed34bbb12	8619324	5738132743295847229	2025-12-12T14:33:15.000Z	0x9512d2ac9d72a9b4442641ac10f3bf789d0502f0904d27d634cb08eac3772009	6949024294078375186
0xf57bf85a1067bddb44a34152d9a2992882bacce5	false	0x888888888889758f76e7103c6cbf23abbf58f946	47	0xdb3faad4436e2d133fdab0788332845df9b0abdf	8619324	97283229652094491	2025-12-12T14:33:15.000Z	0x9512d2ac9d72a9b4442641ac10f3bf789d0502f0904d27d634cb08eac3772009	117812458599645172
0xf57bf85a1067bddb44a34152d9a2992882bacce5	false	0x888888888889758f76e7103c6cbf23abbf58f946	19	0xdb3faad4436e2d133fdab0788332845df9b0abdf	8619324	7102471991861099018263	2025-12-12T14:33:15.000Z	0x9512d2ac9d72a9b4442641ac10f3bf789d0502f0904d27d634cb08eac3772009	8601273729179280144648

Example Query

Query with partition filter

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

YTv6_CollectInterestFee_event

Interest fee collection events emitted by Pendle V1 Yield Token (YT) contracts. Records the amount of interest fees collected in the smallest token unit, used for tracking protocol revenue from 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_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
0xf57bf85a1067bddb44a34152d9a2992882bacce5	false	14	8598019	2025-12-12T08:38:10.000Z	0xadd4c701435ec7d918e37281c738c92818db10cd4df69bb1fd071f691e9910d1	80354736816706747
0xf57bf85a1067bddb44a34152d9a2992882bacce5	false	56	8619324	2025-12-12T14:33:15.000Z	0x9512d2ac9d72a9b4442641ac10f3bf789d0502f0904d27d634cb08eac3772009	45424020211434257
0xf57bf85a1067bddb44a34152d9a2992882bacce5	false	33	8705788	2025-12-13T14:34:19.000Z	0x33e0b6aac63dfe403f3d389f266992629b3fb55dafc8c89972b848b11fe51165	30843386351617125

Example Query

Query with partition filter

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

YTv6_CollectRewardFee_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_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

No sample data available.

Example Query

Query with partition filter

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

YTv6_Mint_event

Pendle YTv6 (Yield Token version 6) mint events recording the creation of Principal Token (PT) and Yield Token (YT) pairs from Standardized Yield (SY) tokens. Contains caller address, SY input amount, PY output amount, and recipient addresses for both PT and YT tokens.

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_receiverPT`	`STRING`	Address designated to receive the Principal Token (PT) portion of the minted yield-bearing tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiverYT`	`STRING`	Address designated to receive the Yield Token (YT) portion of the minted yield-bearing tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountSyToMint`	`STRING`	Amount of Standardized Yield (SY) tokens used to mint Principal and Yield tokens. Numeric string representing the token quantity in the smallest unit denomination.
`in_amountPYOut`	`STRING`	Amount of Principal Yield (PY) tokens minted and distributed. Numeric string representing the token quantity in the smallest unit denomination.

Sample Data

address	removed	in_caller	log_index	block_number	in_receiverPT	in_receiverYT	in_amountPYOut	block_timestamp	transaction_hash	in_amountSyToMint
0x40acbcbc55d40500fc9d9da8204de972e441f809	false	0x888888888889758f76e7103c6cbf23abbf58f946	21	8262632	0x2ed473f528e5b320f850d17adfe0e558f0298aa9	0x2ed473f528e5b320f850d17adfe0e558f0298aa9	33450867372721162	2025-12-08T11:28:23.000Z	0xc9749fa627daffdaa193fb21983d3949c47159ffabab230e853d18e725bc766f	33450867372721162
0xf57bf85a1067bddb44a34152d9a2992882bacce5	false	0x888888888889758f76e7103c6cbf23abbf58f946	21	8262771	0x2ed473f528e5b320f850d17adfe0e558f0298aa9	0x2ed473f528e5b320f850d17adfe0e558f0298aa9	31974740257734912	2025-12-08T11:30:42.000Z	0x56b00fda7122961b3fd7666370bfb29f7f4c1ed77d9c6f03cf7f75e64e38db05	26415344394581103
0xf57bf85a1067bddb44a34152d9a2992882bacce5	false	0x888888888889758f76e7103c6cbf23abbf58f946	56	8384124	0x5fa69163085efd4767f24639eb1fb87ed34bbb12	0xa69bfa73f231b999c47bf6e822524313334ce324	7962360929010523102994	2025-12-09T21:13:15.000Z	0x0501c17e18bdf70634c5ba010c29a48ac73a5d148423ab69827b68ee3d1428b6	6576440772006306953754

Example Query

Query with partition filter

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

YTv6_RedeemInterest_event

Pendle V1 Yield Token (YT) interest redemption events tracking user withdrawals of accrued interest from yield-bearing positions. Records user addresses and interest amounts claimed from YTv6 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_interestOut`	`STRING`	Amount of interest redeemed by the user from the Yield Token (YT) contract. Denominated in the smallest unit of the underlying token.

Sample Data

address	in_user	removed	log_index	block_number	in_interestOut	block_timestamp	transaction_hash
0xf57bf85a1067bddb44a34152d9a2992882bacce5	0x927d81b91c41d1961e3a7d24847b95484e60c626	false	57	8619324	863056384017250894	2025-12-12T14:33:15.000Z	0x9512d2ac9d72a9b4442641ac10f3bf789d0502f0904d27d634cb08eac3772009
0xf57bf85a1067bddb44a34152d9a2992882bacce5	0xedac64752386f0236128036fe6fce6dc2cac2fcf	false	15	8598019	1526739999517428211	2025-12-12T08:38:10.000Z	0xadd4c701435ec7d918e37281c738c92818db10cd4df69bb1fd071f691e9910d1
0xf57bf85a1067bddb44a34152d9a2992882bacce5	0x43f25d8ecff3ed55478beadfb7fbe40ad6040445	false	54	8706683	306007655143802686	2025-12-13T14:49:14.000Z	0x7f674986294d8dfdcfc6bd241a5fc20fe8a29f5aa30a4d929c755d9a2abef333

Example Query

Query with partition filter

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

YTv6_RedeemRewards_event

Reward redemption events from Pendle V6 yield token (YT) contracts capturing user claims of accumulated incentives. Contains user address and reward amounts array for tracking yield 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountRewardsOut`	`ARRAY<STRING>`	Array of reward amounts distributed to the user when redeeming Yield Tokens (YT) in the Pendle protocol. String-encoded numeric values representing token amounts in their smallest denomination.

Sample Data

address	in_user	removed	log_index	block_number	block_timestamp	transaction_hash	in_amountRewardsOut
0xf57bf85a1067bddb44a34152d9a2992882bacce5	0xfb09da501a1939959daefa9dbdf196007a9befa4	false	4	9276292	2025-12-20T05:02:43.000Z	0x5d0ea5569d1ff1ed0450349cd2ed2420ff84f2360ac936f5207dab91f565cd2c	[]
0xf57bf85a1067bddb44a34152d9a2992882bacce5	0x16ffe282441c2922b66bc3ef977822a404847229	false	6	9496134	2025-12-22T18:06:45.000Z	0xc922338f161bdaf29ce616642cbac42bd8718e18c2bf82f41b8afa7693daa493	[]
0xf57bf85a1067bddb44a34152d9a2992882bacce5	0x16ffe282441c2922b66bc3ef977822a404847229	false	6	9888054	2025-12-27T06:58:45.000Z	0x8cfd894f3fed8642031274b7e929fb08c10554bf312905fb86546d9e2aa6458e	[]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_plasma.YTv6_RedeemRewards_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

MarketFactoryV6_CreateNewMarket_event

MarketV5_Mint_event

MarketV5_Swap_event

MarketV6_Burn_event

MarketV6_Mint_event

MarketV6_Swap_event

SYv5_Deposit_event

SYv6_Deposit_event

YieldContractFactoryV5_CreateYieldContract_event

YieldContractFactoryV6_CreateYieldContract_event

YTv5_CollectInterestFee_event

YTv5_CollectRewardFee_event

YTv6_Burn_event

YTv6_CollectInterestFee_event

YTv6_CollectRewardFee_event

YTv6_Mint_event

YTv6_RedeemInterest_event

YTv6_RedeemRewards_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​GaugeController_ReceiveVotingResults_event

​LimitRouter_OrderFilledV2_event

​MarketFactoryV5_CreateNewMarket_event

​MarketFactoryV6_CreateNewMarket_event

​MarketV5_Mint_event

​MarketV5_Swap_event

​MarketV6_Burn_event

​MarketV6_Mint_event

​MarketV6_Swap_event

​SYv5_Deposit_event

​SYv6_Deposit_event

​YieldContractFactoryV5_CreateYieldContract_event

​YieldContractFactoryV6_CreateYieldContract_event

​YTv5_CollectInterestFee_event

​YTv5_CollectRewardFee_event

​YTv6_Burn_event

​YTv6_CollectInterestFee_event

​YTv6_CollectRewardFee_event

​YTv6_Mint_event

​YTv6_RedeemInterest_event

​YTv6_RedeemRewards_event

Tables

GaugeController_ReceiveVotingResults_event

LimitRouter_OrderFilledV2_event

MarketFactoryV5_CreateNewMarket_event

MarketFactoryV6_CreateNewMarket_event

MarketV5_Mint_event

MarketV5_Swap_event

MarketV6_Burn_event

MarketV6_Mint_event

MarketV6_Swap_event

SYv5_Deposit_event

SYv6_Deposit_event

YieldContractFactoryV5_CreateYieldContract_event

YieldContractFactoryV6_CreateYieldContract_event

YTv5_CollectInterestFee_event

YTv5_CollectRewardFee_event

YTv6_Burn_event

YTv6_CollectInterestFee_event

YTv6_CollectRewardFee_event

YTv6_Mint_event

YTv6_RedeemInterest_event

YTv6_RedeemRewards_event