Skip to main content

Tables

GaugeController_ReceiveVotingResults_event

Event emitted when the Pendle GaugeController contract receives voting results, containing arrays of market addresses and their corresponding PENDLE token reward amounts for a specific time period. Used for tracking liquidity mining incentive distributions across Pendle markets.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_wTimeSTRINGUnix timestamp representing the voting period end time. Integer value stored as string, in seconds since epoch.
in_marketsARRAY<STRING>Array of market contract addresses receiving voting allocations. Each address is hex-encoded, 0x-prefixed, and 42 characters long.
in_pendleAmountsARRAY<STRING>Array of PENDLE token amounts allocated to each market. String-encoded integers representing token quantities in wei (smallest unit, 18 decimals).
addressremovedin_wTimelog_indexin_marketsblock_numberblock_timestampin_pendleAmountstransaction_hash
0x47d74516b33ed5d70dde7119a40839f6fcc24e57false1672272000352[“0x7b246b8dbc2a640bf2d8221890cee8327fc23917”,“0x44474d98d1484c26e8d296a43a721998731cf775”,“0x9ec4c502d989f04ffa9312c9d6e3f872ec91a0f9”,“0x54e28e62ea9e8d755dc6e74674eabe2abfdb004e”,“0x9a76925dd91a7561b58d8353f0bce4df1e517abb”]162909572022-12-29T14:17:11.000Z[“131807058784648109832599”,“29724649506328750070019”,“151022725435442892669582”,“59096933193088964366184”,“128348633080491282712814”]0xf82df7530b0e3f15c5eec630273d6fb090e03804f261f88d39d5f1483ac76bee
0x47d74516b33ed5d70dde7119a40839f6fcc24e57false1762992000754[“0xc374f7ec85f8c7de3207a10bb1978ba104bda3b2”,“0x9a4e45841ddb012f1946372e8bd9d65bb17a7768”,“0x520dc4a08e55f6bcc241e0fb780a683a425e8956”,“0x6d60ee6217a2a76859861962a6fb8a28f9dac2a3”,“0x34280882267ffa6383b363e278b027be083bbe3b”,“0x307c15f808914df5a5dbe17e5608f84953ffa023”,“0x6524421041a33a559831a6d305936361b6e4d217”,“0x7da97fbfaa3020f856c60eb4ef068079a9023aca”,“0xe0938446e04f24217491e07719507cf7333a6c2f”,“0xe467c5c54748f0125d729280f90ded77c4e720a4”,“0x1bd78377dfbca2043e38b692d2e0b32396b4772d”,“0x2f8159644f045a388c1fc954e795202dc1d34308”,“0x091215f4de47eae4d8d2df7c748ad33ac6be1e92”,“0xc9904994ef8d0614314d66800718d2a213502f9b”,“0x8585177b041cd3c3fbec607fb620230259cd70db”,“0x1b089668c0833baaf1c523a7ed3d6d8ccfee840b”,“0xb6ac3d5da138918ac4e84441e924a20daa60dbdd”,“0xa83174f1dd8475378abca9d676dad3ce97409e0a”,“0x41b5236df40c4718a76d4342e83153556373c072”,“0xaf5669e4ed9a999667cd2b810878022cf54866d1”,“0x6c6668df3916ad01e54397f54ba9deddbafeeb50”,“0xf342d4bde4ec5b4bba94c17ab4c92ee3792abd5e”,“0xeaac9b0b4f25cc63255198a3920fcf7752509586”,“0x75636d1cf056d765b269e7cbacf4e0ea57300507”,“0xf8094570485b124b4f2abe98909a87511489c162”,“0x2cbb8efe9a7ff340768a1b672475111672e7527e”,“0xa00f596e9d03fe90c5d22c15b468e8dce4d24de0”,“0x3daf20e46708e556570159eaf98eee53a1a5b8a4”,“0x9942a74e6e75cea2db5d068c1e75c9ac687bca06”,“0xc7d566f5cd575fdad0e982bd238d9abcf29807ea”,“0x78728b6a081e800204d5abaaa559a84f2404335e”,“0x15e434c42ab4c9a62ed7db53baaf9d255ea51e0e”,“0xbe570be4238bd9019aa8d575204f1daa27ee0a15”,“0xf55bc75df5933dd35aacf3bca948b0c4630040d1”,“0x95a9504f246cd65bf91c2c550a53f7f415227ed1”,“0x10e3e052bdee38c468ad092c87d330b59af6bbeb”,“0xc35ec9d0d39bfa41af786e3ce91f904dd5fb2eac”,“0x2b0c826bb68fb3ff9d29db368af6210b302ab31b”,“0xdc4ef8ed77f975519777df3a6e36cebacc978962”,“0xcc781b043933c10a04409b22aada3a3d1a7f29d4”,“0x7057c9e6f213bbb9b845fc57010034e9e4a69e8a”,“0xa8eea676ba075a9b1630bd9c2468df6d804c4344”,“0x126b8f10b8a6f3d3dbe5dc991ceb14aba6345e04”,“0x80c229544530c2ba693bf7e8a5aa76ff98705c6e”,“0x233062c1de76a38a4f41ab7c32e7bdb80a1dfc02”,“0x0e3735d5ee96d21426ee40e7dcb623513e0b6876”,“0x56649da435f9a9a57ee9c4c06b728e4ba84fcc6b”,“0x937c7868824ae53db3b7c634de209fb7a74e362c”,“0x3a4204255257698e379245ef94274ef3b2907296”,“0xe5c04b27476a71803fed99a0914a2fc5c37e4cf6”,“0xb1f73a26c8992fc6e6f7a0788e6e7dfb7a0a8f90”,“0xfe8acf962f9a67d67b858819acee296dfda878dd”,“0x39c3f8e0e7c6f44dc8f0397feb124517ba82e26e”,“0x4c60ab7ce24d4d7268317f44b6dc3d6530864e86”,“0x3f53eb4c57c7e7118be8566bcd503ea502639581”,“0x78954a6a2c2a08455f92e47c4e587feb7467bf37”,“0x1821ec9c2d2c13f6b89d21301b93bd8d6667712b”,“0x8af9872eee05c7ca1c24295426e4d71b4af5b559”,“0x4708e55da780a953fded696cecb0e19164ba72f4”,“0x68e0dc97d053edcc6fcdbf7aeb551258357882df”,“0x4eaa571eafcd96f51728756bd7f396459bb9b869”,“0xefa9339980ffee3304af4822b80484bfcc6f35ee”,“0x02c1289dacb6d459fc784236e862bc504c991f81”,“0xc5ecdafbede3c8436c9c09e60bffac3731a9b28e”,“0x69295970dd33b135417c9b866d03c6f59f022f8b”,“0xc78b885d42821a8ac5b46cba2b8f929cdee87dfc”,“0xcb6f35008f4de72733db10d1f24200fa2ec44eb3”,“0xa8f21c9d0afb46382ead7c33e79f00ef9666e122”,“0x28f2c72361f6b7430c5ac30d289265309392901c”,“0xe8cfd40995720f69dc5ae941c1166f9d4b5e40e2”,“0x634dc4b08818021fa55a16044495b02ad45ec430”,“0xa549ea12e9bef89c604183404a929d78a4941eb8”,“0x53f940db819400f226466f5ad330c177a4be6b3c”,“0x71d857c437c56562a27aa087bc3fe529b35b6948”,“0x8268d9d5d3e938812cd7d0b1d3fca478fb202d1a”,“0xeb5819b31a0378407f43aba2f3e9d16b40aa5ec7”,“0x51026ab8b54767e67f7f5543c86bf718cf00cb4c”,“0xc65b7a0f8fc97e1d548860d866f4304e039ef016”,“0xed81f8ba2941c3979de2265c295748a6b6956567”,“0x40b7380796751d15005197fb488b0449bd691e46”,“0xaadbc004dacf10e1fdbd87ca1a40ecaf77cc5b02”,“0x41264f35ef7ef8c4905ca98052e8d7480f12859e”,“0x3d0ef4b41975c52a004c401ee736428620c3ba71”,“0xa444ff5ad4ca1f234c95a6214849ac550722b6dc”,“0x0f998fa5ecaf0f08d877d73773f76e227a5e517b”,“0xcfed4068161991b1fcb8c189509a9fa9078f09a8”,“0x97af38b0f96df80c29bf2e7b4ae6c70dcbcb6eba”,“0x9c0f10226f335054fa024e49631fda3f56faa148”,“0xe4daf4354a2028442946356dd6a49977d89646cd”,“0xc4fb3b527965334fd9db7da0ee5cd6174ae6d6eb”,“0x9df7af9b298b6a37f50c9df4a7a3f048e4629e66”,“0x3b567e07357dc2a1f72481299bc286afff3ea39c”,“0xfce3f966a131c46a51b896ceea3917bc4c302577”,“0x261b252546c7b54cc82bee9b69615ebefcc22ed9”,“0x43137fc40f8bb704ae6e1e912d85d90556167d69”,“0x83fbf88733474f8d6b27a6c7df24f83c07846301”,“0xd3ed08461881b961fd5f2997908401cad42b60cf”,“0x40bcb355623ad5b82709a3fd0d49af2207eb19e5”]237865802025-11-13T00:00:47.000Z[“356882534703942487961”,“275928249071921588197”,“91950675434378540732”,“2623876435503773992”,“9516483454854023972”,“3207398902589140865669”,“96221491888889762720”,“140059780035224543592”,“25139116395182789926”,“45688080491981630867”,“88648030249455500742”,“224141978097882701347”,“7986762085197950976”,“4186520735146793987”,“437944320000000097725”,“138365913486805586597”,“3463616812875859816924”,“4570469022229975246704”,“3362145002918657990”,“1945746579255929994”,“1367863470560465996”,“3032958532286460582176”,“162028527038821574528”,“684288000000000196009”,“4576744624485527986”,“30786033792325976910”,“3317104332886013990”,“18542001673779110946”,“181242034255852514472”,“20786079876691733939”,“126231178475147624632”,“1290990689999”,“268139947097248874219”,“131174189974230182618”,“18557290859201027946”,“14031125678024036959”,“46638973022523353864”,“51894946558194497849”,“312146856355058999”,“1446540312147944701791”,“45607096417611365867”,“88524029440340999”,“102891096343618010700”,“627063540100766998”,“4209935711634520943752”,“749589843397182180819”,“206916539301484352398”,“470305811624013187631”,“1499182339444591720638”,“17518796583164612949”,“1161324263487464996”,“21801095643695543936”,“15585278519683025954”,“1559908217369381314462”,“296467224187643486137”,“604607685817508998”,“2509060747650830992”,“12682379119475042963”,“8203084241089319976”,“4674806911877453986”,“1249229798919724244365”,“1225129290143219996”,“9331915936726349972”,“3566341257995636989”,“19492395046725941943”,“124741992723182999”,“63597037454075069814”,“692181164902688502986”,“66930669376064999”,“180904769943708095473”,“4936176207633428985”,“85315685210056718751”,“1002007699760429997”,“4732790621549165986”,“62480309641932104818”,“3213414318003810218651”,“1824714398948462994”,“494589690519569071561”,“75561454460680847780”,“1893386962219697994”,“34492885940809394899”,“52483305872795489847”,“142099104160628999”,“12226315437018737964”,“294715298113157096142”,“2945638514965904991”,“1439725332315891550811”,“80527268684691080765”,“309786383806483616098”,“16811340203165210951”,“846445430359880997”,“1514268956015713057594”,“40224308067095822882”,“1987526039464052994”,“1206800648963196008489”,“1470513651509871139722”,“554186031218613979387”,“192055972072554017441”]0x2f601acf7644466e0681c7692f48badb486b92c59f372fe2ef98966efcd01f5f
0x47d74516b33ed5d70dde7119a40839f6fcc24e57false1746057600622[“0xc374f7ec85f8c7de3207a10bb1978ba104bda3b2”,“0xb162b764044697cf03617c2efbcb1f42e31e4766”,“0xbe8549a20257917a0a9ef8911daf18190a8842a4”,“0xbba9baaa6b3107182147a12177e0f1ec46b8b072”,“0x34280882267ffa6383b363e278b027be083bbe3b”,“0x1c71752a6c10d66375702aafad4b6d20393702cf”,“0x523f9441853467477b4dde653c554942f8e17162”,“0x925cd38a68993819eef0138a463308c840080f17”,“0x85667e484a32d884010cf16427d90049ccf46e97”,“0xfd482179ddee989c45eab19991852f80ff31457a”,“0xf4cf59259d007a96c641b41621ab52c93b9691b1”,“0x2bf616c236d1abd31ff105247a774e6e738b5f4e”,“0xbdb8f9729d3194f75fd1a3d9bc4ffe0dde3a404c”,“0x8539b41ca14148d1f7400d399723827a80579414”,“0x2d8f5997af9bc7ae4047287425355518ef01fcfc”,“0x8e1c2be682b0d3d8f8ee32024455a34cc724cf08”,“0x4339ffe2b7592dc783ed13cce310531ab366deac”,“0x06e705bdcbd4a9f9bc8d5fccb7841edada77d8a1”,“0xe4af6375f4424b61b91a1e96b9de6ff8e842aa3a”,“0x35a18cd59a214c9e797e14b1191b700eea251f6a”,“0x048680f64d6dff1748ba6d9a01f578433787e24b”,“0x58612beb0e8a126735b19bb222cbc7fc2c162d2a”,“0x928e2e42f3b21c9af0e0454d7bb3884e5d36e1be”,“0x09fa04aac9c6d1c6131352ee950cd67ecc6d4fb9”,“0xe45d2ce15abba3c67b9ff1e7a69225c855d3da82”,“0x931f7ea0c31c14914a452d341bc5cb5d996be71d”,“0x0271a803f0d3dec9ccd105a4a4d41e6ee1458765”,“0x86d27c49a6a7a2bc033b5d67a21f93d62894ccb9”,“0xcba3b226ca62e666042cb4a1e6e4681053885f75”,“0x461cd9222e130d1dc0bd79dab4643952430937c1”,“0xda57abf95a7c21eb9df08fbaada182f749f6c62f”,“0x15e434c42ab4c9a62ed7db53baaf9d255ea51e0e”,“0x82d810ededb09614144900f914e75dd76700f19d”,“0x12f6139a5dc6d80990d30a4d45bb86449ff804d8”,“0xfd5cf95e8b886ace955057ca4dc69466e793fbbe”,“0x4d7356369273c6373e6c5074fe540cb070acfe6b”,“0x9bc2fb257e00468fe921635fe5a73271f385d0eb”,“0x9e612ff1902c5feea4fd69eb236375d5299e0ffc”,“0x9b5418ef165e86490edbfbae865e0791b225f037”,“0x9a63fa80b5ddfd3cab23803fdb93ad2c18f3d5aa”,“0xedda7526ec81055f2af99d51d968fc2fbca9ee96”,“0xdfaab89058daca36759aafa80bebbc6dbf4c2e4e”,“0x9df192d13d61609d1852461c4850595e1f56e714”,“0xb6b2cf977c512bcd195b58e2ccfb3fb15535cb19”,“0x88c4f34b86907b7221c0061f7a0bbec9391ea727”,“0x71b2b207bb596508e119b3def876b6bb381f4c2e”,“0xd122517ca17e5dc1d77bad87d0cfdc00e9691ba4”,“0x6fea50057edd8baa63f3d5ffd72953b61917507d”,“0xa77c0de4d26b7c97d1d42abd6733201206122e25”,“0x45f163e583d34b8e276445dd3da9ae077d137d72”,“0x08bf93c8f85977c64069dd34c5da7b1c636e104f”,“0x461bc2ac3f80801bc11b0f20d63b73fef60c8076”,“0xc88ff954d42d3e11d43b62523b3357847c29377c”,“0xab39fb8e28def89e5df77c2788a811d881d7fc8e”,“0xe6723992ec43aa6011457bbbed7d6cd7db1407b6”,“0xcbeed3364912bcee868cfa9cff6fe865c85ea094”,“0x266728b30c98b24de810e3325adc615486988cb2”,“0xd7a432f7962123561a63e60e7396b6ba622651b1”]223852952025-05-01T00:00:23.000Z[“5128767030632717073664”,“4905348892733942227515”,“144277771705054405575”,“2117266036219973117”,“22424755872881003161”,“1377951243721711751810”,“190266178511472575363”,“1588063182049310123”,“11146706131854371760831”,“161623076297945116494”,“54923114423335477842”,“3201400198780293236”,“547987216183001851083”,“5396981061663533642”,“64374651686888529667”,“12742740377027243585”,“10860320972334750455039”,“30117064773061158687”,“17841452992740579274”,“761869307337293823133”,“1990479808592410176998”,“74620163196396369183”,“4048585844953032451317”,“292645257656532172248”,“1939445148412410397601”,“46580018124293946742”,“18115219045620989274”,“754171639315878196640”,“108767179038981846805”,“2642982949585415551”,“5232650678757284597922”,“1426166124517849374”,“9047836728341313079301”,“5140085313186579317”,“1273846584103527425442”,“542400701701353879367”,“1257442096504567530368”,“7945649949604702054”,“1013796620675237691422”,“1811587629202642176532”,“6371272825759939377447”,“152848221119974976355”,“1262435204710241888830”,“3272432476436047086353”,“185335178261052349306”,“1510183576165455794141”,“24934998444280275419”,“97387543266842192764”,“4517644262156875940499”,“6554949273747947914354”,“1733443187852164554967”,“637866569990892292363”,“628645314745847907315”,“12535420641426478421841”,“1347518913520029116685”,“2637678764802254318987”,“446196004294335340372”,“524127090746090861781”]0x5bb8f08cf887ce5d37550f62730bda6c50ea01b59caa06fcc01ed21dfe159522
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderHashSTRINGUnique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
in_orderTypeINT64Enumerated order type classification. Integer identifier representing the specific type of order or limit being executed within the protocol.
in_YTSTRINGContract address of the Yield Token (YT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_netInputFromMakerSTRINGNet input amount received from the order maker in the Pendle limit order execution. Numeric string representation of token quantity in smallest denomination.
in_netOutputToMakerSTRINGNet output amount sent to the order maker in the Pendle limit order execution. Numeric string representation of token quantity in smallest denomination.
in_feeAmountSTRINGFee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
in_notionalVolumeSTRINGTotal trading volume amount for the order execution. Numeric string representation of token quantity in smallest denomination.
in_makerSTRINGAddress of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
in_takerSTRINGAddress of the order taker who filled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
in_YTaddressremovedin_makerin_takerin_tokenlog_indexblock_numberin_feeAmountin_orderHashin_orderTypeblock_timestamptransaction_hashin_notionalVolumein_netOutputToMakerin_netInputFromMaker
0x029d6247adb0a57138c62e3019c92d3dfc9c18400x000000000000c9b3e2c3ec88b1b4c0cd853f4321false0xa14ad7f4c766bd5ca9b79a4a81873b8bcdf57c860x888888888889758f76e7103c6cbf23abbf58f9460x9d39a5de30e57443bff2a8307a4256c8797a34974223028247223826618985431371550x0f5c0f26b07a50f7bb38d8a2ed897b1e7fdea5e626cd9360bd778d1041dba20532025-07-30T00:04:11.000Z0x0839ed05f5c3fac833dd2161f7bb99429fceb9f004914ce96c0cf63302aa0d9b69819486836798089784890124659356809408764838784246689704310579824607
0x029d6247adb0a57138c62e3019c92d3dfc9c18400x000000000000c9b3e2c3ec88b1b4c0cd853f4321false0x45551cbfbff4086b25cf2a47b9c4dee7689ad1b30x888888888889758f76e7103c6cbf23abbf58f9460x9d39a5de30e57443bff2a8307a4256c8797a34974123028247133271926697704636030x88ad7bf927b67437fe5ffe1be4695ae132172971c15afba11c7c1b0e4cc2f0bd32025-07-30T00:04:11.000Z0x0839ed05f5c3fac833dd2161f7bb99429fceb9f004914ce96c0cf63302aa0d9b4157225612379356690553873635082396140864331550155574375870351154146
0x029d6247adb0a57138c62e3019c92d3dfc9c18400x000000000000c9b3e2c3ec88b1b4c0cd853f4321false0xddfe28a541c46807b5b47fd42c14cb2659053fa30x888888888889758f76e7103c6cbf23abbf58f9460x9d39a5de30e57443bff2a8307a4256c8797a349741230282842104569777769361538130xb05c38f621f503fdec14f22382f3ddf268ba5c08b11ec4e7b28d4ec36562d23732025-07-30T00:11:35.000Z0x7cfea46c928c4fe65ea4d53e7d17bd3014ceca7309594dedd2679e88bfa578a565654938550657805549305411856325446808822873843792375802291508310949699
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_marketSTRINGTrading pair or market identifier specifying the assets being traded or operated on.
in_PTSTRINGContract address of the Principal Token (PT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_scalarRootSTRINGScalar root parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
in_initialAnchorSTRINGInitial anchor parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
in_PTaddressremovedin_marketlog_indexblock_numberin_scalarRootblock_timestampin_initialAnchortransaction_hash
0xcf44e8402a99db82d2acccc4d9354657be2121db0x27b1dacd74688af24a64bd3c9c1b143118740784false0x54e28e62ea9e8d755dc6e74674eabe2abfdb004e4816032229314000000000000000002022-11-23T10:54:47.000Z10204800000000000000x952d4c25142e16032afd36d6be525aeed374517ec0942a7e879221db6ef3e032
0x5fe30ac5cb1abb0e44cdffb2916c254aeb3686500x27b1dacd74688af24a64bd3c9c1b143118740784false0x7b246b8dbc2a640bf2d8221890cee8327fc239174216032202278000000000000000002022-11-23T10:49:23.000Z10106999990000000000x6edb7e8dd09fa0e9ccd4b7195d514d51e03d91e9c05147fac6e458cc6b63bf01
0xb3b61d1587c05eadec579b616c45939f194357030x27b1dacd74688af24a64bd3c9c1b143118740784false0x9ec4c502d989f04ffa9312c9d6e3f872ec91a0f92616032230219000000000000000002022-11-23T10:54:59.000Z10354000000000000000xfe295c65219ed4a44224bef82c8c7da3f0bebb1198c97a204d1c1b41944126a7
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_marketSTRINGTrading pair or market identifier specifying the assets being traded or operated on.
in_PTSTRINGContract address of the Principal Token (PT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_scalarRootSTRINGScalar root parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
in_initialAnchorSTRINGInitial anchor parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
in_lnFeeRateRootSTRINGNatural logarithm of the fee rate root parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
in_PTaddressremovedin_marketlog_indexblock_numberin_scalarRootblock_timestampin_initialAnchorin_lnFeeRateRoottransaction_hash
0xa3ca92a69c6809607837bc3bd6b13e4c1e1e8ae90x6fcf753f2c67b83f7b09746bbc4fa0047b35d050false0x233f5adf236cab22c5dbdd3333a7efd8267d7aee27523036283240850368558077201252025-07-31T03:03:11.000Z103754455061738120795542128048116580x8282901e36264f732c613c7481dcabdfb8a1e4a8e5741d1ced5d935e039e428c
0x12098a5703e4d222e86583e12d71da9608eb01e50x6fcf753f2c67b83f7b09746bbc4fa0047b35d050false0x03c938b574df34477257aff30a7940a23a1064db25222675677178832556231787861502025-06-10T17:32:11.000Z1079114685813901812119285708652738010x7f48551a3c687d4043fb6eebbf6187d28c5409825ad2eaad1209f1b276414c73
0x9304037325e7ec5b2e0a9dcdf33c785ee2f5b1790x6fcf753f2c67b83f7b09746bbc4fa0047b35d050false0xd4f6592de90024e541187527d7f1de83f6cb6a52222671750274535670575461857692025-06-10T04:22:23.000Z102473879481361701579681696491768730x639565600842afce0c2449dbbb728e0d5cbb6c1c784ececad301040cd030c8ca
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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 Ethereum, recording new Principal Token (PT) market deployments with their AMM parameters including fee rates, scalar roots, and initial anchor values.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_marketSTRINGTrading pair or market identifier specifying the assets being traded or operated on.
in_PTSTRINGContract address of the Principal Token (PT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_scalarRootSTRINGScalar root parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
in_initialAnchorSTRINGInitial anchor parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
in_lnFeeRateRootSTRINGNatural logarithm of the fee rate root parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
in_PTaddressremovedin_marketlog_indexblock_numberin_scalarRootblock_timestampin_initialAnchorin_lnFeeRateRoottransaction_hash
0xafa002de2dadb57b2b04e32aa4f42a69adebf2fd0x3d75bd20c983edb5fd218a1b7e0024f1056c7a2ffalse0x403829bce022844f66cdb2911d2260526d4eb8433452039511357681981810000000002024-07-27T03:11:11.000Z110227452800000000029955089790000000x458db49bf4423b7f2728a58333a8fd138bb59963a870b81d1501e481884e21ac
0x96056fc19b633a662fe0366c8cdd38c371407de40x3d75bd20c983edb5fd218a1b7e0024f1056c7a2ffalse0xb9e8bb1105382b018c6adfd95fd9272542cc17761972036087389347636810000000002024-07-22T08:27:35.000Z104716247100000000029955089790000000x8d036eb45eae0ce6dba13bacc90ef5c21466769c5ba31b30fdfa9977c05e92a9
0x7fb0d250d4768e8590cb3c459549c7e33481511e0x3d75bd20c983edb5fd218a1b7e0024f1056c7a2ffalse0x901e710c2f634131b36e3c68b072ed5db9250f3e17520360393163315676890000000002024-07-22T06:50:47.000Z10258019030000000009995003330000000xe9924156186b11c8d74bd2664b1bd6af399a94d00fbcde2fa7f450437963697f
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_marketSTRINGTrading pair or market identifier specifying the assets being traded or operated on.
in_PTSTRINGContract address of the Principal Token (PT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_scalarRootSTRINGScalar root parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
in_initialAnchorSTRINGInitial anchor parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
in_lnFeeRateRootSTRINGNatural logarithm of the fee rate root parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
in_PTaddressremovedin_marketlog_indexblock_numberin_scalarRootblock_timestampin_initialAnchorin_lnFeeRateRoottransaction_hash
0x711214da1a94f478b96c1ca3d14a750f496f2a800x6fcf753f2c67b83f7b09746bbc4fa0047b35d050false0x50700eedde7850b4bf83733c66b272c6ca46c66315922968938225402937436692523562025-07-21T17:04:23.000Z1033913612044563983111377444104559250x44978235f34ef05b0eabf021121b9d10f825fca4085e762798291bd30fc144fb
0xcc31d0c049eb8bc29a265eb81b25c89325f2f78f0x6fcf753f2c67b83f7b09746bbc4fa0047b35d050false0xbdf3ea4673116698219c08a9ad6b51e4e68d22ab4222967381197100720298738766272025-07-21T11:50:47.000Z1044221887915886338119285708652738010xeefbb1afdb31e90406826109c38205b83c53278108c40f5e05bee91b88634fa8
0x5f2f6324aa5590e408ba892e39cec4c0afb160680x6fcf753f2c67b83f7b09746bbc4fa0047b35d050false0x2353193fa14a6477a4523e2c078e4063022fcf6616622669624190028617070760976932025-06-09T21:12:59.000Z1036576577941463641119285708652738010x08dcb599bd14111f94b962c17e8297c950a0c91bce0e3ec48bfe9226a903feaa
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_marketSTRINGTrading pair or market identifier specifying the assets being traded or operated on.
in_PTSTRINGContract address of the Principal Token (PT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_scalarRootSTRINGScalar root parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
in_initialAnchorSTRINGInitial anchor parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
in_lnFeeRateRootSTRINGNatural logarithm of the fee rate root parameter for the Pendle AMM market. String-encoded integer with 18 decimal precision.
in_PTaddressremovedin_marketlog_indexblock_numberin_scalarRootblock_timestampin_initialAnchorin_lnFeeRateRoottransaction_hash
0x29fd7180e5cced14ad148c7997e6b6857a8be86e0x6d247b1c044fa1e22e6b04fa9f71baf99eb29a9ffalse0xfe220a7c2f029a5566ae92bc201f6165b93b4c0522423894442219265017659185084102025-11-28T03:16:47.000Z1053984970246290959107420965319021080xa25db91425efc9573600c1e7d93ed251f5d4bef3b75523a04a063ed15066fdca
0xff10bff4d6e788d511d7b7e657259ae493d996190x6d247b1c044fa1e22e6b04fa9f71baf99eb29a9ffalse0xf5cacfd722bffd141ef8f1d1e4270b8fb2db513640523894733157961762520928151052025-11-28T04:15:59.000Z1035085611410370802158733491562901490xd2cad3f974200447ca959d04accf07130bc1769489d3c234661132743a199e36
0x54bf2659b5cdfd86b75920e93c0844c0364f51660x6d247b1c044fa1e22e6b04fa9f71baf99eb29a9ffalse0x6d8c4de7071d5aee27fc3a810764e62a4a00ceb955723898050154951269537425042952025-11-28T15:25:11.000Z1055456389725145966158733491562901490xd2783d0229c71b1752d19db789c1a64986eb64680d66571c4991d4d491025dfb
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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 Ethereum, recording LP token mints with amounts of Principal Token (PT) and Standardized Yield (SY) deposited. Used for analyzing liquidity provider behavior and pool composition changes in Pendle’s yield trading markets.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_netLpMintedSTRINGNet amount of liquidity provider (LP) tokens minted in the transaction. String-encoded integer representing the token quantity in its smallest unit.
in_netSyUsedSTRINGNet amount of Standardized Yield (SY) tokens consumed in the mint operation. String-encoded integer representing the token quantity in its smallest unit.
in_netPtUsedSTRINGNet amount of Principal Token (PT) consumed in the mint operation. String-encoded integer representing the token quantity in its smallest unit.
addressremovedlog_indexin_receiverblock_numberin_netPtUsedin_netSyUsedin_netLpMintedblock_timestamptransaction_hash
0xc374f7ec85f8c7de3207a10bb1978ba104bda3b2false3290x8d6ce71ab8c98299c1956247ca9aaec080dd2df32277137426588804767829240139275645636522226849537373157570172025-06-24T02:42:35.000Z0xe7246eee7c92fc0623765077fd0ec32f8af1f0e75174afa5cfdd707af6d2c40f
0xc374f7ec85f8c7de3207a10bb1978ba104bda3b2false3160x66724d2b840d70136bbdb528f084584b58ebbc8522774815683099209549879611357837904433973450821826802221314637362025-06-24T14:13:47.000Z0x698144889e902020e2ac23c9485b97595c9ed1104b48d0a04d72e1080e4f5671
0xc374f7ec85f8c7de3207a10bb1978ba104bda3b2false4450x0c94548fd03dd355af3d170dea9a802ceff502d3227728751356879959197932957107943829825052374335585533321596422025-06-24T07:44:11.000Z0x36576269d1d6caaf285acacf405216ea3873aa6222dc859b3e14ac9517423cc9
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_netPtOutSTRINGNet 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_netSyOutSTRINGNet 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_netSyFeeSTRINGAmount of Standardized Yield (SY) token collected as protocol fee from the swap transaction. Numeric string representing token amount in smallest denomination.
in_netSyToReserveSTRINGAmount of Standardized Yield (SY) token allocated to the protocol reserve from the swap transaction. Numeric string representing token amount in smallest denomination.
addressremovedin_callerlog_indexin_netPtOutin_netSyFeein_netSyOutin_receiverblock_numberblock_timestamptransaction_hashin_netSyToReserve
0x0e1c5509b503358ea1dac119c1d413e28cc4b303false0x888888888889758f76e7103c6cbf23abbf58f94613432431964776782808775675026750530-2975879016969618700x3199c7c3c972a8da5f9fad2a838383f827b735f1201527912024-06-23T07:04:35.000Z0x5ff684b5c236559af1bbe9b3a7f90747d25b17657fcf2c77668261f55a8ac3ed60540021400423
0x0e1c5509b503358ea1dac119c1d413e28cc4b303false0x888888888889758f76e7103c6cbf23abbf58f9466113577488153903070018834751377111628-32825797460011644780x3199c7c3c972a8da5f9fad2a838383f827b735f1201527772024-06-23T07:01:47.000Z0x2db2becd132652b5c6075fc15d21228b33b94256b8ebebf5b6697e7fbba9b7a8667801101689302
0x0e1c5509b503358ea1dac119c1d413e28cc4b303false0x888888888889758f76e7103c6cbf23abbf58f946180-7660795258092029178668557692170258226505323670xaa68ca9c69a4ff22203ce189ce4448d7401875e8201530862024-06-23T08:04:11.000Z0xaddf15988bdbe77ff849b1ccde5c9a95c9f4517779b0e24da3f83f02364815eb1429348461536
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.MarketV2_Swap_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_netPtOutSTRINGNet 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_netSyOutSTRINGNet 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_netSyFeeSTRINGAmount of Standardized Yield (SY) token collected as protocol fee from the swap transaction. Numeric string representing token amount in smallest denomination.
in_netSyToReserveSTRINGAmount of Standardized Yield (SY) token allocated to the protocol reserve from the swap transaction. Numeric string representing token amount in smallest denomination.
addressremovedin_callerlog_indexin_netPtOutin_netSyFeein_netSyOutin_receiverblock_numberblock_timestamptransaction_hashin_netSyToReserve
0xe4daf4354a2028442946356dd6a49977d89646cdfalse0x888888888889758f76e7103c6cbf23abbf58f946340598453176-5876510x00000082bc916568cb4479d3a218dafa60ebba25237312602025-11-05T06:17:59.000Z0xe915086dc9b6e8497f67cf2fd912016044657ed481f2bae7874a016f4ad69917140
0x56649da435f9a9a57ee9c4c06b728e4ba84fcc6bfalse0x00000f91109c4d0007e90000d9facad5298a0cac192-4558041486594947419315843279429469358153020x00000f91109c4d0007e90000d9facad5298a0cac237324712025-11-05T10:21:35.000Z0x06511bd01f746adecba4475c06e05359a049fe70fdde8eaf33b9d30dee3af4213892179378701801
0x56649da435f9a9a57ee9c4c06b728e4ba84fcc6bfalse0x888888888889758f76e7103c6cbf23abbf58f94618350837543161054735162577057899-48336020036262540795360x00000f91109c4d0007e90000d9facad5298a0cac237324712025-11-05T10:21:35.000Z0x06511bd01f746adecba4475c06e05359a049fe70fdde8eaf33b9d30dee3af421843787743261211168
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.MarketV3_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MarketV4_Swap_event

Swap events from Pendle V1 markets on Ethereum, recording exchanges between Principal Tokens (PT) and Standardized Yield (SY) tokens with amounts, fees, and reserve movements. Used for analyzing Pendle market liquidity, trading patterns, and yield token price discovery.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_netPtOutSTRINGNet 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_netSyOutSTRINGNet 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_netSyFeeSTRINGAmount of Standardized Yield (SY) token collected as protocol fee from the swap transaction. Numeric string representing token amount in smallest denomination.
in_netSyToReserveSTRINGAmount of Standardized Yield (SY) token allocated to the protocol reserve from the swap transaction. Numeric string representing token amount in smallest denomination.
addressremovedin_callerlog_indexin_netPtOutin_netSyFeein_netSyOutin_receiverblock_numberblock_timestamptransaction_hashin_netSyToReserve
0x8a49f2ac2730ba15ab7ea832edac7f6ba22289f8false0x888888888889758f76e7103c6cbf23abbf58f946307313218279985523261192773399220995290706092-307541522225622494664750x2d876806411a36407350a626bf42d62c82b7d005211939162024-11-15T15:13:47.000Z0xf7aa9ee526fcb01c95bba45ad52a1f60e7ea89875bdfc423abd967fc3ec1ff3d2719376796232564873
0x8a49f2ac2730ba15ab7ea832edac7f6ba22289f8false0x888888888889758f76e7103c6cbf23abbf58f94686711622549423496182860823212748804914233820852-1140394712663619216222840x513b1b01e1c716846466406b4e4ce39e67bb0609211906122024-11-15T04:08:59.000Z0xb061501a5e06f4745c4b2227da249f3ce3d86b523701c313d7fb22cc08be78d410199043931387056681
0x8a49f2ac2730ba15ab7ea832edac7f6ba22289f8false0x888888888889758f76e7103c6cbf23abbf58f946160-546599287489414143876495923819515570377148537706339867343173969480x5d8b3cd632c58d5ce75c2141c1c8b3b0c209b3ed211948902024-11-15T18:29:47.000Z0xba6c7c0332aedd12bd300993d93361f3aa740eec2a75009366ce861be292017a4739055612456301718
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.MarketV4_Swap_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_netPtOutSTRINGNet 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_netSyOutSTRINGNet 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_netSyFeeSTRINGAmount of Standardized Yield (SY) token collected as protocol fee from the swap transaction. Numeric string representing token amount in smallest denomination.
in_netSyToReserveSTRINGAmount of Standardized Yield (SY) token allocated to the protocol reserve from the swap transaction. Numeric string representing token amount in smallest denomination.
addressremovedin_callerlog_indexin_netPtOutin_netSyFeein_netSyOutin_receiverblock_numberblock_timestamptransaction_hashin_netSyToReserve
0xcdd26eb5eb2ce0f203a84553853667ae69ca29cefalse0x888888888889758f76e7103c6cbf23abbf58f946190615331273537546527938259818468659946339-5248202886340873392760x03389449e4b17bb025eeeb2454d92a3ed505f8c2208394322024-09-27T04:00:59.000Z0x78aad171d852091b2d9c8dca97692cba462cc406aa99ea6222d4f3ab4271e5ed207854774927957071
0xff694cc3f74e080637008b3792a9d7760cb456cafalse0x888888888889758f76e7103c6cbf23abbf58f946400166028038803902445103844707136962444-156616844833156257570x0481405dd8a41bdf57b541c4d6190c536a525719208406882024-09-27T08:12:47.000Z0xb3d879b3462368f8b639078d80ad7cbf8230b2533e6429a8e1c2d773b7e8cef93075765709569955
0x84a50177a84dad50fdbf665dfbfb39914b52dff2false0x888888888889758f76e7103c6cbf23abbf58f94676203021125874095470864800135847444301-196376106658862936700x04e0f180471e66990d08a0795488861eaf9842a6208434342024-09-27T17:24:35.000Z0xa97699c65491c3763061aa2441ea8553faf5e2c5d9a068e81cec5c32e233fcfa3840108677955440
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_receiverSySTRINGAddress of the recipient receiving Standardized Yield (SY) tokens from the burn operation. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverPtSTRINGAddress of the recipient receiving Principal Tokens (PT) from the burn operation. Hex-encoded, 0x-prefixed, 42-character string.
in_netLpBurnedSTRINGAmount of Liquidity Provider (LP) tokens burned in the liquidity removal operation. Numeric string representation of the token amount in smallest unit.
in_netSyOutSTRINGNet 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_netPtOutSTRINGNet 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.
addressremovedlog_indexin_netPtOutin_netSyOutblock_numberin_receiverPtin_receiverSyin_netLpBurnedblock_timestamptransaction_hash
0x40bcb355623ad5b82709a3fd0d49af2207eb19e5false487749322388741026079947510458994782637809591998237899940x40bcb355623ad5b82709a3fd0d49af2207eb19e50x5ee9157192b4090c1cb40f50a825cd2c1d16269a86578402362288944539872025-11-13T11:29:47.000Z0xa64d4e683a849882052ac8551040774dc4b65872deb234f08f04537b6220d71e
0xcd9573442af27a2d050dc6ee199a6b2f98354907false5028537000935921838392017198704926245232027641163238691290xcd9573442af27a2d050dc6ee199a6b2f983549070x20b59becded839835a3ba58629430375dae02720772354425988668275800622025-11-24T13:51:47.000Z0x02969926f5dfe2700d181550b6b1d9797c129caf656297ad0f337623ff0aae2e
0xcd9573442af27a2d050dc6ee199a6b2f98354907false558616894854549257901886003051864833294862636238670640xcd9573442af27a2d050dc6ee199a6b2f983549070x20b59becded839835a3ba58629430375dae0272023332092369342544784822025-11-24T06:53:47.000Z0x524f4ca5dd4c8bb7342b46251eddc78c577f276febc896f4ef6d15037a26ecc9
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_netLpMintedSTRINGNet amount of liquidity provider (LP) tokens minted in the transaction. String-encoded integer representing the token quantity in its smallest unit.
in_netSyUsedSTRINGNet amount of Standardized Yield (SY) tokens consumed in the mint operation. String-encoded integer representing the token quantity in its smallest unit.
in_netPtUsedSTRINGNet amount of Principal Token (PT) consumed in the mint operation. String-encoded integer representing the token quantity in its smallest unit.
addressremovedlog_indexin_receiverblock_numberin_netPtUsedin_netSyUsedin_netLpMintedblock_timestamptransaction_hash
0x13333e7caf39a9f9203852e0817d923a3c2f549afalse7290xc2c53b1b9c4ecdced7c545795a9cfa3f7912baec2394970440293231667538603836141712081657577608677902184231076458700352025-12-05T22:31:11.000Z0x14d98dec6bce91bc418670a5110fdc3734df84f1b86d29ce89edaf3924e4786f
0x3d39e4d42b3f6b493ee52ad5a0d8cb222f03f152false1100x06047e077f36491b6265827765cba180b84284b8239463881394869567549520995441364778668234155512292923092966636241151380112025-12-05T11:14:47.000Z0x86ded4056691b2d6d4082d76f1fa3405134c2e63d8e6a0586f1dd1e86d4a3371
0x3d39e4d42b3f6b493ee52ad5a0d8cb222f03f152false11430x4446d86a5c2a8a0e3e3b5d1780b6151cafa334f923949335686340026153849036652409510469733546810261419033334174746817362025-12-05T21:14:59.000Z0xa834c420861ac28eea2095120ec59e2ec204f1fa6212d88f630fc8187e186bf4
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_netPtOutSTRINGNet 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_netSyOutSTRINGNet 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_netSyFeeSTRINGAmount of Standardized Yield (SY) token collected as protocol fee from the swap transaction. Numeric string representing token amount in smallest denomination.
in_netSyToReserveSTRINGAmount of Standardized Yield (SY) token allocated to the protocol reserve from the swap transaction. Numeric string representing token amount in smallest denomination.
addressremovedin_callerlog_indexin_netPtOutin_netSyFeein_netSyOutin_receiverblock_numberblock_timestamptransaction_hashin_netSyToReserve
0xd3ed08461881b961fd5f2997908401cad42b60cffalse0x888888888889758f76e7103c6cbf23abbf58f946472-4006221296058587573468248623327237581357237728962686246722586310x149f533f3a99c2762fde8ceb58cfcadb283f0b5b237846052025-11-12T17:22:23.000Z0x7c3c6152fa376865fb086e06a3e156b67af9545a5960ba02214f914eff2656121988986617900650857
0xd3ed08461881b961fd5f2997908401cad42b60cffalse0x888888888889758f76e7103c6cbf23abbf58f9464952274431821334768634718814136211640568563652-214618063851781304472830xc8f6c5cb17ff43dcc2592fefd3eeb95d6d4018e1237844862025-11-12T16:58:23.000Z0x7e9f7057514436e7fd1d2d5b7e5e86fe42f14243a7cecdc37a801affcee1b84a11308969312454850921
0xd3ed08461881b961fd5f2997908401cad42b60cffalse0x888888888889758f76e7103c6cbf23abbf58f94650164956459376712042751684025871056902261328-61051281224119598965920xd3ed08461881b961fd5f2997908401cad42b60cf237837932025-11-12T14:38:59.000Z0x6fd22d239991ee9b29a4872a81563cf0db1f79b037376af6adc36eecc4c7d9ce3220696845521809062
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_timestampSTRINGUnix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
in_lnLastImpliedRateSTRINGNatural logarithm of the last implied interest rate in the Pendle market. Numeric string representation of a fixed-point decimal value.
addressremovedlog_indexblock_numberin_timestampblock_timestamptransaction_hashin_lnLastImpliedRate
0x40bcb355623ad5b82709a3fd0d49af2207eb19e5false4982380701817632390552025-11-15T20:37:35.000Z0xda2c07cb4cc72cfb0d77f27df212f804743a777a84f8e754300b0df408b48a64168317132756902165
0x40bcb355623ad5b82709a3fd0d49af2207eb19e5false5232380705817632395352025-11-15T20:45:35.000Z0x9dece7210b9688a54c4557834371e6cc75038da7765836aa3ce65c15e0c15a5c169946015371536915
0x40bcb355623ad5b82709a3fd0d49af2207eb19e5false4012380706217632395832025-11-15T20:46:23.000Z0xf5102f252875dbcc053e27bc00cbbf74e0eba5d69c0e26e968664c5dac55b4fb168388219426120936
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.MarketV6_UpdateImpliedRate_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PendleMarket_Swap_event

Swap event records from Pendle V1 protocol markets on Ethereum, capturing PT (Principal Token) and SY (Standardized Yield) token exchanges with net amounts, fees, and reserve transfers. Used for analyzing yield trading activity, pricing dynamics, and liquidity provider fee generation across Pendle fixed-yield markets.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_netPtOutSTRINGNet 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_netSyOutSTRINGNet 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_netSyFeeSTRINGAmount of Standardized Yield (SY) token collected as protocol fee from the swap transaction. Numeric string representing token amount in smallest denomination.
in_netSyToReserveSTRINGAmount of Standardized Yield (SY) token allocated to the protocol reserve from the swap transaction. Numeric string representing token amount in smallest denomination.
addressremovedin_callerlog_indexin_netPtOutin_netSyFeein_netSyOutin_receiverblock_numberblock_timestamptransaction_hashin_netSyToReserve
0xc374f7ec85f8c7de3207a10bb1978ba104bda3b2false0x42c31b4ada1963b5235737901264a61a6920ce5d284469967998312019165321225192-3831028379940920x42c31b4ada1963b5235737901264a61a6920ce5d218326592025-02-12T20:01:59.000Z0xcc60452e6442da3fb7782dc8ddda16bce96ee2b7b37b4a3414be1fec14ac185a132256980153
0xc374f7ec85f8c7de3207a10bb1978ba104bda3b2false0x42c31b4ada1963b5235737901264a61a6920ce5d842064001631799578726158184454-16820775114334830x42c31b4ada1963b5235737901264a61a6920ce5d218317642025-02-12T17:02:11.000Z0x777ded4e200e8a929882bdbb0ae20ca2b833f1e8eb43bac0da416c239fd87dd4580926547563
0xc374f7ec85f8c7de3207a10bb1978ba104bda3b2false0x42c31b4ada1963b5235737901264a61a6920ce5d4129031382827324154538956818959-105182241697894100x42c31b4ada1963b5235737901264a61a6920ce5d218326572025-02-12T20:01:35.000Z0xaba43d5e937ecbdbcfbc2d42a18c8769d8dd8ab6c603750df0784f378f8f4ffa3631165455167
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.PendleMarket_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SYApe_Deposit_event

Deposit events for ApeCoin (APE) into Pendle V1’s Standardized Yield (SY) wrapper on Ethereum, recording caller, receiver, input token amounts, and minted SY tokens. Used for tracking liquidity provisioning and yield tokenization activity in Pendle’s APE markets.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0x47ba20283be4d72d4afb1862994f4203551539c5false0xd30a0b15dc529a8a6b76d8df191e86ab5e39fe4d2160x4d224452801aced8b2f0aebe155379bb5d5943810xd30a0b15dc529a8a6b76d8df191e86ab5e39fe4d1998000823449922210048526941292024-05-30T03:34:11.000Z0x9f16ef0b0e46cb958bd89358aebc53c4efed98091b5d9987c91ff7234b10c7c54268997090000000000000
0x47ba20283be4d72d4afb1862994f4203551539c5false0x0000000001e4ef00d069e71d6ba041b0a16f7ea02880x4d224452801aced8b2f0aebe155379bb5d5943810x9a76925dd91a7561b58d8353f0bce4df1e517abb1756638431959028111652555547162023-06-26T21:53:23.000Z0x3b70d01908975b443ebf18a0c7e4df6df0c92ac38ba384bd4f474b3d2bd2325b4817890000000000000000
0x47ba20283be4d72d4afb1862994f4203551539c5false0x51ccfaf507ece544313f7edf12ca8e5f960e021f730x4d224452801aced8b2f0aebe155379bb5d5943810x51ccfaf507ece544313f7edf12ca8e5f960e021f16210461757560962537777356472022-12-18T08:44:47.000Z0x1c3e94d6003158ac9012382e7a06d8815cfb8be3f3706de0c7d1296e797b139877735810862321300300
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.SYApe_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SYAuraBbAWethSweth_Deposit_event

Deposit events for Pendle’s Standardized Yield (SY) token wrapper for Aura’s Balancer boosted Aura-bb-a-WETH-swETH pool on Ethereum. Tracks token deposits with caller, receiver, input token address, deposited amounts, and resulting SY token output for analyzing yield tokenization flows.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0xcb611d0bd02a74c491b75d51d6ea5558f1887da3false0x0000000001e4ef00d069e71d6ba041b0a16f7ea02530xf951e335afb289353dc249e82926178eac7ded780x8225dd26ddfaaa321e5388e0f4c090ba16217c211777034811854494117639477442023-07-25T13:16:35.000Z0x066ecee5a8176c8a04b85f70ff678f690f1e5d41379f61d209a18e9f455b5ca71163932448274218727
0xcb611d0bd02a74c491b75d51d6ea5558f1887da3false0x0000000001e4ef00d069e71d6ba041b0a16f7ea0800xf951e335afb289353dc249e82926178eac7ded780x8225dd26ddfaaa321e5388e0f4c090ba16217c2117768235296292243357488316132023-07-25T06:09:59.000Z0xd7822e1e70e39a2041fadb88af7c384afbefd136bebfa3841b2cb87071df59d329092371352930266449
0xcb611d0bd02a74c491b75d51d6ea5558f1887da3false0x0000000001e4ef00d069e71d6ba041b0a16f7ea02480xf951e335afb289353dc249e82926178eac7ded780x8225dd26ddfaaa321e5388e0f4c090ba16217c21177678342469615406486438212023-07-25T04:49:11.000Z0xdeb25266d93a0d135b4ecb3e373e65006befaae3624623f149a1806885a8e923242485926723795568
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.SYAuraBbAWethSweth_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SYAuraWethAnkrEth_Deposit_event

Deposit events from Pendle V1’s Standardized Yield (SY) token wrapper for Aura WETH-ankrETH liquidity pool positions on Ethereum. Tracks deposits of underlying tokens (WETH, ankrETH, Aura LP tokens) and minted SY token amounts for analyzing yield tokenization activity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0x7f531a70a240fba0e40169e56eede1c6b7ef8463false0x81c6d7fb1dfd8fc785134c352afc94ae0849c6b81740x8a34b5ad76f528bfec06c80d85ef3b53da7fc3000x81c6d7fb1dfd8fc785134c352afc94ae0849c6b817115840122159575147676157772023-04-24T11:26:23.000Z0xf816c0a2478570675283e0f88c5052eb5bcc8ea1a916954423532fb2b42adbb212215957514767615777
0x7f531a70a240fba0e40169e56eede1c6b7ef8463false0x0000000001e4ef00d069e71d6ba041b0a16f7ea01250x8a34b5ad76f528bfec06c80d85ef3b53da7fc3000xabc8ae339e3f560bf700a3f6ee85ee719979762b17243608164372726651190615332023-05-12T10:42:35.000Z0x81f6867b1936d6435f6069c7073fd0b3152819700e27eb6229c8f6fdf59daf1616437272665119061533
0x7f531a70a240fba0e40169e56eede1c6b7ef8463false0x0000000001e4ef00d069e71d6ba041b0a16f7ea01780x8a34b5ad76f528bfec06c80d85ef3b53da7fc3000xabc8ae339e3f560bf700a3f6ee85ee719979762b17243681240626728310681267132023-05-12T10:57:11.000Z0xe5cda93d786ddd233fa6d9feeea1ff223b01e5d2768d3746708a4799b6adcb7124062672831068126713
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.SYAuraWethAnkrEth_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SYAuraWethRocketEth_Deposit_event

Deposit events for Pendle V1’s Standardized Yield (SY) token wrapping Aura’s WETH-rocketETH LP position on Ethereum. Tracks user deposits of underlying tokens (WETH, rETH, or ETH) and corresponding SY token minting for yield tokenization analysis.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0xc0dd85720e3bc7959890127b5d3af2d29f6c74f4false0x0000000001e4ef00d069e71d6ba041b0a16f7ea06270x1e19cf2d73a72ef1332c882f20534b6519be02760x0000000001e4ef00d069e71d6ba041b0a16f7ea0171408871021485157671963772712023-04-27T23:51:35.000Z0xe042326b3e624bd269656ed540f5b6cdf2156ae4ca24725afb3866b6b2405777102148515767196377271
0xc0dd85720e3bc7959890127b5d3af2d29f6c74f4false0x0000000001e4ef00d069e71d6ba041b0a16f7ea02770xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20x0000000001e4ef00d069e71d6ba041b0a16f7ea0171353041134928066681284007732023-04-27T05:00:11.000Z0xee47bae3406c51bc1eaddd4b89434ead642d4380d2e9b1f8e5e6303992a94990116000000000000000000
0xc0dd85720e3bc7959890127b5d3af2d29f6c74f4false0x0000000001e4ef00d069e71d6ba041b0a16f7ea0760xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20x0000000001e4ef00d069e71d6ba041b0a16f7ea0171373592445612340520847942512023-04-27T11:57:35.000Z0x09053ff9c8da41d6df0979e8f037a698e45be8059c96ce925ed4deaacf8aae07250000000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.SYAuraWethRocketEth_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SYAuraWethStafiEth_Deposit_event

Deposit events for Pendle V1’s Standardized Yield (SY) token wrapping Aura WETH-StaFiETH liquidity provider tokens on Ethereum. Records token conversions showing input token addresses, deposited amounts, and resulting SY token outputs for tracking yield tokenization activity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0x677885afde857b70f40741ff8b60f9afba95dd49false0x0000000001e4ef00d069e71d6ba041b0a16f7ea02950x9559aaa82d9649c7a7b220e7c461d2e74c9a35930xd1434df1e2ad0cb7b3701a751d01981c7cf2dd6217581950957038127020542880232023-06-29T02:21:11.000Z0x3e9ecba511a9e27cd4e48a5370ebba7fba71bbe7417cf03c6710e5e871efdc7891627226740915015138
0x677885afde857b70f40741ff8b60f9afba95dd49false0x0000000001e4ef00d069e71d6ba041b0a16f7ea01330x00000000000000000000000000000000000000000xd1434df1e2ad0cb7b3701a751d01981c7cf2dd6217631905189914328539871696432023-07-06T02:41:59.000Z0x77bbf28a1301f0f7fa36354a6b6473ea17b71d00ffe2c9b2f6ed4ab92277297519000000000000000000
0x677885afde857b70f40741ff8b60f9afba95dd49false0x0000000001e4ef00d069e71d6ba041b0a16f7ea0840x00000000000000000000000000000000000000000xd1434df1e2ad0cb7b3701a751d01981c7cf2dd62183942421075110443835837797942023-10-20T21:33:11.000Z0xde8f0ec605807c8f22732331ee55a09b31540bfca3db8cec06a542ec87672464108964961420226794625
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.SYAuraWethStafiEth_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SYCurveFraxUsdc_Deposit_event

Deposit events from Pendle V1’s Standardized Yield (SY) token wrapper for Curve’s FRAX-USDC pool on Ethereum, tracking conversions of underlying assets into SY tokens. Records input token addresses, deposit amounts, and resulting SY token output for analyzing yield tokenization activity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0xd393d1ddd6b8811a86d925f5e14014282581bc04false0x00000000005bbb0ef59571e58418f9a4357b68a06550xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb480x58d4bc4f5079cbe9095faa9051bae01811521975196685691640491155979745484892024-04-16T14:14:23.000Z0x621cdd564ad3a8042c36070a5a4b3f57182f32bba578253af2fb8e984bfe104f164299937
0xd393d1ddd6b8811a86d925f5e14014282581bc04false0x41fad93f225b5c1c95f2445a5d7fcb85ba46713f1360x853d955acef822db058eb8505911ed77f175b99e0x7b246b8dbc2a640bf2d8221890cee8327fc239171642569789901986687698103643592023-01-17T09:43:11.000Z0x7d048c9e3932b987485a3c88bc95ea838ed37f202743175322543771b488cb7f9002910279312060568817
0xd393d1ddd6b8811a86d925f5e14014282581bc04false0x0000000001e4ef00d069e71d6ba041b0a16f7ea01320xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb480x7b246b8dbc2a640bf2d8221890cee8327fc23917168325202169615342673883160157542023-03-15T09:50:35.000Z0x6ebbdc2d46c530a526c14670ec7b982eb6906c4039fbff57140c8b0686ee2e5e217201287119
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.SYCurveFraxUsdc_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SYLooks_Deposit_event

Deposit events from Pendle V1’s SYLooks contract on Ethereum, recording when users deposit underlying tokens and receive standardized yield tokens (SY). Used for tracking yield tokenization flows and conversion rates between deposited assets and SY output.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0x35c16314d6ee4753289e5cc15a5c5e1dd4ead345false0x0000000001e4ef00d069e71d6ba041b0a16f7ea02200xf4d2888d29d722226fafa5d9b24f9164c092421e0x44474d98d1484c26e8d296a43a721998731cf775168574762283209643208336972662023-03-18T22:00:35.000Z0x6c6b3a16ad5ede873f270e7ddebad0c68187ea0c0a4741a03c9b4ca88771c88c389881219915010885407
0x35c16314d6ee4753289e5cc15a5c5e1dd4ead345false0x0000000001e4ef00d069e71d6ba041b0a16f7ea03230xf4d2888d29d722226fafa5d9b24f9164c092421e0x44474d98d1484c26e8d296a43a721998731cf775167558999571310836022330012632023-03-04T15:14:23.000Z0x0caedf64d671d773e4dca59e3c97a87278bab7ab73e8006e5c25ccbdae9113d21621004351001789327584
0x35c16314d6ee4753289e5cc15a5c5e1dd4ead345false0x0000000001e4ef00d069e71d6ba041b0a16f7ea03990xf4d2888d29d722226fafa5d9b24f9164c092421e0x44474d98d1484c26e8d296a43a721998731cf7751675456236787304883791770753182023-03-04T10:43:47.000Z0x3cef1c4ce05df2f62bcd56d01092b81a0976c10f4cd18d0d0877d5955c5221ea6229870000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.SYLooks_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SYSfrxEth_Deposit_event

Deposit events for Pendle’s Standardized Yield (SY) token wrapper for Frax staked ETH (sfrxETH) on Ethereum, tracking conversions of ETH or sfrxETH into SY tokens. Used for analyzing yield tokenization activity and liquidity flows into Pendle’s interest rate markets.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0xeb83006b0aaddd15ad8afbebe2f4e0937f210673false0x0000000001e4ef00d069e71d6ba041b0a16f7ea01580x00000000000000000000000000000000000000000xfb8f489df4e04609f4f4e54f586f960818b70041174814559575679205390936372023-06-14T23:32:23.000Z0x919361d606c6fdc2439f1087c9992513c3fa5342a6a140384498471bb2f7eb981000000000000000000
0xeb83006b0aaddd15ad8afbebe2f4e0937f210673false0x0000000001e4ef00d069e71d6ba041b0a16f7ea03150x00000000000000000000000000000000000000000xfb8f489df4e04609f4f4e54f586f960818b700411747819547881174196804212023-06-14T12:31:35.000Z0x872fa5bb42a8e5b1de49ddae537c1a7f9dce702a8fbd240bc9ca0d4d0f4862f15000000000000000
0xeb83006b0aaddd15ad8afbebe2f4e0937f210673false0x0000000001e4ef00d069e71d6ba041b0a16f7ea0320xac3e018457b222d93114458476f3e3416abbe38f0x0000000001e4ef00d069e71d6ba041b0a16f7ea017477843250000000000000000002023-06-14T11:20:23.000Z0x92e3489a50bc0f31d0d2bfbbc394031dc62b6ba69b5e5ae200149abd454041db25000000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.SYSfrxEth_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SYStargateLP_Deposit_event

Deposit events for Pendle V1 Standardized Yield (SY) tokens wrapping Stargate liquidity provider positions on Ethereum. Tracks deposits of underlying tokens into SY wrappers with input amounts, output SY amounts, and recipient addresses for analyzing yield tokenization flows.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0x3025680925349c9c01c0f01cf300ec963832ec64false0x0000000001e4ef00d069e71d6ba041b0a16f7ea02040xdac17f958d2ee523a2206206994597c13d831ec70x30e0dc9a1d33eac83211a1113de238b3ce8269501753617919328922023-06-22T15:55:23.000Z0x196e8d79e68b1007ec562c5228aea5838cb61c858a8629eb2e4d839fa02467981934935
0x3025680925349c9c01c0f01cf300ec963832ec64false0x0000000001e4ef00d069e71d6ba041b0a16f7ea01290xdac17f958d2ee523a2206206994597c13d831ec70x30e0dc9a1d33eac83211a1113de238b3ce826950170439258855903072023-04-14T07:22:11.000Z0x6c4ba2acd1bc71319ebbc893dc841b3214695658eb842b8823a8d69c1c5cca5a886526023
0x3025680925349c9c01c0f01cf300ec963832ec64false0x0000000001e4ef00d069e71d6ba041b0a16f7ea03840xdac17f958d2ee523a2206206994597c13d831ec70x30e0dc9a1d33eac83211a1113de238b3ce82695018025510998944512023-08-30T06:03:23.000Z0x69221442a46ab58e68f462596cc59fbfc765794e1a99cc84029d8db97f216559100000000
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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 wrapper on Ethereum, recording conversions of ETH, stETH, and wstETH into SY tokens with caller, receiver, and exchange rate data. Used for tracking user deposits and yield-bearing token wrapping activity in the Pendle protocol.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0xcbc72d92b2dc8187414f6734718563898740c0bcfalse0x0000000001e4ef00d069e71d6ba041b0a16f7ea01850x00000000000000000000000000000000000000000x0000000001e4ef00d069e71d6ba041b0a16f7ea01757155447348446310353567432023-06-27T15:24:23.000Z0xbfa1e5b56ca41bd89a1fafaedcc5ad2e18cf2cf09499dc483ddc2623b7d1e9c45350000000000000000
0xcbc72d92b2dc8187414f6734718563898740c0bcfalse0x0000000001e4ef00d069e71d6ba041b0a16f7ea02560xae7ab96520de3a18e5e111b5eaab095312d7fe840x0000000001e4ef00d069e71d6ba041b0a16f7ea017568427477958532738281035842023-06-27T04:46:35.000Z0x5e7d145818b4d935a02a01717719ea3ae871e77dbdc738d34d54269b0f4c24ec54000000000000000000
0xcbc72d92b2dc8187414f6734718563898740c0bcfalse0x0000000001e4ef00d069e71d6ba041b0a16f7ea02950x00000000000000000000000000000000000000000x0d459a3287afec25c0580691e9944d65feabb15517573746905552634710543362023-06-27T22:46:47.000Z0x1397ae10faa752c828c2aa0ff761ba7fa846b70cc49bb2ac900895218c0f2e06102320286582287011
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0xcbc72d92b2dc8187414f6734718563898740c0bcfalse0x41fad93f225b5c1c95f2445a5d7fcb85ba46713f10880x00000000000000000000000000000000000000000x54e28e62ea9e8d755dc6e74674eabe2abfdb004e16703002112216695689797862023-02-25T04:42:11.000Z0x623a0db9fa5c93c7fb47b43c892316bb585ac98af4ad4fe76068c6fcfdc9df0012471153486321203
0x47ba20283be4d72d4afb1862994f4203551539c5false0x41fad93f225b5c1c95f2445a5d7fcb85ba46713f1550x4d224452801aced8b2f0aebe155379bb5d5943810x9a76925dd91a7561b58d8353f0bce4df1e517abb16708137512061644455235704202023-02-25T22:03:47.000Z0xb4a68cfb973cf8ae4b9095118f7c81fb95182103c6009ccca180518011da057c64625080000000000000
0x47ba20283be4d72d4afb1862994f4203551539c5false0x41fad93f225b5c1c95f2445a5d7fcb85ba46713f510x4d224452801aced8b2f0aebe155379bb5d5943810x9a76925dd91a7561b58d8353f0bce4df1e517abb167024181246836387557881838112023-02-25T02:44:35.000Z0xc94a1f5943d4cf265ce2dbc919b78c076111412a979202950f645fc96dc51941157050484105535598944
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenOutSTRINGContract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSyToRedeemSTRINGAmount of Standardized Yield (SY) tokens being redeemed in the transaction. Numeric string representation of token quantity in smallest denomination.
in_amountTokenOutSTRINGAmount of output tokens received from the redemption or swap operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_callerlog_indexin_receiverin_tokenOutblock_numberblock_timestamptransaction_hashin_amountTokenOutin_amountSyToRedeem
0xcbc72d92b2dc8187414f6734718563898740c0bcfalse0x0000000001e4ef00d069e71d6ba041b0a16f7ea03060x38812c3ac3563bf200482ac9d096952d7cb55f9b0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0172243062023-05-09T17:14:59.000Z0xb261dc67912432d38717d4b289af3287d9a29c7d63c57e2669ff55cd94a695bd9829189840590160689698291898405901606896
0x3025680925349c9c01c0f01cf300ec963832ec64false0x0000000001e4ef00d069e71d6ba041b0a16f7ea03190x5751ee4746865e1ed0cc4891eac28bdb631ffa7e0xdac17f958d2ee523a2206206994597c13d831ec7172197222023-05-09T01:46:59.000Z0x8d7eec02a4e6031c5c3ecf8e6df62e5a0ceedff8e63f86875d69c70eeb3560e82755200363327522922888
0xaa68ca9c69a4ff22203ce189ce4448d7401875e8false0x00000000005bbb0ef59571e58418f9a4357b68a01910xff8ba48f19979a2fa42fa56ce3b85979c61706710xf951e335afb289353dc249e82926178eac7ded78193077252024-02-25T22:58:47.000Z0x075a31d7cd7fb951791d1140dc93891f9c152fa2c04a7aa2fc166a792b8c8c6c7988048271532616979880482715326169
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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 (SY) version 3 contracts on Ethereum, recording when users deposit tokens into yield-bearing positions. Tracks caller, receiver, input token address, deposited amount, and resulting SY token output for analyzing liquidity provision flows.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0xc430db19339a3051192233b4c49f9ab3dc6d16b7false0x0000000001e4ef00d069e71d6ba041b0a16f7ea04180xf1376bcef0f78459c0ed0ba5ddce976f1ddf51f40x38100a480dbed278b0fe57ba80a75498a7dc5bb119914223846707187816643098092024-05-20T22:51:23.000Z0x396b693b9829657a3afb70bcaba15af958c2762909c80445612a18300d56ef9384670718781664309809
0xc430db19339a3051192233b4c49f9ab3dc6d16b7false0x888888888889758f76e7103c6cbf23abbf58f9462510xf1376bcef0f78459c0ed0ba5ddce976f1ddf51f40x38100a480dbed278b0fe57ba80a75498a7dc5bb11991036299699474927060782642024-05-20T09:52:23.000Z0xedff87c057c4c517f3376b8102be4d8b27bd0f3191fbe3d7f20c629c7cdfdf5b9969947492706078264
0x8c28d28bad669afadc37b034a8070d6d7b9dfb74false0x3bef342f4ce7671f76c396e6c7d6fcd7f80ba9cb2880x23878914efe38d27c4d67ab83ed1b93a74d4086a0x3bef342f4ce7671f76c396e6c7d6fcd7f80ba9cb19910016290204402024-05-20T08:42:23.000Z0x12209c49d529a03d2fdf4703a6351aead4e001df76ef9227027ed78064c14a4d30991823
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.SYv3_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SYv4_Deposit_event

Deposit events from Pendle V1 SY (Standardized Yield) v4 contracts on Ethereum, recording when users deposit underlying tokens into yield-bearing positions and receive SY tokens in return. Useful for analyzing Pendle protocol liquidity flows and user deposit behavior.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0x198139f26d42f2028c10427a161e2d0e8bb00346false0x000000000000c9b3e2c3ec88b1b4c0cd853f43214630x00000000000000000000000000000000000000000x000000000000c9b3e2c3ec88b1b4c0cd853f4321203859411402021087604616972024-07-25T20:26:23.000Z0x44f19d5f8ba40117626adffd961f1d493746eacbc4ce42c85888aacc76a79d67164565656093245090
0x4f3a7a07a968b67f1f9692b70242f10e665d38adfalse0x000000000000c9b3e2c3ec88b1b4c0cd853f43213780x00000000000000000000000000000000000000000x000000000000c9b3e2c3ec88b1b4c0cd853f4321203818541174070888912253832024-07-25T06:44:35.000Z0xace31ce86cb438dbc4e8a2381ce643a83c85ce8ef127c65c93b4985f2d22beb7118977286317516838
0x4f3a7a07a968b67f1f9692b70242f10e665d38adfalse0x000000000000c9b3e2c3ec88b1b4c0cd853f43214930x00000000000000000000000000000000000000000x000000000000c9b3e2c3ec88b1b4c0cd853f432120380132168767277446508802024-07-25T00:59:35.000Z0xd785f24e3342041a99f9590d01a8bb697dfa42c169eec9ec7e03ca2320da20f517102436385578208
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0xaa68ca9c69a4ff22203ce189ce4448d7401875e8false0x0000000001e4ef00d069e71d6ba041b0a16f7ea02020xf951e335afb289353dc249e82926178eac7ded780x0000000001e4ef00d069e71d6ba041b0a16f7ea0181045361585953011311473292023-09-10T07:39:11.000Z0x9f92cd613e3f22d9bdebe025fbd1cf155720b2cc21a489f53244c2e5ff78bb4a158595301131147329
0xaa68ca9c69a4ff22203ce189ce4448d7401875e8false0x0000000001e4ef00d069e71d6ba041b0a16f7ea01930xf951e335afb289353dc249e82926178eac7ded780x0000000001e4ef00d069e71d6ba041b0a16f7ea01810286152516803554712227702023-09-10T02:00:35.000Z0x93d30089b7f5662f055569cb0877392513764022a565ea2712bde6fb972fa5065251680355471222770
0xaa68ca9c69a4ff22203ce189ce4448d7401875e8false0x0000000001e4ef00d069e71d6ba041b0a16f7ea01420xf951e335afb289353dc249e82926178eac7ded780x0e1c5509b503358ea1dac119c1d413e28cc4b303181045551000000000000000002023-09-10T07:42:59.000Z0x2f4ff58dea29e6afb0b3ce4167de6eba5b991c7d0c4cb8eaa94c361ce7b8e9a2100000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_tokenInin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountDeposited
0xcbc72d92b2dc8187414f6734718563898740c0bcfalse0x0000000001e4ef00d069e71d6ba041b0a16f7ea02420x00000000000000000000000000000000000000000xd0354d4e7bcf345fb117cabe41acadb724eccca218684001870843380400722023-11-30T11:03:23.000Z0x5563f5a45b2a25f928763d82433cdab319b0af04df10c1a5211be364510fc85f100000000000000
0x87b8e462080fa443a06d2bb119adb3828c407d78false0x888888888889758f76e7103c6cbf23abbf58f9464310x004e9c3ef86bc1ca1f0bb5c7662861ee933505680x888888888889758f76e7103c6cbf23abbf58f946236392895016312025-10-23T09:24:11.000Z0xbc691328ea3ba03c6d71488ee7a80f8aa45d71b6abd8ca910ec77092130e34d5501631
0xc93374d3044e61743547c1845071e94f6fd5123bfalse0x888888888889758f76e7103c6cbf23abbf58f9461170x23346b04a7f55b8760e5860aa5a77383d63491cd0x21a69c55fae5be461f7b0da635537dfe3fc84d26236433881820000000000000000002025-10-23T23:13:35.000Z0xf2b922fdfa0396812771a3de699fa2412ceee70fe3775c8e3cb6a1d4f5b48ae9182000000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_SYSTRINGContract address of the Standardized Yield (SY) token in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_expirySTRINGExpiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
in_PTSTRINGContract address of the Principal Token (PT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_YTSTRINGContract address of the Yield Token (YT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_PTin_SYin_YTaddressremovedin_expirylog_indexblock_numberblock_timestamptransaction_hash
0xf77205f5a1eeab54555b13b231fa5e4e0cf2fc1c0x677885afde857b70f40741ff8b60f9afba95dd490xcfd3a9e44957d5996663b58b69a79978ccfa778f0x70ee0a6db4f5a2dc4d9c0b57be97b9987e75bafdfalse1719446400283170797022023-04-19T09:15:35.000Z0x717bbe15088ec769608ff7c3e20d1284ad8b91ab1544b25c83cdf6a1f2f87467
0x158b791a17956925a2bc55c37b0daf8c3ace45490x0a26e7ab5c554232314a8d459eff0ede72333f080xa42374d76d4b7cf95c2c1e3661537d8c89f68ffa0x70ee0a6db4f5a2dc4d9c0b57be97b9987e75bafdfalse1735171200215180620612023-09-04T08:56:23.000Z0x2f530017050faae55b259a0c1fb4732bba9b8ba55c88a9c422d98628d9e595d0
0xac0650178e8be0c26b25673618c7be465a40aaf90x90f1935f733dd8826dca2bd01ccfc600f20e978e0x013889973cced40030175d138c685266b055e3f40x70ee0a6db4f5a2dc4d9c0b57be97b9987e75bafdfalse171158400056180620082023-09-04T08:45:47.000Z0x66c43d45b53ed7cb21c3fc74dd81de7507566ca822260b16b8b2f736d134e7b7
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_SYSTRINGContract address of the Standardized Yield (SY) token in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_expirySTRINGExpiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
in_PTSTRINGContract address of the Principal Token (PT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_YTSTRINGContract address of the Yield Token (YT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_PTin_SYin_YTaddressremovedin_expirylog_indexblock_numberblock_timestamptransaction_hash
0xa0e3d7418a34057016403197064b70c127e01e190x215a61dead7e1303b8571bb429491aeac5f2061e0x20c8cf9714339fd018898cb5de84c089e48d1c870xdf3601014686674e53d1fa52f7602525483f9122false1714003200116193670072024-03-05T05:54:47.000Z0x3f19188f6cc8db7a35e36c6e627ddd5c2260d1b0855f9a1958d866068f1c3079
0xc69ad9bab1dee23f4605a82b3354f8e40d1e59660xac0047886a985071476a1186be89222659970d650xfb35fd0095dd1096b1ca49ad44d8c5812a2016770xdf3601014686674e53d1fa52f7602525483f9122false1719446400126189695322024-01-09T12:53:59.000Z0x78f99dd6ce7d3235664116287765a90ac2b616905968e620febbfc445ca6f351
0x386bf9105ef88e79fb8ca53dcc9a4e6f04be01020x60d1afd87c5ab1a13e27638f1e75277febf4908c0xaf86da90a5c1e1a41be3b944b16944081087b7aa0xdf3601014686674e53d1fa52f7602525483f9122false171944640098189694182024-01-09T12:31:11.000Z0xe2f31b3cc7b0aa4ef58bac1092531b48136478d82cdcca05cc27190e34653ccd
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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 Ethereum, capturing the deployment of Principal Token (PT), Yield Token (YT), and Standardized Yield (SY) token addresses with their expiry timestamps. Used for tracking new yield-bearing position launches and analyzing Pendle’s asset coverage expansion.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_SYSTRINGContract address of the Standardized Yield (SY) token in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_expirySTRINGExpiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
in_PTSTRINGContract address of the Principal Token (PT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_YTSTRINGContract address of the Yield Token (YT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_PTin_SYin_YTaddressremovedin_expirylog_indexblock_numberblock_timestamptransaction_hash
0xafa002de2dadb57b2b04e32aa4f42a69adebf2fd0x1a7096563c94029dfd55e625a19f099726ac4f3f0xb978b4cc7bd1bcc684c3da0f3305c564ed8590140x273b4bfa3bb30fe8f32c467b5f0046834557f072false1730332800344203951132024-07-27T03:11:11.000Z0x458db49bf4423b7f2728a58333a8fd138bb59963a870b81d1501e481884e21ac
0x5c8151643f7aac530e2c5d13f91ca2a2d645a9a70xe833c7a12a10a44cb8b19bdf0931053ac136f1050xfdfc9e828ae3708814996147d23aceaef4e4cdf20x273b4bfa3bb30fe8f32c467b5f0046834557f072false17273088005203603842024-07-22T06:48:47.000Z0xd8b2fbe6372c456c6c32755e1a80a0f8bb2fd59a3b823f85f4cff920d9a5cd63
0x16e0ea59836581745ab6a3e369f19d7d40006f940x998a1d40f097fd36bff15ca78fc0673bd2a8280c0x4084c7af1ed7cee6d7d9853403065d4f5b9816c80x273b4bfa3bb30fe8f32c467b5f0046834557f072false1727308800106203603902024-07-22T06:50:11.000Z0x9ac8bac16313845abddac2f268b202191c587cc728baca77e4d4711010c9df25
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_SYSTRINGContract address of the Standardized Yield (SY) token in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_expirySTRINGExpiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
in_PTSTRINGContract address of the Principal Token (PT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_YTSTRINGContract address of the Yield Token (YT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_PTin_SYin_YTaddressremovedin_expirylog_indexblock_numberblock_timestamptransaction_hash
0x5bc38df326b941f289d60d60c543e393cd076b8a0x611fcc0350b493907de7ee010d1061933bd9e7420xc38ff86883e47632248730d4eb4301d287db0cf00x35a338522a435d46f77be32c70e215b813d0e3acfalse1756944000107226824412025-06-11T16:13:47.000Z0xe4a5f17081185afc56e819b5797acc13ae8a856bd27ec6d58e722a7d265a6c71
0x61d799b23c938220d27fc03ad2044a7aa891fe810x797f9d67a878250e0aa572c41a8a4e862ad09d5c0xb33e788c5656bc2221cac553df0da88ed0ce55970x35a338522a435d46f77be32c70e215b813d0e3acfalse175694400024226829762025-06-11T18:01:35.000Z0x9a5aa5395ab6600a6765f77ec2b379094975b22d50f511d34b5c1fc9678e0fea
0x9aef3bf940a22a58d8c55e287e2edfdb0130cf2b0xb258a604282f765fc752e5afd88974a5d6b401660xebfdccf3733cae8ef144d167231cff60b577000c0x35a338522a435d46f77be32c70e215b813d0e3acfalse1765411200281226818862025-06-11T14:22:11.000Z0x3c389d1d151fc3fbea5c8cb5ea861600022d9b40c8c2951d81a8d2ada53381d1
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_SYSTRINGContract address of the Standardized Yield (SY) token in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_expirySTRINGExpiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
in_PTSTRINGContract address of the Principal Token (PT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_YTSTRINGContract address of the Yield Token (YT) in the Pendle protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_PTin_SYin_YTaddressremovedin_expirylog_indexblock_numberblock_timestamptransaction_hash
0xafdbc3c812eb833cd2848454524d173b8dfc9bd00x5ee9157192b4090c1cb40f50a825cd2c1d16269a0xdea02a800416260bbcb67c59de1f694377bd4d200x3e6eba46abc5ab18ed95f6667d8b2fd4020e4637false176843520010237693032025-11-10T13:57:11.000Z0x9b47dfeb045d604b25d1a51e8e23731a2b763f400539afa746f2fcd2132d5c9e
0xbbb0bd679d84f54c987e5cabf2c366954fec635b0x6fc5b9eebf6f19556db8c8fdcc8d4a52e6dc106d0xb77b5a903ddb7a3cce06ffc92eab36c20ace1c7f0x3e6eba46abc5ab18ed95f6667d8b2fd4020e4637false1777507200395238487992025-11-21T17:16:35.000Z0x8e9554d4cccc506950ffaed4a6106e37c0061b501814e4b7157a2635649c176d
0xbe66e7492c311d97574bc043bdfa7100411497c90x785685b3a6a2af752694fda7058965302e59f8e60x8580ff7ef198ad6aab2b4a778f126cc66ac4bf540x3e6eba46abc5ab18ed95f6667d8b2fd4020e4637false1774483200218238417392025-11-20T17:29:11.000Z0x0e8e3ae154495ea55855d36a4d48551f5f3b9bfffa2a79e1741f13875a8c5e42
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_amountInterestFeeSTRINGAmount of interest fee collected in the CollectInterestFee event. String representation of an integer value denominated in the smallest unit of the underlying token.
addressremovedlog_indexblock_numberblock_timestamptransaction_hashin_amountInterestFee
0x029d6247adb0a57138c62e3019c92d3dfc9c1840false220229043842025-07-12T16:48:47.000Z0xfc190b2f149e68bed56337709c540a6f7e6b90685e6e352d322e168fe2d9696d105751546682472120
0x029d6247adb0a57138c62e3019c92d3dfc9c1840false411229003652025-07-12T03:21:11.000Z0x90bc588cd74966d33d995c468b664ea3cae2b69cb2230db6334013b4fb93fdae36576120771123276190
0x029d6247adb0a57138c62e3019c92d3dfc9c1840false273228999742025-07-12T02:01:47.000Z0x18e62f8d5312b5bb31f7a09daa43da4ca91080036e4ae8047c31ce8ae398625f39590893892287614985
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_rewardTokenSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_amountRewardFeeSTRINGAmount of reward fee collected from the yield token contract. Numeric string representation of token quantity in smallest denomination.
addressremovedlog_indexblock_numberin_rewardTokenblock_timestamptransaction_hashin_amountRewardFee
0x4263edde8814056f8672acc3a8d6a57160003245false36222874790xd533a949740bb3306d119cc777fa900ba034cd522025-04-17T08:19:59.000Z0xdb93fe42bdd89898e26dd1df3f409fd55bc8776462e9c8d487cc15a678aed57841765300444549820
0xc5e62a939d2e85f9ebb6aeffc03b053dacf90140false74222879510x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae92025-04-17T09:54:35.000Z0xa1b08368a83c834feccdc644229cb4e5d5e20e998f134888471c9d05e5cbefe062736263935698922
0x1477a353f248ac94b52f863e234755943a18b94cfalse76215812870x2da17faf782ae884faf7db2208bbc66b6e085c222025-01-08T17:35:35.000Z0xec1e1d47adcbefb2d59a58d3b90529da2be0dc0e618cdfd842906fe3e63e448877714874625890372571
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_amountPYToRedeemSTRINGQuantity of principal yield (PY) tokens being redeemed in the burn operation. Integer string representation of token amount in smallest divisible unit.
in_amountSyOutSTRINGQuantity of standardized yield (SY) tokens received from the deposit operation. Integer string representation of token amount in smallest divisible unit.
addressremovedin_callerlog_indexin_receiverblock_numberin_amountSyOutblock_timestamptransaction_hashin_amountPYToRedeem
0xcf5a8ad29619a66f0d5001a79a8dfad3a13f9a4dfalse0x888888888889758f76e7103c6cbf23abbf58f9461970x55cb9535aa1ee7c98916b044af5679eb5ea1c1712395836523847718497460545722025-12-07T03:44:59.000Z0xe0d67e60383aa0ed9cd048a3a3ca6b2a8e966718712fa28ed5e719a03b8930692415449978466418980
0xcf5a8ad29619a66f0d5001a79a8dfad3a13f9a4dfalse0x888888888889758f76e7103c6cbf23abbf58f9462070x55cb9535aa1ee7c98916b044af5679eb5ea1c17123958365130491984228677852025-12-07T03:44:59.000Z0xe0d67e60383aa0ed9cd048a3a3ca6b2a8e966718712fa28ed5e719a03b89306913217065629517740
0xcf5a8ad29619a66f0d5001a79a8dfad3a13f9a4dfalse0x888888888889758f76e7103c6cbf23abbf58f9462050xaca598edc3b62f8c24adba7cd24f6d795dd4257f2395836513596243053882804242025-12-07T03:44:59.000Z0xe0d67e60383aa0ed9cd048a3a3ca6b2a8e966718712fa28ed5e719a03b8930691377114753984643776
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_amountInterestFeeSTRINGAmount of interest fee collected in the CollectInterestFee event. String representation of an integer value denominated in the smallest unit of the underlying token.
addressremovedlog_indexblock_numberblock_timestamptransaction_hashin_amountInterestFee
0x7c1e7b27f94c4cd3d1db52c6f7dbfce40040cb12false474239549832025-12-06T16:21:47.000Z0x3f1de4e313953182658fb1ad447055e3764784ca19ddb332fcb424a15afc9ac217648016207194
0x7c1e7b27f94c4cd3d1db52c6f7dbfce40040cb12false1045239546842025-12-06T15:20:23.000Z0x6df5c1c80cdc2f4da68f687165115a193429fdac25e737544da45edf1487e7109955860230537
0xcf58a107978dab1467df123490663a9813447170false77239539672025-12-06T12:54:23.000Z0x6737ceca57d27a599301a8ba8805de21c6fc4b2ca3381689319aebaa91c729483654105509061043225
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.YTv6_CollectInterestFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

YTv6_CollectRewardFee_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_rewardTokenSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_amountRewardFeeSTRINGAmount of reward fee collected from the yield token contract. Numeric string representation of token quantity in smallest denomination.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverPTSTRINGAddress designated to receive the Principal Token (PT) portion of the minted yield-bearing tokens. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverYTSTRINGAddress designated to receive the Yield Token (YT) portion of the minted yield-bearing tokens. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSyToMintSTRINGAmount of Standardized Yield (SY) tokens used to mint Principal and Yield tokens. Numeric string representing the token quantity in the smallest unit denomination.
in_amountPYOutSTRINGAmount of Principal Yield (PY) tokens minted and distributed. Numeric string representing the token quantity in the smallest unit denomination.
addressremovedin_callerlog_indexblock_numberin_receiverPTin_receiverYTin_amountPYOutblock_timestamptransaction_hashin_amountSyToMint
0x08903411e7a3eb500e30aac3bdd44775055b8c00false0x888888888889758f76e7103c6cbf23abbf58f946358239611830x37a530552ca9df0533d317a292dcc8a582776aa00x888888888889758f76e7103c6cbf23abbf58f946883318893065037612762552025-12-07T13:13:59.000Z0x9a58060655ec865bf592ac125a950bad88c800b82cd7375472bc24a458071b3387407372477577312491982
0x08903411e7a3eb500e30aac3bdd44775055b8c00false0x888888888889758f76e7103c6cbf23abbf58f94635239599860x657e21723ae99c05c9c2a6032343c7865bcb19400x888888888889758f76e7103c6cbf23abbf58f9461515464578087380932641992025-12-07T09:12:59.000Z0x9f89302727108bc5fed7db1a82510ecb68d9b243a1d824a40a1fe3a2afb015f1149960312061054481894042
0x08903411e7a3eb500e30aac3bdd44775055b8c00false0x888888888889758f76e7103c6cbf23abbf58f94662239601380x6d8c4de7071d5aee27fc3a810764e62a4a00ceb90xa21957306bd617e489f2a4070975e5abf4f6f1af6594680090154832829202025-12-07T09:43:35.000Z0x311d9469fe6523fda4e3f9f06abf76b2bad439594563b799c8a71c1b46242568652565753473797017635
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_interestOutSTRINGAmount of interest redeemed by the user from the Yield Token (YT) contract. Denominated in the smallest unit of the underlying token.
addressin_userremovedlog_indexblock_numberin_interestOutblock_timestamptransaction_hash
0xcf58a107978dab1467df123490663a98134471700xf58ceb34f53060c0fdb562d2254803edac2a6aebfalse672323963629405040928161240038902025-12-07T21:26:47.000Z0xf17bae9307b6a10bdca0c54163c8f7b5974789ae879279228211f14c50b56346
0xcf58a107978dab1467df123490663a98134471700x79881b20a4199f7f140c1893a0667730eee88347false12239579165287306028678472390152025-12-07T02:14:47.000Z0xc660047e0178ba242ee78a174e0b5b75132089548265e7c7214cefb150b356fd
0xcf5a8ad29619a66f0d5001a79a8dfad3a13f9a4d0x4aaef9d0f3a802f6786a925ca3e497110b122a08false2162395836541471065548861332025-12-07T03:44:59.000Z0xe0d67e60383aa0ed9cd048a3a3ca6b2a8e966718712fa28ed5e719a03b893069
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountRewardsOutARRAY<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.
addressin_userremovedlog_indexblock_numberblock_timestamptransaction_hashin_amountRewardsOut
0x4addcba85f1f5474e7ed3abc3ff3e32af1e5abcf0xdf2bce9242f29adedfae7766730eadc3920781d9false248238954232025-11-28T06:34:47.000Z0x5a0dad639945b375d35eb9a74e2b719e78eea638a07a11105f1a65d0b3020388[]
0x08903411e7a3eb500e30aac3bdd44775055b8c000x8a27535ad41a37ba89be80305610280e7cbd7356false188239278312025-12-02T19:22:23.000Z0xe11cc4f2a095219c97aca1ab94b7c8e745095a4061cc6a1917c9baacd73b108f[]
0x08903411e7a3eb500e30aac3bdd44775055b8c000xcbcc520f4b2278f0c121c84146aba415f97cf15ffalse369239980632025-12-12T17:35:23.000Z0x1bf961f8743eec91fef6869ceaba15f628b84f1b545980f7b48ae3b017eb2bfc[]
Query with partition filter
SELECT *
FROM `tt-contracts.pendle_v1_ethereum.YTv6_RedeemRewards_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100