WITH base AS (

SELECT

livequery.live.udf_api('https://api.llama.fi/protocols') AS response

VALUE :name :: STRING AS name,

VALUE :category :: STRING AS category,

VALUE :chain :: STRING AS chain,

round(VALUE :tvl :: STRING) AS tvl,

case when round(VALUE :change_1d :: float,3)>0 then '🟢'||round(VALUE :change_1d :: float,3)||' %'

when round(VALUE :change_1d :: float,3)=0 then round(VALUE :change_1d :: float,3)||' %'

else '🔴'||round(VALUE :change_1d :: float,3)||' %'

end as change_1d ,

case when round(VALUE :change_1h :: float,3)>0 then '🟢'||round(VALUE :change_1h :: float,3)||' %'

when round(VALUE :change_1h :: float,3)=0 then round(VALUE :change_1h :: float,3)||' %'

else '🔴'||round(VALUE :change_1h :: float,3)||' %'

end as change_1h ,

VALUE :url :: STRING AS url,

VALUE :twitter :: STRING AS twitter,

VALUE :description :: STRING AS discription,

split(to_timestamp(VALUE:listedAt)::date,' ')[0] AS listedAT,

VALUE :chainTvls as chainTvls ,

VALUE :chains as chains

base,

LATERAL FLATTEN (

input => response :data

)

where VALUE:chains ilike '%sei%'

and VALUE :category :: STRING !='CEX'