pendle_pool as( select * from $query('f90ce887-7773-43b6-ac7d-a666182c79e0') ),

pendle_data as(

select from_address as pool, case when amount is null then raw_amount/1e18 else amount end amount, contract_address, block_timestamp from ethereum.core.ez_token_transfers union all

select to_address as pool, case when amount is null then 0-raw_amount/1e18 else 0-amount end amount, contract_address, block_timestamp from ethereum.core.ez_token_transfers ),

pendle_liquid as(

select chain, category, protocol, symbol, sy, sum(amount*price) tvl, count(distinct mk) pool

from pendle_data tb1

join pendle_pool tb2 on tb1.contract_address = tb2.sy and tb1.pool = '0x0000000000000000000000000000000000000000'

where chain = 'Ethereum'

group by 1,2,3,4,5)

select chain, category, protocol, symbol, sum(pool) pool, sum(case when symbol like '%sUSDe%' then tvl/pool*1.16 else tvl/pool end) tvl, max(sy) sy

from pendle_liquid

group by 1,2,3,4

order by tvl desc