-- forked from Benqi Lending Markets Over Time @ https://flipsidecrypto.xyz/edit/queries/85020c3b-b673-46ed-8564-748da876c3ea
select date_trunc ({{Time_Interval}},date) as date,
symbol as market,
avg (apy) as Market_APY,
avg (tvl_usd) as TVL
from external.defillama.fact_pool_yields
where chain = 'Avalanche'
--and (projects ilike '%AAVE%'
and projects ilike '%aave%'
--and date = (select max(date) from external.defillama.fact_pool_yields and chain = 'Avalanche' )
group by 1,2
order by 1 desc