pendle_contract as( select * from $query('f797cc43-627c-4228-a233-b544f72d1526') ),

pendle_oracle as( select * from $query('f90ce887-7773-43b6-ac7d-a666182c79e0') order by date desc limit 3),

pendle_data as(

select to_address as pool, amount, contract_address, block_timestamp from ethereum.core.ez_token_transfers union all

select to_address as pool, amount, contract_address, block_timestamp from Base.core.ez_token_transfers union all

select to_address as pool, amount, contract_address, block_timestamp from bsc.core.ez_token_transfers union all

select to_address as pool, amount, contract_address, block_timestamp from arbitrum.core.ez_token_transfers union all

select to_address as pool, amount, contract_address, block_timestamp from mantle.core.ez_token_transfers

),

pendle_fee as(

select date_trunc('week',block_timestamp - interval '72 hours' ) as epoch, sum(amount) balance

from pendle_data tb1

join pendle_contract tb2 on tb1.contract_address = tb2.sy

where pool in ('0x8270400d528c34e1596ef367eedec99080a1b592','0xcbcb48e22622a3778b6f14c2f5d258ba026b05e6','0x5c30d3578a4d07a340650a76b9ae5df20d5bdf55','0xd77e9062c6df3f2d1cb5bf45855fa1e7712a059e')

and category = 'BTC'

group by 1)

select * from pendle_fee

order by epoch desc