pendle_v1_bsc

Tables

GaugeController_ReceiveVotingResults_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_wTime`	`STRING`	Unix timestamp representing the voting period end time. Integer value stored as string, in seconds since epoch.
`in_markets`	`ARRAY<STRING>`	Array of market contract addresses receiving voting allocations. Each address is hex-encoded, 0x-prefixed, and 42 characters long.
`in_pendleAmounts`	`ARRAY<STRING>`	Array of PENDLE token amounts allocated to each market. String-encoded integers representing token quantities in wei (smallest unit, 18 decimals).

Sample Data

address	removed	in_wTime	log_index	in_markets	block_number	block_timestamp	in_pendleAmounts	transaction_hash
0x704478dd72fd7f9b83d1f1e0fc18c14b54f034d0	false	1694044800	93	[“0x66317dec4a3d8d1e47b85f704e5df675a68bb7c9”,“0x080f52a881ba96eee2268682733c857c560e5dd4”,“0xeda1d0e1681d59dea451702963d6287b844cb94c”]	31519108	2023-09-07T00:09:03.000Z	[“4961207362922304178624”,“10927283262449667459210”,“5189607239775224544447”]	0xf9761e1e5b5f8b14b16e27f043834a91fd2957b308fd38b624fb5cea7aa21623
0x704478dd72fd7f9b83d1f1e0fc18c14b54f034d0	false	1753315200	260	[“0x74c5050a89046c40296a32aeaed31be89d6a6d87”,“0xfa4b91d63e7cab716dd049a23c56f70237c6ddbb”,“0xe616d50e441aa2f6d6cd43eba1b1632ab1b046e6”,“0x7608eb2fc533343556e443511a2747f605e49c9b”,“0x2ac20c37b5577e04bb68e239a45f4fb3b4edb184”,“0xe08fc3054450053cd341da695f72b18e6110fffc”,“0xb5b56637810e4d090894785993f4cdd6875d927e”,“0x1630d8228588d406767c2225f927154c05d2e2bb”,“0x4c6c233b16fd3f9c4ec139174ca8ee8ba0eb8a88”,“0x527be6fa23ff71e3faf5c2c1511b0531b67a701d”,“0xbd577ddabb5a1672d3c786726b87a175de652b96”]	55089987	2025-07-24T00:03:53.000Z	[“12638205251529178967”,“17812810337951948512”,“30872146160615099392”,“798488392663081668”,“7161667518937772335”,“1108701387269741081908”,“277017506388655867673”,“5240487836664125058”,“1519606581185152938356”,“8137009961487454202102”,“1592636181379196577383”]	0x6599381840aa2e9a988fa4cae4ad748012715e6baf0bdee2654fc5401dfd2f17
0x704478dd72fd7f9b83d1f1e0fc18c14b54f034d0	false	1714608000	157	[“0x66317dec4a3d8d1e47b85f704e5df675a68bb7c9”,“0x080f52a881ba96eee2268682733c857c560e5dd4”,“0xeda1d0e1681d59dea451702963d6287b844cb94c”,“0xb2eea27af50030a445418553c4892065cf3a720a”]	38355168	2024-05-02T00:04:58.000Z	[“981658208579317101279”,“2613994948360244351048”,“1268278099831508055357”,“202631634289120660192”]	0x2dfa607242e91168077167f44e7c20651ced45c05f2fa37660cb46d1162f87e7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_bsc.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
0x5e9d14e48c7a35c77caf83bd15ae2f73d411e523	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0xc6dd9976066f3364b4d6a72cd4f1fa0468327aa7	0x888888888889758f76e7103c6cbf23abbf58f946	0x5a110fc00474038f6c02e89c707d638602ea44b5	727	52674152	11331790659581120	0xa8a77353c0c16cec0bbac4505fe1d9b36df7b668101a574c4e2b49102e631dbf	3	2025-07-03T00:43:28.000Z	0xe3bb07b92c6450d921f66b82eb637e431fe44130eb85b7f1ad2b04b377bfca84	2435176208320841013525	2428227372383015977	2437604435693224030227
0x7670557db8891a3365350ad0899a096c967ebdb9	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0xa32422ccc420208ab0a3e48ccfc6e1c3dd926669	0x888888888889758f76e7103c6cbf23abbf58f946	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	1724	52697333	145959110450323043	0x6a4f4019cf3a0f6abea230b711384ba7b193d392c6d937e98baa0d346cf6febb	2	2025-07-03T05:33:19.000Z	0x14d2acf1c61f2ef4f8be5562d64eddde6c23b87edb6f91d4924254a314b6abe0	2001056796725514469021	2013006650924422579771	11949854198908110750
0x7670557db8891a3365350ad0899a096c967ebdb9	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0xa32422ccc420208ab0a3e48ccfc6e1c3dd926669	0x888888888889758f76e7103c6cbf23abbf58f946	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	762	52697771	116791143316790885	0x6a4f4019cf3a0f6abea230b711384ba7b193d392c6d937e98baa0d346cf6febb	2	2025-07-03T05:38:47.000Z	0x084fb126e3eb540295cc18f9a47ff15ea28eb1a0659e04629f3cddd352f6bfc3	1601347335700635190608	1610909169021663819541	9561833321028628933

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_bsc.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
0x70c1138b54ba212776d3a9d29b6160c54c31cd5d	0x2bea6bfd8fbff45aa2a893eb3b6d85d10efcc70e	false	0x080f52a881ba96eee2268682733c857c560e5dd4	44	29484876	114833600000000000000	2023-06-28T03:00:15.000Z	1062697999000000000	0x6b3a41c8a37111d2991a1fe79ceee861dd097615da5e8379fce8091860a6b312
0x5ec2ae0afdec891e7702344dc2a31c636b3627eb	0x2bea6bfd8fbff45aa2a893eb3b6d85d10efcc70e	false	0x66317dec4a3d8d1e47b85f704e5df675a68bb7c9	57	29485025	29290520000000000000	2023-06-28T03:07:42.000Z	1075220000000000000	0xe2328fb6c1595f0700e58721057696844eab3a1f45137cc7fc50e908614e7327
0x04eb6b56ff53f457c8e857ca8d4fbc8d9a531c0c	0x2bea6bfd8fbff45aa2a893eb3b6d85d10efcc70e	false	0xeda1d0e1681d59dea451702963d6287b844cb94c	12	29827413	71188500000000000000	2023-07-10T01:21:14.000Z	1060546000000000000	0x21efd65dcfb52db204bd818d0cc090e1074e143abe787a1ebafac25188da8620

Example Query

Query with partition filter

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

in_PT	address	removed	in_market	log_index	block_number	in_scalarRoot	block_timestamp	in_initialAnchor	in_lnFeeRateRoot	transaction_hash
0x1627abfd41cdaaff4fc595444519410160fe9df1	0x7c7f73f7a320364dbb3c9aaa9bccd402040ee0f9	false	0x61b79369738fad86c4e948fc775048104b7ffbf0	293	47593782	17882705219106955662	2025-03-19T05:43:40.000Z	1061439428091232858	9950330853168082	0x3f2ea344fb46b51471557dc7716d410a66d78ccf5dd6c812074e30dd0346b50e
0xb84cec1ab2af11b530ae0d8594b1493556be49cd	0x7c7f73f7a320364dbb3c9aaa9bccd402040ee0f9	false	0xbd577ddabb5a1672d3c786726b87a175de652b96	221	48165064	12364741558853802969	2025-04-08T01:50:13.000Z	1108161309738838546	14888612493750654	0xd05e72eaf3b789523f85b6fc62e06bfad06b93873ba4283ea9b5da5de08d0e3d
0xd76ec0a96eaffe1cca33313352deda1cd3cfa7ee	0x7c7f73f7a320364dbb3c9aaa9bccd402040ee0f9	false	0x9edac81bac78a2c06b59514d6eb62dd7a57adf21	98	55823452	23410728026672075900	2025-07-30T08:53:24.000Z	1020665258715592471	9950330853168082	0x1382ad4f28cae466b84092b295275c5c6fb3235dc9f17dff60e6186e4206e4f6

Example Query

Query with partition filter

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

MarketFactoryV4_CreateNewMarket_event

Market creation events from Pendle V1 protocol’s MarketFactoryV4 contract on BSC. Records new AMM (Automated Market Maker) market deployments for principal token (PT) trading with initialization parameters including fee rates, scalar roots, and initial anchor 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
0x6ca018b8610d8f2f22fb1cddb76428f34b17bbc6	0x7d20e644d2a9e149e5be9be9ad2ab243a7835d37	false	0x2a880c8a723caaebc4917c01493123b90b5a1241	297	43370898	29949792318000000000	2024-10-23T14:10:45.000Z	1050651033000000000	999500333000000	0x35bff7e7e2248443cb4063551cd533c987804b61e0ec6e4d7ba30edb41d663c9
0x541b5eeac7d4434c8f87e2d32019d67611179606	0x7d20e644d2a9e149e5be9be9ad2ab243a7835d37	false	0x9daa2878a8739e66e08e7ad35316c5143c0ea7c7	147	42702462	30359509445000000000	2024-09-30T09:06:29.000Z	1036087618000000000	999500333000000	0x3d2177c2602c1e3dab47e1f1924df4c09a00a96761c131886e219ae23bd8cfe0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_bsc.MarketFactoryV4_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
0xe669b136cffc8625096ba2b8451ce3bfded81d23	0x7c7f73f7a320364dbb3c9aaa9bccd402040ee0f9	false	0x4c6c233b16fd3f9c4ec139174ca8ee8ba0eb8a88	1187	49525135	58912688874824651463	2025-05-12T06:21:28.000Z	1013363234990457730	2995508979798478	0xc6e3f90145ea2736a34d71025d41b73856c8b8ec69c195600455e42c5ba81109
0x0010604431e5e0d37785b135c2f9c421a9f1837d	0x7c7f73f7a320364dbb3c9aaa9bccd402040ee0f9	false	0x6113943361e4dbaeedc0ba260195a84adebd1b9f	735	64693451	13445098600229816599	2025-10-15T09:13:23.000Z	1101579375191156255	15873349156290149	0x1be3a54991e4388fdc0e47673e3c9bb2dd430b9e12b29009ccc8474c1553e66b
0xd76ec0a96eaffe1cca33313352deda1cd3cfa7ee	0x7c7f73f7a320364dbb3c9aaa9bccd402040ee0f9	false	0x9edac81bac78a2c06b59514d6eb62dd7a57adf21	98	55823452	23410728026672075900	2025-07-30T08:53:24.000Z	1020665258715592471	9950330853168082	0x1382ad4f28cae466b84092b295275c5c6fb3235dc9f17dff60e6186e4206e4f6

Example Query

Query with partition filter

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

MarketV2_Mint_event

Liquidity provision events from Pendle V2 markets on BNB Smart Chain, recording when users mint LP tokens by depositing Principal Tokens (PT) and Standardized Yield (SY) tokens. Used for tracking liquidity provider activity, pool composition changes, and yield farming participation.

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
0xeda1d0e1681d59dea451702963d6287b844cb94c	false	418	0x6f4a9b3d7434465990722dd5b248101a1040afd8	42664882	1106989933945195	858146916638566	969933056468654	2024-09-29T01:47:26.000Z	0x4ea37f167f7cc0a899ae648ce768eb14de4d54402bfc8a6555cb5397e396abbd
0x080f52a881ba96eee2268682733c857c560e5dd4	false	108	0x856607800735714b7ac9637fac080cf2b953245c	42685171	41334581696522675	66409687675453258	54054361319056625	2024-09-29T18:41:53.000Z	0x1f29c64c90ab0d8fa12912df61c8921b81647af32ad38bda32ab14ec8d578815
0x080f52a881ba96eee2268682733c857c560e5dd4	false	190	0xe1a0743c3b2e6ad54326461df06a6312452610ef	42683836	37272190728550665849	59862175824988259425	48731235077255656841	2024-09-29T17:35:08.000Z	0xa63b9937e135d25e24667d784345f494a29cc8d8c0ba85c4489e07aadb96b813

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_bsc.MarketV2_Mint_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
0x080f52a881ba96eee2268682733c857c560e5dd4	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	208	65531137394730111	53415743747139	-61738752374325997	0x080f52a881ba96eee2268682733c857c560e5dd4	36110737	2024-02-13T21:51:56.000Z	0xca0910d6a4a9c93944ec5e2a362914059cea8012e1006619e3b5b7f584552abe	42732594997710
0x080f52a881ba96eee2268682733c857c560e5dd4	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	193	4988314216104	4068625386	-4699528465431	0x39ec25b2d6e92e838f3efe4eca1a6e36e8ebbfdc	36104834	2024-02-13T16:56:10.000Z	0xe93eb7fd1c9684031084acf832c36a238ad371bb19bb7a6115d88efacab834d4	3254900308
0xeda1d0e1681d59dea451702963d6287b844cb94c	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	173	4510871390661	5524049354	-4050983970715	0x05ecce3bc8249d5c5bcc3e21a2025440e2c59abe	36104263	2024-02-13T16:27:37.000Z	0x9d776180a086cef0d3f22ded24b102578a3ff7becfd9d903a834e40610617a36	4419239483

Example Query

Query with partition filter

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

MarketV3_Mint_event

Liquidity provision events from Pendle V3 markets on BNB Chain, recording when users mint LP tokens by depositing Principal Tokens (PT) and Standardized Yield (SY) tokens. Used to track liquidity additions, provider behavior, and pool composition changes across Pendle yield trading 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_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
0x1d9d27f0b89181cf1593ac2b36a37b444eb66bee	false	213	0x0ce040fed2488bda3b058f7755feec749d58c4fd	47385094	825963710651766054	3107974833198256656	2013846841253493380	2025-03-11T23:48:34.000Z	0x17d61c1e804ca3bc7803db0512badb4be76a637dc6b1787ffdb80506dca1aef4
0x1d9d27f0b89181cf1593ac2b36a37b444eb66bee	false	393	0x338fe1a22b55ca5f10b6f391310d47c9bee06a2b	47372106	1352008367945534654	4904931088138868133	3202163108222643751	2025-03-11T12:59:06.000Z	0xd418b9aa5500aa08448c036a8ff1852743f7de1853c607fe72fce926cc8fae10
0x1d9d27f0b89181cf1593ac2b36a37b444eb66bee	false	207	0x2d0312eb6951766e228f5f2c03625050f6bf0226	47376138	476836177060245696	1785862435437028523	1158272017735956188	2025-03-11T16:20:46.000Z	0x767f40adb3aab5e65d994166c685a8b83136cd21b5e604f325b088f7319bc97f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_bsc.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
0x1630d8228588d406767c2225f927154c05d2e2bb	false	0x888888888889758f76e7103c6cbf23abbf58f946	88	-21100751512325181696	9934127843936361	20421704339734406324	0x414d3c8a26157085f286abe3bc6e1bb010733602	52197432	2025-06-27T16:07:47.000Z	0xc371e1b1d901b28c6db12f0ef5547caa9b7b5102595a28e2284f613bc853a8da	7947302275149088
0x2ac20c37b5577e04bb68e239a45f4fb3b4edb184	false	0x888888888889758f76e7103c6cbf23abbf58f946	102	5210793126690944796	1786885781649047	-4944852256378172522	0x2ac20c37b5577e04bb68e239a45f4fb3b4edb184	52183138	2025-06-27T10:10:26.000Z	0x37f69fdbcce33a71b00e43f5322b4b0423be995b90d9e8e1b05f7755cde0bd83	1429508625319237
0x2ac20c37b5577e04bb68e239a45f4fb3b4edb184	false	0x888888888889758f76e7103c6cbf23abbf58f946	2018	-862784574355130990634	296352160116144639	818164390584789962408	0x7eec75fe8d9ac678f9b4e0ecf2af7b445e0c5b4c	52165577	2025-06-27T02:51:25.000Z	0xf252ba947d7414ff28ce21989380408847f647ba3168cebb4e4998fdce671005	237081728092915711

Example Query

Query with partition filter

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

MarketV4_Mint_event

Liquidity provision events from Pendle V1 markets on BNB Chain, recording LP token mints when users deposit PT (Principal Token) and SY (Standardized Yield) assets. Used for tracking liquidity additions, provider behavior, and AMM 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
0x9daa2878a8739e66e08e7ad35316c5143c0ea7c7	false	83	0x22fc5a29bd3d6cce19a06f844019fd506fce4455	46598278	585334838377256	1217932837353829	905006641965144	2025-02-12T16:04:05.000Z	0x91823f74ee994f25ec5ef7de2c287ff59d495993af4c9901ee6d3f6baed47ea8
0x9daa2878a8739e66e08e7ad35316c5143c0ea7c7	false	131	0x5b28b21a5a5fcd0480e5becedb56368bc0d0353b	46592975	12667219021460	28066597520241	20444679135405	2025-02-12T11:38:56.000Z	0x6b9b821f150806a26526f03788c42dfb6f2abed1f46d4f26888085063679c98b
0x9daa2878a8739e66e08e7ad35316c5143c0ea7c7	false	209	0x9058614265eb32a64e01a8e906ba786fdd5061aa	46594538	52662702204704	116712570808447	85011039617735	2025-02-12T12:57:05.000Z	0xa83d7df624f971c7a87df2fbc17125ab2aaf5fc99e729370d1d535490aa0303c

Example Query

Query with partition filter

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

MarketV4_Swap_event

Swap execution records from Pendle V1 yield trading protocol on BNB Smart Chain, tracking exchanges between Principal Tokens (PT) and Standardized Yield (SY) tokens with associated fees and reserves. Used for analyzing trading activity, liquidity dynamics, and fee generation 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
0x9daa2878a8739e66e08e7ad35316c5143c0ea7c7	false	0x888888888889758f76e7103c6cbf23abbf58f946	247	-52748468016017	24393713813	50856557243950	0x141ec2d606f12ff959d7d07cde6811e5fdff2831	42774461	2024-10-02T21:06:37.000Z	0xbd3e8869f960334f41a75daf05342079dd896ccee69606bdbc5213a13c845015	19514971050
0x9daa2878a8739e66e08e7ad35316c5143c0ea7c7	false	0x888888888889758f76e7103c6cbf23abbf58f946	98	2203047466812312	1022545623136	-2125795127201552	0x15194b6653a6947f126484b64422b9972f368a11	42757723	2024-10-02T07:09:43.000Z	0xcaa78aa23798c743e54288f5f7a71067bed5475486b93963251efdc50ff5c66d	818036498508
0x9daa2878a8739e66e08e7ad35316c5143c0ea7c7	false	0x888888888889758f76e7103c6cbf23abbf58f946	210	-5447843570090823	2524692536988	5251315698908806	0x7914d72c9e9ca7f6bfdd09fc7e3f20d7bc3fb8a0	42762728	2024-10-02T11:19:58.000Z	0x57456309b2f13b793062f975efba0b70579b4a46b2261058537cc961679eb7f9	2019754029590

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_bsc.MarketV4_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
0x1d9d27f0b89181cf1593ac2b36a37b444eb66bee	false	262	0x5e0c702d21b49488bdbe0b48631968c41c6646f8	47808985	96422786248539789	365802446907766979	236606862755951613	2025-03-26T17:05:09.000Z	0x662720cff142104545ffbb7f93ae1bac92db04d68f624cb06a5de8ad3ef6e02a
0x1d9d27f0b89181cf1593ac2b36a37b444eb66bee	false	479	0x7a7e299b18dfcb7cb35476c4dcc0e911d209303a	47807569	6552020103731867971	24855525679824572711	16077094534112389467	2025-03-26T15:54:21.000Z	0x6f8a8fa7063f698862e68c65b0f2cf4d9c8f469d18ae8db349d869abe115eba7
0x1d9d27f0b89181cf1593ac2b36a37b444eb66bee	false	358	0x22fc5a29bd3d6cce19a06f844019fd506fce4455	47789693	1252711857004476527	4637863392829729042	3014830228693502498	2025-03-26T01:00:05.000Z	0xb53b482c7112cfbebd2ef93e385e3d2f624997aa66637cd421b65651cd21657b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_bsc.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
0x0921ccc98956b1599003fd9739d5e66bf319a161	false	0x888888888889758f76e7103c6cbf23abbf58f946	42	634364202558382147	1088370	-2507638424	0x0921ccc98956b1599003fd9739d5e66bf319a161	45872526	2025-01-18T11:14:25.000Z	0xd9f9df5e3c0e736ec9a31dc22218314d632578160b15f6d5fb78a9f469cdd807	870696
0x0921ccc98956b1599003fd9739d5e66bf319a161	false	0x888888888889758f76e7103c6cbf23abbf58f946	15	-23392755080924954	40041	92395127	0x7b5a43070bd97c2814f0d8b3b31ed53450375c19	45881390	2025-01-18T18:37:38.000Z	0x5683914b5c28f64390abd734e8f6369fbeea7b1a22e25312a0371815af040740	32032
0x1630d8228588d406767c2225f927154c05d2e2bb	false	0x888888888889758f76e7103c6cbf23abbf58f946	454	-2555130329202646518264	440275990389837396	2519975568316362339215	0x414d3c8a26157085f286abe3bc6e1bb010733602	63503346	2025-10-05T01:13:23.000Z	0x1564b9e4222a60893a4db1aee698a0010c790a5280847d6eb4acef5a480a8b11	352220792311869916

Example Query

Query with partition filter

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

PendleMarket_Swap_event

Swap execution events from Pendle V1 markets on BNB Smart Chain, recording exchanges between Principal Tokens (PT) and Standardized Yield (SY) tokens with fees and reserve allocations. Used for analyzing Pendle market trading activity, liquidity depth, and yield token price discovery.

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
0x66317dec4a3d8d1e47b85f704e5df675a68bb7c9	false	0x00000000025efadc0b8d17d3d87ab5056e3d2510	117	11975815838414	7212966251	-11727871276841	0x66317dec4a3d8d1e47b85f704e5df675a68bb7c9	33508923	2023-11-15T08:00:19.000Z	0xb23c35d1f85396217623bd668f1a5d1e039ea98624f668d9d24d72db2a88fd97	5770373000
0x66317dec4a3d8d1e47b85f704e5df675a68bb7c9	false	0x00000000025efadc0b8d17d3d87ab5056e3d2510	265	-265348745784743041	159421210205901	259547517746892014	0xf86dda825885674f85c5420079e1df1bc0f372c6	33521271	2023-11-15T18:19:49.000Z	0x3494e5397fa3040aba6bfd9ae3615f9a852af8f51f0b70ef7a77ddbb8e323085	127536968164720
0x66317dec4a3d8d1e47b85f704e5df675a68bb7c9	false	0x00000000025efadc0b8d17d3d87ab5056e3d2510	74	287229913250130483	172996311045666	-281309143440391107	0x66317dec4a3d8d1e47b85f704e5df675a68bb7c9	33509541	2023-11-15T08:31:24.000Z	0x5632e6d6420e65767fc4564dbab27ba879218b273384fa04cf434bd0ddcd9f87	138397048836532

Example Query

Query with partition filter

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

SYThenafrxETH_Deposit_event

Deposit events from Pendle v1’s SY (Standardized Yield) token wrapper for Thena frxETH on BNB Smart Chain, recording ETH deposits converted to yield-bearing tokens. Tracks caller addresses, deposited amounts, and resulting SY token outputs for analyzing yield tokenization flow and liquidity provision patterns.

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
0xf86dda825885674f85c5420079e1df1bc0f372c6	false	0x00000000025efadc0b8d17d3d87ab5056e3d2510	123	0x2170ed0880ac9a755fd29b2688956bd959f933f8	0x66317dec4a3d8d1e47b85f704e5df675a68bb7c9	31155246	2502507805722524549	2023-08-25T07:27:44.000Z	0x8208cef46adb29928632cdc374735ec463f6f8921046436b43a246fada1ff245	4999932533472791892
0xf86dda825885674f85c5420079e1df1bc0f372c6	false	0x00000000025efadc0b8d17d3d87ab5056e3d2510	516	0x2170ed0880ac9a755fd29b2688956bd959f933f8	0x66317dec4a3d8d1e47b85f704e5df675a68bb7c9	31148370	673949168385688479	2023-08-25T01:42:53.000Z	0x024761a86dcf8314e6723edef88e09582f3254537cfffd8860ea6add293267a6	1346467506152892712
0xf86dda825885674f85c5420079e1df1bc0f372c6	false	0x00000000025efadc0b8d17d3d87ab5056e3d2510	156	0x2170ed0880ac9a755fd29b2688956bd959f933f8	0x66317dec4a3d8d1e47b85f704e5df675a68bb7c9	29663970	2000939781393382	2023-07-04T08:42:20.000Z	0x60273b9d47a460ad8348fb217de48054664fbbbd16277a238d7381cdac8aa4db	4000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_bsc.SYThenafrxETH_Deposit_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
0x96f77f24b3d17166fcaf3a9e3b8330ff38b966f9	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	276	0x2170ed0880ac9a755fd29b2688956bd959f933f8	0x080f52a881ba96eee2268682733c857c560e5dd4	37293969	1217068103926802	2024-03-26T02:02:51.000Z	0xcd382798b8fc9ce70b0424da3a330b7279416187985a4b0c951bc1b9bb3dd40a	1259263121780854
0x96f77f24b3d17166fcaf3a9e3b8330ff38b966f9	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	180	0xa2e3356610840701bdf5611a53974510ae27e2e1	0x080f52a881ba96eee2268682733c857c560e5dd4	37295610	4421281465915238	2024-03-26T03:25:05.000Z	0x7cc5ca843989485d54648144512193bda0d439d1a75ccb5f4c3c87215f88a622	4421281465915238
0x58732f1c1243a0d5876a601fb8d1ee508b21580d	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	131	0x52f24a5e03aee338da5fd9df68d2b6fae1178827	0xeda1d0e1681d59dea451702963d6287b844cb94c	35878765	52442927429979	2024-02-05T20:12:39.000Z	0xd590c884fca8d1b8e602080dd7ee3240ec87ff0e364b597c880d2fea58ce835c	52442927429979

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_bsc.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
0x58732f1c1243a0d5876a601fb8d1ee508b21580d	false	0x00000000025efadc0b8d17d3d87ab5056e3d2510	57	0x59f0c4a186744b573f15fbbc3737014f7f3da835	0x52f24a5e03aee338da5fd9df68d2b6fae1178827	31847644	2023-09-18T10:42:43.000Z	0x05e937adecf554f82fae811a4cce2b95870bc9e4b0c9052712cab8617b46d138	462013420409333199	462013420409333199
0x58732f1c1243a0d5876a601fb8d1ee508b21580d	false	0x00000000025efadc0b8d17d3d87ab5056e3d2510	74	0x59f0c4a186744b573f15fbbc3737014f7f3da835	0x52f24a5e03aee338da5fd9df68d2b6fae1178827	31844612	2023-09-18T08:10:45.000Z	0x6a183b9d23ca6970d2025309fe65320eefb83b119c592086daa54266c395c1b7	42276820346652131	42276820346652131
0x58732f1c1243a0d5876a601fb8d1ee508b21580d	false	0x00000000025efadc0b8d17d3d87ab5056e3d2510	283	0x59f0c4a186744b573f15fbbc3737014f7f3da835	0x52f24a5e03aee338da5fd9df68d2b6fae1178827	31854800	2023-09-18T16:41:03.000Z	0x3c300357fbc48208ee8e6564433c06b0b44a291a2b106fda2673718908b3ca42	2175377698892246068	2175377698892246068

Example Query

Query with partition filter

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

SYv4_Deposit_event

Deposit events from Pendle V1 SYv4 (Standardized Yield version 4) contracts on BNB Smart Chain, recording token deposits into yield-bearing positions with input token, deposited amount, and corresponding SY token output. Used to track liquidity provision flows and yield token minting activity in the Pendle protocol.

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
0x141ec2d606f12ff959d7d07cde6811e5fdff2831	false	0x888888888889758f76e7103c6cbf23abbf58f946	81	0x1346b618dc92810ec74163e4c27004c921d446a5	0xe616d50e441aa2f6d6cd43eba1b1632ab1b046e6	51650242	31372170827433113	2025-06-18T04:05:12.000Z	0x755678e22b61eca821c934725e2c73b40a8c5d9478bc8e6515cbd801edc84f29	31372170827433113
0x7b5a43070bd97c2814f0d8b3b31ed53450375c19	false	0x888888888889758f76e7103c6cbf23abbf58f946	61	0xa07c5b74c9b40447a954e1466938b865b6bbea36	0x0921ccc98956b1599003fd9739d5e66bf319a161	51681926	362871675	2025-06-18T17:17:31.000Z	0xdd6d18a636005b89855c2f1ff64200e66f8b5b87735a8bc123b027fe6a444e2d	362871675
0x141ec2d606f12ff959d7d07cde6811e5fdff2831	false	0x888888888889758f76e7103c6cbf23abbf58f946	274	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	0x9daa2878a8739e66e08e7ad35316c5143c0ea7c7	47326739	126191069775624	2025-03-09T23:10:34.000Z	0x6b34b50db30745d2c51c0bf3e7d0464be5a0a47e7e0d0200ce96ad9ce23bf7c6	126191069775624

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_bsc.SYv4_Deposit_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
0x7b5a43070bd97c2814f0d8b3b31ed53450375c19	false	0x888888888889758f76e7103c6cbf23abbf58f946	279	0x0000000000000000000000000000000000000000	0x0921ccc98956b1599003fd9739d5e66bf319a161	44526400	7085187	2024-12-02T17:20:15.000Z	0x3a4ce244824def2a7707144cbf717cf5629a20e9a8e59e77efe1cfaa4d31704b	1739248624311612
0x141ec2d606f12ff959d7d07cde6811e5fdff2831	false	0x888888888889758f76e7103c6cbf23abbf58f946	212	0x1346b618dc92810ec74163e4c27004c921d446a5	0x7914d72c9e9ca7f6bfdd09fc7e3f20d7bc3fb8a0	44517044	228603213846492	2024-12-02T09:32:27.000Z	0x90d60777ec64891cdf1dc155a4578da2e1c57071bb98b0c0793e4e735d58ba29	228603213846492
0x141ec2d606f12ff959d7d07cde6811e5fdff2831	false	0x888888888889758f76e7103c6cbf23abbf58f946	86	0x1346b618dc92810ec74163e4c27004c921d446a5	0x7914d72c9e9ca7f6bfdd09fc7e3f20d7bc3fb8a0	44519307	93529625636380	2024-12-02T11:25:36.000Z	0x246e96424ba7f3c2bee0bc899090116da8b00eb1387600bea232afa0950f4da5	93529625636380

Example Query

Query with partition filter

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

SYwBETH_Deposit_event

Deposit events for wrapped BETH (Binance ETH) tokens into Pendle V1 standardized yield (SY) contracts on BNB Smart Chain. Tracks token wrapping operations including input token addresses, deposited amounts, and resulting SY token output for yield tokenization 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
0x96f77f24b3d17166fcaf3a9e3b8330ff38b966f9	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	223	0xa2e3356610840701bdf5611a53974510ae27e2e1	0x080f52a881ba96eee2268682733c857c560e5dd4	37231433	23876290806777344	2024-03-23T21:49:11.000Z	0x272b42718c2edf0eb8d3a91ca64caf3996ebd29aba655a2c5e58ad80ed4f6986	23876290806777344
0x96f77f24b3d17166fcaf3a9e3b8330ff38b966f9	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	303	0xa2e3356610840701bdf5611a53974510ae27e2e1	0x080f52a881ba96eee2268682733c857c560e5dd4	37233681	29810000000000000	2024-03-23T23:41:58.000Z	0x59e9c401cde56a9c97fa7fbb6420dd3305b91906ab65b01fafa1b640821c6b65	29810000000000000
0x96f77f24b3d17166fcaf3a9e3b8330ff38b966f9	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	240	0xa2e3356610840701bdf5611a53974510ae27e2e1	0x080f52a881ba96eee2268682733c857c560e5dd4	37227883	46297378614802612	2024-03-23T18:51:10.000Z	0xbcebdf63d6d0774e77f408552613abf735ad2182ce4a48ad8cc4604b6bcaa0f7	46297378614802612

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_bsc.SYwBETH_Deposit_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
0x04eb6b56ff53f457c8e857ca8d4fbc8d9a531c0c	0x58732f1c1243a0d5876a601fb8d1ee508b21580d	0x269f3e230c90c0a29140106d4cfb5860af6f6827	0xa2530b4cfbf271e2b409a05c2ce520e4cb5fcc88	false	1750896000	218	29827407	2023-07-10T01:20:56.000Z	0xc63e6c5df37d346ac59da133b9e2e027824e5d2740f4868d0faba182922242e6
0x5ec2ae0afdec891e7702344dc2a31c636b3627eb	0xf86dda825885674f85c5420079e1df1bc0f372c6	0x8d0884eba8e481ccadf2f91e62170cdf79ae9c64	0xa2530b4cfbf271e2b409a05c2ce520e4cb5fcc88	false	1719446400	34	29485018	2023-06-28T03:07:21.000Z	0xcd1263f7f36c44112dfe10f6b1e626cd5afbb8b0d5d55a254860f93139d82f60
0x70c1138b54ba212776d3a9d29b6160c54c31cd5d	0x96f77f24b3d17166fcaf3a9e3b8330ff38b966f9	0x429c77e193ff7e6c6c3b2e1f00877b91792e87ee	0xa2530b4cfbf271e2b409a05c2ce520e4cb5fcc88	false	1735171200	24	29484869	2023-06-28T02:59:54.000Z	0x2b2519718945bf4af4aba8c6a43592f11e8d58d8cecb149a986e5a867765bd3a

Example Query

Query with partition filter

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

in_PT	in_SY	in_YT	address	removed	in_expiry	log_index	block_number	block_timestamp	transaction_hash
0x5ec5033a44ffb6f21da3a4f4cce4163485d61747	0xe49269b5d31299bce407c8cccf241274e9a93c9a	0x964b6d486a89025e5557a5af3b4cc100a3f9734c	0x40ae6da2d92aa3dcb7f8d7a7209fd12bdfcb7c85	false	1727308800	249	38051460	2024-04-21T10:32:09.000Z	0x888b0330db9ea9445930e709f4164bc583c6af00abb55b1dd0d2b2d26c5d6346
0x0e8ba474fcb6581059c61c328a21cfa285c7cee7	0x56b70ac3a6ae850f6aee67591d1bb86895ba211e	0xbf1e6e67ce2bd8da1ea7342354126b59b46d4000	0x40ae6da2d92aa3dcb7f8d7a7209fd12bdfcb7c85	false	1727308800	146	38706182	2024-05-14T05:10:52.000Z	0x0a07c961a620abf8d84aaf089f7124eaede60487af4fa63ee15644359162b2c8

Example Query

Query with partition filter

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

YieldContractFactoryV4_CreateYieldContract_event

Contract deployment events from Pendle V1 yield tokenization factory on BSC, recording the creation of Principal Token (PT), Yield Token (YT), and Standardized Yield (SY) contracts with their expiry timestamps for tracking new yield-bearing asset 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
0x541b5eeac7d4434c8f87e2d32019d67611179606	0x141ec2d606f12ff959d7d07cde6811e5fdff2831	0x7914d72c9e9ca7f6bfdd09fc7e3f20d7bc3fb8a0	0xdb6380041441a94050199b4a46771d8d93553509	false	1743033600	146	42702462	2024-09-30T09:06:29.000Z	0x3d2177c2602c1e3dab47e1f1924df4c09a00a96761c131886e219ae23bd8cfe0
0x6ca018b8610d8f2f22fb1cddb76428f34b17bbc6	0x7b5a43070bd97c2814f0d8b3b31ed53450375c19	0x52a9b513e75dbd41fa41b8f30ebf12af8d3c6df8	0xdb6380041441a94050199b4a46771d8d93553509	false	1750896000	296	43370898	2024-10-23T14:10:45.000Z	0x35bff7e7e2248443cb4063551cd533c987804b61e0ec6e4d7ba30edb41d663c9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_bsc.YieldContractFactoryV4_CreateYieldContract_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
0xb901c7a2d2bc05d8b7e7ee4f7fcf72caaabd2f49	0x193b2f36957f7e9e498758bbf182273bc145bb92	0x950490f74db75c60351ccd4468e755d131826672	0xe006760020384a20774dea977c313ef5f51fe17d	false	1757548800	1030	51160967	2025-06-09T16:11:50.000Z	0x887423f96eeedd9eebad0014da160eeae424d183c1b9b4eeb168fb7c84e5c5d0
0x727d98304a0e7a5b7fe05cc4a90b25b585b99ebc	0xdd3059d662497a212e4ef71260387ec6adc6e8b9	0x4cae96c5acbb9264c9c75021779fa483e3c750ed	0xe006760020384a20774dea977c313ef5f51fe17d	false	1767830400	738	64372949	2025-10-12T14:26:24.000Z	0x4cfdb64130d176cb5529c98335f5e2bd80b05965be3f71bba13163f087c62ed3
0x607c834cfb7fcbbb341cbe23f77a6e83bcf3f55c	0x5719acdb9abbbc6ba414c9dbff5b2967342f465d	0x35c4668db919ded034f047526765544a92a4da09	0xe006760020384a20774dea977c313ef5f51fe17d	false	1761782400	610	54435443	2025-07-18T07:41:07.000Z	0x9f2c1f3d5333bfb50f75d54e9dde37926bfb78de570a7c9d32cd411f3c59f5d0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_bsc.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
0x44264c7be2d92f010b20b29c4531fc09381c56f3	false	63	48110324	2025-04-06T04:13:09.000Z	0x863c58d05e4f2dad0d4a43a9c5c5b4b9823b1e234b3832cea6e94868b1a4d800	47984165321014
0x89c625c475f33a78a8c60250137a3d51aa12b357	false	193	48114303	2025-04-06T07:32:06.000Z	0x91c5a60f035b973f5fdcab0f1d8f44cf9d483b39157604c5e706bb9ed226dd43	2510574024100448
0x5e4ea9538e8ae4c22f3897e85c7ab51672bb3a62	false	218	48115614	2025-04-06T08:37:39.000Z	0x32fb2f0274c4fddeb755e407c2f72c6408d661964ff27ac8a5f11bdc033ad546	34677514268516442

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_bsc.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
0xfbebe2d163add17dc718ffc7b08880ca765a0fab	false	508	69556599	0xcf6bb5389c92bdda8a3747ddb454cb7a64626c63	2025-11-26T14:55:19.000Z	0xa7e0b7bb8475060353a383eb14e0ec6beed547c1a2d6975ac31f54d8b29fa6be
0xfbebe2d163add17dc718ffc7b08880ca765a0fab	false	572	62292243	0xcf6bb5389c92bdda8a3747ddb454cb7a64626c63	2025-09-24T12:48:13.000Z	0xd3d9e94951815fe85dcd5d32dfcf47104629d2bb34119f64c96a5ec024f45b36
0xfbebe2d163add17dc718ffc7b08880ca765a0fab	false	234	55864946	0xcf6bb5389c92bdda8a3747ddb454cb7a64626c63	2025-07-30T17:32:05.000Z	0x74a51358d115244cf70d3500b01c441f13e9e5f444f46e018010864a64a12f7f

Example Query

Query with partition filter

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

MarketFactoryV2_CreateNewMarket_event

MarketFactoryV3_CreateNewMarket_event

MarketFactoryV4_CreateNewMarket_event

MarketFactoryV5_CreateNewMarket_event

MarketV2_Mint_event

MarketV2_Swap_event

MarketV3_Mint_event

MarketV3_Swap_event

MarketV4_Mint_event

MarketV4_Swap_event

MarketV5_Mint_event

MarketV5_Swap_event

PendleMarket_Swap_event

SYThenafrxETH_Deposit_event

SYv2_Deposit_event

SYv2_Redeem_event

SYv4_Deposit_event

SYv5_Deposit_event

SYwBETH_Deposit_event

YieldContractFactoryV2_CreateYieldContract_event

YieldContractFactoryV3_CreateYieldContract_event

YieldContractFactoryV4_CreateYieldContract_event

YieldContractFactoryV5_CreateYieldContract_event

YTv5_CollectInterestFee_event

YTv5_CollectRewardFee_event

​Tables

​GaugeController_ReceiveVotingResults_event

​LimitRouter_OrderFilledV2_event

​MarketFactoryV2_CreateNewMarket_event

​MarketFactoryV3_CreateNewMarket_event

​MarketFactoryV4_CreateNewMarket_event

​MarketFactoryV5_CreateNewMarket_event

​MarketV2_Mint_event

​MarketV2_Swap_event

​MarketV3_Mint_event

​MarketV3_Swap_event

​MarketV4_Mint_event

​MarketV4_Swap_event

​MarketV5_Mint_event

​MarketV5_Swap_event

​PendleMarket_Swap_event

​SYThenafrxETH_Deposit_event

​SYv2_Deposit_event

​SYv2_Redeem_event

​SYv4_Deposit_event

​SYv5_Deposit_event

​SYwBETH_Deposit_event

​YieldContractFactoryV2_CreateYieldContract_event

​YieldContractFactoryV3_CreateYieldContract_event

​YieldContractFactoryV4_CreateYieldContract_event

​YieldContractFactoryV5_CreateYieldContract_event

​YTv5_CollectInterestFee_event

​YTv5_CollectRewardFee_event

Tables

GaugeController_ReceiveVotingResults_event

LimitRouter_OrderFilledV2_event

MarketFactoryV2_CreateNewMarket_event

MarketFactoryV3_CreateNewMarket_event

MarketFactoryV4_CreateNewMarket_event

MarketFactoryV5_CreateNewMarket_event

MarketV2_Mint_event

MarketV2_Swap_event

MarketV3_Mint_event

MarketV3_Swap_event

MarketV4_Mint_event

MarketV4_Swap_event

MarketV5_Mint_event

MarketV5_Swap_event

PendleMarket_Swap_event

SYThenafrxETH_Deposit_event

SYv2_Deposit_event

SYv2_Redeem_event

SYv4_Deposit_event

SYv5_Deposit_event

SYwBETH_Deposit_event

YieldContractFactoryV2_CreateYieldContract_event

YieldContractFactoryV3_CreateYieldContract_event

YieldContractFactoryV4_CreateYieldContract_event

YieldContractFactoryV5_CreateYieldContract_event

YTv5_CollectInterestFee_event

YTv5_CollectRewardFee_event