-- Coingecko 🤝 Flipside LiveQuery Function

with response as (

SELECT live.udf_api(

'GET',

'https://api.coingecko.com/api/v3/coins/list',

{'x-cg-demo-api-key':'{apikey}'},

{},

'coingecko') as resp

),

tokens as (

select

value:id::string as id,

value:name::string as name,

value:symbol::string as symbol

from response,

lateral flatten (input => resp:data)

select * from tokens

where name ilike any (

'bitcoin','ethereum','solana',

'avalanche','axelar','sei',

'aptos','arbitrum','base',

'blast','cosmos','flow',

'near protocol','optimism','polygon',

'sui','thorchain','klaytn'