SELECT * FROM ( WITH json AS ( SELECT livequery.live.udf_api ( 'https://api.llama.fi/v2/historicalChainTvl/Sui' ) AS response ), data AS ( SELECT TO_TIMESTAMP(value:date::string) AS date, value:tvl::double AS tvl_usd FROM json, LATERAL FLATTEN(input => response:data)) SELECT 'Sui' AS network, avg(tvl_usd) as avg_tvl FROM data WHERE date <= dateadd('month', 1, (SELECT min(date) FROM data)) ) UNION SELECT * FROM ( WITH json AS ( SELECT livequery.live.udf_api ( 'https://api.llama.fi/v2/historicalChainTvl/Sei' ) AS response ), data AS ( SELECT TO_TIMESTAMP(value:date::string) AS date, value:tvl::double AS tvl_usd FROM json, LATERAL FLATTEN(input => response:data)) SELECT 'Sei' AS network, avg(tvl_usd) as avg_tvl FROM data WHERE date <= dateadd('month', 1, (SELECT min(date) FROM data)) ) UNION SELECT * FROM ( WITH json AS ( SELECT livequery.live.udf_api ( 'https://api.llama.fi/v2/historicalChainTvl/INJECTIVE' ) AS response ), data AS ( SELECT TO_TIMESTAMP(value:date::string) AS date, value:tvl::double AS tvl_usd FROM json, LATERAL FLATTEN(input => response:data)) SELECT 'INJECTIVE' AS network, avg(tvl_usd) as avg_tvl FROM data WHERE date <= dateadd('month', 1, (SELECT min(date) FROM data)) ) UNION SELECT * FROM ( WITH json AS ( SELECT livequery.live.udf_api ( 'https://api.llama.fi/v2/historicalChainTvl/Kujira' ) AS response ), data AS ( SELECT TO_TIMESTAMP(value:date::string) AS date, value:tvl::double AS tvl_usd FROM json, LATERAL FLATTEN(input => response:data)) SELECT 'Kujira' AS network, avg(tvl_usd) as avg_tvl FROM data WHERE date <= dateadd('month', 1, (SELECT min(date) FROM data)) ) UNION SELECT * FROM ( WITH json AS ( SELECT livequery.live.udf_api ( 'https://api.llama.fi/v2/historicalChainTvl/Juno' ) AS response ), data AS ( SELECT TO_TIMESTAMP(value:date::string) AS date, value:tvl::double AS tvl_usd FROM json, LATERAL FLATTEN(input => response:data)) SELECT 'Juno' AS network, avg(tvl_usd) as avg_tvl FROM data WHERE date <= dateadd('month', 1, (SELECT min(date) FROM data)) ) UNION SELECT * FROM ( WITH json AS ( SELECT livequery.live.udf_api ( 'https://api.llama.fi/v2/historicalChainTvl/Umee' ) AS response ), data AS ( SELECT TO_TIMESTAMP(value:date::string) AS date, value:tvl::double AS tvl_usd FROM json, LATERAL FLATTEN(input => response:data)) SELECT 'Umee' AS network, avg(tvl_usd) as avg_tvl FROM data WHERE date <= dateadd('month', 1, (SELECT min(date) FROM data)) ) UNION SELECT * FROM ( WITH json AS ( SELECT livequery.live.udf_api ( 'https://api.llama.fi/v2/historicalChainTvl/Evmos' ) AS response ), data AS ( SELECT TO_TIMESTAMP(value:date::string) AS date, value:tvl::double AS tvl_usd FROM json, LATERAL FLATTEN(input => response:data)) SELECT 'Evmos' AS network, avg(tvl_usd) as avg_tvl FROM data WHERE date <= dateadd('month', 1, (SELECT min(date) FROM data)) ) UNION SELECT * FROM ( WITH json AS ( SELECT livequery.live.udf_api ( 'https://api.llama.fi/v2/historicalChainTvl/Persistence' ) AS response ), data AS ( SELECT TO_TIMESTAMP(value:date::string) AS date, value:tvl::double AS tvl_usd FROM json, LATERAL FLATTEN(input => response:data)) SELECT 'Persistence' AS network, avg(tvl_usd) as avg_tvl FROM data WHERE date <= dateadd('month', 2, (SELECT min(date) FROM data)) ) UNION SELECT * FROM ( WITH json AS ( SELECT livequery.live.udf_api ( 'https://api.llama.fi/v2/historicalChainTvl/Stargaze' ) AS response ), data AS ( SELECT TO_TIMESTAMP(value:date::string) AS date, value:tvl::double AS tvl_usd FROM json, LATERAL FLATTEN(input => response:data)) SELECT 'Stargaze' AS network, avg(tvl_usd) AS tvl_usd FROM data WHERE date <= dateadd('month', 1, (SELECT min(date) FROM data)) ) UNION SELECT * FROM ( WITH json AS ( SELECT livequery.live.udf_api ( 'https://api.llama.fi/v2/historicalChainTvl/Terra' ) AS response ), data AS ( SELECT TO_TIMESTAMP(value:date::string) AS date, value:tvl::double AS tvl_usd FROM json, LATERAL FLATTEN(input => response:data)) SELECT 'Terra' AS network, avg(tvl_usd) AS tvl_usd FROM data WHERE date <= dateadd('month', 1, (SELECT min(date) FROM data)) ) ORDER BY 2 DESC

SEI vs the Field