pendle_raw_data as(

select * from $query('55b2f8cd-cc50-44f1-aadc-a931078b4443') union all -- Ethereum

select * from $query('5bc69b65-9bae-48e4-bb0f-492a41da705d') union all -- Base

select * from $query('d3513ad5-0183-4f04-84c9-731acb342111') union all -- Arbitrum

select * from $query('7c717f0f-6d3f-4822-b87b-ac092a07a2b9') union all -- Bsc

select * from $query('3e73d35c-5184-45d5-baf8-97737eac0177') -- Mantle

),

pendle_liquid as(

select chain, protocol, symbol, max(tvl) tvl_usd

from pendle_raw_data

group by 1,2,3)

select *, sum(tvl_usd) over() tvl_usd_all

from pendle_liquid

order by tvl_usd desc