pendle_v1_base

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
0x17f100fb4be2707675c6439468d38249dd993d58	false	1735171200	206	[“0x483f2e223c58a5ef19c4b32fbc6de57709749cb3”,“0x727cebacfb10ffd353fc221d06a862b437ec1735”,“0xd94fd7bceb29159405ae1e06ce80e51ef1a484b0”,“0x3124d41708edbdc7995a55183e802e3d9d0d5ef1”,“0xecc2c994aa0c599a7f69a7cfb9106fe4dffb4341”,“0x14936c9b8eb798ca6291c2d6ce5de2c6cb5f1f9c”]	24191039	2024-12-26T00:03:45.000Z	[“23994584124145917425”,“6085487837277221487760”,“149669645699974803627”,“26249448700465430453”,“411594256640051670”,“918872574406275808979”]	0xe4204b796737486244775630ed7550f8d2a726ef3865136b7040ae356753a5a6
0x17f100fb4be2707675c6439468d38249dd993d58	false	1742428800	242	[“0x483f2e223c58a5ef19c4b32fbc6de57709749cb3”,“0x727cebacfb10ffd353fc221d06a862b437ec1735”,“0xd94fd7bceb29159405ae1e06ce80e51ef1a484b0”,“0x3124d41708edbdc7995a55183e802e3d9d0d5ef1”,“0xecc2c994aa0c599a7f69a7cfb9106fe4dffb4341”,“0x14936c9b8eb798ca6291c2d6ce5de2c6cb5f1f9c”,“0x621d4d92e9bed484e6d2cb8a37d342c804a0908c”,“0xe15578523937ed7f08e8f7a1fa8a021e07025a08”]	27819839	2025-03-20T00:03:45.000Z	[“7736893122282810821”,“376350718762713396287”,“877706605415307315”,“41894247831685537751”,“6468389907996101486”,“583989155416238633431”,“20402210429741435920”,“3798854101609301644242”]	0x18e8707028cf4bee4cc9b2f78dccb73df8f035842662b4bf6a6252b106fef08c
0x17f100fb4be2707675c6439468d38249dd993d58	false	1763596800	745	[“0x483f2e223c58a5ef19c4b32fbc6de57709749cb3”,“0x496f251487f6fdc8355df5eb5940c6285ef7314a”,“0x0a3ff49732b13e11b91f1c8d61c6c9c10bf5a36c”,“0x9621342d8fb87359abe8ab2270f402f202f87b67”,“0x8991847176b1d187e403dd92a4e55fc8d7684538”,“0xd5dd84c7b8919dceb09536a0fef6db9046805127”,“0x5304a194a535b7c4c54a1e7bc138e8556f412a5d”,“0x5d6e67fce4ad099363d062815b784d281460c49b”,“0xa679ce6d07cbe579252f0f9742fc73884b1c611c”,“0x10c2b26cb728b672f78c5badda8c5376d08cbfd0”,“0x53fb20ff03ef94ef224557cc6262e0f11c20f718”,“0xc25b8b6e56f403b690c0eac8a64c26af7689b49f”]	38403850	2025-11-20T00:04:07.000Z	[“12684099638216159963”,“390411244057031998”,“449916373394927998”,“1626371874463148995”,“1838033012384810994”,“53870400108260999”,“5822338041797804983”,“34032362633060516900”,“33089925161574863903”,“176413441990915205486”,“1493068406148209380656”,“422574296666345998”]	0xda85fb853880dfc79e61f49677a6aaa1af25e43dbd3747d956a09f8313d806bb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.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
0x61468ea4d55c02744041f16daf8ed0262891661f	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0xb610a569ca5d199f006a85780748cc5a6b74b7f5	0x888888888889758f76e7103c6cbf23abbf58f946	0x35e5db674d8e93a03d814fa0ada70731efe8a4b9	128	34349147	134786670988892272	0xa56e22b83b3472c1263a580f9c74a615abacaea0dddadb7a419892d3bb8a3bc7	3	2025-08-18T03:27:21.000Z	0xdd41edb01d60d43b292bfe4745730c979e7033ce5f2341a9404d3f04d426e2ce	826534137628001529265	7499934501637551053	834034072129639080397
0x61468ea4d55c02744041f16daf8ed0262891661f	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0xb610a569ca5d199f006a85780748cc5a6b74b7f5	0x888888888889758f76e7103c6cbf23abbf58f946	0x35e5db674d8e93a03d814fa0ada70731efe8a4b9	951	34348959	195005982339548044	0xa56e22b83b3472c1263a580f9c74a615abacaea0dddadb7a419892d3bb8a3bc7	3	2025-08-18T03:21:05.000Z	0xd5334678a616aed929e32eb4609eaed4e27b9c80a01d3b2bdfa69753341d6937	1195671464188525756715	10850723283379528574	1206522187471905285362
0x5fd84c3dd5c00ab9e04bd94685b55e8dd0c1e3fd	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0x3f51ad2d5ff5b2fc5ace0da7002dc364a3001e32	0x888888888889758f76e7103c6cbf23abbf58f946	0xecac9c5f704e954931349da37f60e39f515c11c1	136	23425202	228	0x4272027ada611c78216a507f2df2b2666bafa17f38897733510ed99d52be0b70	0	2024-12-08T06:35:51.000Z	0x624661772184566fe37af726b95a581492da04ef494f3bafd4dbcf9ac1a5e5c6	485240	506189	485240

Example Query

Query with partition filter

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

MarketFactoryV3_CreateNewMarket_event

Event log emitted when a new Automated Market Maker (AMM) market is created in Pendle’s MarketFactoryV3 contract. Contains the Principal Token (PT) address, deployed market address, and AMM initialization parameters including initial anchor, scalar root, and fee rate root.

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
0x7c3039d2385000cf366e3ac6ab9d7642e8440dd2	0x59968008a703dc13e6beaeced644bdce4ee45d13	false	0x4eae2e40c6612005214ea919cc7653da853ed409	84	30809675	64648394164276601007	2025-05-28T05:04:57.000Z	1014425094992556509	4987541511039073	0xc268eacfbc36100f886cf57cf389476cd364ede40bfb819f780468ea3e9465d2
0x43fe057b02ce301a2b09c9873676032892566de7	0x59968008a703dc13e6beaeced644bdce4ee45d13	false	0xad4e0efc7b641591dc1a94efc5d352d098516d2e	595	29867754	22870282897369617492	2025-05-06T09:47:35.000Z	1018096246534566460	9950330853168082	0x3057d411b6b28dc6eb858b1f35892df0462b9dfd42385ed246bcf087f18d6690
0xb1847b85da0595c6f72b0757ee292bd472dca45e	0x59968008a703dc13e6beaeced644bdce4ee45d13	false	0x6144511e1bd935c258b7b9075f120474df1b1e5f	420	29867233	32055840630288480075	2025-05-06T09:30:13.000Z	1017246070695877819	4987541511039073	0x76d4721a140548cd748bb066d16bc5310dacdf61b90d391613924bf4ad7b0e61

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.MarketFactoryV3_CreateNewMarket_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
0x4063caeb877466e5bf5e5bd9c5ff371fd7155fe3	0x59968008a703dc13e6beaeced644bdce4ee45d13	false	0x5c7368adbad8e92334b868e3385a169076fe9c98	532	31640927	44154056544232248777	2025-06-16T10:53:21.000Z	1144493450214007439	9950330853168082	0x9914de5ad0a029844009691e5d460cce53ae955cb3e0a48caa53d696d7a18644
0x0f63dd2978d47113d50251b0e9272daadf17ed9f	0x59968008a703dc13e6beaeced644bdce4ee45d13	false	0x81e5674d45983a1fc38a52ca96e8279c67386404	340	31638764	44153212067421661924	2025-06-16T09:41:15.000Z	1144515531064694520	9950330853168082	0x7a22b4ac83ffb3bee3c92276f2222bb7773057e316d66a802e128814a16c6789
0x7f49ebf545e3a53005a424aee1773c9ab6d3a8c6	0x59968008a703dc13e6beaeced644bdce4ee45d13	false	0x9797c37ff0028bce50a586f3d54bb35dee2b59b1	334	31633130	44151012518801140198	2025-06-16T06:33:27.000Z	1144573047593560522	9950330853168082	0x483cd23fad4faa51cc2589a2f80c4010c7684303fd029ed0f8c796bcb183ad46

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.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
0xf2a69e0191aad3a7a124397972d0ca0405c1d8d1	0x81e80a50e56d10c501ff17b5fe2f662bd9ea4590	false	0x4ac60d0f9f98287764681df14298c1a11006aefd	780	39202164	148816845577494625573	2025-12-08T11:34:35.000Z	1003924821368969564	1399020913707341	0x445b51ba6aad27132bc666c31e4871151c22a300ee142e0266b9e68b744128c0
0xcf794ce58769015207b0ee13b30ba008cf04010f	0x81e80a50e56d10c501ff17b5fe2f662bd9ea4590	false	0xd43ae4a31effb282ad6e5808f37a515e1572ecf0	564	39239224	24034699459525499287	2025-12-09T08:09:55.000Z	1095126430392336225	11928570865273801	0xeeaf5a8f620ed80b2124a543243418cc028d3518e765d3ce7be4c82fdb6f7deb
0x480cca67e3929d65fd72fdb55aad9b61069b4d4e	0x81e80a50e56d10c501ff17b5fe2f662bd9ea4590	false	0x7099df107eda4df48cde3c7f8a211a29d4149b6c	72	39779231	21739443490753398537	2025-12-21T20:10:09.000Z	1091085337213704315	11928570865273801	0x5ce6df256f226d8264e3750abd234a38007626cb0fd09b3cb72040e6773c2366

Example Query

Query with partition filter

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

MarketV3_Mint_event

Liquidity provision events from Pendle V3 markets on Base, recording when users mint LP tokens by depositing Principal Tokens (PT) and Standardized Yield (SY) tokens. Used for analyzing liquidity provider behavior and pool composition changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x3124d41708edbdc7995a55183e802e3d9d0d5ef1	false	810	0xbf0449e4c9a997800eeda1193625ecd35a3d175e	31129451	3346375	63681235899	585784434	2025-06-04T14:44:09.000Z	0xf178eecd68650dc4b81f7af020b3f08cf8fdcafcf0e9a91116c3a994cbb00089
0x4eae2e40c6612005214ea919cc7653da853ed409	false	126	0xd0e72c1b2eb87e3dc0445b7f689cadcfc872b293	31145302	169334001896724243	1318641796628827809	564265523385851020	2025-06-04T23:32:31.000Z	0x531eb670bf7a065e2ff352bf303446d950b3e1464318adc95e0e8e3dfc73bec7
0x4eae2e40c6612005214ea919cc7653da853ed409	false	145	0xf09c63a2b47d7b383ecc517a295727312384eaed	31124217	116034830930175225	880786728434309360	378009093548848117	2025-06-04T11:49:41.000Z	0x12cccc9ed31d2cd28873b9ac2d4842f8ab8addf75d020c6a643d688e3ee35902

Example Query

Query with partition filter

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

MarketV3_Swap_event

Pendle V3 market swap events capturing Principal Token (PT) and Standardized Yield (SY) token exchanges with protocol fee allocation. Records caller, receiver, net PT and SY amounts, fee collection, and reserve contributions for tracking yield trading activity 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_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
0xe15578523937ed7f08e8f7a1fa8a021e07025a08	false	0x888888888889758f76e7103c6cbf23abbf58f946	281	20654484438843776457	8628760215245859	-20145106703478093832	0x01b4ed571290a87f361cd3fa1640c47093e1602b	27076564	2025-03-02T19:07:55.000Z	0x2fee0348f0c687bfafb1e0def1275be7e833decc362ceff1a6e7d61c7cf385ce	6903008172196687
0xe15578523937ed7f08e8f7a1fa8a021e07025a08	false	0x888888888889758f76e7103c6cbf23abbf58f946	296	15348304906437936544	6411794453804757	-14969845616728846337	0x01b4ed571290a87f361cd3fa1640c47093e1602b	27076650	2025-03-02T19:10:47.000Z	0x371af4e8fa1622b82091cb1ec9975f7d1c7d748e54bb8f414c891d5f84e3a6a9	5129435563043805
0xe15578523937ed7f08e8f7a1fa8a021e07025a08	false	0x888888888889758f76e7103c6cbf23abbf58f946	146	2026970963986092767991	849506378941830892	-1976915120625416117911	0x0736c28b9caa1fab32f55f63f2b2aa93f84f183f	27069282	2025-03-02T15:05:11.000Z	0x1b2f691ff15d1e1566c845636f49fc675ec6f6b486f6a54cbd94c45e1e853e3a	679605103153464713

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.MarketV3_Swap_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
0x483f2e223c58a5ef19c4b32fbc6de57709749cb3	false	157	0xcd54cc88ac8bb4f437937b5dfa9c341570c6169b	22869900	136840981370881125	125921033958110629	131267504973861845	2024-11-25T10:05:47.000Z	0x61314efdf4823a42f5a03542fc9b34c011a496478c6a8b362317d5a2292d1b19
0x3124d41708edbdc7995a55183e802e3d9d0d5ef1	false	428	0xbf0449e4c9a997800eeda1193625ecd35a3d175e	29422956	2895605	58113373260	529178653	2025-04-26T02:40:59.000Z	0x7bdfda9f8cf42218d96828c14a0df682587254a4d28bd806990337dc8765b4c8
0x3124d41708edbdc7995a55183e802e3d9d0d5ef1	false	237	0xf2a7d3793dc6ffff16787b208e5bf5efaf4134b4	29422064	1865944	37448258370	341003277	2025-04-26T02:11:15.000Z	0xe432255bf75f0c93b29fae02bc543e1440d7ac7a5f8e4a3d842089b50d254f77

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.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
0x0a3ff49732b13e11b91f1c8d61c6c9c10bf5a36c	false	0x888888888889758f76e7103c6cbf23abbf58f946	1540	599684818	41258	-500638053	0x3d2e091fbf85ff7f3b20f2d96488dd9c92441a69	38521555	2025-11-22T17:27:37.000Z	0xeda50f397eb60434853624b1a228f71bb70d5373fdd365eadd5faac9be01dc50	33006
0x0a3ff49732b13e11b91f1c8d61c6c9c10bf5a36c	false	0x888888888889758f76e7103c6cbf23abbf58f946	44	799408362	54929	-667379400	0x3d2e091fbf85ff7f3b20f2d96488dd9c92441a69	38522953	2025-11-22T18:14:13.000Z	0x3934e86d7d79dbb154dd9823069ff45fcf4a9213e11cdd4557e3358e3c8d8d2d	43943
0x0a3ff49732b13e11b91f1c8d61c6c9c10bf5a36c	false	0x888888888889758f76e7103c6cbf23abbf58f946	598	-799408360	54924	667263060	0x3d2e091fbf85ff7f3b20f2d96488dd9c92441a69	38522938	2025-11-22T18:13:43.000Z	0xaf6e0ce006f5a35c560d59ceb36c9ead28ded189e4c29c44f99ba6d7041ef03c	43939

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.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
0xd43ae4a31effb282ad6e5808f37a515e1572ecf0	false	496	1273034617662233479	785524593067526391	39651345	0x39e1ceacb646a71295dc832cd19207c681c2d291	0x39e1ceacb646a71295dc832cd19207c681c2d291	1000000000000000000	2025-12-18T21:07:17.000Z	0x34874e142350f353a9f289b8e959ba818e715bc6f284502f8bb9bacc1f7533ce
0xd43ae4a31effb282ad6e5808f37a515e1572ecf0	false	253	1228695229905967150	833723178946826303	39675620	0x39e1ceacb646a71295dc832cd19207c681c2d291	0x39e1ceacb646a71295dc832cd19207c681c2d291	1000000000000000000	2025-12-19T10:36:27.000Z	0xfd9bba56ac3ac58de7a184bc6d0a6c91b0a974c029fd2d33c69c660381eafb6a
0xd43ae4a31effb282ad6e5808f37a515e1572ecf0	false	656	1220451291509012381	841301635733113825	39675652	0xd43ae4a31effb282ad6e5808f37a515e1572ecf0	0x39e1ceacb646a71295dc832cd19207c681c2d291	1000000000000000000	2025-12-19T10:37:31.000Z	0x8346706bb3eba848ec5d404787e1d2dc9963903c44a3c5bcf41d18798efef987

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.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
0x4ac60d0f9f98287764681df14298c1a11006aefd	false	815	0x98fa74aeb7c9e941500fbbe9e7950c179b76a52b	39202164	660000000000	288	13785950	2025-12-08T11:34:35.000Z	0x445b51ba6aad27132bc666c31e4871151c22a300ee142e0266b9e68b744128c0
0xd43ae4a31effb282ad6e5808f37a515e1572ecf0	false	590	0x03cbca42a26f90d2268bb3e5fafa8986648d3e7e	39239224	30920524681214836600	19079475318785163400	24288832567645689727	2025-12-09T08:09:55.000Z	0xeeaf5a8f620ed80b2124a543243418cc028d3518e765d3ce7be4c82fdb6f7deb
0x4ac60d0f9f98287764681df14298c1a11006aefd	false	286	0x3fa8165eb6b16e0fb49d5063e06997015659489c	39370148	102542370000000000	44745762	2142040194047	2025-12-12T08:54:03.000Z	0xd03dd22a920e20719133e789fb1e93d9b7b3090a0990490fa280a7428f997196

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.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
0x4ac60d0f9f98287764681df14298c1a11006aefd	false	0x888888888889758f76e7103c6cbf23abbf58f946	1451	-134001890181824683	299	13376843	0x28888f74ca99924d5a2d48e82bf3d32cc7ec0355	39587648	2025-12-17T09:44:03.000Z	0x2f52cfcf0dc2eb45bf9f7cb7d7d2cac38f81d3ba68e9bdd586e7c1be561828ac	239
0x4ac60d0f9f98287764681df14298c1a11006aefd	false	0x888888888889758f76e7103c6cbf23abbf58f946	459	-473727642755034	1	47290	0x28888f74ca99924d5a2d48e82bf3d32cc7ec0355	39600599	2025-12-17T16:55:45.000Z	0x423980be822d94d258c18de75af383e1a0d5c6a02af2a399870f8689a53d3b06	0
0xd43ae4a31effb282ad6e5808f37a515e1572ecf0	false	0x888888888889758f76e7103c6cbf23abbf58f946	661	-1220451291509012381	6280447727369425	1104129394286848898	0x39e1ceacb646a71295dc832cd19207c681c2d291	39675652	2025-12-19T10:37:31.000Z	0x8346706bb3eba848ec5d404787e1d2dc9963903c44a3c5bcf41d18798efef987	5024358181895540

Example Query

Query with partition filter

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

MarketV6_UpdateImpliedRate_event

Pendle V6 market event emitted when the natural logarithm of the implied interest rate is updated. Tracks rate changes with timestamp for yield trading 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_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_lnLastImpliedRate`	`STRING`	Natural logarithm of the last implied interest rate in the Pendle market. Numeric string representation of a fixed-point decimal value.

Sample Data

address	removed	log_index	block_number	in_timestamp	block_timestamp	transaction_hash	in_lnLastImpliedRate
0x4ac60d0f9f98287764681df14298c1a11006aefd	false	814	39202164	1765193675	2025-12-08T11:34:35.000Z	0x445b51ba6aad27132bc666c31e4871151c22a300ee142e0266b9e68b744128c0	9844874308919421
0xd43ae4a31effb282ad6e5808f37a515e1572ecf0	false	589	39239224	1765267795	2025-12-09T08:09:55.000Z	0xeeaf5a8f620ed80b2124a543243418cc028d3518e765d3ce7be4c82fdb6f7deb	198850858745165184
0x4ac60d0f9f98287764681df14298c1a11006aefd	false	285	39370148	1765529643	2025-12-12T08:54:03.000Z	0xd03dd22a920e20719133e789fb1e93d9b7b3090a0990490fa280a7428f997196	9844874308919421

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.MarketV6_UpdateImpliedRate_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
0xe181aed8e14469231618504df46e8c069314589b	false	0x888888888889758f76e7103c6cbf23abbf58f946	647	0x0000000f2eb9f69274678c76222b35eec7588a65	0x44e2b05b2c17a12b37f11de18000922e64e23faa	33339479	210769614	2025-07-25T18:31:45.000Z	0x6e9c82e3b3f7c67d68666204d03c8aec10928d037abb308e6e3d53625d4af39a	210769614
0xe181aed8e14469231618504df46e8c069314589b	false	0x888888888889758f76e7103c6cbf23abbf58f946	71	0x0000000f2eb9f69274678c76222b35eec7588a65	0x44e2b05b2c17a12b37f11de18000922e64e23faa	33338212	5000000	2025-07-25T17:49:31.000Z	0x8b2ac6f0b67631297ddee0dd239ff1dbc3ab53f1c16e29ebce3297ed24debe8d	5000000
0xe181aed8e14469231618504df46e8c069314589b	false	0x888888888889758f76e7103c6cbf23abbf58f946	797	0x0000000f2eb9f69274678c76222b35eec7588a65	0x44e2b05b2c17a12b37f11de18000922e64e23faa	33337167	20000000	2025-07-25T17:14:41.000Z	0x525c00ff9a5837cc830b60cf42295a29ee5fd1c9706fdcd8d64c409a2b3ef64a	20000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.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
0xda89510d10f1ba01d45669049aa885d66fef2588	false	0x888888888889758f76e7103c6cbf23abbf58f946	797	0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf	0x2ed473f528e5b320f850d17adfe0e558f0298aa9	39202164	354	2025-12-08T11:34:35.000Z	0x445b51ba6aad27132bc666c31e4871151c22a300ee142e0266b9e68b744128c0	354
0x12bb794760afc19b2e4363b0fa4a938133a76123	false	0x888888888889758f76e7103c6cbf23abbf58f946	572	0xaf69bf9ea9e0166498c0502af5b5945980ed1e0e	0x2ed473f528e5b320f850d17adfe0e558f0298aa9	39239224	50000000000000000000	2025-12-09T08:09:55.000Z	0xeeaf5a8f620ed80b2124a543243418cc028d3518e765d3ce7be4c82fdb6f7deb	50000000000000000000
0x12bb794760afc19b2e4363b0fa4a938133a76123	false	0x03cbca42a26f90d2268bb3e5fafa8986648d3e7e	53	0xaf69bf9ea9e0166498c0502af5b5945980ed1e0e	0x03cbca42a26f90d2268bb3e5fafa8986648d3e7e	39240275	1000000000000000000	2025-12-09T08:44:57.000Z	0x6dead1114cb3a3eca851ba40f55d1c27f61a29546a5a0a968394f54acfae8351	1000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.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
0xa28a34f1e16d845a0a709bafaac3831ca7a417a7	0x4b272672a58da22b213e733f5aba48cfec534d30	0x5f42d7365ed7b51a77c275e9f36a8d8f9cc56750	0x963ddbb35c1ae44e2a159e3b5fb5177e0b32660d	false	1753920000	228	28949226	2025-04-15T03:29:59.000Z	0x05207866de88f1b690b521bbb0ef4289e1aa215f166da8e8326b1caf7d470faa
0x2a9e9256e0d1ad0f7f9d7c7248cb7e2f06072deb	0xc40febf5a33b8c92b187d9be0fd3fe0ac2e4b07c	0xe84009923221bb401c811643c5a5efaf56eed4ca	0x963ddbb35c1ae44e2a159e3b5fb5177e0b32660d	false	1750896000	155	23119666	2024-12-01T04:51:19.000Z	0x8d7d62378ad3869426ccc4192fe75c1f2bc89a06eb76034a8bec75c622b075e6
0x5c6593f57ee95519ff6a8cd16a5e41ff50af239a	0x7f5efa1bb887a5080ceacd6f3e2c0fc16bd90c90	0xdc2ffc7b4bd5a38d5842e5fdbb407e731dd30796	0x963ddbb35c1ae44e2a159e3b5fb5177e0b32660d	false	1750896000	187	23119967	2024-12-01T05:01:21.000Z	0xf0964d35bc4c0a020ec3ebde7e0efa786413ab5b13f7512a4238b50baf364a49

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.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
0xf2a69e0191aad3a7a124397972d0ca0405c1d8d1	0xda89510d10f1ba01d45669049aa885d66fef2588	0x28888f74ca99924d5a2d48e82bf3d32cc7ec0355	0xddbfa21ecf024971486684e4e1600998adeabc88	false	1771459200	779	39202164	2025-12-08T11:34:35.000Z	0x445b51ba6aad27132bc666c31e4871151c22a300ee142e0266b9e68b744128c0
0xcf794ce58769015207b0ee13b30ba008cf04010f	0x12bb794760afc19b2e4363b0fa4a938133a76123	0xa1743dffb83b4f640aff2a6ed96b245c32973f5f	0xddbfa21ecf024971486684e4e1600998adeabc88	false	1781136000	563	39239224	2025-12-09T08:09:55.000Z	0xeeaf5a8f620ed80b2124a543243418cc028d3518e765d3ce7be4c82fdb6f7deb
0x480cca67e3929d65fd72fdb55aad9b61069b4d4e	0x5453a2ca28b1c90837f416d7fa3047d1ed7a3df4	0x685eee1505077201fecc1b0c3e9478946f2a59d8	0xddbfa21ecf024971486684e4e1600998adeabc88	false	1782345600	71	39779231	2025-12-21T20:10:09.000Z	0x5ce6df256f226d8264e3750abd234a38007626cb0fd09b3cb72040e6773c2366

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.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
0xb80b9f31064be8a97e4ced4e1368f45826c59868	false	742	25648423	2025-01-28T17:43:13.000Z	0x276427bbde15d16997e84d4ab31dc16d9ba45e31ae84f67ba6c22ba26cdbcda5	11575343413871619
0xb80b9f31064be8a97e4ced4e1368f45826c59868	false	51	25626015	2025-01-28T05:16:17.000Z	0x3aef7d7a13ee2c5ebabe6d87a5adde514f2a32ff6acaae9d02a3a428a08fb5c9	9986004087797148166
0xb80b9f31064be8a97e4ced4e1368f45826c59868	false	204	25645433	2025-01-28T16:03:33.000Z	0xaa0882200898d76254ab57c887e2d5dd9f35142c4c3e4b9d0b555e91deded054	4017172992781133458

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.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
0xce714a2ce5ecec1ba7efdc6456f12c4e7b46fa69	false	79	32148428	0x940181a94a35a4569e4529a3cdfb74e38fd98631	2025-06-28T04:50:03.000Z	0x90ec662b7572ffa76efda63f058c5aabb58a32d091b4a901d284f405f07a51fc	105665411122788611
0xce714a2ce5ecec1ba7efdc6456f12c4e7b46fa69	false	157	32144987	0x940181a94a35a4569e4529a3cdfb74e38fd98631	2025-06-28T02:55:21.000Z	0xcd41e1a696e1ef078721e304c95b3037bb22f829d69d76883d5e3d7292298c32	284664003571915478
0xe84009923221bb401c811643c5a5efaf56eed4ca	false	221	32171148	0xa88594d404727625a9437c3f886c7643872296ae	2025-06-28T17:27:23.000Z	0x4a1361f4a7ae0930d3ac37fd02275c254822e60577e156394db81b2b71a31bf7	33837427374643945597

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.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
0xa1743dffb83b4f640aff2a6ed96b245c32973f5f	false	0x888888888889758f76e7103c6cbf23abbf58f946	678	0x39e1ceacb646a71295dc832cd19207c681c2d291	39550246	1000000000000000000	2025-12-16T12:57:19.000Z	0xad62601c9697e3264c86ae9d192261ee4c65ae00437d804a7c29ec4a17492d5a	1000000000000000000
0xa1743dffb83b4f640aff2a6ed96b245c32973f5f	false	0x888888888889758f76e7103c6cbf23abbf58f946	692	0x39e1ceacb646a71295dc832cd19207c681c2d291	39675497	1000000000000000000	2025-12-19T10:32:21.000Z	0xed05f4fc0d0955afea875e798284153575945b6b7c56a3d21eab1022ebf762e5	1000000000000000000
0xa1743dffb83b4f640aff2a6ed96b245c32973f5f	false	0x888888888889758f76e7103c6cbf23abbf58f946	853	0x39e1ceacb646a71295dc832cd19207c681c2d291	39675581	827554122254234281	2025-12-19T10:35:09.000Z	0xd0ef7ac76cc23e59f92cced184aef534af344f7e9c988b3beb91349c198a1be0	827554122254234281

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_base.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_base.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
0x28888f74ca99924d5a2d48e82bf3d32cc7ec0355	false	0x888888888889758f76e7103c6cbf23abbf58f946	804	39202164	0x2ed473f528e5b320f850d17adfe0e558f0298aa9	0x2ed473f528e5b320f850d17adfe0e558f0298aa9	660000000000	2025-12-08T11:34:35.000Z	0x445b51ba6aad27132bc666c31e4871151c22a300ee142e0266b9e68b744128c0	66
0xa1743dffb83b4f640aff2a6ed96b245c32973f5f	false	0x888888888889758f76e7103c6cbf23abbf58f946	579	39239224	0x2ed473f528e5b320f850d17adfe0e558f0298aa9	0x2ed473f528e5b320f850d17adfe0e558f0298aa9	30920524681214836600	2025-12-09T08:09:55.000Z	0xeeaf5a8f620ed80b2124a543243418cc028d3518e765d3ce7be4c82fdb6f7deb	30920524681214836600
0x28888f74ca99924d5a2d48e82bf3d32cc7ec0355	false	0x888888888889758f76e7103c6cbf23abbf58f946	280	39370148	0x4ac60d0f9f98287764681df14298c1a11006aefd	0x3fa8165eb6b16e0fb49d5063e06997015659489c	102542370000000000	2025-12-12T08:54:03.000Z	0xd03dd22a920e20719133e789fb1e93d9b7b3090a0990490fa280a7428f997196	10254237

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

GaugeController_ReceiveVotingResults_event

LimitRouter_OrderFilledV2_event

MarketFactoryV3_CreateNewMarket_event

MarketFactoryV5_CreateNewMarket_event

MarketFactoryV6_CreateNewMarket_event

MarketV3_Mint_event

MarketV3_Swap_event

MarketV5_Mint_event

MarketV5_Swap_event

MarketV6_Burn_event

MarketV6_Mint_event

MarketV6_Swap_event

MarketV6_UpdateImpliedRate_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

​MarketFactoryV3_CreateNewMarket_event

​MarketFactoryV5_CreateNewMarket_event

​MarketFactoryV6_CreateNewMarket_event

​MarketV3_Mint_event

​MarketV3_Swap_event

​MarketV5_Mint_event

​MarketV5_Swap_event

​MarketV6_Burn_event

​MarketV6_Mint_event

​MarketV6_Swap_event

​MarketV6_UpdateImpliedRate_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

MarketFactoryV3_CreateNewMarket_event

MarketFactoryV5_CreateNewMarket_event

MarketFactoryV6_CreateNewMarket_event

MarketV3_Mint_event

MarketV3_Swap_event

MarketV5_Mint_event

MarketV5_Swap_event

MarketV6_Burn_event

MarketV6_Mint_event

MarketV6_Swap_event

MarketV6_UpdateImpliedRate_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