with tokens as (SELECT name , address, decimal, price

FROM (

VALUES

( 'YEET','0x1740F679325ef3686B2f574e392007A92e4BeD41',1e18,0.8),

( 'WBERA','0x7507c1dc16935B82698e4C63f2746A2fCf994dF8',1e18,55),

( 'HONEY','0x0E4aaF1351de4c0264C5c7056Ef3777b41BD8e03',1e18,1),

( 'KDK','0xfd27998fa0eaB1A6372Db14Afd4bF7c4a58C5364',1e18,1760),

( 'xKDK','0x414b50157a5697f14e91417c5275a7496dcf429d',1e18,100),

( 'iBGT','0x46eFC86F0D7455F135CC9df501673739d513E982',1e18,250),

( 'BERO','0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f',1e18,35),

( 'oBERO','0x7629668774f918c00Eb4b03AdF5C4e2E53d45f0b',1e18,34)

) AS X(name,address,decimal,price)),

prices as (

select value['address'] as token_address, value['price'] as usd_price from (

select live.udf_api(

'GET',

'https://bartio.api.oogabooga.io/v1/prices',

{'content-type': 'application/json',

'Authorization':'Bearer {{debank_key}}'},

{}

) as resp

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

),

tokens_data as (

select symbol, cast(token_address as varchar) as token_address, usd_price from prices p

join berachain.testnet.dim_contracts d on lower(d.ADDRESS)=lower(p.token_address)

),

yeet_price as (select week, avg(yeet_p) as yeet_p from (

select week, CASE

WHEN honey_in > 0 then honey_in/yeet_out

WHEN yeet_in > 0 then honey_out/yeet_in

END as yeet_p

from (