DATE_TRUNC('DAY', date) AS DAY,

chain,

AVG(tvl_usd) AS tvl

external.defillama.fact_chain_tvl

chain ilike any ('%near%', '%optimism%', '%base%', '%arbitrum%')

and chain <> 'Arbitrum Nova'

and date > current_date - 60

GROUP BY

1,

2

;