WITH tvl_changes AS (
SELECT
date,
tvl_usd,
LAG(tvl_usd, 1) OVER (ORDER BY date) AS prev_tvl_usd
FROM external.defillama.fact_chain_tvl
where date>='2023-01-01' and chain='Thorchain'
)
SELECT
date,
tvl_usd,
prev_tvl_usd,
(CASE
WHEN prev_tvl_usd IS NULL OR prev_tvl_usd = 0 THEN NULL
ELSE (tvl_usd - prev_tvl_usd) / prev_tvl_usd * 100
END) AS pct_change
FROM
tvl_changes
ORDER BY
date;