--chain,

--symbol,

avg(APY) as avg_apy

--tvl_usd

from external.defillama.fact_pool_yields

where (symbol like '%USD%'

or

symbol like '%DAI%')

and

date = current_date() - 1

and

symbol not like '%-%'

and

symbol not in ('IUSD','REUSDC','XUSDC','XUSDT','YUSD','UPUSDC','GTDAICORE','YUSD','ATUSD','AUSDC')

and

tvl_usd >= 10000000

group by 1

order by APY desc