SELECT

protocol,

chain,

date,

chain_tvl,

LAG(chain_tvl, 7) OVER (PARTITION BY protocol ORDER BY date) AS Previous7DaysTvl,

LAG(chain_tvl, 30) OVER (PARTITION BY protocol ORDER BY date) AS Previous30DaysTvl

FROM external.defillama.fact_protocol_tvl

WHERE protocol ILIKE 'raydium'

AND chain ILIKE 'SOLANA'

SELECT

date,

chain_tvl,

((chain_tvl - Previous7DaysTvl) / NULLIF(Previous7DaysTvl, 0)) * 100 AS Tvl_Growth7Day,

((chain_tvl - Previous30DaysTvl) / NULLIF(Previous30DaysTvl, 0)) * 100 AS TvlGrowth30Day

FROM

TvlGrowth

ORDER BY

date DESC

LIMIT 1;