Query editor
-- =============================================================================-- Yield.xyz — Aave v3 Vaults: TVL + Inflow / Outflow per vault-- 84 vaults (yieldId *-aave-v3-lending OR Yield name contains "Aave").-- Vault-driven LEFT JOIN: every vault appears even with zero activity.-- Excludes 1 Sepolia testnet vault and 2 rows with typo'd duplicate proxies-- (Rebind eurc/usdt — proxies belong to Finery & Veera vaults; fix in sheet).-- =============================================================================WITHvaults(client, proxy, yield_name, network, chain, asset, decimals) AS (VALUES('Binance US', 0xa2078c2681cce818a9b557963b9f803701c6c551, 'Aave USDT', 'Ethereum', 'ethereum', 'USDT', 6),('Binance US', 0xeb4d86bf147ec9970f7f0992141b64e4c1a4417a, 'Aave WETH', 'Base', 'base', 'WETH', 18),('Finery Markets', 0x79eabf4636218b4ba9f6908834913ba75743c177, 'USDT Aave Lending', 'Polygon', 'polygon', 'USDT', 6),('Finery Markets', 0x41dba23299d91946f0ca78477b65be5d73c88725, 'USDC Aave Lending', 'Polygon', 'polygon', 'USDC', 6),('Finery Markets', 0x4516c2486d29879696d7b4d77238fce9679aed5b, 'USDT Aave Lending', 'Optimism', 'optimism', 'USDT', 6),('Finery Markets', 0x63b81cc744687b64d5b4181af2ce10e35ea7ae05, 'USDC Aave Lending', 'Optimism', 'optimism', 'USDC', 6),('Finery Markets', 0x131db41caadb1ecbc2ada9c895864d6de03b759a, 'USDT Aave Lending', 'Ethereum', 'ethereum', 'USDT', 6),('Finery Markets', 0x68c9af8041598dec77f26ab453dbcbaa60b7c409, 'USDC Aave Lending', 'Ethereum', 'ethereum', 'USDC', 6),('Finery Markets', 0x5dfe2a1993ba4e1d3628ed47f5abff5346c186a4, 'USDC Aave Lending', 'Base', 'base', 'USDC', 6),('Finery Markets', 0x7330140f6c1261ea0fc4b37bdbea44c7d7e004b5, 'EURC Aave Lending', 'Base', 'base', 'EURC', 6),('Finery Markets', 0x38c171ecaa837d02879c2b1a607a53e7647b5006, 'USDT Aave Lending', 'Arbitrum', 'arbitrum', 'USDT', 6),('Finery Markets', 0x7efdfcf984339b09c98f2a95053a9dcb54f69f59, 'USDC Aave Lending', 'Arbitrum', 'arbitrum', 'USDC', 6),('Finoa', 0xcfeea2c1a27e19210379390bdcac161333be6059, 'USDC Aave Lending', 'Base', 'base', 'USDC', 6),('LatAIm', 0x1c0ddd120614d2cad58696e6ca3ccce1c2604f25, 'USDT Aave Lending', 'Polygon', 'polygon', 'USDT', 6),('LatAIm', 0xff22a9660a51af9d841d020584aff44c7a78e107, 'USDC Aave Lending', 'Polygon', 'polygon', 'USDC', 6),('LatAIm', 0x5a78c31b02d85a0d9f19d8cf3f7986a8baca7d0a, 'USDT Aave Lending', 'Optimism', 'optimism', 'USDT', 6),('LatAIm', 0x313ed682e15689d07a25327f6e0d790106908dc7, 'USDC Aave Lending', 'Optimism', 'optimism', 'USDC', 6),('LatAIm', 0x790b09bf0f987c31461da807dc5d4a174a6a8abc, 'USDC Aave Lending', 'Base', 'base', 'USDC', 6),('LatAIm', 0xf9bac4848cc736eb8715ff1692163819645dc54e, 'USDT Aave Lending', 'Ethereum', 'ethereum', 'USDT', 6),('LatAIm', 0xe3835d99edbc16c1713b359c0442a38da0816d55, 'USDC Aave Lending', 'Ethereum', 'ethereum', 'USDC', 6),('LatAIm', 0x6ae9103e323d9a7a9c5ce21ffdad68e74ca874b3, 'EURC Aave Lending', 'Base', 'base', 'EURC', 6),('LatAIm', 0x7814007c2a8c1c8c36a5f9d309b46442b608b142, 'USDT Aave Lending', 'Arbitrum', 'arbitrum', 'USDT', 6),('LatAIm', 0x3b30969c7f885c54c4c664ebc4f343b2dd7fd338, 'USDC Aave Lending', 'Arbitrum', 'arbitrum', 'USDC', 6),('Meria', 0xb9449f2340e641d3007e707552ffa8e609f9ea79, 'USDC Aave Lending', 'Base', 'base', 'USDC', 6),('Meria', 0xc79c1c8596c491b22a2fe4db9598a528de41a30c, 'USDC Aave Lending', 'Ethereum', 'ethereum', 'USDC', 6),('Porto', 0x18d051201e6377343e857ee7a195c68f9c3ac414, 'USDT Aave Lending', 'Polygon', 'polygon', 'USDT', 6),('Porto', 0xc7d4fcfcd8e1416488cc127938c6b2228be814b3, 'USDC Aave Lending', 'Polygon', 'polygon', 'USDC', 6),('Porto', 0x212d4ba95fd4f5575ac62a79f0dad28211a92e90, 'USDT Aave Lending', 'Optimism', 'optimism', 'USDT', 6),('Porto', 0x6f0c3accf7fc9446c68483de7f36af1bdd358f0d, 'USDC Aave Lending', 'Optimism', 'optimism', 'USDC', 6),('Porto', 0x5b6b838629641ef7730dab2cb6325c3ddbf32e68, 'USDC Aave Lending', 'Base', 'base', 'USDC', 6),('Porto', 0x5b52ffbb227c256f5f9e80e8d5bed5d693bb755b, 'USDT Aave Lending', 'Ethereum', 'ethereum', 'USDT', 6),('Porto', 0x3fe937a48ec7da50eeb0a4c888804d1f593e7cc0, 'USDC Aave Lending', 'Ethereum', 'ethereum', 'USDC', 6),('Porto', 0x2abc8a5752358933d9cf3933f5fefab6f113b45e, 'EURC Aave Lending', 'Base', 'base', 'EURC', 6),('Porto', 0x432b5bf3a486fb594a334ec564201f4316965411, 'USDT Aave Lending', 'Arbitrum', 'arbitrum', 'USDT', 6),('Porto', 0xffedbacb4d962f560bbbecbb41798c95c8bc95a9, 'USDC Aave Lending', 'Arbitrum', 'arbitrum', 'USDC', 6),('Rebind', 0x3e1c434541ecca30cd631b3a27170a223f896b03, 'EURe Aave Lending', 'Gnosis', 'gnosis', 'EURe', 18),('Rebind', 0x124927025f2a2e28a41b06c1cdde04667bb6b5ad, 'rebind aave weth', 'Base', 'base', 'WETH', 18),('Rebind', 0x5150b6c808ad8aba8242e427f612b10102ca77b8, 'rebind aave usdc', 'Arbitrum', 'arbitrum', 'USDC', 6),('Recommended by Yield..xyz', 0x2c282113b4e38c2de82c80563386029ae073604e, 'USDT Aave Lending', 'Polygon', 'polygon', 'USDT', 6),('Recommended by Yield..xyz', 0x61886d3eca6155d2c5d2ac8d5fe52a484df02189, 'USDC Aave Lending', 'Polygon', 'polygon', 'USDC', 6),('Recommended by Yield..xyz', 0xed7fc9889cbc56d29726c6dad045a6f57d7f9456, 'USDT Aave Lending', 'Optimism', 'optimism', 'USDT', 6),('Recommended by Yield..xyz', 0x7b0bfd260998371efd301f98612b807501b8d534, 'USDC Aave Lending', 'Optimism', 'optimism', 'USDC', 6),('Recommended by Yield..xyz', 0xf8d1444c1f6ef8028fac3e777de4a6db7b7c51c1, 'USDC Aave Lending', 'Base', 'base', 'USDC', 6),('Recommended by Yield..xyz', 0x19bfe4a14b7fc0346fcb25182605153189cbc810, 'USDT Aave Lending', 'Ethereum', 'ethereum', 'USDT', 6),('Recommended by Yield..xyz', 0x1e26141630e327c9b7d8dcdf7446867de76b594b, 'USDC Aave Lending', 'Ethereum', 'ethereum', 'USDC', 6),('Recommended by Yield..xyz', 0xdfd77d9895f4157c3bddeadcb965fc9d30e5c993, 'EURC Aave Lending', 'Base', 'base', 'EURC', 6),('Recommended by Yield..xyz', 0x91d1ebbce4d6719baef2a4b637052ca55792e93d, 'USDT Aave Lending', 'Arbitrum', 'arbitrum', 'USDT', 6),('Recommended by Yield..xyz', 0xbb2c60c5ad02b59da54d39f654ad5efc5a197244, 'USDC Aave Lending', 'Arbitrum', 'arbitrum', 'USDC', 6),