SELECT

*,

ROW_NUMBER() OVER (PARTITION BY pool_id ORDER BY date DESC) as rn

FROM external.defillama.fact_pool_yields

WHERE tvl_usd >= 1000000

SELECT

*

FROM latest_yields

WHERE rn = 1

AND APY > 0

AND APY_MEAN_30D > 0;