AVG(case when DATE between CURRENT_DATE-8 and CURRENT_DATE-7 THEN TVL_USD ELSE NULL END) AS DAY_7

, AVG(case when DATE between CURRENT_DATE-31 and CURRENT_DATE-30 THEN TVL_USD ELSE NULL END) AS DAY_30

, AVG(case when DATE between CURRENT_DATE-91 and CURRENT_DATE-90 THEN TVL_USD ELSE NULL END) AS DAY_90

, AVG(case when DATE between CURRENT_DATE-1 and CURRENT_DATE THEN TVL_USD ELSE NULL END) AS NOW

, NOW - DAY_7 AS INCREASE7

, NOW - DAY_30 AS INCREASE30

, NOW - DAY_90 AS INCREASE90

, INCREASE7*100/DAY_7 AS INCREASE7_PERCENT

, INCREASE30*100/DAY_30 AS INCREASE30_PERCENT

, INCREASE90*100/DAY_90 AS INCREASE90_PERCENT

external.defillama.fact_chain_tvl

WHERE

CHAIN IN ('CORE')

AND

DATE > CURRENT_DATE - 120