select

value:ADDRESS as address

from (

select

live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/b0d8b93a-3da2-488a-a2c5-f465c27dffb0/data/latest') as resp

), lateral flatten (input => resp:data)

select address, value from (

select address, live.udf_api(

'GET',

concat('https://pro-openapi.debank.com/v1/user/total_balance?id=',address),

{'Accept': 'application/json',

'AccessKey':'{{debank_key}}'},

{}

) as resp

from (

select address from addresses

)

), lateral flatten(input => resp:data)

where path = 'total_usd_value'