Query editor
WITH vaults AS (SELECT * FROM (VALUES('yoUSD Yield Optimizer', 0x6db81fd565da286c9269743b2df479af3f68aeda, 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 'USDC', 6, 'base'),('yoEUR Yield Optimizer', 0x4d0edbbdfa3020c54f3655556dff88fac2631faf, 0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42, 'EURC', 6, 'base'),('yoETH Yield Optimizer', 0x6c3b8934b91bfc115cc1dae0bc244304dcf6ff3a, 0x4200000000000000000000000000000000000006, 'WETH', 18, 'base'),('yoBTC Yield Optimizer', 0x21ce224fae6712cc98145ab07268753f2ff63c07, 0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf, 'cbBTC', 8, 'base'),('WETH Aave Lending', 0x2b8d67028ec6a94001aeb72feb62825408951373, 0x7ceb23fd6bc0add59e62ac25578270cff1b9f619, 'WETH', 18, 'polygon'),('USDT Aave Lending', 0x420772baa2d577271438d5fc35ec0bda694e9ada, 0xc2132d05d31c914a87c6611c10748aeb04b58e8f, 'USDT0', 6, 'polygon'),('USDC Aave Lending', 0xcc7a52362337631a260975f19ea23aa5a7a9dd87, 0x3c499c542cef5e3811e1192ce70d8cc03d5c3359, 'USDC', 6, 'polygon'),('WETH Aave Lending', 0x21cf86166e155d7a8f8276d9bd2e1b35310cd9be, 0x4200000000000000000000000000000000000006, 'WETH', 18, 'optimism'),('USDT Aave Lending', 0x38692febc7176ca874f97ae79cdbe37fe642ec9f, 0x94b008aa00579c1307b0ef2c499ad98a8ce58e58, 'USDT', 6, 'optimism'),('USDC Aave Lending', 0x4f6e27442192a34b60e016937639f1d0af3e2300, 0x0b2c639c533813f4aa9d7837caf62653d097ff85, 'USDC', 6, 'optimism'),('USDC Fluid Vault', 0x601f32ba53787dbd4bc5b2e2c10e74fe04bf67f2, 0x3c499c542cef5e3811e1192ce70d8cc03d5c3359, 'USDC', 6, 'polygon'),('WBNB Aave Lending', 0x8a4cbb8d43fe43332a67728ac4706968fe027455, 0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c, 'WBNB', 18, 'bnb'),('USDC Aave Lending', 0xcbf9525dff97132b45fde14579b10e7c9505c422, 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 'USDC', 6, 'base'),('Seamless WETH', 0xcc05c1f9993e44e787341ddc33223617b7133541, 0x4200000000000000000000000000000000000006, 'WETH', 18, 'base'),('Seamless USDC Vault', 0x467771fd30b27dceaed7375b744ca036269bd128, 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 'USDC', 6, 'base'),('EURC Aave Lending', 0xc8050b74083fa6371b9ccbffcf2b8ddeb9831289, 0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42, 'EURC', 6, 'base'),('USDT0 Lending Fluid Vault', 0x74f6730babb9d2e43f091f0ee3c1d5a071bd7dff, 0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb, 'USDT0', 6, 'plasma'),('USDS Sky Savings Rate', 0x88c7bd27600d3ba7593b3b6bf0e61abedceb26a6, 0xdc035d45d973e3ec169d2276ddab16f1e407384f, 'USDS', 18, 'ethereum'),('Moonwell Flagship EURC', 0x273de6dc1a07bfc66824a4add391a6deadd99228, 0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42, 'EURC', 6, 'base'),('Moonwell Flagship ETH Morpho Vault', 0x34d781e30575f8aa0d4b576eabf358a70c694914, 0x4200000000000000000000000000000000000006, 'WETH', 18, 'base'),('USDT Aave Lending', 0x06fc83e781494e27352636642aa643116e064455, 0xdac17f958d2ee523a2206206994597c13d831ec7, 'USDT', 6, 'ethereum'),('Horizon cbBTC', 0xec4c03685ffd192e4e5686b5b574a25b70414719, 0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf, 'cbBTC', 8, 'base'),('Gauntlet WETH Core Morpho Vault', 0x6387c10332b155d3e8e927e1290a5bd73fd96310, 0x4200000000000000000000000000000000000006, 'WETH', 18, 'base'),('USDC Aave Lending', 0xc96cfafa81084e87a85a43e58c86d3046b520342, 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48, 'USDC', 6, 'ethereum'),('Tether USD Lending Fluid Vault', 0xc88f84f97d69cc8ade7b54e419a25c084724e952, 0xdac17f958d2ee523a2206206994597c13d831ec7, 'USDT', 6, 'ethereum'),('TAC cbBTC Morpho Vault', 0xb02a51a97322479821437da138bd7db6140306e1, 0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf, 'cbBTC', 8, 'ethereum'),('Steakhouse USDT', 0x895a1603af16d28cf40c6d45d19706231191017c, 0xdac17f958d2ee523a2206206994597c13d831ec7, 'USDT', 6, 'ethereum'),('Re7 USDT Vault', 0xe4074efdfc6f050f4ff4211f7df631354b29de08, 0xdac17f958d2ee523a2206206994597c13d831ec7, 'USDT', 6, 'ethereum'),('Gauntlet USDT Prime', 0x4fb2ef0b74f6b4162ac0db8c1483916510c2586a, 0xdac17f958d2ee523a2206206994597c13d831ec7, 'USDT', 6, 'ethereum'),('Gauntlet USDC Prime Vault', 0x57611bb55480cab730206e02883c8764f7dd5cb2, 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48, 'USDC', 6, 'ethereum'),('Gauntlet USDC Frontier Morpho Vault', 0x1ca5437300c782d33045c03597654495e379f65a, 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48, 'USDC', 6, 'ethereum'),('Gauntlet USDC Prime Morpho Vault', 0xe416629449596a76ad12823178aa3d97f3894b7d, 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 'USDC', 6, 'base'),('Gauntlet USDC Prime Morpho Vault', 0xa643e29fef6d154cf925f656b4ff85b46a98e12b, 0x0b2c639c533813f4aa9d7837caf62653d097ff85, 'USDC', 6, 'optimism'),('Gauntlet LRT Core Morpho Vault', 0xfd35adcf137d4c4639e724d36f9e05f9897a4d9c, 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2, 'WETH', 18, 'ethereum'),('Fluid WETH Vault', 0x21409c430ecb2d7659744101a14bb7d420b6adfb, 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2, 'WETH', 18, 'ethereum'),('Fluid USDC Vault', 0x6d93922d9b66b9985fd69cd0d958b3a935091108, 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48, 'USDC', 6, 'ethereum'),('Ethereum Gauntlet WBTC Core Morpho Vault', 0xc5a4ec2c04a4fc42a3cee5c622ecf9b5084e361d, 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599, 'WBTC', 8, 'ethereum'),('Gauntlet USDC Core', 0x86d941bdfacceeaa2f2dad79d5cebdc09f2c28bf, 0xaf88d065e77c8cc2239327c5edb3a432268e5831, 'USDC', 6, 'arbitrum'),('Ethena USDe Staking', 0x2bdc022ed8639f0b65a41aa60835b225ac074041, 0x4c9edd5852cd905f086c759e8383e09bff1e68b3, 'USDe', 18, 'ethereum'),('Gauntlet Compound USDT', 0x6377927bdce45f31a1028132ce0e6a900376447c, 0xc2132d05d31c914a87c6611c10748aeb04b58e8f, 'USDT0', 6, 'polygon'),('Gauntlet Compound USDC', 0xe3c4a5357d1a7c8b085881a0e8c429fb1878979f, 0x3c499c542cef5e3811e1192ce70d8cc03d5c3359, 'USDC', 6, 'polygon'),('Gauntlet cbBTC Core', 0x0ec405035bcf0843117508b12cd1050c370407ef, 0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf, 'cbBTC', 8, 'base'),('Frontier YO cbBTC', 0xedf7a39df0c3ac753b843787bdd62c19d5871d2f, 0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf, 'cbBTC', 8, 'base'),('DAI Yearn Vault V3', 0x936e48cc08ab9c4f393a056b57dfc40ce91799cd, 0x6b175474e89094c44da98b954eedeac495271d0f, 'DAI', 18, 'ethereum'),('Fluid WETH Vault', 0xfde448d21d63b531e9ef39a1e702b680c80c499c, 0x82af49447d8a07e3bd95bd0d56f35241523fbab1, 'WETH', 18, 'arbitrum'),('Fluid USDC Vault', 0x72307662b090e16073d18de13d4548efdb16b4de, 0xaf88d065e77c8cc2239327c5edb3a432268e5831, 'USDC', 6, 'arbitrum'),('ARB-1 yVault Yearn Vault V3', 0x48b52a30e8759ffaee0455670f985ebb79198fc1, 0x912ce59144191c1204e64559fe8253a0e49e6548, 'ARB', 18, 'arbitrum'),('USDT Aave Lending', 0xc1f4e992d91a2c416ac590d82c20f58369e071fb, 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9, 'USDT0', 6, 'arbitrum'),('USDC Aave Lending', 0x8f78dee52bfc209248ca8ff6ad1b527fa6fa55c4, 0xaf88d065e77c8cc2239327c5edb3a432268e5831, 'USDC', 6, 'arbitrum')) AS t(vault_name, proxy_address, asset_address, asset_symbol, asset_decimals, blockchain)),pricing AS (SELECTDATE_TRUNC('day', minute) AS day,blockchain,contract_address,AVG(price) AS priceFROM prices.usd