SELECT livequery.live.udf_api(

'https://api.dexscreener.com/latest/dex/tokens/0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'

) AS response

SELECT

(CASE WHEN value:pairAddress = '0xe6EC4C661F0B822BA2851b4A1de9Ad64132fbFe3' THEN '3BC-WETH'

WHEN value:pairAddress = '0x1445fA540021e67d2a0291BAc79036c45AF991d3' THEN '3BC-USDC'

END) AS pairname,

value:pairAddress AS pairAddress,

value:liquidity:usd AS liquidity_usd,

value:marketCap AS marketCap,

value:priceUsd AS priceUsd,

value:priceChange:h1 AS priceChange_h1,

value:priceChange:h6 AS priceChange_h6,

value:priceChange:h24 AS priceChange_h24,

value:txns:h1:buys AS h1_buys,

value:txns:h6:buys AS h6_buys,

value:txns:h24:buys AS h24_buys,

value:txns:h1:sells AS h1_sells,

value:txns:h6:sells AS h6_sells,

value:txns:h24:sells AS h24_sells,

value:volume:h1 AS volume_h1,

value:volume:h6 AS volume_h6,

value:volume:h24 AS volume_h24

from api_call, lateral FLATTEN (input => response:data:pairs)

where pairAddress in ('0xe6EC4C661F0B822BA2851b4A1de9Ad64132fbFe3','0x1445fA540021e67d2a0291BAc79036c45AF991d3')

ORDER BY 1 DESC