flipside

    Pendle Expiry
    neo_nguyenPendle Expiry
    Updated 2025-03-29
    with

    pendle_supply_pt as( select * from $query('63ab21c3-2a2e-40ea-a109-fbfa40890c8e') ),
    pendle_liquid_pt as( select * from $query('fd936f10-611b-4c26-8cc6-01de0762c55b') ),
    pendle_liquid_sy as( select * from $query('7f7bf23f-a346-40ac-b378-0e762a717986') )

    select
    expiry, a.pool_name,
    supply_pt + liquidity_sy as tvl,
    supply_pt - liquidity_pt as float_pt,
    liquidity_pt+liquidity_sy as liquidity_total,
    liquidity_pt, liquidity_sy,
    balance_pt, balance_sy,
    pool_address
    from pendle_liquid_pt as a
    join pendle_liquid_sy as b on a.pool_name = b.pool_name
    join pendle_supply_pt as c on a.pool_name = c.pool_name
    order by expiry desc, tvl desc





    Last run: 20 days ago
    EXPIRY
    POOL_NAME
    TVL
    FLOAT_PT
    LIQUIDITY_TOTAL
    LIQUIDITY_PT
    LIQUIDITY_SY
    BALANCE_PT
    BALANCE_SY
    POOL_ADDRESS
    1
    		2025-03-27sUSDE-27MAR2025188270634.494794151631716.61545536638917.879338735176563.46759211462354.4117466435176563.46759211260650.354953970xcdd26eb5eb2ce0f203a84553853667ae69ca29ce
    2
    		2025-03-27pumpBTC-27MAR202583464627.7218432990918.68638600482473709.035457279168555.45058963305153.5848676961.4667347440.13961360x8098b48a1c4e4080b30a43a7ebc0c87b52f17222
    3
    		2025-03-27USDe-27MAR202549974691.989046347101042.59819022873649.39085612758603.13715474115046.253701362758603.13715474115046.253701360xb451a36c8b6b2eac77ad0737ba732818143a0e25
    4
    		2025-03-27LBTC-27MAR202531886086.003556410552714.108055921333371.895500520470490.9602537862880.935246846244.0086520310.28555760x70b70ac0445c3ef04e314dfda6caafd825428221
    5
    		2025-03-27corn-eBTC-27MAR202529618020.937050923931775.7932485686245.143802975457488.16915452228756.97464845165.143433072.730562890x2c71ead7ac9ae53d05f8664e77031d4f9eba064b
    6
    		2025-03-27wstUSR-27MAR202517554407.8127759618563.660575977935844.152198997618110.33999723317733.8122017577618110.33999723296947.4880390270x353d0b2efb5b3a7987fb06d30ad6160522d08426
    7
    		2025-03-27USD0++-27MAR202511835977.65756348009361.224617473826616.432945913178143.80966923648472.6232766773310566.46840545675492.3159132150xafdc922d0059147486cc1f0f32e3a2354b0d35cc
    8
    		2025-03-27SolvBTC.BBN-27MAR20255855109.362401075611318.59105288243790.771348194233670.00784720310120.7635009912.800262540.12128554780x3fd13bad9fc47e001bf9088afd1a1b2fc24673d5
    9
    		2025-03-27rsENA-27MAR20252025847.36448455956203.687315571069643.677168981026786.9164047142856.7607642672632786.96514028109889.1301647880x7e0209ab6fa3c7730603b68799bbe9327dab7e88
    10
    		2025-03-27uniBTC-27MAR20251489032.5116558302514.944371651186517.567284151138578.1222680247939.44501613313.562711740.571053370x380c751bd0412f47ca560b6afeb566d88dc18630
    11
    		2025-03-27BTC-Zerolend-eBTC-27MAR20251238116.82594007281763.993513016956352.832427056915672.89714139440679.93528566210.92995060.479485070x98ffefd1a51d322c8def6d0ba183e71547216f7f
    12
    		2025-03-27rsUSDe-27MAR20251131232.86965692874183.640232562257049.229424355246705.46345490810343.765969447246705.4634549088917.0396288330x890b6afc834c2a2cc6cb9b6627272ab4ecfd8271
    13
    		2025-03-27USUALX-27MAR2025719859.821495417357914.725186202361945.096309215344243.40275169217701.6935575232868695.02293077104127.6091619040xb9b7840ec34094ce1269c38ba7a6ac7407f9c4e3
    14
    		2025-03-27eEIGEN-27MAR2025365023.508649711108091.720673398256931.787976313246332.29925822810599.488718085248820.5043012410494.5432852320x07c5b1f5265591a8e0e541466654b07dd2d1a6fd
    15
    		2025-03-27staking-USDS-27MAR2025237152.52543819281063.929614997156088.595823195149827.4065121746261.189311021149827.4065121746261.1893110210x977ebf77581f94de969349549ab2108a681e8f4c
    16
    		2025-03-27apxETH-27MAR2025205591.28382899214397.853889126191193.429939866182796.8289967218396.60094314596.7363249074.1398050270xe6d4986cd935529fc4505d48e926bcd36a58a0f0
    17
    		2025-02-27sUSDE-27FEB20253012697.701744552867736.34282694144961.358917611138564.0957017336397.263215878138564.0957017335514.8820826570xd3c29550d12a5234e6aeb5aea7c841134cd6ddd5
    18
    		2025-02-27corn-uniBTC-27FEB20251058645.8778126414835.5433179921043810.33449465744664.102453685299146.2320409628.870418613.563421810x99b633a6a2e0d6414e7c7ecea1134c0a330a73fe
    19
    		2025-02-27corn-SolvBTC.BBN-27FEB2025743314.542017115163631.998022153579682.543994962167212.256283969412470.2877109932.003843894.9429753790xe6b03f3182692db1ed7d3a91f6fadf3e4dff2b95
    20
    		2025-02-27cornLBTC-27FEB2025370797.101377649228453.77502958142343.326348069133629.9706576128713.3556904571.592871860.103863370xc118635bcde024c5b01c6be2b0569a2608a8032c
    43
    8KB
    1s