pendle_v1_sonic

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
0xee708fc793a02f1edd5bb9dbd7fd13010d1f7136	false	1756944000	16	[“0x004f76045b42ef3e89814b12b37e69da19c8a212”,“0xc1fd739f2bf1aad96f04d6ae35ed04da4d68366b”,“0x7e2bcdb749d90aa1e9e7262872ac8b1e062b2c4d”,“0x19524fc9b2348d4d6a489a4cd3179405e84eeb9b”,“0x4aee8d5e242c2485bd124299203c7fa5108c25fc”,“0xc9646f2a8a1d2f12a7fbf0274ec2d3ecc65f1468”,“0x784abe614738e4b30add5ae8cc96e59b5728d936”,“0xabfc41b413891c647d0d1cd66bf64bc6ed8fee71”,“0x7fa648887b2a10cbbf7c54d00d86d0b2a0a37b53”,“0xb92dd6487a9644ce384b4a2198aa2dd230e00b72”,“0xd0e59a083cc31356d29d9b6d2574024e945468a3”,“0x92a991e5cf27de3ffd021d2fcf79f0b2f140aad4”,“0x0d769b6ad1a553cb789490ca264352318aaaa8c6”,“0x1ab8253c77eb7edd5e4d95ed435e1e77042e95a0”,“0xcb8c4ee27096da1f045ad60696779011c90c7ce1”]	45661442	2025-09-04T00:03:58.000Z	[“1050665928689582156301”,“2590705455314159990”,“11241795797535239960”,“4582258605728399983”,“99021333196434239651”,“18353015306494559935”,“2880821039131319989”,“8134320495966119971”,“13495306233147479952”,“3648457791329519987”,“951045988587599996”,“1052922719960159996”,“225341947726639679206”,“135934309901331599521”,“825417440712839997”]	0x75f37851540dd5085befd16b3c0f4b2c428683fcd0c3fe843c84e45edf7ed938
0xee708fc793a02f1edd5bb9dbd7fd13010d1f7136	false	1741824000	6	[“0xd14117baf6ec5d12be68cd06e763a4b82c9b6d1d”,“0x6e4e95fab7db1f0524b4b0a05f0b9c96380b7dfa”,“0x3aef1d372d0a7a7e482f465bc14a42d78f920392”,“0x4e82347bc41cfd5d62cef483c7f0a739a8158963”,“0x3f5ea53d1160177445b1898afbb16da111182418”]	13346531	2025-03-13T00:03:34.000Z	[“357096781816743669682”,“695638616045973367284”,“963380188337672270431”,“355260178205918300632”,“290553095590013518120”]	0xc50f705562c43b4473e826db271535252f4d067769dc2f79db34f1af5fdb551e
0xee708fc793a02f1edd5bb9dbd7fd13010d1f7136	false	1741824001	6	[“0xd14117baf6ec5d12be68cd06e763a4b82c9b6d1d”,“0x6e4e95fab7db1f0524b4b0a05f0b9c96380b7dfa”,“0x3aef1d372d0a7a7e482f465bc14a42d78f920392”,“0x4e82347bc41cfd5d62cef483c7f0a739a8158963”,“0x3f5ea53d1160177445b1898afbb16da111182418”]	13368290	2025-03-13T02:33:59.000Z	[“818000000000000000000”,“818000000000000000000”,“2685000000000000000000”,“818000000000000000000”,“1227000000000000000000”]	0x462352c4e415f1faf6de625dbb093b5b3002dcc2e4ecdec1dd3f239242e6db52

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_sonic.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
0x30989fd89e9fa16191f38807d56cdfe98ad206f2	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0xd40a658e89170b3fd28009ae55c4d98fe2ad6fb0	0x888888888889758f76e7103c6cbf23abbf58f946	0x8bb86a99f97f5d19718bd5ca0b0ca00354532ef3	111	19438923	269865729122409	0x03fa893ee3c8452523e6eb8416991c4b2fb9d69d6ca5feabc2f512969d8c7f0d	3	2025-04-10T19:21:41.000Z	0x58a6b6a7b696a89f189536d73304370e821e2f4d82256b39be1008f8dec5c7a3	2045030877730042767	15768689330600156	2061937349359519906
0x30989fd89e9fa16191f38807d56cdfe98ad206f2	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0xd40a658e89170b3fd28009ae55c4d98fe2ad6fb0	0x888888888889758f76e7103c6cbf23abbf58f946	0x8bb86a99f97f5d19718bd5ca0b0ca00354532ef3	41	19354412	894471740934255	0x1091ae5deb2edcb3ed34d2f5f505db314da63a7d688d2bc14684a5b560afcbf4	3	2025-04-10T10:43:22.000Z	0x0b7773a0dbb57b4c0157094d0cbe5fcc9072f875bb94ea384d0eb5b90682ac74	6728021967632356141	52266951795764743	6784023032454072263
0x30989fd89e9fa16191f38807d56cdfe98ad206f2	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0xd40a658e89170b3fd28009ae55c4d98fe2ad6fb0	0x888888888889758f76e7103c6cbf23abbf58f946	0x8bb86a99f97f5d19718bd5ca0b0ca00354532ef3	39	19438252	781722024619043	0x1091ae5deb2edcb3ed34d2f5f505db314da63a7d688d2bc14684a5b560afcbf4	3	2025-04-10T19:17:16.000Z	0xd1c50a7d7d5e6257dad795633638fb63363f0c586d7bc6d4fa28bb160f64fa14	5923478891102991152	45677288693709157	5972451724075754877

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_sonic.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
0xbab91a3046003a5be46693d14e28d3b48252cf93	0xfee31a6ec6ebefa0b5a594bf5b1139e3c6faa0fb	false	0xabfc41b413891c647d0d1cd66bf64bc6ed8fee71	11	36158330	2296770857984959670	2025-06-27T10:07:24.000Z	1478418954746697622	48780640314556431	0xb719abf82f69f0b7f6dc382277bf11b87702383243c6a4e9e85a33cf28c4677b
0x14438b1cc1c4183432f7eae2dc27400467033036	0xfee31a6ec6ebefa0b5a594bf5b1139e3c6faa0fb	false	0xcb8c4ee27096da1f045ad60696779011c90c7ce1	16	44462651	37215638646638198487	2025-08-25T13:37:19.000Z	1026281456915540788	5982071677547463	0x4d74ed29e9f85b8557d5bb94c0519bfd62196227e77f8f34cba1dc0f0bcc8534
0x0816792e394707f9b51b1e710a8186e2a4f98fa6	0xfee31a6ec6ebefa0b5a594bf5b1139e3c6faa0fb	false	0x19524fc9b2348d4d6a489a4cd3179405e84eeb9b	11	38556520	19057212096595175933	2025-07-15T03:55:16.000Z	1061925771390693417	11137744410455925	0xf3a7fc4a8de0f11dba55b5f514a0cc2f864b8649c53a7a3d3db213c83b1d7002

Example Query

Query with partition filter

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

MarketV5_Mint_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_netLpMinted`	`STRING`	Net amount of liquidity provider (LP) tokens minted in the transaction. String-encoded integer representing the token quantity in its smallest unit.
`in_netSyUsed`	`STRING`	Net amount of Standardized Yield (SY) tokens consumed in the mint operation. String-encoded integer representing the token quantity in its smallest unit.
`in_netPtUsed`	`STRING`	Net amount of Principal Token (PT) consumed in the mint operation. String-encoded integer representing the token quantity in its smallest unit.

Sample Data

address	removed	log_index	in_receiver	block_number	in_netPtUsed	in_netSyUsed	in_netLpMinted	block_timestamp	transaction_hash
0x004f76045b42ef3e89814b12b37e69da19c8a212	false	20	0x81794deb7ac412929cc6506b64f9c43870086ac5	39301884	97078042	238054994	164925592	2025-07-20T01:48:58.000Z	0x1d7ffc20e07dd8ef4780dc26189490995096bb66a46f716fc385b4c9e3c9c2f4
0x19524fc9b2348d4d6a489a4cd3179405e84eeb9b	false	16	0xc20c94022182505a0c73d1f235acb86647bda29e	39294324	5535984774492368266	15100117979721440429	10772156778870128876	2025-07-20T00:29:24.000Z	0xbd5d6d0d7503645b74be259d5a937d08572215d24f4ed10e056db3440bd45260
0x19524fc9b2348d4d6a489a4cd3179405e84eeb9b	false	23	0x859e1dfb430a7156faef11947f2fc2a3c34b733a	39406984	41890818458949724694823	115522459409870756318995	82210814918985182223673	2025-07-20T19:44:58.000Z	0xb76e4d28ddb1831fedc74dcee96a5aa17d0c9a6cae6f61360d712fcf1a5681e9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_sonic.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
0x004f76045b42ef3e89814b12b37e69da19c8a212	false	0x888888888889758f76e7103c6cbf23abbf58f946	104	1076756477	432145	-1018741960	0x004f76045b42ef3e89814b12b37e69da19c8a212	42448352	2025-08-11T02:00:35.000Z	0x0b1d81ea2df1589fcfe81bf701af3ca6e5318c5ba969379b3bd7ac1d19af9e4f	345715
0x004f76045b42ef3e89814b12b37e69da19c8a212	false	0x888888888889758f76e7103c6cbf23abbf58f946	40	-464665823	185733	439402696	0x2405243576fdff777d54963bca4782180287b6a1	42522518	2025-08-11T14:15:40.000Z	0x2ce58c40be1bd3d1102a8c8197bbac78bf9d6d295b2491759051b49020d49069	148586
0x004f76045b42ef3e89814b12b37e69da19c8a212	false	0x888888888889758f76e7103c6cbf23abbf58f946	20	4731211	1888	-4478041	0x2405243576fdff777d54963bca4782180287b6a1	42556997	2025-08-11T19:41:46.000Z	0x7e73aec829e71f387a1b1fa7d45bea3bd42eb6b2d12e04664e502f18ee5e3901	1510

Example Query

Query with partition filter

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

SYv5_Deposit_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenIn`	`STRING`	Contract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountDeposited`	`STRING`	Quantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
`in_amountSyOut`	`STRING`	Quantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.

Sample Data

address	removed	in_caller	log_index	in_tokenIn	in_receiver	block_number	in_amountSyOut	block_timestamp	transaction_hash	in_amountDeposited
0x7076dee976098b444f68c6382e8f062237879a9f	false	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	35	0x0000000000000000000000000000000000000000	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	47138137	96673414456440236522	2025-09-17T09:22:26.000Z	0x3e7364879214d196195965ffe87dde08ae9124c2f76af7b6147772015015bbe4	100133442488446758278
0x7076dee976098b444f68c6382e8f062237879a9f	false	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	47	0x0000000000000000000000000000000000000000	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	47139168	416142929879380238482	2025-09-17T09:35:22.000Z	0xd3aa1bbdbdc6b44d2c4e20729d0a129ebef99870659b01360b682c555e7b8cb6	431037057813102540973
0x7076dee976098b444f68c6382e8f062237879a9f	false	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	42	0x0000000000000000000000000000000000000000	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	47137878	101010654471411571042	2025-09-17T09:19:14.000Z	0x4bc4aaf098c4739b16f5387528ea69fdbc9ba1cb6f743250e067439b5984ac7f	104625916205648638787

Example Query

Query with partition filter

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

YieldContractFactoryV5_CreateYieldContract_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_SY`	`STRING`	Contract address of the Standardized Yield (SY) token in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`in_PT`	`STRING`	Contract address of the Principal Token (PT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_YT`	`STRING`	Contract address of the Yield Token (YT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_PT	in_SY	in_YT	address	removed	in_expiry	log_index	block_number	block_timestamp	transaction_hash
0x5ee17fd12ede62b508f9615db384ce7b834ba657	0x23a052dfcabd4fa7bd52e7e67e0fb0ee596e7383	0x8ea40880fd6e9647b73fe3faa5042e6694576f0c	0x0582d93fd9c9d42f26be5d86a5f75291f92102c2	false	1761782400	10	41665184	2025-08-05T00:23:50.000Z	0x67256f8482f18275ccfa6ac8a84d421a10c82bccabab0b46aede53f8631f1936
0x930441aa7ab17654df5663781ca0c02cc17e6643	0xc4a9d8b486f388cc0e4168d2904277e8c8372fa3	0x18d2d54f42ba720851bae861b98a0f4b079e6027	0x0582d93fd9c9d42f26be5d86a5f75291f92102c2	false	1755129600	1	13022783	2025-03-11T09:57:45.000Z	0xb471afaeae8e0a8edf7ab9862dbee919af6c5a7ff4ee2af5dc301a7571df3545
0x0816792e394707f9b51b1e710a8186e2a4f98fa6	0xdd3059d662497a212e4ef71260387ec6adc6e8b9	0xde891fae97a70acc25c10a3275874919b0cca44c	0x0582d93fd9c9d42f26be5d86a5f75291f92102c2	false	1766016000	10	38556520	2025-07-15T03:55:16.000Z	0xf3a7fc4a8de0f11dba55b5f514a0cc2f864b8649c53a7a3d3db213c83b1d7002

Example Query

Query with partition filter

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

YTv5_CollectInterestFee_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_amountInterestFee`	`STRING`	Amount of interest fee collected in the CollectInterestFee event. String representation of an integer value denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_amountInterestFee
0x236093091952fb85cd755c6c808ee9802c3874d6	false	8	53471232	2025-11-04T00:15:00.000Z	0xad6e2c0fac6cd4534850de102b1adb8726c7e764fd910c3c16b2d07aa31610a9	235326066751733241
0x236093091952fb85cd755c6c808ee9802c3874d6	false	3	53657207	2025-11-04T22:25:39.000Z	0x6bb9b2bfccce0ea0c588206508fa95213009f935a692c2028eea4972c106c433	656550409723439691
0x236093091952fb85cd755c6c808ee9802c3874d6	false	3	53478944	2025-11-04T01:13:26.000Z	0xa77c7785d4eb19e0422660a98c1fca848dfa5a47b70c05e9c7ec19fdc7ac7338	2687516722492663631

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_sonic.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
0x64547ba3f2d032c2d9f43e6ca1a98516a43dad3f	false	8	20313889	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	2025-04-15T04:11:09.000Z	0x25dc889098a48ef571ff29e4b3333882a74cb56c81430c34ee5af125ec80ee5b	183414892201938303
0x64547ba3f2d032c2d9f43e6ca1a98516a43dad3f	false	5	20313889	0x53f753e4b17f4075d6fa2c6909033d224b81e698	2025-04-15T04:11:09.000Z	0x25dc889098a48ef571ff29e4b3333882a74cb56c81430c34ee5af125ec80ee5b	0
0x64547ba3f2d032c2d9f43e6ca1a98516a43dad3f	false	5	20315639	0x53f753e4b17f4075d6fa2c6909033d224b81e698	2025-04-15T04:25:29.000Z	0x2b4aed8e4f6c65e561b008e1814d08aa10df3ecd603364f8dd542f5312c68073	0

Example Query

Query with partition filter

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

MarketFactoryV5_CreateNewMarket_event

MarketV5_Mint_event

MarketV5_Swap_event

SYv5_Deposit_event

YieldContractFactoryV5_CreateYieldContract_event

YTv5_CollectInterestFee_event

YTv5_CollectRewardFee_event

​Tables

​GaugeController_ReceiveVotingResults_event

​LimitRouter_OrderFilledV2_event

​MarketFactoryV5_CreateNewMarket_event

​MarketV5_Mint_event

​MarketV5_Swap_event

​SYv5_Deposit_event

​YieldContractFactoryV5_CreateYieldContract_event

​YTv5_CollectInterestFee_event

​YTv5_CollectRewardFee_event

Tables

GaugeController_ReceiveVotingResults_event

LimitRouter_OrderFilledV2_event

MarketFactoryV5_CreateNewMarket_event

MarketV5_Mint_event

MarketV5_Swap_event

SYv5_Deposit_event

YieldContractFactoryV5_CreateYieldContract_event

YTv5_CollectInterestFee_event

YTv5_CollectRewardFee_event