SELECT

'All Chain' AS "Protocol"

,date::date AS "Date"

,tvl_usd AS "TVL"

FROM external.defillama.fact_chain_tvl

WHERE chain = 'Klaytn'

AND date >= current_date - interval '6 month'

),

neopin_tvl_tab AS (

SELECT

'Neopin' AS "Protocol"

,log.value:DATE::date AS "Date"

,log.value:TVL_USD AS "TVL"

FROM (SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/v1/queries/a17c8f8f-1327-41b7-a853-3785ee0a7996/data/latest') as resp )

,LATERAL FLATTEN (input => resp:data) log

),

Capybara_tvl_tab AS (

SELECT

'Capybara' AS "Protocol"

,log.value:DATE::date AS "Date"

,log.value:TVL_USD AS "TVL"

FROM (SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/v1/queries/dc318092-71fb-43fa-8b6e-0d49a931e403/data/latest') as resp )

,LATERAL FLATTEN (input => resp:data) log

),

Dgswap_tvl_tab AS (

SELECT

'DragonSwap' AS "Protocol"

,log.value:DATE::date AS "Date"

,log.value:TVL_USD AS "TVL"

FROM (SELECT livequery.live.udf_api( '') as resp )

,LATERAL FLATTEN (input => resp:data) log

),