pendle_v1_optimism

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
0x6875e4a945e498fe1b90bbb13cfbaf0b68658c9c	false	1723075200	8	[“0x24fb77c8c776c75f869bc65e6856af56f57d919f”]	123738357	2024-08-08T00:04:51.000Z	[“7350491324186984716”]	0x12c0164a29351098ed968b69d41678f1f738e02e8b7c9f154fd41593fb57f461
0x6875e4a945e498fe1b90bbb13cfbaf0b68658c9c	false	1704326400	36	[“0x0c485feb9e6fee816652ea8f3bed2a8f59296e40”,“0x24fb77c8c776c75f869bc65e6856af56f57d919f”]	114364228	2024-01-04T00:13:53.000Z	[“78321596573530718731”,“94339838834013487250”]	0x0f929e25f0687b65ec5da1868a2715ad37f0e5e05cd9e8950131f26b593db224
0x6875e4a945e498fe1b90bbb13cfbaf0b68658c9c	false	1725494400	12	[“0x24fb77c8c776c75f869bc65e6856af56f57d919f”]	124947968	2024-09-05T00:05:13.000Z	[“5455007544021860288”]	0x34b098e696fd3ffbe6218320982e92738cb9820dc67b442c434ed176a9d3ce5a

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

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

MarketFactoryV2_CreateNewMarket_event

Event emitted when a new Pendle V1 AMM market is created through the factory contract, recording the Principal Token (PT) address, market address, and AMM initialization parameters (initialAnchor and scalarRoot). Used for tracking Pendle market deployments across chains.

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.

Sample Data

in_PT	address	removed	in_market	log_index	block_number	in_scalarRoot	block_timestamp	in_initialAnchor	transaction_hash
0xaa92ea52612fa5ee5aba5510682485c19750cb82	0x17f100fb4be2707675c6439468d38249dd993d58	false	0x0c485feb9e6fee816652ea8f3bed2a8f59296e40	70	108064143	147092073019000000000	2023-08-11T04:11:03.000Z	1030688322000000000	0xd6b3bf3b566c9713b26239d80cd441982ba75ab3ffa83d0cb11c8a1a3618a4f5
0xf4225f061e5e01aa59de5e615729a9180301eb07	0x17f100fb4be2707675c6439468d38249dd993d58	false	0x24fb77c8c776c75f869bc65e6856af56f57d919f	20	108063779	145746856536000000000	2023-08-11T03:58:55.000Z	1045262948000000000	0x9ad7ac77512e427ef5314adcc8308ee73d0934ca87ed4e3a539a03ebba01e9aa

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

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

MarketV2_Swap_event

Swap events from Pendle V2 market contracts recording exchanges between Principal Tokens (PT) and Standardized Yield (SY) tokens. Contains net token amounts transferred, protocol fees collected, and reserve allocations for tracking yield trading activity and fee revenue.

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
0x0c485feb9e6fee816652ea8f3bed2a8f59296e40	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	21	97717896964804508	70787207234599	-87874180985547147	0x0c485feb9e6fee816652ea8f3bed2a8f59296e40	109210399	2023-09-06T16:59:35.000Z	0x3dd9bf637ad59cbfc2b273a15f68c5f4fb9061a5d41ab02a9404c6d8f784c2a8	56629765787679
0x0c485feb9e6fee816652ea8f3bed2a8f59296e40	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	26	24711971479906505367	17919482084372000	-22222156704015742466	0x0c485feb9e6fee816652ea8f3bed2a8f59296e40	109197338	2023-09-06T09:44:13.000Z	0xc9ac099498edacb1959f8474532b744a308b248f880c4459a0bee2c5b55b5fbb	14335585667497599
0x0c485feb9e6fee816652ea8f3bed2a8f59296e40	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	35	5351695334205963	3879209698905	-4808308196488529	0x0c485feb9e6fee816652ea8f3bed2a8f59296e40	109191130	2023-09-06T06:17:17.000Z	0x311b73fa0e2dd8a99c510ba72bc0e24cf44f63768494154359e8f880f6d82e57	3103367759123

Example Query

Query with partition filter

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

SYv2_Deposit_event

Deposit events emitted by Pendle V2 Standardized Yield (SY) contracts recording token deposits and corresponding SY token minting. Contains caller address, input token, deposited amount, receiver address, and SY tokens issued for yield tracking and liquidity 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_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
0x96a528f4414ac3ccd21342996c93f2ecdec24286	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	159	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	0x24fb77c8c776c75f869bc65e6856af56f57d919f	117720658	25881088345517073	2024-03-21T16:54:53.000Z	0x5933aed71423178258f976617fcd6d02d70a730744001b827e72969e900fa546	25881088345517073
0x96a528f4414ac3ccd21342996c93f2ecdec24286	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	43	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	0x24fb77c8c776c75f869bc65e6856af56f57d919f	117718463	69012074746775388	2024-03-21T15:41:43.000Z	0x36ccfb6190081503ec180d349a583533fafb3c01e198750af665fa845442ed71	69012074746775388
0x96a528f4414ac3ccd21342996c93f2ecdec24286	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	12	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	0x24fb77c8c776c75f869bc65e6856af56f57d919f	110626266	87582333436418	2023-10-09T11:35:09.000Z	0xd2946663db8baa362d55844f62e6527bfda4e9a90d5213fdb5e8f191b4dd92b2	87582333436418

Example Query

Query with partition filter

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

SYv2_Redeem_event

Pendle V2 Standardized Yield (SY) token redemption events recording conversions from SY tokens back to underlying assets. Contains caller address, receiver address, output token contract, and amounts for both redeemed SY tokens and received output 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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenOut`	`STRING`	Contract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountSyToRedeem`	`STRING`	Amount of Standardized Yield (SY) tokens being redeemed in the transaction. Numeric string representation of token quantity in smallest denomination.
`in_amountTokenOut`	`STRING`	Amount of output tokens received from the redemption or swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_caller	log_index	in_receiver	in_tokenOut	block_number	block_timestamp	transaction_hash	in_amountTokenOut	in_amountSyToRedeem
0x96a528f4414ac3ccd21342996c93f2ecdec24286	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	21	0x7076dee976098b444f68c6382e8f062237879a9f	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	116271782	2024-02-17T03:59:01.000Z	0xb8ee012fd8e40fa15880d7c733c9b0210a331cf62d5c41cd3ceb68e869943d28	963607166298356	963607166298356
0x9d6d509c0354aca187aac6bea7d063d3ef68e2a0	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	24	0x7076dee976098b444f68c6382e8f062237879a9f	0x9bcef72be871e61ed4fbbc7630889bee758eb81d	116286205	2024-02-17T11:59:47.000Z	0x08024dd0b1c044e6043538e832d1c0fa89711f66b26830dc1e383a5340c7237d	229627090575419422	229627090575419422
0x96a528f4414ac3ccd21342996c93f2ecdec24286	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	95	0x02a6faadc8fdacf8bf99951b3c6303ef19168149	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	108503741	2023-08-21T08:24:19.000Z	0x2807a8da77435c5859c9b84ce1433cfda5d2b54d49f99b4b05e1831be2b57b84	811420500485107	811420500485107

Example Query

Query with partition filter

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

YieldContractFactoryV2_CreateYieldContract_event

Event log emitted when a new Pendle yield contract is created, recording the deployed Principal Token (PT), Yield Token (YT), and Standardized Yield (SY) token addresses along with expiry timestamp. Used for tracking Pendle protocol yield tokenization deployments.

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
0xf4225f061e5e01aa59de5e615729a9180301eb07	0x96a528f4414ac3ccd21342996c93f2ecdec24286	0x1dfe41cc7f7860ba7f1076ca6d0fedd707c87a00	0xf5a7de2d276dbda3eef1b62a9e718eff4d29ddc8	false	1727308800	38	108063770	2023-08-11T03:58:37.000Z	0x8602832c668801094450612a8a2f244e4bf1f8258dabd1b0bab30f69bdaf0689
0xaa92ea52612fa5ee5aba5510682485c19750cb82	0x9d6d509c0354aca187aac6bea7d063d3ef68e2a0	0xe8f0cf61598e0d7d20f99b978bdeff4d4222feb8	0xf5a7de2d276dbda3eef1b62a9e718eff4d29ddc8	false	1719446400	8	108064132	2023-08-11T04:10:41.000Z	0xee53d9c16a82b1425137527622a18933f17562152109a2ed18e9af82fbfb2767

Example Query

Query with partition filter

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

YieldContractFactoryV3_CreateYieldContract_event

Event log emitted when a new yield contract is created in the Pendle V3 protocol, recording the deployment of Principal Token (PT), Yield Token (YT), and Standardized Yield (SY) token contracts with their expiration timestamp. Primary source for tracking Pendle yield tokenization contract deployments.

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

No sample data available.

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

GaugeController_ReceiveVotingResults_event

LimitRouter_OrderFilledV2_event

MarketFactoryV2_CreateNewMarket_event

MarketFactoryV3_CreateNewMarket_event

MarketV2_Swap_event

SYv2_Deposit_event

SYv2_Redeem_event

YieldContractFactoryV2_CreateYieldContract_event

YieldContractFactoryV3_CreateYieldContract_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​GaugeController_ReceiveVotingResults_event

​LimitRouter_OrderFilledV2_event

​MarketFactoryV2_CreateNewMarket_event

​MarketFactoryV3_CreateNewMarket_event

​MarketV2_Swap_event

​SYv2_Deposit_event

​SYv2_Redeem_event

​YieldContractFactoryV2_CreateYieldContract_event

​YieldContractFactoryV3_CreateYieldContract_event

Tables

GaugeController_ReceiveVotingResults_event

LimitRouter_OrderFilledV2_event

MarketFactoryV2_CreateNewMarket_event

MarketFactoryV3_CreateNewMarket_event

MarketV2_Swap_event

SYv2_Deposit_event

SYv2_Redeem_event

YieldContractFactoryV2_CreateYieldContract_event

YieldContractFactoryV3_CreateYieldContract_event