-- forked from Dately Avalanche Specific DEXs TVL Over Time @ https://flipsidecrypto.xyz/edit/queries/ed9441ec-84c2-407b-9ee2-922c4c765449
select date,
protocol,
sum (chain_tvl) as tvl
from external.defillama.fact_protocol_tvl
where category in ('Lending','Leveraged Farming','lending')
and chain ilike 'Avalanche'
group by 1,2
order by 1 desc