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)

),

tokens as (SELECT name , address, decimal, price

FROM (

VALUES

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

( 'BERA','0x7507c1dc16935B82698e4C63f2746A2fCf994dF8',1e18,80),

( '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))

,obero_price as (

with buys as (select tx_hash, (utils.udf_hex_to_int(substr(data,3,66))::int)/1e18 as amount

from berachain.testnet.fact_event_logs

where contract_address=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')

and origin_to_address=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')

and ORIGIN_FUNCTION_SIGNATURE='0xba002b70'

and TOPICS[0]='0x3590f0a355392f9c1de13cd72ea564d10019bb3605905ea543b424a360b9a88e'

order by block_timestamp desc limit 1