-- forked from Trader JOE TVL @ https://flipsidecrypto.xyz/studio/queries/026c4e02-fa83-43ad-8751-230c0b6052a1
with tvl as(
select * from external.defillama.fact_protocol_tvl
where protocol ilike '%Joe%'
and chain ='Avalanche'
)
select * from tvl where date>=current_date-7