date,

sum(chain_tvl),

chain,

protocol

from

external.defillama.fact_protocol_tvl

where

chain ilike 'Avalanche%'

group by

date,

chain,

protocol

order by

date desc,

2 desc