Query editor
WITH src AS (SELECT json_parse(http_get('https://api.llama.fi/protocol/merchant-moe')) AS j),tb AS (SELECTdate(from_unixtime(CAST(json_extract_scalar(x, '$.date') AS bigint))) AS dt,CAST(json_extract_scalar(x, '$.totalLiquidityUSD') AS double) AS tvl,json_extract_scalar(j, '$.name') AS projectFROM src,UNNEST(CAST(COALESCE(json_extract(j, '$.chainTvls.Mantle.tvl'),json_extract(j, '$.chainTvls.mantle.tvl')) AS array(json))) AS t(x)),t1 as (SELECTdt,project,tvl,LAG(tvl,1) OVER (PARTITION BY project ORDER BY dt) AS tvl_1,LAG(tvl,7) OVER (PARTITION BY project ORDER BY dt) AS tvl_7FROM tbwhere dt >= date('2025-01-01')and dt < current_date)SELECTdt,project,tvl,tvl-tvl_1 as change_1d,(tvl/tvl_1 -1) as change_1d_pct,tvl-tvl_7 as change_7d,(tvl/tvl_7 -1) as change_7d_pctFROM t1order by 1 desc, tvl desc