pendle_v1_arbitrum - Token Terminal Docs

Tables

BorosAMMFactory_AMMCreated_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_amm`	`STRING`	Contract address of the automated market maker (AMM). Hex-encoded, 0x-prefixed, 42-character string.
`in_isPositive`	`BOOL`	-
`in_createParams`	`STRUCT<ammId STRING, name STRING, symbol STRING, router STRING, market STRING, oracleImpliedRateWindow STRING, feeRate STRING, totalSupplyCap STRING, seeder STRING, permissionController STRING>`	-
`in_seedParams`	`STRUCT<minAbsRate STRING, maxAbsRate STRING, cutOffTimestamp STRING, initialAbsRate STRING, initialSize STRING, flipLiquidity STRING, initialCash STRING>`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

BorosMarket_FeeRatesUpdated_event

Fee rate configuration changes for Pendle V1 Boros markets on Arbitrum, recording updates to taker and over-the-counter (OTC) fee parameters. Used for tracking protocol fee adjustments across different market contracts.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newTakerFee`	`STRING`	Updated taker fee rate charged by the Pendle Boros market, stored as a string-formatted integer representing basis points or wei-denominated fee. All sample values show 500000000000000, indicating a consistent fee rate across markets.
`in_newOtcFee`	`STRING`	Updated fee rate for over-the-counter (OTC) trades on the Pendle Boros market, denominated in the protocol’s smallest unit. Typically set to 500000000000000 (0.05% when converted from basis points).

Sample Data

address	removed	log_index	block_number	in_newOtcFee	in_newTakerFee	block_timestamp	transaction_hash
0x8fcf5e75f4d8bc03b8970593cc8a841fc65c12b3	false	5	379639440	500000000000000	500000000000000	2025-09-16T04:46:39.000Z	0x6d6d46427f558e37ca9f68152bc8028b9654689282abc31b357ec73d98f66ad1
0x725fa7500f1b6e08972f04f7fc1931ea7c47314f	false	4	379639276	500000000000000	500000000000000	2025-09-16T04:45:58.000Z	0x9d681f0d010f31eb749e6cd7b034b62b491dde473a2a434990e6fd4db834ee4a
0x30c3cf7bfe1c694382c4901aae5c9d679ec8450d	false	5	362039678	500000000000000	500000000000000	2025-07-27T07:45:18.000Z	0xaef0279ec605cf6ced4c65b53cb4f59e0f7d42eb13dff6d552d4cda3be344629

Example Query

Query with partition filter

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

BorosMarket_LimitOrderFilled_event

Limit order execution events from Pendle V1’s Boros Market contract on Arbitrum, capturing order ID ranges (in_from to in_to) when limit orders are filled. Used for tracking off-chain order matching activity and analyzing order execution patterns in Pendle’s 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	in_from	removed	log_index	block_number	block_timestamp	transaction_hash
9258758719083118596	0x25a62d6ca94f67248fbfb7257513bcf74210bcdf	9258758719083118595	false	9	391339487	2025-10-20T00:11:45.000Z	0x543d3c538456c4a0625ea14e8a9bf8eece5864e9c66aa4995eb04deeeb563ded
9258757619571490824	0x25a62d6ca94f67248fbfb7257513bcf74210bcdf	9258757619571490824	false	8	391339487	2025-10-20T00:11:45.000Z	0x543d3c538456c4a0625ea14e8a9bf8eece5864e9c66aa4995eb04deeeb563ded
9332100542702288909	0x25a62d6ca94f67248fbfb7257513bcf74210bcdf	9332100542702288908	false	7	391395242	2025-10-20T04:04:17.000Z	0xc688ab51fa4f79800a65213b32052f6436fda4e4d70ccfcc4016a4c8c0d4e830

Example Query

Query with partition filter

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

BorosMarket_LimitOrderPartiallyFilled_event

Partial fill events for limit orders on Pendle V1’s Boros Market on Arbitrum, recording the order ID and filled token amount for each execution. Used to track progressive order fulfillment and reconstruct complete order fill history.

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_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_filledSize`	`STRING`	Quantity of the limit order that was filled in this partial execution event, denominated in the smallest unit of the token (wei for 18-decimal tokens). Values range from small amounts like 10000000000000 to nearly 2 tokens (1999990000000000000).

Sample Data

address	removed	log_index	in_orderId	block_number	in_filledSize	block_timestamp	transaction_hash
0x30c3cf7bfe1c694382c4901aae5c9d679ec8450d	false	19	9258415671455252481	368400015	1999990000000000000	2025-08-14T17:00:06.000Z	0x9d5b8a338580a26bfe3b3674c297d1f4d5bc38614b0e7d0eb43ddb781f29c645
0x30c3cf7bfe1c694382c4901aae5c9d679ec8450d	false	5	9258415671455252481	368395332	10000000000000	2025-08-14T16:40:37.000Z	0xf81d4b67a456b8fbfe8b09d29afe571ba83af58b255e2661bb0b32df06d54b5a
0x30c3cf7bfe1c694382c4901aae5c9d679ec8450d	false	24	9258415671455252481	368417196	12126000000000000	2025-08-14T18:11:35.000Z	0x1a546270bf71e8511b42966c6d194ac1ea6e6866783a2ca673c8c94889a4be69

Example Query

Query with partition filter

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

BorosMarket_Liquidate_event

Liquidation events from Pendle V1’s Boros market on Arbitrum, capturing positions forcibly closed due to undercollateralization with liquidator addresses, fees collected, and violator account identifiers. Used for analyzing liquidation activity, risk management effectiveness, and liquidator profitability in yield tokenization 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_liq`	`STRING`	Encoded identifier representing the liquidated position or market being liquidated in the Boros protocol. Typically contains hexadecimal-encoded data including contract addresses and position parameters.
`in_vio`	`STRING`	Account identifier of the violator (position holder) being liquidated in encoded format. Hex-encoded string combining the user’s address with additional position metadata flags.
`in_liqTrade`	`STRING`	Amount of tokens or assets transferred during the liquidation trade between the liquidator and the protocol. Value is typically a large integer representing the token amount in its smallest unit (wei for ERC20 tokens).
`in_liqFee`	`STRING`	Fee amount collected by the liquidator during the liquidation event, denominated in the smallest unit of the asset. Values are typically in the billions to trillions range indicating wei-level precision for token amounts.

Sample Data

in_liq	in_vio	address	removed	in_liqFee	log_index	in_liqTrade	block_number	block_timestamp	transaction_hash
0xb180808080e0544f77261cdecc9a2540104682f600000200000d	0xcd54cc88ac8bb4f437937b5dfa9c341570c6169b000002ffffff	0x97a22f2384f8971e60ae735979d486f9810bb2ed	false	45579896704830	6	115792089237316195423161744322602828969071447693271851284161546534542276445811	395310680	2025-10-31T11:41:07.000Z	0xff937952c3b7b80405a32b13ba432a293ef020d6687f4a92761ad4867b9d36d1
0xb180808080e0544f77261cdecc9a2540104682f600000100000c	0xef6ecebf334fe51cca3c6ce8d3eb1f4aeda71278000001ffffff	0xc1af5a647260102659743b85977f753471ea2f7b	false	1035156862282	4	115792089237316195423561690816836860122973179220947300912516988758823702418927	395269311	2025-10-31T08:49:10.000Z	0xd13b2789b7436a0b1a2aa2fdd2f1b4bf03168a51f897ce6c9378d16b400eabb3
0xb180808080e0544f77261cdecc9a2540104682f600000100000c	0x9b30f3aca385c8f6c2192ae527ce993c85ebba6c000001ffffff	0xc1af5a647260102659743b85977f753471ea2f7b	false	51428036885670	21	115792089237316195423109236592815127291284757360152746421026336480487524197358	395270053	2025-10-31T08:52:16.000Z	0xeadab050cba1d7882ad610e39f304af1415683ccf398fa294a193f7c339c95e9

Example Query

Query with partition filter

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

BorosMarket_MarketOrdersFilled_event

Market order fill events from Pendle v1’s Boros markets on Arbitrum, capturing trade execution amounts and fees paid by users. Used for analyzing trading volume, fee generation, and user activity across different Pendle yield token 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_totalTrade`	`STRING`	Total trade amount executed in the market order, denominated in the smallest unit of the token. Values are large integers representing wei-equivalent amounts for ERC-20 tokens in Pendle V1 markets.
`in_totalFees`	`STRING`	Total fees collected from the transaction. Numeric string representation of the fee amount in the token’s smallest unit.

Sample Data

address	in_user	removed	log_index	block_number	in_totalFees	in_totalTrade	block_timestamp	transaction_hash
0x30c3cf7bfe1c694382c4901aae5c9d679ec8450d	0xb585b882c8e9dbb36a5058012c57660781321715000002ffffff	false	3	365178136	707762557077626	3402823669209384634633746074317682114560589719378550710870	2025-08-05T09:30:11.000Z	0x0b67721d8c70786e69c0986a343f808134c17b9d09ff5260d4eb26c538935175
0x30c3cf7bfe1c694382c4901aae5c9d679ec8450d	0xe0b09a386630ee13c2600e2411fe6225be4f016e000002ffffff	false	1	365169849	70776255708	115792089237316195423570644726320986915146803657954070734709502557854446390022	2025-08-05T08:55:36.000Z	0x0cd26434cc37795755086caeba53a5028bb88aaffa0472949284b2b1c7f2edea
0x30c3cf7bfe1c694382c4901aae5c9d679ec8450d	0x2186f9b34be0156c97c68ac6a74944a125265283000002ffffff	false	7	365173457	15581559245381	74913963833148998944639633346556989550185991682514807891	2025-08-05T09:10:40.000Z	0xb7c552e78b04546f15439c9dc6d9fd15de6df8b897f33c3ead0e23b3d12549e4

Example Query

Query with partition filter

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

BorosMarket_OtcSwap_event

Over-the-counter (OTC) swap execution events from Pendle V1’s Boros Market on Arbitrum, capturing peer-to-peer trades with user addresses, counterparty details, cash transfers, and fee amounts. Used for analyzing direct bilateral trading activity and liquidity provision patterns outside of automated market makers.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_counterParty`	`STRING`	Address of the counterparty receiving tokens in this over-the-counter swap on Pendle’s Boros market. Hex-encoded identifier with additional suffix bytes appended to the standard 20-byte address format.
`in_trade`	`STRING`	Identifier or structured data representing the trade or swap operation. Specific format varies by protocol implementation.
`in_cashToCounter`	`STRING`	Amount of cash or tokens transferred to the counterparty in the over-the-counter (OTC) swap transaction, denominated in the smallest unit of the token. Often zero when the trade is settled through other means or involves different settlement terms.
`in_otcFee`	`STRING`	Fee charged in wei for executing the over-the-counter swap transaction on Pendle’s Boros Market. Values range from approximately 1.3 trillion to 40 trillion wei.

Sample Data

address	in_user	removed	in_trade	in_otcFee	log_index	block_number	block_timestamp	in_counterParty	in_cashToCounter	transaction_hash
0x25a62d6ca94f67248fbfb7257513bcf74210bcdf	0x9bcd43b2f6f43cb26032edf584f9e511091f83b0ff0001000004	false	115792089237316195423363314480718406649391457257251968338073895345859812392960	40685922076739	11	397789446	2025-11-07T15:34:13.000Z	0x0ee61be6f8f73fb1412cc1205fb706ea441901abff0001000004	45854189108939890	0xee874bf0d406107c0a73e8ebdcca316b5aadb724c6c4709be7b087bd91f8424a
0x25a62d6ca94f67248fbfb7257513bcf74210bcdf	0xf3cfdf82c94a4bae302ce02267d1c8f44e5a7d13ff0001000004	false	115792089237316195423411231265284790341349681929262133766500783282491236548608	31512642197812	17	397653454	2025-11-07T06:08:36.000Z	0x0ee61be6f8f73fb1412cc1205fb706ea441901abff0001000004	35371361203277262	0xcf1c8241dd0669cd248681eda2e3293dd92d0124dab3269a2b344512552241bf
0x25a62d6ca94f67248fbfb7257513bcf74210bcdf	0x8f5824cefb4b1eaf582fcc59646bbe7a63a68b88000001ffffff	false	115792089237316195423527914633454965784528926339108012481551255311543099270100	8438163795687	19	397709763	2025-11-07T10:02:56.000Z	0x0ee61be6f8f73fb1412cc1205fb706ea441901abff0001000004	0	0x44fc4ecc271e17e3e183e756a543bd2c9d2d8ab0c22f432f9b995f2f25b6db19

Example Query

Query with partition filter

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

BorosMarket_PaymentFromSettlement_event

Payment settlement events from Pendle v1 Boros Markets on Arbitrum, recording fees collected and yield payments distributed to users between time periods. Used for analyzing protocol revenue and user earnings from yield tokenization positions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_lastFTime`	`STRING`	Unix timestamp of the previous settlement period’s end time for this user’s position in the Pendle market. Can be zero if this is the user’s first settlement, as shown in sample rows where new positions initialize with ‘0’.
`in_latestFTime`	`STRING`	Latest fee time (fTime) in the settlement period as a Unix timestamp. Represents the end boundary of the time range for which fees and payments are being calculated in this settlement event.
`in_payment`	`STRING`	Amount paid by the buyer in the transaction. Numeric string representation in smallest token denomination.
`in_fees`	`STRING`	Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination.

Sample Data

address	in_fees	in_user	removed	log_index	in_payment	block_number	in_lastFTime	in_latestFTime	block_timestamp	transaction_hash
0x25a62d6ca94f67248fbfb7257513bcf74210bcdf	14613820991088	0x0ee61be6f8f73fb1412cc1205fb706ea441901abff0001000004	false	7	376450202002760	397565025	1762444800	1762473600	2025-11-07T00:00:37.000Z	0x28970410dce031dae7d117803dba1394bb915659975227e110bd85c49e0a3213
0x25a62d6ca94f67248fbfb7257513bcf74210bcdf	0	0x2ff7835653ed4a2615c5d475aa207343c58f29b8000001ffffff	false	6	0	397565025	1762444800	1762473600	2025-11-07T00:00:37.000Z	0x28970410dce031dae7d117803dba1394bb915659975227e110bd85c49e0a3213
0xf9997c488e7286988b0829583de8787ba9683d34	640956018085447	0xed3f08b113b1d99e0885b82fcb24b544cd3a84a8ff0002000005	false	4	26610522931149801	397565028	1762444800	1762473600	2025-11-07T00:00:38.000Z	0xd3f1680a25efa33a778016d7d62ff4f358d63d2181004f871e3f1d6adb05627c

Example Query

Query with partition filter

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

BorosMarketFactory_MarketCreated_event

Market creation events from Pendle v1’s Boros perpetual futures factory on Arbitrum. Contains immutable market parameters (maturity dates, tick sizes, token IDs) and configurable risk settings (margin ratios, fees, liquidation thresholds) for analyzing new market deployments and protocol expansion.

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_immData`	`STRUCT<name STRING, symbol STRING, k_isIsolatedOnly BOOL, k_maturity STRING, k_tokenId STRING, k_marketId STRING, k_tickStep INT64, k_iTickThresh STRING>`	Immutable market parameters defined at creation, including market name, symbol, token/market identifiers, maturity timestamp, and trading configuration values. These values remain constant throughout the market’s lifecycle and define the core identity and mechanics of the Pendle market.
`in_config`	`STRUCT<maxOpenOrders STRING, markRateOracle STRING, fIndexOracle STRING, hardOICap STRING, takerFee STRING, otcFee STRING, liqSettings STRUCT<base STRING, slope STRING, feeRate STRING>, kIM STRING, kMM STRING, tThresh STRING, maxRateDeviationFactorBase1e4 STRING, closingOrderBoundBase1e4 STRING, loUpperConstBase1e4 INT64, loUpperSlopeBase1e4 INT64, loLowerConstBase1e4 INT64, loLowerSlopeBase1e4 INT64, status INT64, useImpliedAsMarkRate BOOL>`	Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.

Sample Data

address	removed	in_config	in_market	log_index	in_immData	block_number	block_timestamp	transaction_hash
0x3080808080ee6a795c1a6ff388195aa5f11ecee0	false	{“kIM”:“909090909090909090”,“kMM”:“666666666666666666”,“otcFee”:“500000000000000”,“status”:0,“tThresh”:“604800”,“takerFee”:“500000000000000”,“hardOICap”:“1000000000000000000000000”,“liqSettings”:{“base”:“250000000000000000”,“slope”:“500000000000000000”,“feeRate”:“500000000000000”},“fIndexOracle”:“0xa40fa70e460ee86ab7225e8fa38dd3f1bf0a2a63”,“maxOpenOrders”:“100”,“markRateOracle”:“0x0000000000000000000000000000000000000000”,“loLowerConstBase1e4”:-50,“loLowerSlopeBase1e4”:9500,“loUpperConstBase1e4”:50,“loUpperSlopeBase1e4”:10500,“useImpliedAsMarkRate”:true,“closingOrderBoundBase1e4”:“1000”,“maxRateDeviationFactorBase1e4”:“1500”}	0xf0128c7373755704c41b7d72bda5399fa379bcd6	16	{“name”:“Hyperliquid HYPE 26 Dec 2025”,“symbol”:“HYPERLIQUID-HYPE-26DEC2025”,“k_tokenId”:“3”,“k_marketId”:“18”,“k_maturity”:“1766707200”,“k_tickStep”:2,“k_iTickThresh”:“954”,“k_isIsolatedOnly”:false}	399730023	2025-11-13T06:10:37.000Z	0x09d7305a8b9380743e63b189964c8c51168b4500f2a764cdf36af008dcb7f22c
0x3080808080ee6a795c1a6ff388195aa5f11ecee0	false	{“kIM”:“312500000000000000”,“kMM”:“222222222222222222”,“otcFee”:“500000000000000”,“status”:0,“tThresh”:“864000”,“takerFee”:“500000000000000”,“hardOICap”:“400000000000000000000”,“liqSettings”:{“base”:“250000000000000000”,“slope”:“500000000000000000”,“feeRate”:“500000000000000”},“fIndexOracle”:“0x1aa9de72e6a2815a539a63b5c8784bb7b75cde6a”,“maxOpenOrders”:“100”,“markRateOracle”:“0x0000000000000000000000000000000000000000”,“loLowerConstBase1e4”:-30,“loLowerSlopeBase1e4”:9500,“loUpperConstBase1e4”:30,“loUpperSlopeBase1e4”:10500,“useImpliedAsMarkRate”:true,“closingOrderBoundBase1e4”:“1000”,“maxRateDeviationFactorBase1e4”:“1500”}	0x426aa4232f927e7ae5d4a029e07656125de632de	47	{“name”:“Binance BTCUSDT 27 Mar 2026”,“symbol”:“BINANCE-BTCUSDT-27MAR2026”,“k_tokenId”:“1”,“k_marketId”:“23”,“k_maturity”:“1774569600”,“k_tickStep”:2,“k_iTickThresh”:“583”,“k_isIsolatedOnly”:false}	404518746	2025-11-27T02:41:52.000Z	0x6aededf466bba8e3cbdff8089444e14ffc664771ea113370d36a56e4c02b8e9b
0x3080808080ee6a795c1a6ff388195aa5f11ecee0	false	{“kIM”:“312500000000000000”,“kMM”:“222222222222222222”,“otcFee”:“500000000000000”,“status”:0,“tThresh”:“864000”,“takerFee”:“500000000000000”,“hardOICap”:“20000000000000000000000”,“liqSettings”:{“base”:“250000000000000000”,“slope”:“500000000000000000”,“feeRate”:“500000000000000”},“fIndexOracle”:“0xcb06bd2b3d4e4923a7ddf3bd0703096615f6e9e9”,“maxOpenOrders”:“100”,“markRateOracle”:“0x0000000000000000000000000000000000000000”,“loLowerConstBase1e4”:-30,“loLowerSlopeBase1e4”:9500,“loUpperConstBase1e4”:30,“loUpperSlopeBase1e4”:10500,“useImpliedAsMarkRate”:true,“closingOrderBoundBase1e4”:“1000”,“maxRateDeviationFactorBase1e4”:“1500”}	0x5b955dc854f9fcf1e39a37d5c7ce43cbd58f1e80	43	{“name”:“Binance ETHUSDT 27 Mar 2026”,“symbol”:“BINANCE-ETHUSDT-27MAR2026”,“k_tokenId”:“2”,“k_marketId”:“24”,“k_maturity”:“1774569600”,“k_tickStep”:2,“k_iTickThresh”:“583”,“k_isIsolatedOnly”:false}	404518903	2025-11-27T02:42:31.000Z	0x960a2793629594f1cfc86f999923c49e619f869ddf934f57cbd4efbda08d18b1

Example Query

Query with partition filter

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

BorosMarketHubEntry_CashTransfer_event

Cash transfer events from Pendle V1’s Boros Market Hub contract on Arbitrum, tracking token movements between market participants with sender, recipient, and transfer amounts. Used for analyzing yield token trading flows and liquidity provider activity within 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x00801b11586c8c00e67446abdd245917c669537500000200000d	0x1080808080f145b14228443212e62447c112adad	0x00801b11586c8c00e67446abdd245917c6695375000002ffffff	false	3228412428858047	18	393093506	2025-10-25T01:54:30.000Z	0x6f5152f391823cdcc0204deae44529d48f9051685daa67f04ff05d1ebb660a76
0x38f19144de923f681c59ae7aba69c4859d6b8ec2000002ffffff	0x1080808080f145b14228443212e62447c112adad	0x38f19144de923f681c59ae7aba69c4859d6b8ec2ff0002000009	false	466466105915875106	15	393174644	2025-10-25T07:32:28.000Z	0x363d7d1043c0557dc3ab50d53ec4f4f5e735d1dbfcd74586a0f0532e4bae351d
0x38f19144de923f681c59ae7aba69c4859d6b8ec2000002ffffff	0x1080808080f145b14228443212e62447c112adad	0x38f19144de923f681c59ae7aba69c4859d6b8ec2ff0002000007	false	1430884230531789487	13	393174553	2025-10-25T07:32:05.000Z	0x4b281bab0641be7a728c3b53ffa389c896dbc087b8f1a4197f13dca5846a3766

Example Query

Query with partition filter

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

BorosMarketHubEntry_CollectFee_event

Fee collection events from Pendle v1’s Boros Market Hub contract on Arbitrum, recording amounts and token identifiers for protocol fees harvested. Used for tracking revenue generation and fee distribution across different Pendle market types.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_tokenId	block_number	block_timestamp	transaction_hash
0x1080808080f145b14228443212e62447c112adad	false	464742789926903153	1	1	400144169	2025-11-14T10:53:38.000Z	0x2439c3c9c1f7afc6455d798688f9be2a1e3c9373f439d862ff8f8e89d26d6674
0x1080808080f145b14228443212e62447c112adad	false	28893085630561794162	3	2	400144169	2025-11-14T10:53:38.000Z	0x2439c3c9c1f7afc6455d798688f9be2a1e3c9373f439d862ff8f8e89d26d6674
0x1080808080f145b14228443212e62447c112adad	false	16793930564746812200900	5	3	400144169	2025-11-14T10:53:38.000Z	0x2439c3c9c1f7afc6455d798688f9be2a1e3c9373f439d862ff8f8e89d26d6674

Example Query

Query with partition filter

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

BorosMarketHubEntry_EnterMarket_event

Market entry events from Pendle V1’s Boros Market Hub on Arbitrum, recording when users enter specific markets with associated entrance fees. Useful for tracking user participation patterns and fee structures across different Pendle yield 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_marketId`	`STRING`	Unique identifier for a market within the Dolomite protocol. String representation of a non-negative integer starting from 0.
`in_entranceFee`	`STRING`	Fee paid in wei by the user to enter the specified Pendle Boros market. Values typically range from 8 trillion to 270 trillion wei (0.000008 to 0.00027 tokens).

Sample Data

address	in_user	removed	in_marketId	block_number	in_entranceFee	block_timestamp	transaction_hash
0x1080808080f145b14228443212e62447c112adad	0x780ac8cd6a715c4e00c67d65ac1bada2db4a10df000001ffffff	false	2	366676566	8000000000000	2025-08-09T17:31:35.000Z	0xca9fdc1844256b6098b85d1e1f704e3060a1c6b260e2ebd14fa46aee06b5441a
0x1080808080f145b14228443212e62447c112adad	0x5a3b142f804dbb404896adca16a6e94b30655593000001ffffff	false	2	366654219	8000000000000	2025-08-09T15:58:36.000Z	0x3b40f28eef77874f4308e7095f513df2043a5419719521137e50141f1e13a36f
0x1080808080f145b14228443212e62447c112adad	0xc0df6bfc22e364cebcf99bb01310e639f22f708b000001ffffff	false	2	366510096	8000000000000	2025-08-09T05:59:13.000Z	0xb96699c876bc9b9bb5bd965b4d4df2caffe717d336da33208cca36f2bd3d9c89

Example Query

Query with partition filter

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

BorosMarketHubEntry_ExitMarket_event

Market exit events from Pendle v1’s Boros Market Hub on Arbitrum, tracking when users leave specific lending markets identified by marketId. Used for analyzing user portfolio adjustments and market participation patterns across Boros protocol 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_marketId`	`STRING`	Unique identifier for a market within the Dolomite protocol. String representation of a non-negative integer starting from 0.

Sample Data

address	in_user	removed	log_index	in_marketId	block_number	block_timestamp	transaction_hash
0x1080808080f145b14228443212e62447c112adad	0x49e4fc8d10294886c74895cb47fe9351ccae62ea000003ffffff	false	2	11	399700601	2025-11-13T04:08:11.000Z	0x15f237405f06c77e6927813c130ef0947ae8033dbb911a68aeac22d9264c24fc
0x1080808080f145b14228443212e62447c112adad	0x570536c56f4ed8df9c4636bafae009f7c13734f6000002ffffff	false	1	5	399825783	2025-11-13T12:48:56.000Z	0xbb9eb984f421df74a022afead204bbc8b8b5942dfc09866355a70e6f64a8f9bc
0x1080808080f145b14228443212e62447c112adad	0x608f84867d616e4f6d63d7be7de8eb77d060b30c000001ffffff	false	31	6	399752638	2025-11-13T07:44:41.000Z	0x58216d5bbb27fba6b47e8c4fb27c29bbccfa5b3f539d7403c4baa04fd63b31e2

Example Query

Query with partition filter

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

BorosMarketHubEntry_MarketAdded_event

Market registration events from Pendle v1 protocol on Arbitrum tracking when new yield trading markets are added to the BorosMarketHub contract. Contains market addresses and sequential market IDs for identifying available 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_marketId`	`STRING`	Unique identifier for a market within the Dolomite protocol. String representation of a non-negative integer starting from 0.
`in_marketAddress`	`STRING`	Contract address of the Pendle market that was added to the Boros Market Hub registry. Hex-encoded, 0x-prefixed 40-character string representing the deployed market contract on Arbitrum.

Sample Data

address	removed	log_index	in_marketId	block_number	block_timestamp	in_marketAddress	transaction_hash
0x1080808080f145b14228443212e62447c112adad	false	4	21	401814991	2025-11-19T06:56:53.000Z	0x3d9f65eb9adfdc78272c3b87ae1470740e3f8343	0xf8ae8d1a26cffd5e571b67035ce45346f00eeb4f891ffceb4565c7aef0937788
0x1080808080f145b14228443212e62447c112adad	false	3	20	401814991	2025-11-19T06:56:53.000Z	0x27c4e20f5b464a2630db5847ba9c35c7a0596981	0xf8ae8d1a26cffd5e571b67035ce45346f00eeb4f891ffceb4565c7aef0937788
0x1080808080f145b14228443212e62447c112adad	false	5	22	401814991	2025-11-19T06:56:53.000Z	0xd7a047834d0dfdd4b94a6861efaf1d9051c87d62	0xf8ae8d1a26cffd5e571b67035ce45346f00eeb4f891ffceb4565c7aef0937788

Example Query

Query with partition filter

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

BorosMarketHubEntry_PayTreasury_event

Treasury payment events from Pendle V1’s Boros Market Hub contract on Arbitrum, recording fee distributions to protocol treasury with user addresses and payment amounts. Used for tracking protocol revenue and fee collection 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	block_number	block_timestamp	transaction_hash
0x1080808080f145b14228443212e62447c112adad	0xfba489ae24edacba1564abec52e86429829852f0000002ffffff	false	225801959546524	372423233	2025-08-26T08:01:40.000Z	0xac59292d3301d5fce3b57877410a8cba31959526b3c6e7d51e61d9079ee6faa5
0x1080808080f145b14228443212e62447c112adad	0xb83345da6828909d6df3b242a91d7d3a78b78f7d000001ffffff	false	9109194764263	372476423	2025-08-26T11:42:49.000Z	0x86d31ef00a31228fda93eb32e372e33e1adf0f01474e05166999bcdf24a80c4a
0x1080808080f145b14228443212e62447c112adad	0x7e5c1a665bfd595a8de3ac91dabb37a65db04096000002ffffff	false	218190603009802	372635412	2025-08-26T22:44:04.000Z	0xe0ff615165fb8df52b9573fd49b4635b3b6271c4d1f6f08004da1dacec7b55d8

Example Query

Query with partition filter

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

BorosMarketHubEntry_TokenAdded_event

Token registration events from Pendle V1’s Boros Market Hub contract on Arbitrum, recording when new token addresses are added to the protocol with assigned token IDs. Used for tracking which assets are supported by the Boros yield tokenization 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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_tokenAddress`	`STRING`	Token contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_tokenId	block_number	block_timestamp	in_tokenAddress	transaction_hash
0x1080808080f145b14228443212e62447c112adad	false	2	1	362025653	2025-07-27T06:46:54.000Z	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	0x500f1914ce45e154376918d8d9d7c1db4709a2b06a97cac370b459c2fda50b45
0x1080808080f145b14228443212e62447c112adad	false	2	2	362025659	2025-07-27T06:46:56.000Z	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xc2d2e6c30464fd2ffec54871d4ee042bcd4150f8e6d010538ead508843e17357
0x1080808080f145b14228443212e62447c112adad	false	0	3	383116700	2025-09-26T05:58:12.000Z	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0xdf5a856b05958edadd1748dd61d82321dcf1d7f5f0dce66d832bf09df842c9ea

Example Query

Query with partition filter

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

BorosMarketHubEntry_VaultDeposit_event

Deposit events from Pendle V1’s Boros Market Hub vaults on Arbitrum, capturing user account addresses and unscaled token amounts for each vault deposit transaction. Used for tracking liquidity provision and vault participation activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_acc`	`STRING`	Account identifier or vault address receiving the deposit, encoded with additional metadata flags. Hex-encoded string with appended numerical suffixes indicating vault configuration parameters.
`in_unscaledAmount`	`STRING`	Raw token amount deposited into the vault before decimal normalization. Stored as a string integer representing the smallest unit of the token (e.g., wei for ETH, smallest divisible unit for ERC-20 tokens).

Sample Data

in_acc	address	removed	log_index	block_number	block_timestamp	transaction_hash	in_unscaledAmount
0x1b5bd4ed671c2e0ae70d3971b5a73dc51bdddb0b000003ffffff	0x1080808080f145b14228443212e62447c112adad	false	4	406595688	2025-12-03T02:40:37.000Z	0x3a34a70e98e59259d88172cdb06a80e6e0df0eff7d8f2830cd8ccf4627f9e9c6	300000000
0x35b5c3b1dc4cd7c2d740ad5ddb7dc1b6aa56a66d000003ffffff	0x1080808080f145b14228443212e62447c112adad	false	4	406596693	2025-12-03T02:44:47.000Z	0x5b8dc384355172098faf9ecbe2a9fa830db123d25e72f1d6bb46141a2784103a	2000000000
0x75ac90948f56c4307be68fd5e71abd3aa4f2f2e6000003000012	0x1080808080f145b14228443212e62447c112adad	false	4	406893698	2025-12-03T23:19:39.000Z	0xe954c9daf8fa3995bd76cca2860333be08175f1669182c6547dcfbf762060abb	2002881

Example Query

Query with partition filter

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

BorosMarketHubEntry_VaultWithdrawalFinalized_event

Vault withdrawal completion events from Pendle v1’s Boros Market Hub on Arbitrum, tracking finalized withdrawals with token IDs, root addresses, and unscaled amounts. Used for analyzing withdrawal patterns and liquidity movements across Pendle’s yield tokenization vaults.

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_root`	`STRING`	User address that initiated the vault withdrawal request. Hex-encoded, 0x-prefixed Ethereum address representing the owner of the withdrawn position.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_totalUnscaledAmount`	`STRING`	Total amount of tokens withdrawn from the vault in unscaled (raw) token units, before applying any decimal normalization. Values range from small integers to wei-denominated amounts (18 decimals) depending on the token standard.

Sample Data

address	in_root	removed	log_index	in_tokenId	block_number	block_timestamp	transaction_hash	in_totalUnscaledAmount
0x1080808080f145b14228443212e62447c112adad	0x2c4e1e7251470d5731dc7c6290befbacf91c1f80	false	2	1	386989600	2025-10-07T10:32:02.000Z	0xe8037142abf1c2f02602299ec1f178e4285c711ec75dee2eff28f8e26476495b	670986
0x1080808080f145b14228443212e62447c112adad	0xc73a0ba657374de66feb4268f3d2ea5f4fbd5350	false	1	1	387002588	2025-10-07T11:26:02.000Z	0x9539099e881742e598c14051f42819ac9f57bd6d46b0ce0c861278179ac2103a	1515508
0x1080808080f145b14228443212e62447c112adad	0x589736e1d18b24b1178ef6565f93e219e304798f	false	1	1	387133850	2025-10-07T20:31:31.000Z	0x692d6533d1d736168e660ec205565e253bfbc9a4533ca4f2e75e18c910c56cf1	1309031

Example Query

Query with partition filter

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

BorosRouter_AddLiquidityDualToAmm_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_ammId`	`STRING`	Unique identifier for the automated market maker (AMM) pool. String representation of a non-negative integer.
`in_exactSizeIn`	`STRING`	-
`in_netLpOut`	`STRING`	-
`in_netCashIn`	`STRING`	-
`in_netOtcFee`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

BorosRouter_AddLiquiditySingleCashToAmm_event

Liquidity provision events from Pendle V1’s Boros Router on Arbitrum where users add single-sided cash positions to automated market maker (AMM) pools. Tracks cash deposits, LP tokens minted, intermediate swap sizes, and OTC fees for analyzing liquidity provider behavior and yield tokenization strategies.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_ammId`	`STRING`	Unique identifier for the automated market maker (AMM) pool. String representation of a non-negative integer.
`in_netLpOut`	`STRING`	Net amount of liquidity provider (LP) tokens received by the user from adding single-sided cash to the Pendle AMM. Denominated in the smallest unit (wei-equivalent) of the LP token for the specified pool.
`in_netCashIn`	`STRING`	Amount of cash tokens deposited by the user into the AMM liquidity pool. Denominated in the smallest unit of the underlying token (wei-equivalent), representing the input side of a single-sided liquidity provision.
`in_totalTakerOtcFee`	`STRING`	Total fee paid by the liquidity provider for the OTC (over-the-counter) swap component of the transaction. Denominated in the same units as the cash input, typically in wei for token amounts.
`in_swapSizeInterm`	`STRING`	Intermediate swap size in the AMM liquidity addition operation, denominated in the smallest unit of the base token. Represents the amount swapped internally before final LP token minting.

Sample Data

address	in_user	removed	in_ammId	log_index	in_netLpOut	block_number	in_netCashIn	block_timestamp	transaction_hash	in_swapSizeInterm	in_totalTakerOtcFee
0x8080808080dab95efed788a9214e400ba552def6	0xd9d41d7bfcf658d3a7beb79aa4558ba5148a2292ff0003000012	false	180	14	15273806138608291488115	407007991	4999782373532773041201	2025-12-04T07:17:33.000Z	0x4a6d30788c91d7f65d46c4a1f746a7ef340fbf301c58f5f8fed4d454d622ae6a	22538511582326509009504	1340475403469419088
0x8080808080dab95efed788a9214e400ba552def6	0xc1c16daa953a36bece0d3b908110dbfdbcdf7a6bff0003000012	false	180	38	4586750480920161255821	407069746	1499903542489324650478	2025-12-04T11:33:42.000Z	0x1bcce4391506a93178fae5226a0591a8b3f68273ae12eaf97456cf27b61b52e9	7042464215236983369833	415634018182365344
0x8080808080dab95efed788a9214e400ba552def6	0x0a4740508133c8e0e915f856cca2cc71c66ae188ff0003000012	false	180	7	5739671059772580552	407095569	1875973246579921117	2025-12-04T13:20:42.000Z	0xa817ccb612a364396ad958bd22c4e7b89481c27b7d214aaffcbd6882a6de410a	8985349595516857454	528248292430502

Example Query

Query with partition filter

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

BorosRouter_RemoveLiquidityDualFromAmm_event

Liquidity removal events from Pendle V1’s BorosRouter automated market maker (AMM) pools on Arbitrum, capturing LP token burns with corresponding cash and size withdrawals plus fees. Tracks dual-sided liquidity exits for analyzing LP behavior and pool dynamics across different AMM pairs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_ammId`	`STRING`	Unique identifier for the automated market maker (AMM) pool. String representation of a non-negative integer.
`in_lpToRemove`	`STRING`	Amount of liquidity provider (LP) tokens being removed from the automated market maker (AMM) pool. Represented in wei (smallest unit), typically ranging from millions to quadrillions based on token decimals and position size.
`in_netCashOut`	`STRING`	Amount of cash tokens withdrawn from the AMM liquidity pool when removing LP positions, denominated in the pool’s cash token base units. Represents the actual token output received by the user from the dual-side liquidity removal.
`in_netSizeOut`	`STRING`	Amount of principal tokens (size) received by the user when removing liquidity from the Pendle AMM pool. Denominated in the smallest unit of the principal token (wei-equivalent), representing the token quantity returned to the liquidity provider.
`in_netOtcFee`	`STRING`	Fee charged for over-the-counter (OTC) services during the dual liquidity removal from the AMM, denominated in the smallest token unit. Represents the cost incurred by the user for removing liquidity through the Boros Router.

Sample Data

address	in_user	removed	in_ammId	log_index	block_number	in_netOtcFee	in_lpToRemove	in_netCashOut	in_netSizeOut	block_timestamp	transaction_hash
0x8080808080dab95efed788a9214e400ba552def6	0x7d956297679911771aeb4131d8d620adb2f7bdc9000003000011	false	170	15	395725365	2322277182414410794	34658791025602363981561	4483995748344042444429	64377051006171640997709	2025-11-01T16:25:53.000Z	0x8e8079f004dec5d4e4ca1dd83a3a67d4c42607ae3ea81d654411b57085541d53
0x8080808080dab95efed788a9214e400ba552def6	0x7d956297679911771aeb4131d8d620adb2f7bdc9000003000011	false	170	14	395593484	2183366966070360716	34658791025602363981561	4508957339134608234050	59676426280113447319288	2025-11-01T07:17:27.000Z	0x0a721eae01e23ebf0b87bb1366483bac66cc107abec70a2006c28ac4f5a11b2d
0x8080808080dab95efed788a9214e400ba552def6	0x7d956297679911771aeb4131d8d620adb2f7bdc900000100000c	false	120	13	395725292	23675125820353	372322440902543071	21585597914230145	656310449956612743	2025-11-01T16:25:35.000Z	0xdd172aafffb7d45643bdb2df6f73112e136335fc0504028309a0068e7e124e49

Example Query

Query with partition filter

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

BorosRouter_RemoveLiquiditySingleCashFromAmm_event

Liquidity removal events from Pendle V1’s BorosRouter contract on Arbitrum where liquidity providers withdraw single-sided cash positions from automated market maker (AMM) pools. Records LP token amounts burned, cash received, intermediate position sizes, and taker fees for analyzing liquidity provider exit behavior.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_ammId`	`STRING`	Unique identifier for the automated market maker (AMM) pool. String representation of a non-negative integer.
`in_lpToRemove`	`STRING`	Amount of liquidity provider (LP) tokens being removed from the Pendle AMM pool. Specified in the token’s smallest unit (wei-equivalent), representing the user’s share of the pool being withdrawn.
`in_netCashOut`	`STRING`	Amount of cash tokens received by the user after removing liquidity from the Automated Market Maker (AMM). Raw integer value representing the token amount in smallest denomination (wei for ETH-based tokens).
`in_netTakerOtcFee`	`STRING`	Fee paid to the taker in the over-the-counter (OTC) transaction, denominated in the smallest unit of the underlying token. Values are typically small relative to other transaction amounts, often in the range of millions to trillions of wei.
`in_netSizeInterm`	`STRING`	Amount of intermediate position size change during the liquidity removal operation, denominated in the smallest token unit. Negative values indicate a reduction in position size as LP tokens are burned for cash withdrawal.

Sample Data

address	in_user	removed	in_ammId	log_index	block_number	in_lpToRemove	in_netCashOut	block_timestamp	in_netSizeInterm	transaction_hash	in_netTakerOtcFee
0x8080808080dab95efed788a9214e400ba552def6	0x1b30164400925ba077d0538027793b8eadbda607ff000300000b	false	110	12	394585723	29380020729724497884405	6544912543819657386178	2025-10-29T09:25:22.000Z	-44343159130750304146913	0x76c96bfd0fe6a673c85d77615f37c11f65cfa31f89066b868f6cd0180b9eadee	197418174212244507
0x8080808080dab95efed788a9214e400ba552def6	0x1b30164400925ba077d0538027793b8eadbda607ff000300000b	false	110	10	394711496	29380020729724497884410	6536200010491256246737	2025-10-29T18:08:08.000Z	-41137703633450798903396	0xa8860f879d47636ccb2df24e17683f009be5bda30393672027235aaf37931b1b	140882546689899998
0x8080808080dab95efed788a9214e400ba552def6	0x5c32a2d32ac2d478b1476602706b6e9080153e1bff000300000b	false	110	11	394712110	17704693295509832150707	3938624196594097799893	2025-10-29T18:10:42.000Z	-25894892302969161142617	0xd0f9d42133ea3de8899262b5f169032d8f70bb63ae24d4eb23b9dad8625fb50f	88681138023866992

Example Query

Query with partition filter

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

BorosRouter_SingleOrderExecuted_event

Order execution events from Pendle V1’s Boros Router on Arbitrum, recording matched order sizes, taker fees, and Time-In-Force (TIF) parameters. Enables analysis of order fill patterns and fee collection across different AMM pools and market pairs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_marketId`	`STRING`	Unique identifier for a market within the Dolomite protocol. String representation of a non-negative integer starting from 0.
`in_ammId`	`STRING`	Unique identifier for the automated market maker (AMM) pool. String representation of a non-negative integer.
`in_tif`	`INT64`	Time-in-force flag indicating order validity duration (0 for immediate-or-cancel, 2 for good-till-cancel). Controls how long the order remains active in the Pendle AMM order book before expiration.
`in_matched`	`STRING`	Quantity of matched order volume or filled amount in the transaction. Stored as large integer string to preserve precision for high-value trades.
`in_takerOtcFee`	`STRING`	Fee charged to the taker (order receiver) for over-the-counter execution, denominated in the smallest unit of the relevant token. Typically ranges from billions to quadrillions of wei-equivalent units.

Sample Data

in_tif	address	in_user	removed	in_ammId	log_index	in_matched	in_marketId	block_number	in_takerOtcFee	block_timestamp	transaction_hash
2	0x8080808080dab95efed788a9214e400ba552def6	0x02ff541f434cd611f1e5da22dc234cb3ff2d5e6e000002ffffff	false	30	22	1688350436232799015335294866227180066251740332951542124034	3	382970265	2265578082192	2025-09-25T19:50:16.000Z	0x5b0e9ab9437685218a92ab41731560b2f5fe48268064c3ae4898eda775024bda
0	0x8080808080dab95efed788a9214e400ba552def6	0x02ff541f434cd611f1e5da22dc234cb3ff2d5e6e000002ffffff	false	30	19	818754970583381890012465576713537148619129291119571140	3	382684744	3296033708	2025-09-25T00:05:09.000Z	0x7b2c02e8b95eb453d4c07e87b5e2d0626bdb9e014601d9b1f86dbc0259f85865
2	0x8080808080dab95efed788a9214e400ba552def6	0x05a6ee6c9e59460bcc8455cc3f5852bac3e2ca56000002ffffff	false	50	28	1361129467683753853853498429727072845824229685016791938123	5	382883698	502283105022832	2025-09-25T13:50:51.000Z	0xa883f9af8e1ef2f1aed2dd0fda1ee3078bee59bc5330b729e0d1a1fd3e313eab

Example Query

Query with partition filter

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

BorosRouter_SwapWithAmm_event

AMM (Automated Market Maker) swap events from Pendle V1’s Boros Router on Arbitrum, recording trades between users and liquidity pools with market identifiers, matched amounts, and OTC (over-the-counter) fees. Used for analyzing trading activity and fee revenue across Pendle’s yield token 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_marketId`	`STRING`	Unique identifier for a market within the Dolomite protocol. String representation of a non-negative integer starting from 0.
`in_ammId`	`STRING`	Unique identifier for the automated market maker (AMM) pool. String representation of a non-negative integer.
`in_matched`	`STRING`	Encoded value representing the matched amount or position in the AMM swap transaction. Large integer values suggest bit-packed data or high-precision token amounts.
`in_otcFee`	`STRING`	Over-the-counter (OTC) fee charged for this swap transaction, denominated in the smallest unit of the relevant token. Values range from millions to tens of trillions, indicating fee amounts in wei or similar base units.

Sample Data

address	in_user	removed	in_ammId	in_otcFee	log_index	in_matched	in_marketId	block_number	block_timestamp	transaction_hash
0x8080808080dab95efed788a9214e400ba552def6	0xb180808080e0544f77261cdecc9a2540104682f6000001000002	false	20	55485885768273	14	270255569297073226943232410648788585193089004745172266113	2	365480480	2025-08-06T06:33:31.000Z	0xf35525d7ac54703ac7f2741be131afa0b4d4cf0c852fd5573d1c90451e3a4527
0x8080808080dab95efed788a9214e400ba552def6	0xb180808080e0544f77261cdecc9a2540104682f6000001000004	false	40	3064610351545	6	115792089237316195423560697603406783730174097369123244592401938664335262932562	4	388944259	2025-10-13T02:00:27.000Z	0x2df1e0cf35c560c304a8a9bd0fe9f0de42bdae7a11f35081bff2f2ec15d0d191
0x8080808080dab95efed788a9214e400ba552def6	0xb180808080e0544f77261cdecc9a2540104682f6000001000004	false	40	876400424337	23	115792089237316195423568043073068211507225722155157805318526938343192747591846	4	388943466	2025-10-13T01:57:09.000Z	0x330f3c1234895803ec342444ff9eddf07f469cf4f3e8ff31752c58d015e88ac0

Example Query

Query with partition filter

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

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
0x1e56299ebc8a1010cec26005d12e3e5c5cc2db00	false	1682553600	4	[“0x7d49e5adc0eaad9c027857767638613253ef125f”,“0xa0192f6567f8f5dc38c53323235fd08b318d2dca”,“0x0a21291a184cf36ad3b0a0def4a17c12cbd66a14”]	84652382	2023-04-27T00:04:59.000Z	[“39336433089661910289725”,“20568470470275214769963”,“25412090350578392130287”]	0xd961496a49c4021a38d02c64a049ba41be1a8fd4231ab487edcdba3f669f8f5b
0x1e56299ebc8a1010cec26005d12e3e5c5cc2db00	false	1696464000	14	[“0x7d49e5adc0eaad9c027857767638613253ef125f”,“0xa0192f6567f8f5dc38c53323235fd08b318d2dca”,“0x0a21291a184cf36ad3b0a0def4a17c12cbd66a14”,“0x24e4df37ea00c4954d668e3ce19ffdcffdec2cf6”,“0x3803d89c31de8b7def55c86f2469a5ea4db41b92”,“0x6ea328bf810ef0f0bd1291eb52f1529aa073cefa”,“0x08a152834de126d2ef83d612ff36e4523fd0017f”,“0x14fbc760efaf36781cb0eb3cb255ad976117b9bd”,“0xfd8aee8fcc10aac1897f8d5271d112810c79e022”,“0xc8fd1f1e059d97ec71ae566dd6ca788dc92f36af”,“0x0f249f735647992572eea231fc24b35f7b6b34e1”,“0xf617792ea9dceb2208f4c440258b21d2f3fdb9a3”,“0xb7ffe52ea584d2169ae66e7f0423574a5e15056f”]	137581096	2023-10-05T00:05:05.000Z	[“12006822915502502411228”,“1064366273647471713023”,“1182652315191675431353”,“2806452028224439082108”,“1047945018233697179598”,“9846924743182057027579”,“5085271488287262907774”,“16971903619583234511914”,“2079816200714997009774”,“10027344626287102437185”,“5688606835330234535876”,“34949134137719616692376”,“2162089164399784450101”]	0x57a8eb16bdea5124d0f0ba237f74f0a2b33c2b583fb7180f58f7d3cb88f99fff
0x1e56299ebc8a1010cec26005d12e3e5c5cc2db00	false	1685577600	7	[“0x7d49e5adc0eaad9c027857767638613253ef125f”,“0xa0192f6567f8f5dc38c53323235fd08b318d2dca”,“0x0a21291a184cf36ad3b0a0def4a17c12cbd66a14”,“0x24e4df37ea00c4954d668e3ce19ffdcffdec2cf6”,“0x3803d89c31de8b7def55c86f2469a5ea4db41b92”,“0x6ea328bf810ef0f0bd1291eb52f1529aa073cefa”]	96506749	2023-06-01T00:03:57.000Z	[“39182599662177686111923”,“11392924447582798673084”,“25106152481104733981142”,“12462777657358051574018”,“18257114446256244744950”,“1095034039149237550442”]	0x3928a461ade11172e9454c9042ccd30960a6d2dd137cb8daa6782150885c082a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.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
0x05735b65686635f5c87aa9d2dae494fb2e838f38	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0x01eb1e903bfa3a8ddaa64e4c42643e5975c04836	0x00000000005bbb0ef59571e58418f9a4357b68a0	0x2416092f143378750bb29b79ed961ab195cceea5	40	206338088	267678540259019	0x638c6282df4ad06785b0bff5108b03b0ffeaf745a839f9264ebb0a0b23de9e93	3	2024-04-30T09:37:45.000Z	0x93db4b901f8ec5146fe7aed701e5b90094b23314ab4b626f72b610424b304413	1697244482707620080	69538676446130706	1781482190613008057
0x05735b65686635f5c87aa9d2dae494fb2e838f38	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0x020063499dd4f59f718fb7a2122777342134a5cb	0x00000000005bbb0ef59571e58418f9a4357b68a0	0x2416092f143378750bb29b79ed961ab195cceea5	17	206388698	87631030225041	0xdb58dd2c844057f865f105279706e1b9398fc4f7cf773056eadac5f8ed54654e	2	2024-04-30T13:14:05.000Z	0x512debcc8bc84f2e72b182156ec89acbe100b69265240fcba1b2926f5e1d6992	556999213325201212	581799455660728019	19990000000000000
0x05735b65686635f5c87aa9d2dae494fb2e838f38	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	false	0x0236730ce7f2f76250b355ae62b461fdb62a9a7e	0x00000000005bbb0ef59571e58418f9a4357b68a0	0x2416092f143378750bb29b79ed961ab195cceea5	68	206429273	104628960990705	0x9a456b9bcc30e143f8e46f8d0b5d3827d4a5924f4a71c4b3bc95e509deeaa942	3	2024-04-30T16:10:14.000Z	0xfaaad459e96107f55ec85d7df2b77c7ced1fde383324f99d17aaf61e7bb80188	666565087883802721	24162103973438532	696485644708418919

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.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	block_number	in_scalarRoot	block_timestamp	in_initialAnchor	transaction_hash
0xad22fca714559da1eb25fb24443b0446b54246fc	0xf5a7de2d276dbda3eef1b62a9e718eff4d29ddc8	false	0xf617792ea9dceb2208f4c440258b21d2f3fdb9a3	132152754	21899787320000000000	2023-09-18T07:55:56.000Z	1153945483000000000	0xf4c901fa20976390cd870d34ad1f5db51f777d48c37fa5ed5d715a7b3a1551b5
0x0e7938fc1021572a46db7ccb7ef8b056a80ffd68	0xf5a7de2d276dbda3eef1b62a9e718eff4d29ddc8	false	0x8036762bcc01704949e8995eb6c7c85aca155e20	137290452	38277379714000000000	2023-10-04T02:57:33.000Z	1042006233000000000	0xa924726e7db5a8acb767b577937422da40fa88dd3a02ad81463981fddb4a7aae
0x8491f9a5ba93ab2def499d956fd7caaf1e9f6040	0xf5a7de2d276dbda3eef1b62a9e718eff4d29ddc8	false	0xb7ffe52ea584d2169ae66e7f0423574a5e15056f	137294913	38277548936000000000	2023-10-04T03:17:26.000Z	1042001573000000000	0x78074dc1e72e86682bc67e1559e7991424443ab11888e1490d3fa1b4db80e3a6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.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
0x2d5405688f253d741a9f1090dd90d8a285cf5c79	0x2fcb47b58350cd377f94d3821e7373df60bd9ced	false	0x6abe9ac2df48490693bdb9d66fa898fc9cd7cc36	2	206242665	10324763686000000000	2024-04-30T02:56:16.000Z	1041846750000000000	499875041000000	0xe6cc80863f7954691f4b3838a3f4608166eaf28f5f652e52794871792d86a037
0xd7e810aed2988b8a7ea0187d55c939110b178521	0x2fcb47b58350cd377f94d3821e7373df60bd9ced	false	0xcf602767e9c82194daf58eb67a3169d60dbaac62	2	206243513	10324763686000000000	2024-04-30T02:59:51.000Z	1041846750000000000	499875041000000	0xe6fc872d19802c5905f44da1caae18b30f8d8e6da1a1268507f82f1fc17c0f69
0x5a4e68e1f82dd4eafbda13e47e0ec3cc452ed521	0x2fcb47b58350cd377f94d3821e7373df60bd9ced	false	0x6febb4d63f6715793107db9214e9e88dc3e7c3bd	0	156987308	375471166789000000000	2023-12-05T03:07:20.000Z	1011395430000000000	2995508979798371	0x079e37b766a12d18b90a34449b3c2def8062045ea354a9e0278c0c8c5c55914b

Example Query

Query with partition filter

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

MarketFactoryV4_CreateNewMarket_event

Market creation events from Pendle V1’s MarketFactoryV4 contract on Arbitrum, recording new PT (Principal Token) markets with their initialization parameters including fee rates, anchor points, and market addresses for tracking Pendle’s yield trading market 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_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
0xd9de069f0980fed309e8885cdfbd66bdd66cdb77	0xd9f5e9589016da862d2abce980a5a5b99a94f3e8	false	0x8c2afc4eddb23cfdcc62a8aac14633d456a91477	2	237594699	23793702873000000000	2024-07-30T10:31:11.000Z	1059760693000000000	999500333000000	0x51973ca9c59c29ac35161cbc54c75d55b3317e5bca7704bd6d2c0c1c707fcdaf
0x2be6fab4d1408e7ad6ad91ce7b77fa2a7670782f	0xd9f5e9589016da862d2abce980a5a5b99a94f3e8	false	0xa877a0e177b54a37066c1786f91a1dab68f094af	2	237601819	23793702873000000000	2024-07-30T11:00:57.000Z	1059760693000000000	999500333000000	0x1dc134ce1ab711c37388eb1f02d481310a765200d62bc3fbaf560ee684a1fbd5
0x22e9ad26ea0e65a7073571d5d7172ff6336084ad	0xd9f5e9589016da862d2abce980a5a5b99a94f3e8	false	0x279b44e48226d40ec389129061cb0b56c5c09e46	2	233743830	23146542820000000000	2024-07-19T06:06:04.000Z	1041871770000000000	999500333000000	0xb6cb8c3bcc9210d3c65fef2e82e2ffe0047c736948f91b2e1c3fd55e3d72777c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.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
0x0fc042b32a9a6191834ea12ffa04f2044d0eb302	0xd29e76c6f15ada0150d10a1d3f45accd2098283b	false	0x4505ec38982bb796b34d050ca8d765acff1abdee	2	285218188	20106780196000000000	2024-12-16T02:51:23.000Z	1087848626000000000	1998002662000000	0x85b536689a1e23b4a95561710b91e3a1462e893e03726e0116359861299994db
0xf93e88b07dfc860abf72d13a088a7092ce213190	0xd29e76c6f15ada0150d10a1d3f45accd2098283b	false	0xc0cda2d5d4d75544cdf01ef69b1e5e56ea366d17	2	264997381	33369136469000000000	2024-10-18T05:26:48.000Z	1014538106000000000	999500333000000	0x4b33b12f854da96959cc992683fd36518a9831e9852999478b6e4a82659b96ea
0xb33808ea0e883138680ba29311a220a7377cdb92	0xd29e76c6f15ada0150d10a1d3f45accd2098283b	false	0xbf5e60ddf654085f80dae9dd33ec0e345773e1f8	2	271837691	89316496353000000000	2024-11-07T02:55:08.000Z	1028180525000000000	499875041000000	0x15cfc86abf4cc23292a8e716e8e387e3f0a0f09ba1c0f48870f7b51af7a67c7b

Example Query

Query with partition filter

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

MarketFactoryV6_CreateNewMarket_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_PT`	`STRING`	Contract address of the Principal Token (PT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_scalarRoot`	`STRING`	Scalar root parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
`in_initialAnchor`	`STRING`	Initial anchor parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
`in_lnFeeRateRoot`	`STRING`	Natural logarithm of the fee rate root parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.

Sample Data

in_PT	address	removed	in_market	log_index	block_number	in_scalarRoot	block_timestamp	in_initialAnchor	in_lnFeeRateRoot	transaction_hash
0x9b3924f9652cabf3db48b7b4c92e474c571b3ab4	0x49f2f7002669e0e4425fa0203975625ab4af3143	false	0xfad63f0a2ff618edde23561dff212edfeddbe89d	2	402362671	21388985832151064158	2025-11-20T20:56:33.000Z	1037486123402475354	11137744410455925	0x8cc2c89140520ada238bd70f26078156220147f4dd6a8a43223e596b1e950fc6
0x5b2c615e22272234aacf187632a0531ca1243279	0x49f2f7002669e0e4425fa0203975625ab4af3143	false	0x3308574370f19ea639f4671838e01cfb77d8db70	4	400238684	13806897126844085122	2025-11-14T17:26:34.000Z	1054927191715275557	16660440893107241	0x2bf6aa20f9fbf7633c10653cf45201f27df95e4a57499330806a7691d00e8f49
0x1bf1311fcf914a69dd5805c9b06b72f80539cb3f	0x49f2f7002669e0e4425fa0203975625ab4af3143	false	0x2092fa5d02276b3136a50f3c2c3a6ed45413183e	2	400238921	13806902161001002282	2025-11-14T17:27:31.000Z	1054926799444190311	16660440893107241	0x0495c21ddf899c5a4a2f24ca73eb7a74c8cdd0bc15a31f61788429013daaa744

Example Query

Query with partition filter

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

MarketV2_Mint_event

Liquidity provision events from Pendle V1 markets on Arbitrum, recording Principal Token (PT) and Standardized Yield (SY) deposits exchanged for LP tokens. Tracks minting transactions with token amounts and recipient addresses for analyzing liquidity provider activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x08a152834de126d2ef83d612ff36e4523fd0017f	false	49	0x2d3e7aa0834cd204a7ec2389bff01b6e51384264	223477371	5465332593347	4962517591166	5191595189002	2024-06-19T11:30:25.000Z	0xfbb2dcffac85f695f1b64356530a8dcae3123fa7f246d6fc728a7389303b93c6
0x08a152834de126d2ef83d612ff36e4523fd0017f	false	75	0x2d3e7aa0834cd204a7ec2389bff01b6e51384264	223362211	529367946857	462547449954	492871654238	2024-06-19T03:30:22.000Z	0x35ce57a43aad05398e041c9a6bce7f23769ed409d56e6a520367b983e0da030e
0x08a152834de126d2ef83d612ff36e4523fd0017f	false	35	0x2d3e7aa0834cd204a7ec2389bff01b6e51384264	223592455	1528638965416	1387819916023	1451974481871	2024-06-19T19:30:23.000Z	0x03e31ea4a49dd0fcfea686df1641a3969e3f807743edf45a7c67929c43d7cefc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.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
0x0a21291a184cf36ad3b0a0def4a17c12cbd66a14	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	17	-76429141	87405	72809154	0x068def65b9dbaff02b4ee54572a9fa7dfb188ea3	80826475	2023-04-15T20:47:18.000Z	0x52eddf87dc7375c7238a73c752712430eec2b0784d3424f7230a75fdafc5d9d0	69924
0x0a21291a184cf36ad3b0a0def4a17c12cbd66a14	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	16	-158122287	180995	150640533	0x068def65b9dbaff02b4ee54572a9fa7dfb188ea3	80696706	2023-04-15T11:49:27.000Z	0xe5a432d8988252998515011c45b7b53c58e2072b3c0fb3cb32d5ca781dd03e77	144796
0x0a21291a184cf36ad3b0a0def4a17c12cbd66a14	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	40	-769229737	879808	732683354	0x068def65b9dbaff02b4ee54572a9fa7dfb188ea3	80786634	2023-04-15T18:01:15.000Z	0x60582708c5f4a5b43745a3afb2a2e572211bf3b3da29f9a0bbc8fc8503768fd9	703846

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.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 Arbitrum, recording when users deposit Principal Tokens (PT) and Standardized Yield (SY) tokens to mint LP tokens. Useful for analyzing liquidity provider behavior, pool composition changes, and yield farming activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x0bd6890b3bb15f16430546147734b254d0b03059	false	90	0x62fc95fba4b802ac13017aaa65ca62ffce6df0ea	316591477	1254057	3021684	2218332	2025-03-17T09:40:25.000Z	0xd7d4d94151582ea6f608ba04806e9af21b01e11053f3ecf7e2d34de0e3fd891b
0x0bd6890b3bb15f16430546147734b254d0b03059	false	65	0x62fc95fba4b802ac13017aaa65ca62ffce6df0ea	316711625	1145270	2867004	2084545	2025-03-17T18:00:54.000Z	0x93cee01ba2b543f04391e394a77e6a02eed5a3523ecb22834d16ba909b8b74ef
0x0bd6890b3bb15f16430546147734b254d0b03059	false	21	0xa664af21ddd48360896085502b8f8c2a83abd9a7	316595154	1816917539	4425584140	3240013980	2025-03-17T09:55:45.000Z	0x89d101783601d8105c0abd40575c7438a289a4e0f65e753e211242c6e7f058ec

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.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
0xe11f9786b06438456b044b3e21712228adcaa0d1	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	48	10551699030679275956	1794761550011513	-9687975093890696496	0x1c6c6eb5942f99400da8e8b3a7540038f02c81ec	181606989	2024-02-17T08:11:25.000Z	0xcf4ee0bbead313f98b233a94740600b05a54cd359001b6c9ae06c4403aa2a2e0	1435809240009210
0x6f02c88650837c8dfe89f66723c4743e9cf833cd	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	64	35022887625147286403	6115788682800586	-32940790897769662131	0x257f069c2140d83c03df5ba8803c163b613efe2e	181557665	2024-02-17T04:39:14.000Z	0x741661f352f4b1c7d2bf24e0d7f0c3187d8fe02ee0804be154d9dc3147a03b36	4892630946240468
0x6f02c88650837c8dfe89f66723c4743e9cf833cd	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	80	-1854691943034845553	322351141161108	1743953274433650706	0x28df0f193d8e45073bc1db6f2347812c031ba818	181662456	2024-02-17T12:08:52.000Z	0xc1ce82f1dd4e2dc18991ffbd4dc9c0c557a5d45915abf7de4354e2aa8bb7392d	257880912928886

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.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 Arbitrum, recording Principal Token (PT) and Standardized Yield (SY) deposits with resulting LP token mints. Used to track liquidity provider activity, pool composition changes, and yield tokenization 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
0x279b44e48226d40ec389129061cb0b56c5c09e46	false	31	0x0f687b1d213aefb1c174cd8c136cdf563f2a7897	237279519	1177490489735613289	1735254807987301983	1471527562562733593	2024-07-29T12:31:19.000Z	0xadcb94cc144d5c5970532f1c62a2ec06e0e528c18bdc00f4814267e3697cbf63
0x279b44e48226d40ec389129061cb0b56c5c09e46	false	41	0x1b46d5864198788c22221cf3f68ff4f70b5839ed	237168854	117807897580389286	173490413113502149	147162553721316582	2024-07-29T04:49:32.000Z	0x594f9636389ba9dadc82bc4cf1c927831789e6e0668539fdb8448b54345bc68d
0x279b44e48226d40ec389129061cb0b56c5c09e46	false	29	0x40534e513df8277870b81e97b5107b3f39de4f15	237320466	195765489602670587	289630136803928140	245245781302893825	2024-07-29T15:23:05.000Z	0x50d5f28feb04cbfcb4d68c61f53615974876be74b0ccda03f90ffaa0179124bd

Example Query

Query with partition filter

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

MarketV4_Swap_event

Swap events from Pendle V1 protocol markets on Arbitrum, recording exchanges between Principal Tokens (PT) and Standardized Yield (SY) tokens with fees and reserve adjustments. Used for analyzing Pendle market liquidity, trading volumes, and yield token pricing dynamics.

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
0x279b44e48226d40ec389129061cb0b56c5c09e46	false	0x888888888889758f76e7103c6cbf23abbf58f946	85	61035170379310	6191071061	-56185361541983	0x279b44e48226d40ec389129061cb0b56c5c09e46	274804028	2024-11-15T18:11:56.000Z	0x38a65048e28802632dee6904ab557efba7756085aa41b5ec6c380706084aa71e	4952856849
0x279b44e48226d40ec389129061cb0b56c5c09e46	false	0x888888888889758f76e7103c6cbf23abbf58f946	27	104270165300318117	10685978477507	-95982027579033933	0x279b44e48226d40ec389129061cb0b56c5c09e46	274660531	2024-11-15T08:10:48.000Z	0x5ff469f000af26d38fa92e0c81096113c09c7d3c951bf36169fd2b1815c8f5b4	8548782782005
0x279b44e48226d40ec389129061cb0b56c5c09e46	false	0x888888888889758f76e7103c6cbf23abbf58f946	66	304887869092358	31118226027	-280655058120152	0x279b44e48226d40ec389129061cb0b56c5c09e46	274717726	2024-11-15T12:10:37.000Z	0xef16419cebeb92be79649ae64d5f62f82cafa7fe3eed0e88c6f602eee3b5ef90	24894580822

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.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
0x281fe15fd3e08a282f52d5cf09a4d13c3709e66d	false	29	0x4f94fa2932758dc101e4ab14f798cec8db41b320	265322069	519676893482114221	1197274299213012796	862246799376356289	2024-10-19T04:06:50.000Z	0xb0d56c936390cea1844aee2da87032779c085149a89e8568ed5f9080fe576dbd
0x281fe15fd3e08a282f52d5cf09a4d13c3709e66d	false	36	0x8fe355d4ae1a7f93abd5599c98139e619e0a38f4	265365088	65264549836878718727	149377690576448126264	107791315103762682072	2024-10-19T07:06:27.000Z	0x0ebfa80bdec89954ae6b2bff74f7b7be1235db07f12389b468ba1b66f89d4c95
0x281fe15fd3e08a282f52d5cf09a4d13c3709e66d	false	21	0xa886fb35bcef40e7ffedc8fc160c411de829dc19	265589256	9527181554349103723	23161635665923998557	16417675787128653802	2024-10-19T22:46:34.000Z	0x31a4b7b1e3ec805b8c9c8d7f708debe3b2f84dac5671098b28775695ddf62fbd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.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
0x281fe15fd3e08a282f52d5cf09a4d13c3709e66d	false	0x888888888889758f76e7103c6cbf23abbf58f946	36	103080836025680852856	19880693552923501	-101854839039433226455	0x1412a1eb9841f87c9bd2e81e5fe147622def0aef	254522339	2024-09-17T17:08:39.000Z	0x5e4df3b43f5e77ea209f16649d563dd774a3f82c763a2d826ef559a04467d1c9	15904554842338800
0x281fe15fd3e08a282f52d5cf09a4d13c3709e66d	false	0x888888888889758f76e7103c6cbf23abbf58f946	38	100867098382680727625	19449713357089768	-99667782758716161975	0x1412a1eb9841f87c9bd2e81e5fe147622def0aef	254527481	2024-09-17T17:30:16.000Z	0xdccf395b84276ad9a5714c860b016b2d17f70df821954ec475eb2cf569bee9d2	15559770685671814
0x281fe15fd3e08a282f52d5cf09a4d13c3709e66d	false	0x1bdee418cef5deb70390f64d2075b04300500c76	14	326086917365106700	63015296638722	-322195200361294026	0x23469796b3677c322e33a12b5d86eb14157d0dad	254472987	2024-09-17T13:41:07.000Z	0x7c969ee06693a215b661a3f5a2d960161055ced7a1f922b0445b5cfa4a581fa3	50412237310977

Example Query

Query with partition filter

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

MarketV6_Burn_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_receiverSy`	`STRING`	Address of the recipient receiving Standardized Yield (SY) tokens from the burn operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiverPt`	`STRING`	Address of the recipient receiving Principal Tokens (PT) from the burn operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_netLpBurned`	`STRING`	Amount of Liquidity Provider (LP) tokens burned in the liquidity removal operation. Numeric string representation of the token amount in smallest unit.
`in_netSyOut`	`STRING`	Net amount of Standardized Yield (SY) token transferred in the swap or burn operation. Positive values indicate SY received by the user, negative values indicate SY provided by the user to the pool.
`in_netPtOut`	`STRING`	Net amount of Principal Token (PT) transferred in the swap or burn operation. Positive values indicate PT received by the user, negative values indicate PT provided by the user to the pool.

Sample Data

address	removed	log_index	in_netPtOut	in_netSyOut	block_number	in_receiverPt	in_receiverSy	in_netLpBurned	block_timestamp	transaction_hash
0x2092fa5d02276b3136a50f3c2c3a6ed45413183e	false	8	2410973367731010893263	3993344760250127329468	403402024	0x2092fa5d02276b3136a50f3c2c3a6ed45413183e	0x30ccf4bbee313fcd19f3e295b3ba2920a24e2f62	3148719902526648734032	2025-11-23T21:12:45.000Z	0x68ffa813dc7b8858c545fd3d6531884989c2da8b4e92943f1fe727444588b51f
0x2092fa5d02276b3136a50f3c2c3a6ed45413183e	false	8	570097470005945090369	944084192625936552203	403402609	0x2092fa5d02276b3136a50f3c2c3a6ed45413183e	0x30ccf4bbee313fcd19f3e295b3ba2920a24e2f62	744453164187302610610	2025-11-23T21:15:15.000Z	0x8bd662e9a19d66155e3b3964f910d61aeecd9de3b860c3ec5a5adeb2c73644bc
0x2092fa5d02276b3136a50f3c2c3a6ed45413183e	false	8	1435507234637053440525	2377099845256669481321	403403322	0x2092fa5d02276b3136a50f3c2c3a6ed45413183e	0x30ccf4bbee313fcd19f3e295b3ba2920a24e2f62	1874480977976526869373	2025-11-23T21:18:13.000Z	0xe00cabe6bf2fd57abb1f5d293d227d8b4b7983c470a50f8ac325627b64bddbe3

Example Query

Query with partition filter

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

MarketV6_Mint_event

Pendle V6 market liquidity provision events recording the minting of LP (Liquidity Provider) tokens in exchange for PT (Principal Token) and SY (Standardized Yield) token deposits. Tracks quantities of tokens consumed and LP tokens issued to the receiver address for yield-bearing asset pool analytics.

Columns

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

Sample Data

address	removed	log_index	in_receiver	block_number	in_netPtUsed	in_netSyUsed	in_netLpMinted	block_timestamp	transaction_hash
0x2092fa5d02276b3136a50f3c2c3a6ed45413183e	false	15	0x429e45fe7cc9a84ed42a781b4f08687649c48588	402658438	11599458079558430409713	17838354541848684093256	14451981392590902785486	2025-11-21T17:27:06.000Z	0x50e4a87e0d731bf96aeb92e4b0852f565fbe62e1bed978e05fd6e56730ae9346
0x2092fa5d02276b3136a50f3c2c3a6ed45413183e	false	15	0xee3ce66e2c40035ceac880b29f9d7201aedd210f	402496255	3609633658410741238498	5205845869375473318197	4321926261901005830228	2025-11-21T06:13:02.000Z	0x2db8bdef76587d722700ba896f64f074d3632294611b10bd8d34821c981ec6c3
0x2092fa5d02276b3136a50f3c2c3a6ed45413183e	false	15	0xebc3769c489d0f2d5ddd643206fc7739bb85b7f1	402605726	396109140062754877107	593734718130272278422	485675342732477584060	2025-11-21T13:47:52.000Z	0x28d5e47ef3954d76910ce87b656e19d6613ce241cb9fba0609ff64529e810d24

Example Query

Query with partition filter

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

MarketV6_Swap_event

Pendle Protocol V6 market swap events recording Principal Token (PT) and Standardized Yield (SY) token exchanges. Contains swap direction (PT/SY amounts with positive for receipts, negative for contributions), protocol fees, reserve allocations, caller and receiver addresses for tracking yield token trading activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_netPtOut`	`STRING`	Net amount of Principal Token (PT) transferred in the swap or burn operation. Positive values indicate PT received by the user, negative values indicate PT provided by the user to the pool.
`in_netSyOut`	`STRING`	Net amount of Standardized Yield (SY) token transferred in the swap or burn operation. Positive values indicate SY received by the user, negative values indicate SY provided by the user to the pool.
`in_netSyFee`	`STRING`	Amount of Standardized Yield (SY) token collected as protocol fee from the swap transaction. Numeric string representing token amount in smallest denomination.
`in_netSyToReserve`	`STRING`	Amount of Standardized Yield (SY) token allocated to the protocol reserve from the swap transaction. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	in_caller	log_index	in_netPtOut	in_netSyFee	in_netSyOut	in_receiver	block_number	block_timestamp	transaction_hash	in_netSyToReserve
0xfad63f0a2ff618edde23561dff212edfeddbe89d	false	0x888888888889758f76e7103c6cbf23abbf58f946	79	23536889868	6222136	-22784179352	0xb4f8331cab96f624ccb386fbcba9cb3de176e836	407122828	2025-12-04T15:13:50.000Z	0x5b1a7729c1ad47545daaf0b34a589491425f0ebf03cb5efc2922eb80ef4a9953	4977708
0x3308574370f19ea639f4671838e01cfb77d8db70	false	0x888888888889758f76e7103c6cbf23abbf58f946	89	204048322325744920896	59336951320130396	-199317285899136726526	0x11ff5d408f6aa0366620f2833b4cd35603c08eeb	407156753	2025-12-04T17:34:40.000Z	0x0595181fdd849a68e2a9793663c120b8f0252b40df55aee07b640aaa10e163ad	47469561056104316
0x2092fa5d02276b3136a50f3c2c3a6ed45413183e	false	0x888888888889758f76e7103c6cbf23abbf58f946	62	10185382615267222821225	3892760970049900634	-9358339625461690462798	0x0320cb495b33c2895978068efd1c32c4e470a40d	407110599	2025-12-04T14:23:02.000Z	0x4857298c5dd667a9f5a5a4be3c64fd30f4b69241e896e16b6ba24fb7511a3aed	3114208776039920506

Example Query

Query with partition filter

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

MarketV6_UpdateImpliedRate_event

Pendle V6 market event emitted when the natural logarithm of the implied interest rate is updated. Tracks rate changes with timestamp for yield trading analytics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_lnLastImpliedRate`	`STRING`	Natural logarithm of the last implied interest rate in the Pendle market. Numeric string representation of a fixed-point decimal value.

Sample Data

address	removed	log_index	block_number	in_timestamp	block_timestamp	transaction_hash	in_lnLastImpliedRate
0x3308574370f19ea639f4671838e01cfb77d8db70	false	7	406914506	1764809175	2025-12-04T00:46:15.000Z	0x18d7554f65aee7108df591ddecf0414ce3e3ef3d6353a425832e268351ff7f27	102668977757815184
0x3308574370f19ea639f4671838e01cfb77d8db70	false	30	406918596	1764810195	2025-12-04T01:03:15.000Z	0xe4a7c6e84097df28df1038fe7bb36abb137764bc88f8fe68c4d0b0e86cc8f97d	102695012871663071
0x3308574370f19ea639f4671838e01cfb77d8db70	false	23	406918596	1764810195	2025-12-04T01:03:15.000Z	0xe4a7c6e84097df28df1038fe7bb36abb137764bc88f8fe68c4d0b0e86cc8f97d	102695012871663071

Example Query

Query with partition filter

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

PendleMarket_Swap_event

Swap events from Pendle V1 yield trading markets on Arbitrum, recording exchanges between principal tokens (PT) and standardized yield (SY) tokens with fees and reserve allocation. Used to analyze yield trading activity, liquidity provider revenue, and price discovery in fixed-yield 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
0x14fbc760efaf36781cb0eb3cb255ad976117b9bd	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	26	19884568664888393	12662260308633	-17279699378200723	0x14fbc760efaf36781cb0eb3cb255ad976117b9bd	259189712	2024-10-01T07:15:45.000Z	0xea2680922adcdb139ae200fdf54632a41a8a8175691b4f65a4d7b1cddbe3ee5f	10129808246906
0x14fbc760efaf36781cb0eb3cb255ad976117b9bd	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	63	245944641729779	156687359086	-214106029196896	0x14fbc760efaf36781cb0eb3cb255ad976117b9bd	259310382	2024-10-01T15:41:32.000Z	0x1efa6e2e59ce08aa0cf3cd515d8e5e4bab0a1d747f093b7eccea25c0718fec80	125349887269
0x14fbc760efaf36781cb0eb3cb255ad976117b9bd	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	30	16264667766239953	10357130391494	-14134016381195782	0x14fbc760efaf36781cb0eb3cb255ad976117b9bd	259189968	2024-10-01T07:16:49.000Z	0x5bf77f628c8c7d7007b99a4bdba1a03e63b128a5bb351112c65b5d0da76e7a9f	8285704313194

Example Query

Query with partition filter

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

SYCamelotARBETH_Deposit_event

Deposit events for Pendle V1’s Standardized Yield (SY) token wrapping Camelot ARB-ETH liquidity provider positions on Arbitrum. Records token deposits with input amounts, output SY token amounts, and participant addresses for tracking yield tokenization activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_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
0x318eec91f653ca72fafb038f9ad792a6bc0d644c	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	46	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x69ddf9ce5568efa913f1ea601ed298ccfebfc811	132107180	510966444538664	2023-09-18T04:28:01.000Z	0xaebaab0641ba15089565428e416f258ff58af56417f62f83a63b638acd31a860	24891480828472
0x318eec91f653ca72fafb038f9ad792a6bc0d644c	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	54	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x3803d89c31de8b7def55c86f2469a5ea4db41b92	132207410	8127757881888652401	2023-09-18T11:49:39.000Z	0x915c45e7e58f3024eee598ef6006e034ad6ee12cc9a91381ab0e7cbd27d6d62f	396928322148805091
0x318eec91f653ca72fafb038f9ad792a6bc0d644c	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	47	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x3803d89c31de8b7def55c86f2469a5ea4db41b92	132170309	68460100202791941	2023-09-18T09:11:46.000Z	0x9cc4264176effd585ed751d57839e3c70395beca8ab6d74f077b48ae87d9cab2	3343940533767133

Example Query

Query with partition filter

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

SYCamelotGRAILARB_Deposit_event

Deposit events from Pendle V1’s Standardized Yield (SY) token contract for Camelot GRAIL-ARB liquidity pool on Arbitrum. Tracks conversions of underlying tokens (GRAIL-ARB LP or GRAIL) into SY tokens with caller, receiver, and amount data 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
0xdd4c7313fe4c92e043b9b7dfe433e239bcd05a0d	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	64	0x3d9907f9a368ad0a51be60f7da3b97cf940982d8	0x6ea328bf810ef0f0bd1291eb52f1529aa073cefa	201895211	2338098388950936	2024-04-17T08:19:24.000Z	0x4ecc96594cf7e8f21d341caa64c76fbdbc55cdbb9d55e1ea47072480a80ae01b	146226663861650
0xdd4c7313fe4c92e043b9b7dfe433e239bcd05a0d	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	60	0x3d9907f9a368ad0a51be60f7da3b97cf940982d8	0x6ea328bf810ef0f0bd1291eb52f1529aa073cefa	201939500	118112960113274	2024-04-17T11:26:54.000Z	0xbd1ef23e783e04f150d7fe99a9d19dc5543150cd4f4a0e27ebd9c89d3c36c025	7384295933403
0xdd4c7313fe4c92e043b9b7dfe433e239bcd05a0d	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	54	0x3d9907f9a368ad0a51be60f7da3b97cf940982d8	0x6ea328bf810ef0f0bd1291eb52f1529aa073cefa	201939505	176835496784862	2024-04-17T11:26:55.000Z	0x44390c04adfb0686553c633ab6fa543f66ae0cfe1370e4bea236af3cf8d40867	11055566390883

Example Query

Query with partition filter

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

SYCamelotPENDLEETH_Deposit_event

Deposit events from Pendle V1’s Camelot PENDLE-ETH Standardized Yield (SY) token contract on Arbitrum, recording token deposits with input amounts and corresponding SY token outputs. Used for tracking liquidity provision and yield tokenization activity in the Pendle-Camelot pool.

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
0xc79d8a2aa6d769138e599d4dbc30569c9870a6ee	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	50	0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e8	0x24e4df37ea00c4954d668e3ce19ffdcffdec2cf6	92301071	433795986266775932	2023-05-19T14:25:00.000Z	0xbe7d02fe7af6de4ab81916e485041d73f0acc8ebcef306cd6160b79e46566f1d	62284936081999698005
0xc79d8a2aa6d769138e599d4dbc30569c9870a6ee	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	50	0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e8	0x24e4df37ea00c4954d668e3ce19ffdcffdec2cf6	92255236	19119269757478391848	2023-05-19T11:12:51.000Z	0x84c3fdf919f7428cfa7c00300ea06a794fb0f5c68ed5ca54ecdf751164c1f6fa	2735906224555162153436
0xc79d8a2aa6d769138e599d4dbc30569c9870a6ee	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	50	0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e8	0x24e4df37ea00c4954d668e3ce19ffdcffdec2cf6	92331317	1065958454646328530	2023-05-19T16:32:03.000Z	0x9db4c06e31253d48ebce3fab56bd0e4a0906bdd1ff7d26ac123eb11c4cf99feb	152991681330268642937

Example Query

Query with partition filter

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

SYgDAI_Deposit_event

Deposit events for the Pendle SYgDAI (Standardized Yield gDAI) token on Arbitrum, recording when users deposit gDAI to mint SY tokens with caller, receiver, input token, and output amounts. Tracks standardized yield token minting activity for analyzing Pendle protocol usage and liquidity flows.

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
0xaf699fb0d9f12bf7b14474ae5c9bea688888df73	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	3	0xd85e038593d7a098614721eae955ec2022b9b91b	0x4a8e64c3a66ce0830e3bf2ea7863b013aa592114	168261488	224000000000000000000	2024-01-08T07:08:59.000Z	0xdd7443f75c9b8a5383263ca0b395a82e0e47f0dab516bdb9d7bea0d0624c27ce	224000000000000000000
0xaf699fb0d9f12bf7b14474ae5c9bea688888df73	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	3	0xd85e038593d7a098614721eae955ec2022b9b91b	0xa0192f6567f8f5dc38c53323235fd08b318d2dca	168297322	16089430833835618031796	2024-01-08T09:41:24.000Z	0x38c7ed53250e3c7b343c791d4ecad5efb47e8ac95d594742b4ba85f45e1d9285	16089430833835618031796
0xaf699fb0d9f12bf7b14474ae5c9bea688888df73	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	4	0xd85e038593d7a098614721eae955ec2022b9b91b	0x4a8e64c3a66ce0830e3bf2ea7863b013aa592114	168258705	3000000000000000000000	2024-01-08T06:57:15.000Z	0xadc8acff1d4cd698b105b689e8f79b70662250ce7a9025479151635f6f601c8d	3000000000000000000000

Example Query

Query with partition filter

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

SYGLP_Deposit_event

Deposit events for Pendle V1’s SYGLP (Standardized Yield GLP) token contract on Arbitrum, recording when users deposit tokens to mint SY tokens. Tracks depositor addresses, input tokens, deposited amounts, and corresponding SY token output for analyzing yield tokenization flows.

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
0x2066a650af4b6895f72e618587aad5e8120b7790	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	21	0x5402b5f40310bded796c7d0f3ff6683f5c0cffdf	0x7d49e5adc0eaad9c027857767638613253ef125f	118776174	182908847531054522113	2023-08-06T16:36:38.000Z	0x9707fdca4f4d1c2333e146b71fa6527f0aa07604324a80d3a3dc34a6b7062fd0	182908847531054522113
0x2066a650af4b6895f72e618587aad5e8120b7790	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	23	0x0000000000000000000000000000000000000000	0x7d49e5adc0eaad9c027857767638613253ef125f	118604198	183203258244272259	2023-08-06T04:13:56.000Z	0x6daf545c532ae1f36ada807606ecba3903497c0c2b67030cce44dcd4c78233c7	100000000000000
0x2066a650af4b6895f72e618587aad5e8120b7790	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	23	0x0000000000000000000000000000000000000000	0x7d49e5adc0eaad9c027857767638613253ef125f	118674644	1828671234880155665	2023-08-06T09:25:02.000Z	0x48265451fcc13511e97f1093e2ff6aea093e30f1ced0a535d362ff08d673b18e	1000000000000000

Example Query

Query with partition filter

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

SYrETH_Deposit_event

Deposit events from Pendle V1’s SYrETH (Standardized Yield rETH) contract on Arbitrum, tracking when users wrap rETH into yield-bearing SY tokens. Records depositor addresses, input token amounts, and corresponding SY tokens minted for analyzing liquidity provisioning 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
0xc0cf4b266be5b3229c49590b59e67a09c15b22f4	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	37	0xec70dcb4a1efa46b8f2d97c310c9c4790ba5ffa8	0x14fbc760efaf36781cb0eb3cb255ad976117b9bd	228968319	169580066613263195	2024-07-05T09:16:32.000Z	0x8f6d3f7e374395ca5cbdd08d245d1369d9394a72c998b85b591d542b363eb173	169580066613263195
0xc0cf4b266be5b3229c49590b59e67a09c15b22f4	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	156	0xec70dcb4a1efa46b8f2d97c310c9c4790ba5ffa8	0x14fbc760efaf36781cb0eb3cb255ad976117b9bd	229025216	18809889202408313	2024-07-05T13:14:40.000Z	0x0f9bcb4322b3bf8a76f4143b2770a1800b6ea5cdc770390d2e3b12549301cc6f	18809889202408313
0xc0cf4b266be5b3229c49590b59e67a09c15b22f4	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	9	0xec70dcb4a1efa46b8f2d97c310c9c4790ba5ffa8	0x14fbc760efaf36781cb0eb3cb255ad976117b9bd	228949221	3737966747370319	2024-07-05T07:56:45.000Z	0x325066c4cdfe32289755af9488a426ddad87373feead07f748a4c8aeb182661c	3737966747370319

Example Query

Query with partition filter

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

SYStargateLP_Deposit_event

Deposit events from Pendle V1’s Stargate liquidity pool (LP) Standardized Yield (SY) token wrapper on Arbitrum, recording conversions of Stargate LP tokens into SY tokens with depositor, receiver, and amount data. Used for tracking yield-bearing asset deposits and LP position wrapping activity in Pendle’s interest rate trading 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
0x068def65b9dbaff02b4ee54572a9fa7dfb188ea3	false	0x888888888889758f76e7103c6cbf23abbf58f946	39	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0x0a21291a184cf36ad3b0a0def4a17c12cbd66a14	222618380	10846388	2024-06-16T23:37:54.000Z	0x151222012f91797bdc1e366d4ad67077fb538c5712b08ea69c49e1d17f3068e4	10870907
0x068def65b9dbaff02b4ee54572a9fa7dfb188ea3	false	0x888888888889758f76e7103c6cbf23abbf58f946	17	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0x0a21291a184cf36ad3b0a0def4a17c12cbd66a14	222394024	10077220	2024-06-16T08:03:27.000Z	0xbff8ddfae184ab911086dc416d50223d785c1907c4f8aef2457b384652a70c43	10100000
0x068def65b9dbaff02b4ee54572a9fa7dfb188ea3	false	0x888888888889758f76e7103c6cbf23abbf58f946	23	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0x0a21291a184cf36ad3b0a0def4a17c12cbd66a14	222370855	11382297	2024-06-16T06:27:07.000Z	0xf801f62dcf8360c7256f3b58c76aeed2b2a98135bbb89994e8f9844ab2ee8553	11408027

Example Query

Query with partition filter

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

SYstETH_Deposit_event

Deposit events from Pendle V1’s stETH Standardized Yield (SY) token contract on Arbitrum, recording conversions of wstETH into SY tokens with caller, receiver, and minted amounts. Used for tracking yield tokenization flows and liquidity provisioning into Pendle’s fixed-yield 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_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
0x80c12d5b6cc494632bf11b03f09436c8b61cc5df	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	54	0x5979d7b546e38e414f7e9822514be443a4800529	0x08a152834de126d2ef83d612ff36e4523fd0017f	293988688	235529577847007	2025-01-10T14:30:48.000Z	0x59403bc11a6ea3e73a26ed0c77ab1b10a6bea0bf3a1a5b61a13b8b28fe1cdc87	235529577847007
0x80c12d5b6cc494632bf11b03f09436c8b61cc5df	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	21	0x5979d7b546e38e414f7e9822514be443a4800529	0x08a152834de126d2ef83d612ff36e4523fd0017f	294103129	115180172685168	2025-01-10T22:30:54.000Z	0x058d75525c4cae6fda368c161fb25ca00e87a5dbe873eb1342acd2ee7a0a2c0b	115180172685168
0x80c12d5b6cc494632bf11b03f09436c8b61cc5df	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	24	0x5979d7b546e38e414f7e9822514be443a4800529	0x08a152834de126d2ef83d612ff36e4523fd0017f	293873884	178980220317795	2025-01-10T06:31:24.000Z	0x1d2aeffd50b9d2a97f97875e3f0410df79559d54be82500e597685c7fd762593	178980220317795

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.SYstETH_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
0x5c4110ed760470f79e469a901bd6fb45a65be0f4	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	9	0xb688ba096b7bb75d7841e47163cd12d18b36a5bf	0x00000000005bbb0ef59571e58418f9a4357b68a0	183256434	861168586322852774537	2024-02-22T06:49:48.000Z	0xc7a81ad5fd963dd6b2828d69c3137114db93caad50dab52cb08a23cf7c2740b8	881873525544608419141
0x5c4110ed760470f79e469a901bd6fb45a65be0f4	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	26	0xb688ba096b7bb75d7841e47163cd12d18b36a5bf	0x00000000005bbb0ef59571e58418f9a4357b68a0	183274721	109652253746175936940	2024-02-22T08:07:00.000Z	0x1eb2fa04d7120a44f7e2c2ee0d116daa49eda0fc79bc7dc840dd500f9c7de88a	112289020878370018661
0xc79d8a2aa6d769138e599d4dbc30569c9870a6ee	false	0x00000000005bbb0ef59571e58418f9a4357b68a0	35	0xbfca4230115de8341f3a3d5e8845ffb3337b2be3	0x00000000005bbb0ef59571e58418f9a4357b68a0	183276389	718466406100632845	2024-02-22T08:14:00.000Z	0x34266ca509168100f5825e89f0a272817055802c269d2c55d6a6b2c631aa1662	718466406100632845

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.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
0x068def65b9dbaff02b4ee54572a9fa7dfb188ea3	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	33	0xaf02f27abf8337fe8c78e9dd22ab85b4661ff50d	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	127653829	2023-09-03T13:06:33.000Z	0x821889e2a208189b872b0c95711b716f227ba00e725611f94852806206ba401d	54827216	54715122
0x068def65b9dbaff02b4ee54572a9fa7dfb188ea3	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	17	0x54397796ebca0a0eb999b0f263f081dd7448c877	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	127549431	2023-09-03T05:22:38.000Z	0x66cf515741780f3f4bf45ea65b2033f8cee86365b7914c151d78b3e0e4092031	110822796	110596241
0x068def65b9dbaff02b4ee54572a9fa7dfb188ea3	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	25	0xb9a36a32a467be0155793c92f177fee9ee1fc27f	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	127657362	2023-09-03T13:21:44.000Z	0x2c91d9cfacfbc86b8bb87d4556e55534fe6a8fd0bc77965477297e553a0b0abf	119966802	119721530

Example Query

Query with partition filter

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

SYv3_Deposit_event

Deposit events from Pendle V1 Standardized Yield version 3 (SYv3) contracts on Arbitrum, tracking when users wrap underlying tokens into SY tokens with input amounts and resulting SY output. Used for analyzing yield token minting activity, wrapper contract interactions, and tracking liquidity provisioning flows through Pendle’s tokenization layer.

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
0x369751a0b33df3ade5e2ee55e7bb9556b10f390c	false	0x888888888889758f76e7103c6cbf23abbf58f946	54	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0x875f154f4ec93255beaea9367c3adf71cdcb4cc0	265434580	41369080	2024-10-19T11:57:40.000Z	0x853a85cb65d86b3a0ff2594842508305cf7afb5844bf6bbc4832beef27813ef6	45201838
0x369751a0b33df3ade5e2ee55e7bb9556b10f390c	false	0x888888888889758f76e7103c6cbf23abbf58f946	53	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0x875f154f4ec93255beaea9367c3adf71cdcb4cc0	265376684	32103075589	2024-10-19T07:54:53.000Z	0xcec4f0d4960768c69d256ed9d6a3e5feeca2507403054c6a479b441e2b5698bf	35076610577
0x369751a0b33df3ade5e2ee55e7bb9556b10f390c	false	0x888888888889758f76e7103c6cbf23abbf58f946	10	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0x875f154f4ec93255beaea9367c3adf71cdcb4cc0	265583151	183030523	2024-10-19T22:20:49.000Z	0x43ba1464dcf32162fbd4d34d5d528361d706fa822b0546b91b6ddcd653440456	200000000

Example Query

Query with partition filter

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

SYv3_Redeem_event

Standardized Yield (SY) token redemption events from Pendle V1 on Arbitrum, recording when users unwrap SY tokens back into underlying assets. Tracks caller, receiver, output token addresses, and redemption amounts for analyzing yield token unwrapping activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_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
0x0de802e3d6cc9145a150bbdc8da9f988a98c5202	false	0x888888888889758f76e7103c6cbf23abbf58f946	3	0x63a45e0b2686f7be77bb85735c35704d1046459a	0x2416092f143378750bb29b79ed961ab195cceea5	226200586	2024-06-27T08:37:53.000Z	0x010cbc1a38088a71b6266ab1ab70bc65652acccd04e740b682776503368ae5ad	595303081619471	595303081619471
0x0de802e3d6cc9145a150bbdc8da9f988a98c5202	false	0x888888888889758f76e7103c6cbf23abbf58f946	3	0x63a45e0b2686f7be77bb85735c35704d1046459a	0x2416092f143378750bb29b79ed961ab195cceea5	226126291	2024-06-27T03:28:15.000Z	0x441980ae4db3453f2fd8dece631f1ceb51bb095c1af5a07cad1bcab6481d5e86	35757387563602206	35757387563602206
0x0de802e3d6cc9145a150bbdc8da9f988a98c5202	false	0x888888888889758f76e7103c6cbf23abbf58f946	3	0x63a45e0b2686f7be77bb85735c35704d1046459a	0x2416092f143378750bb29b79ed961ab195cceea5	226200838	2024-06-27T08:38:57.000Z	0x238827ede8dc1197bd7c4b11f70b5e5e99ba12c98fa5f429673a534567ccce79	657620146087887	657620146087887

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.SYv3_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) contracts on Arbitrum, recording when users deposit tokens to receive SY tokens in return. Tracks input token addresses, deposited amounts, and resulting SY token amounts for analyzing yield tokenization flows.

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
0x5b56f4bf94807b547eb5e7eba5cd8c033af83aed	false	0x888888888889758f76e7103c6cbf23abbf58f946	28	0x3d15fd46ce9e551498328b1c83071d9509e2c3a0	0x3e4e3291ed667fb4dee680d19e5702ef8275493d	301124363	1056871012276006424	2025-01-31T08:42:03.000Z	0x89d0dd204ab19d36c7bb6886e6feb1e604f8af1c6a13623bfabb8a5fa320ccda	1056871012276006424
0x5b56f4bf94807b547eb5e7eba5cd8c033af83aed	false	0x888888888889758f76e7103c6cbf23abbf58f946	5	0x3d15fd46ce9e551498328b1c83071d9509e2c3a0	0x3e4e3291ed667fb4dee680d19e5702ef8275493d	301129139	439940332022870357	2025-01-31T09:02:11.000Z	0x05b98d226901d5937f2450f6cae923a31ec5676421eed49196b4208105044b12	439940332022870357
0x0a9ed458e6c283d1e84237e3347333aa08221d09	false	0x888888888889758f76e7103c6cbf23abbf58f946	41	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0x22e0f26320ace985e3cb2434095f18bfe114e28e	301108178	62887684	2025-01-31T07:33:49.000Z	0x6917332db4dcc91caa62eae957dd925c30fd0fa148219a53a9921b18b87bb592	72593999

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.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
0x80c12d5b6cc494632bf11b03f09436c8b61cc5df	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	26	0x5979d7b546e38e414f7e9822514be443a4800529	0x08a152834de126d2ef83d612ff36e4523fd0017f	127631668	37674474740	2023-09-03T11:30:22.000Z	0x9d24a57dc72e3252ab43896667cb6bc7c152e2725c7eaa614b79ad05417cd56c	37674474740
0x80c12d5b6cc494632bf11b03f09436c8b61cc5df	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	21	0x5979d7b546e38e414f7e9822514be443a4800529	0x08a152834de126d2ef83d612ff36e4523fd0017f	127631637	93069601046	2023-09-03T11:30:14.000Z	0x9108ecd2eeccc55f0d85b8bdb0278422e258e6a30e57084960ee696df8683665	93069601046
0x80c12d5b6cc494632bf11b03f09436c8b61cc5df	false	0x0000000001e4ef00d069e71d6ba041b0a16f7ea0	14	0x5979d7b546e38e414f7e9822514be443a4800529	0x08a152834de126d2ef83d612ff36e4523fd0017f	127515133	95917990777382891	2023-09-03T02:21:10.000Z	0x0525825252d965a8d637b9164028de5c50178655a1c9edeba72c7c35b4265585	95917990777382891

Example Query

Query with partition filter

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

SYv6_Deposit_event

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

Columns

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

Sample Data

address	removed	in_caller	log_index	in_tokenIn	in_receiver	block_number	in_amountSyOut	block_timestamp	transaction_hash	in_amountDeposited
0xc32e96b4c7eb7959b6a92f3f7ed5d2321e6ed3d4	false	0x888888888889758f76e7103c6cbf23abbf58f946	53	0xfdd22ce6d1f66bc0ec89b20bf16ccb6670f55a5a	0x2133a087017870ec20f82d097603d6cd29d160c7	398864916	5027046	2025-11-10T18:10:07.000Z	0x583f58daf2529710dd89034bae789111262597540d452cfd637cb9e65e3876da	5027046
0xc32e96b4c7eb7959b6a92f3f7ed5d2321e6ed3d4	false	0x888888888889758f76e7103c6cbf23abbf58f946	124	0xfdd22ce6d1f66bc0ec89b20bf16ccb6670f55a5a	0x2133a087017870ec20f82d097603d6cd29d160c7	398656926	14657755	2025-11-10T03:45:01.000Z	0x2f5ac257807584b55ac447e21a839c636a234ecc5f0db6197c3a38bbfa8f848b	14657755
0xc32e96b4c7eb7959b6a92f3f7ed5d2321e6ed3d4	false	0x888888888889758f76e7103c6cbf23abbf58f946	61	0xfdd22ce6d1f66bc0ec89b20bf16ccb6670f55a5a	0x2133a087017870ec20f82d097603d6cd29d160c7	398787415	967930	2025-11-10T12:47:48.000Z	0xcc09e8e00f36a39359eb8d4f70ea75ba316d82a644776bfbdf1574689e9da5a7	967930

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.SYv6_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
0x877b050d26a780bb43642171859434fdf496f1ae	0xa972fb7828f0bff8a22f7f8c63b17cfb971bfc0a	0x9bb47ff1ade2bc22c9f0761560063baa3df883b5	0x28de02ac3c3f5ef427e55c321f73fdc7f192e8e4	false	1719446400	1	88493791	2023-05-08T06:58:39.000Z	0x2cef5be7171608365d340abe07cb2b9d8fbf7e0cfaad57ceaeb987ac8e0e5ea2
0xba1f509c6e5f1f6a529ecc0913b27658a678b4b9	0xc79d8a2aa6d769138e599d4dbc30569c9870a6ee	0x7588c74473a84d7fa87bec375b408e3402f7fdb9	0x28de02ac3c3f5ef427e55c321f73fdc7f192e8e4	false	1719446400	1	88876462	2023-05-09T09:59:30.000Z	0x7ecb1b9eadef48b0d667b52cd81f70164896b27ad718e466006e057a85b8b05a
0x4c1c121849b8ace08e037ef620552476852f2212	0x4665d514e82b2f9c78fa2b984e450f33d9efc842	0xa728c4d0d94a42b3e87458e55595a919f3d84b99	0x28de02ac3c3f5ef427e55c321f73fdc7f192e8e4	false	1719446400	1	88791165	2023-05-09T04:04:09.000Z	0x85ff17570692c1eac4632292fd30c920bce2f0111045c444eb4788ff0f9054af

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.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
0xb72b988caf33f3d8a6d816974fe8caa199e5e86c	0x50288c30c37fa1ec6167a31e575ea8632645de20	0xa1c32ef8d3c4c30cb596bab8647e11daf0fa5c94	0xeb38531db128eca928aea1b1ce9e5609b15ba146	false	1719446400	1	158939601	2023-12-11T04:24:49.000Z	0x130336605bf06206f48baa725bed2ff7085c965fd75ec40c91800e97baff7a7a
0x9addde3a8819c2eed4e5113b7aa1cecf4096bec3	0x22b9e6f6c462bb0b03f76d3a8246950d95f03692	0x0c9d0caf36c14f26d29a18d84b19a4c2565f5739	0xeb38531db128eca928aea1b1ce9e5609b15ba146	false	1711584000	1	158935307	2023-12-11T04:05:43.000Z	0xda5d251910297667517e85d794d5fde0cc78a7c3a5fe80ee24bddc2df2884ab5
0x8d164e0c662c9e199baac9e97b6a8664c75700ea	0xf176fb51f4eb826136a54fdc71c50fcd2202e272	0x28df0f193d8e45073bc1db6f2347812c031ba818	0xeb38531db128eca928aea1b1ce9e5609b15ba146	false	1714003200	1	180269742	2024-02-13T08:29:38.000Z	0x65eed6de14f4003612fe252f88032180434754576c4eca0c25587debcd64ebbc

Example Query

Query with partition filter

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

YieldContractFactoryV4_CreateYieldContract_event

Yield contract creation events from Pendle V1 protocol on Arbitrum, recording the deployment of Principal Token (PT) and Yield Token (YT) pairs with their associated Standardized Yield (SY) token and expiry timestamp. Used for tracking new yield-bearing markets and analyzing protocol expansion across different underlying 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
0x22e9ad26ea0e65a7073571d5d7172ff6336084ad	0x5b56f4bf94807b547eb5e7eba5cd8c033af83aed	0xa810ba21e65d54de0283002db8fb6ea504c83234	0xc7f8f9f1dde1104664b6fc8f33e49b169c12f41e	false	1735171200	1	233743830	2024-07-19T06:06:04.000Z	0xb6cb8c3bcc9210d3c65fef2e82e2ffe0047c736948f91b2e1c3fd55e3d72777c
0xd9de069f0980fed309e8885cdfbd66bdd66cdb77	0xc987809440fdd08dcea0d0571c7a8e9a9bbb45cc	0x75690ebcb89a655de5f9f3b8b68e7032450afe94	0xc7f8f9f1dde1104664b6fc8f33e49b169c12f41e	false	1735171200	1	237594699	2024-07-30T10:31:11.000Z	0x51973ca9c59c29ac35161cbc54c75d55b3317e5bca7704bd6d2c0c1c707fcdaf
0x2be6fab4d1408e7ad6ad91ce7b77fa2a7670782f	0x0a9ed458e6c283d1e84237e3347333aa08221d09	0x03577ffa91edb93ac3aee081efbe6f323da949e1	0xc7f8f9f1dde1104664b6fc8f33e49b169c12f41e	false	1735171200	1	237601819	2024-07-30T11:00:57.000Z	0x1dc134ce1ab711c37388eb1f02d481310a765200d62bc3fbaf560ee684a1fbd5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pendle_v1_arbitrum.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
0x0fc042b32a9a6191834ea12ffa04f2044d0eb302	0xbe9a9b386fdba0de5fd76fa2495b0940102ea1e4	0x8dc75acdc362e22febf0a9e358e501a6414aafa7	0xff29e023910fb9bfc86729c1050af193a45a0c0c	false	1750896000	1	285218188	2024-12-16T02:51:23.000Z	0x85b536689a1e23b4a95561710b91e3a1462e893e03726e0116359861299994db
0xf93e88b07dfc860abf72d13a088a7092ce213190	0xd302d7fd2c9375a433018fdfa5613be6ad3f18e3	0x836997ae68e92f59da33e8f4a0ad9f3943193820	0xff29e023910fb9bfc86729c1050af193a45a0c0c	false	1735171200	1	264997381	2024-10-18T05:26:48.000Z	0x4b33b12f854da96959cc992683fd36518a9831e9852999478b6e4a82659b96ea
0x4d5d8375c39dc91a8aca33ff4a4564de92dcd04c	0xaf699fb0d9f12bf7b14474ae5c9bea688888df73	0x4ac1cc1f45b07bb317883ecb7a2a1d95bf617d02	0xff29e023910fb9bfc86729c1050af193a45a0c0c	false	1743033600	1	248806900	2024-09-01T01:24:26.000Z	0xfe2abb67907e945aedca01b85cdabbd052d22a20724d31068023323d813ea620

Example Query

Query with partition filter

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

YieldContractFactoryV6_CreateYieldContract_event

Event emitted when Pendle protocol’s YieldContractFactoryV6 creates a new yield contract, recording the deployed Principal Token (PT), Yield Token (YT), and Standardized Yield (SY) token addresses along with the contract’s expiration timestamp. Used for tracking new yield token pair deployments across Pendle markets.

Columns

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

Sample Data

in_PT	in_SY	in_YT	address	removed	in_expiry	log_index	block_number	block_timestamp	transaction_hash
0x494272e77a472f1fdedb7da42162a8d771e978e7	0x23a052dfcabd4fa7bd52e7e67e0fb0ee596e7383	0xf789cd56b628d78011bbaac6283d0a542e24c7a5	0xba814bf6e27a6d6bae4a8ac65c8bc3d8e9b0aacf	false	1779321600	8	401082062	2025-11-17T04:04:32.000Z	0x3b49de457c707cb7ba04f060fa0cbf70863ea097860b36e213b7d9ed059e357c
0xda0c3695d8ca7753a60940b975457169a0cd992d	0xa809c9814d04282490c0078200a7597452a9452d	0x33bc17677078c880af8655f6cfa0b3bcb8e96c2c	0xba814bf6e27a6d6bae4a8ac65c8bc3d8e9b0aacf	false	1770854400	22	401084307	2025-11-17T04:13:52.000Z	0x61f8cafb47b0e3e866b6dbb68b1df3d290d7c5277f5d072f50b1562402a91cb7
0x95b4655b30e7446f79c63ad3987006a5b99e954c	0xc913698f534ed275f28d8379f5600f333f60594d	0x41442b994cb51848af1c439eefdb88637417360e	0xba814bf6e27a6d6bae4a8ac65c8bc3d8e9b0aacf	false	1767225600	5	392526519	2025-10-23T10:36:00.000Z	0x6c70d1fcfb0bff3bf45b80b8a977b66241596355b1f0442657008990e9ce096f

Example Query

Query with partition filter

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

YTv5_CollectInterestFee_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_amountInterestFee
0x0fb95ec4086b3007c894ad78703bc634150a1d50	false	55	392448209	2025-10-23T05:10:15.000Z	0x0e9b63098b11e4df8e3b2a13fe4209173abf4a7ebdca0fe16e104d797420b85a	233606126
0x2133a087017870ec20f82d097603d6cd29d160c7	false	3	392411649	2025-10-23T02:37:57.000Z	0xbad175eb2ba38f17c733536b607f28dad2d02aa9737301950c2da5512818233c	11705
0x2133a087017870ec20f82d097603d6cd29d160c7	false	3	392568331	2025-10-23T13:29:48.000Z	0xa4fc3bb48500927d412b1d18cb4b1c67fc296cb605622e1ccab8150c97d136cf	239837

Example Query

Query with partition filter

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

YTv5_CollectRewardFee_event

Reward fee collection events emitted by Pendle V5 Yield Token (YT) contracts when protocol fees are extracted from accrued rewards. Contains the reward token address and collected fee amount for protocol revenue tracking.

Columns

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

Sample Data

address	removed	log_index	block_number	in_rewardToken	block_timestamp	transaction_hash	in_amountRewardFee
0xa661223676633a701b3d1e51bd8c47e2da07c1f6	false	25	340250964	0x912ce59144191c1204e64559fe8253a0e49e6548	2025-05-25T03:41:26.000Z	0x6ce9e55db1a2a60916ab1a1bfedd528f4e132a393cb8e9b5a27a4ffb199944f9	0
0xa661223676633a701b3d1e51bd8c47e2da07c1f6	false	24	340250964	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2025-05-25T03:41:26.000Z	0x6ce9e55db1a2a60916ab1a1bfedd528f4e132a393cb8e9b5a27a4ffb199944f9	1651733689893218
0x4173dd58ee78764bfd274e2bd79fc684cdd40397	false	26	340371200	0x2ac2b254bc18cd4999f64773a966e4f4869c34ee	2025-05-25T12:03:40.000Z	0xa58c8fcef884db381e54084628bbd5990d35e8eaa976dd21315919355623da86	869771136549625258

Example Query

Query with partition filter

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

YTv6_Burn_event

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

Columns

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

Sample Data

address	removed	in_caller	log_index	in_receiver	block_number	in_amountSyOut	block_timestamp	transaction_hash	in_amountPYToRedeem
0x12da049222953b558008789d1b54a0630d6ef51e	false	0x888888888889758f76e7103c6cbf23abbf58f946	9	0xc32e96b4c7eb7959b6a92f3f7ed5d2321e6ed3d4	406265390	706032437	2025-12-02T03:48:41.000Z	0x93d08b83fed156c76bfd5215a6151e5c89affa5b64c6498630cef9ac97c92a5a	715088384
0x12da049222953b558008789d1b54a0630d6ef51e	false	0x888888888889758f76e7103c6cbf23abbf58f946	10	0xc32e96b4c7eb7959b6a92f3f7ed5d2321e6ed3d4	406265843	826753481	2025-12-02T03:50:35.000Z	0x3d4861873b2bdd05d17abe7b98cb8e328e37d92c62aae8f400361b0e6a9e8212	837357860
0x12da049222953b558008789d1b54a0630d6ef51e	false	0x888888888889758f76e7103c6cbf23abbf58f946	21	0xc32e96b4c7eb7959b6a92f3f7ed5d2321e6ed3d4	406266487	601102293	2025-12-02T03:53:16.000Z	0x22fe2883c8034af2744238a2316b340171b44edbbe99951a7b2efb98811134ee	608812350

Example Query

Query with partition filter

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

YTv6_CollectInterestFee_event

Interest fee collection events emitted by Pendle V1 Yield Token (YT) contracts. Records the amount of interest fees collected in the smallest token unit, used for tracking protocol revenue from yield-bearing assets.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_amountInterestFee
0x12da049222953b558008789d1b54a0630d6ef51e	false	3	406677642	2025-12-03T08:21:29.000Z	0x7b0b020493234fe784f0619b9128f2d1883c50c741f1d950d8380169c148888c	1564062
0x12da049222953b558008789d1b54a0630d6ef51e	false	3	406645166	2025-12-03T06:06:25.000Z	0x223e645613c232cf5f80a0b97ab553967cdf6978eda6741c19837579d03328b6	3916260
0x12da049222953b558008789d1b54a0630d6ef51e	false	3	406573322	2025-12-03T01:07:42.000Z	0x2866af88c80eceeddae77b1550eefc67df5eadec8b854c09ad6f6272186ea00b	1671030

Example Query

Query with partition filter

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

YTv6_CollectRewardFee_event

No description available.

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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

YTv6_Mint_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiverPT`	`STRING`	Address designated to receive the Principal Token (PT) portion of the minted yield-bearing tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiverYT`	`STRING`	Address designated to receive the Yield Token (YT) portion of the minted yield-bearing tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountSyToMint`	`STRING`	Amount of Standardized Yield (SY) tokens used to mint Principal and Yield tokens. Numeric string representing the token quantity in the smallest unit denomination.
`in_amountPYOut`	`STRING`	Amount of Principal Yield (PY) tokens minted and distributed. Numeric string representing the token quantity in the smallest unit denomination.

Sample Data

address	removed	in_caller	log_index	block_number	in_receiverPT	in_receiverYT	in_amountPYOut	block_timestamp	transaction_hash	in_amountSyToMint
0x214d1950027863f5e1ec6369797d9a51ef1bb66f	false	0x888888888889758f76e7103c6cbf23abbf58f946	8	406577616	0x04c751f8be5d5bb4a23b4397dc23adfa250c25f0	0x04c751f8be5d5bb4a23b4397dc23adfa250c25f0	18404685072342818366942	2025-12-03T01:25:32.000Z	0x15a072b5a9e66ade361c6a51027a66126905b44d8a6bb675a8f3822a9fc713a9	17452749994000000000000
0xdb795dc5e359f3c53b83f603e10fd9901f851190	false	0x888888888889758f76e7103c6cbf23abbf58f946	8	406686157	0x4e464e83275672a468bc781e83ae70ac22f388c6	0x4e464e83275672a468bc781e83ae70ac22f388c6	27992000000000000000000	2025-12-03T08:56:49.000Z	0x0c3acd00152c1c91f6bf78bf48ae7d5ea587ffdadfe0514367f6b1e79a6aa8c2	27992000000000000000000
0xdb795dc5e359f3c53b83f603e10fd9901f851190	false	0x888888888889758f76e7103c6cbf23abbf58f946	8	406683077	0x4e464e83275672a468bc781e83ae70ac22f388c6	0x4e464e83275672a468bc781e83ae70ac22f388c6	40081228644249307591080	2025-12-03T08:44:02.000Z	0x317e20f91a159455646d93b67308ec30383fbf9f5a4af4b34d540bf3c68c7352	40081228644249307591080

Example Query

Query with partition filter

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

YTv6_RedeemInterest_event

Pendle V1 Yield Token (YT) interest redemption events tracking user withdrawals of accrued interest from yield-bearing positions. Records user addresses and interest amounts claimed from YTv6 contracts.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_interestOut`	`STRING`	Amount of interest redeemed by the user from the Yield Token (YT) contract. Denominated in the smallest unit of the underlying token.

Sample Data

address	in_user	removed	log_index	block_number	in_interestOut	block_timestamp	transaction_hash
0x12da049222953b558008789d1b54a0630d6ef51e	0xba9c45cc80c01e184b1d1163ed75e88795bdad2c	false	4	407640466	21475	2025-12-06T03:04:11.000Z	0xd34910999b7824b421c0b70d8509402a05d867f2fcd5e6ab385e5f3abdf4084e
0x12da049222953b558008789d1b54a0630d6ef51e	0xf48e40b7274b86bd78ee1a79660481deeb1b7dbe	false	4	407623242	158653432	2025-12-06T01:52:37.000Z	0x12a5d0d1a6fe7d84f4de6a1cb4f3f88fec7820770b7f028a3a1b68835d8aaaa3
0x12da049222953b558008789d1b54a0630d6ef51e	0xbc59bc6f063287e63c4df600a0f8f768aa778480	false	4	407757687	794772	2025-12-06T11:11:04.000Z	0x1497cf9fb625b5ed56e86088f72223f6911cb04d6f8635334e252ea7db439c33

Example Query

Query with partition filter

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

YTv6_RedeemRewards_event

Reward redemption events from Pendle V6 yield token (YT) contracts capturing user claims of accumulated incentives. Contains user address and reward amounts array for tracking yield distribution.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountRewardsOut`	`ARRAY<STRING>`	Array of reward amounts distributed to the user when redeeming Yield Tokens (YT) in the Pendle protocol. String-encoded numeric values representing token amounts in their smallest denomination.

Sample Data

address	in_user	removed	log_index	block_number	block_timestamp	transaction_hash	in_amountRewardsOut
0x12da049222953b558008789d1b54a0630d6ef51e	0x534d620d8776d787d0b4764ddc5396e8d9c3a1ce	false	10	406742564	2025-12-03T12:51:15.000Z	0xb39270f8176310b27f60281c54a2ce9cf9a81ca558808ccbf39e51b5e2f96845	[]
0x12da049222953b558008789d1b54a0630d6ef51e	0x534d620d8776d787d0b4764ddc5396e8d9c3a1ce	false	1	404928903	2025-11-28T07:08:50.000Z	0x51ecbb8ed14645306dac5eaa0fb07f52e624ed3d273e1f4545acd11f29e379a5	[]
0x12da049222953b558008789d1b54a0630d6ef51e	0x534d620d8776d787d0b4764ddc5396e8d9c3a1ce	false	10	406072734	2025-12-01T14:28:20.000Z	0x419b084d1bba065b2eb4854f9d8926fe1a571f910c59557db85c1982070bc555	[]

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​BorosAMMFactory_AMMCreated_event

​BorosMarket_FeeRatesUpdated_event

​BorosMarket_LimitOrderFilled_event

​BorosMarket_LimitOrderPartiallyFilled_event

​BorosMarket_Liquidate_event

​BorosMarket_MarketOrdersFilled_event

​BorosMarket_OtcSwap_event

​BorosMarket_PaymentFromSettlement_event

​BorosMarketFactory_MarketCreated_event

​BorosMarketHubEntry_CashTransfer_event

​BorosMarketHubEntry_CollectFee_event

​BorosMarketHubEntry_EnterMarket_event

​BorosMarketHubEntry_ExitMarket_event

​BorosMarketHubEntry_MarketAdded_event

​BorosMarketHubEntry_PayTreasury_event

​BorosMarketHubEntry_TokenAdded_event

​BorosMarketHubEntry_VaultDeposit_event

​BorosMarketHubEntry_VaultWithdrawalFinalized_event

​BorosRouter_AddLiquidityDualToAmm_event

​BorosRouter_AddLiquiditySingleCashToAmm_event

​BorosRouter_RemoveLiquidityDualFromAmm_event

​BorosRouter_RemoveLiquiditySingleCashFromAmm_event

​BorosRouter_SingleOrderExecuted_event

​BorosRouter_SwapWithAmm_event

​GaugeController_ReceiveVotingResults_event

​LimitRouter_OrderFilledV2_event

​MarketFactoryV2_CreateNewMarket_event

​MarketFactoryV3_CreateNewMarket_event

​MarketFactoryV4_CreateNewMarket_event

​MarketFactoryV5_CreateNewMarket_event

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

​MarketV6_Burn_event

​MarketV6_Mint_event

​MarketV6_Swap_event

​MarketV6_UpdateImpliedRate_event

​PendleMarket_Swap_event

​SYCamelotARBETH_Deposit_event

​SYCamelotGRAILARB_Deposit_event

​SYCamelotPENDLEETH_Deposit_event

​SYgDAI_Deposit_event

​SYGLP_Deposit_event

​SYrETH_Deposit_event

​SYStargateLP_Deposit_event

​SYstETH_Deposit_event

​SYv2_Deposit_event

​SYv2_Redeem_event

​SYv3_Deposit_event

​SYv3_Redeem_event

​SYv4_Deposit_event

​SYv5_Deposit_event

​SYv6_Deposit_event

​YieldContractFactoryV2_CreateYieldContract_event

​YieldContractFactoryV3_CreateYieldContract_event

​YieldContractFactoryV4_CreateYieldContract_event

​YieldContractFactoryV5_CreateYieldContract_event

​YieldContractFactoryV6_CreateYieldContract_event

​YTv5_CollectInterestFee_event

​YTv5_CollectRewardFee_event

​YTv6_Burn_event

​YTv6_CollectInterestFee_event

​YTv6_CollectRewardFee_event

​YTv6_Mint_event

​YTv6_RedeemInterest_event

​YTv6_RedeemRewards_event

Tables

BorosAMMFactory_AMMCreated_event

BorosMarket_FeeRatesUpdated_event

BorosMarket_LimitOrderFilled_event

BorosMarket_LimitOrderPartiallyFilled_event

BorosMarket_Liquidate_event

BorosMarket_MarketOrdersFilled_event

BorosMarket_OtcSwap_event

BorosMarket_PaymentFromSettlement_event

BorosMarketFactory_MarketCreated_event

BorosMarketHubEntry_CashTransfer_event

BorosMarketHubEntry_CollectFee_event

BorosMarketHubEntry_EnterMarket_event

BorosMarketHubEntry_ExitMarket_event

BorosMarketHubEntry_MarketAdded_event

BorosMarketHubEntry_PayTreasury_event

BorosMarketHubEntry_TokenAdded_event

BorosMarketHubEntry_VaultDeposit_event

BorosMarketHubEntry_VaultWithdrawalFinalized_event

BorosRouter_AddLiquidityDualToAmm_event

BorosRouter_AddLiquiditySingleCashToAmm_event

BorosRouter_RemoveLiquidityDualFromAmm_event

BorosRouter_RemoveLiquiditySingleCashFromAmm_event

BorosRouter_SingleOrderExecuted_event

BorosRouter_SwapWithAmm_event

GaugeController_ReceiveVotingResults_event

LimitRouter_OrderFilledV2_event

MarketFactoryV2_CreateNewMarket_event

MarketFactoryV3_CreateNewMarket_event

MarketFactoryV4_CreateNewMarket_event

MarketFactoryV5_CreateNewMarket_event

MarketFactoryV6_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

MarketV6_Burn_event

MarketV6_Mint_event

MarketV6_Swap_event

MarketV6_UpdateImpliedRate_event

PendleMarket_Swap_event

SYCamelotARBETH_Deposit_event

SYCamelotGRAILARB_Deposit_event

SYCamelotPENDLEETH_Deposit_event

SYgDAI_Deposit_event

SYGLP_Deposit_event

SYrETH_Deposit_event

SYStargateLP_Deposit_event

SYstETH_Deposit_event

SYv2_Deposit_event

SYv2_Redeem_event

SYv3_Deposit_event

SYv3_Redeem_event

SYv4_Deposit_event

SYv5_Deposit_event

SYv6_Deposit_event

YieldContractFactoryV2_CreateYieldContract_event

YieldContractFactoryV3_CreateYieldContract_event

YieldContractFactoryV4_CreateYieldContract_event

YieldContractFactoryV5_CreateYieldContract_event

YieldContractFactoryV6_CreateYieldContract_event

YTv5_CollectInterestFee_event

YTv5_CollectRewardFee_event

YTv6_Burn_event

YTv6_CollectInterestFee_event

YTv6_CollectRewardFee_event

YTv6_Mint_event

YTv6_RedeemInterest_event

YTv6_RedeemRewards_event