pendle_pool as( select chain, protocol, symbol, sy, mk, price from $query('f90ce887-7773-43b6-ac7d-a666182c79e0') group by 1,2,3,4,5,6 ),

pendle_ethereum 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_base as(

select from_address as pool, case when amount is null then raw_amount/1e18 else amount end amount, contract_address, block_timestamp from base.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 base.core.ez_token_transfers ),

pendle_ethereum_tvl as(

select date_trunc('week',block_timestamp) time, chain, protocol, symbol, sy, sum(amount*price) tvl

from pendle_ethereum tb1

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

where chain = 'Ethereum' and symbol like '%LBTC%'

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

pendle_base_tvl as(

select date_trunc('week',block_timestamp) time, chain, protocol, symbol, sy, sum(amount*price) tvl

from pendle_base tb1

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

where chain = 'Base' and symbol like '%LBTC%'

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

pendle_protocol as(

select * from pendle_ethereum_tvl union all

select * from pendle_base_tvl)

select

time, chain, sy,

case when symbol = 'LBTC' and chain = 'Ethereum' then 'LBTC (Ether)'

when symbol = 'LBTC' and chain = 'Base' then 'LBTC (Base)'

else symbol end symbol,

tvl,