Query editor
-- Reah vault activity across all OAV vaults.WITH vaults AS (SELECT * FROM (VALUES-- vault_name, proxy_address, asset_address (deposit asset = gateway token), asset_symbol, asset_decimals, blockchain('Reah Gauntlet USDC Prime Vault', 0xae63325df4c27376f9d46059fd1c36019c8ad5ac, 0x8c106eedad96553e64287a5a6839c3cc78afa3d0, 'gtusdcp', 18, 'ethereum'),('Reah Gauntlet USDC Prime Vault', 0x0beae7efc6c7c83eab05db38b2313d81b46059b3, 0x050ce30b927da55177a4914ec73480238bad56f0, 'gtUSDC', 18, 'base'),('Reah Gauntlet USDC Prime Vault 2', 0xf809fccc48df108d92df4c1dd3610ba9feff47f6, 0x050ce30b927da55177a4914ec73480238bad56f0, 'gtUSDC', 18, 'base'),('Reah Gauntlet USDC Prime Vault 2', 0x0e6cacc905de5117e131d610b178b28ef4e84adc, 0x8c106eedad96553e64287a5a6839c3cc78afa3d0, 'gtusdcp', 18, 'ethereum'),('Reah Gauntlet USDC Vault', 0xe9915e300407ca84910ad976406a0053cabfff6e, 0xdd0f28e19c1780eb6396170735d45153d261490d, 'gtUSDC', 18, 'ethereum'),('Reah Gauntlet USDC Prime Vault', 0x9fa299522e0075250b94b3e45f0bb769a0560246, 0xee8f4ec5672f09119b96ab6fb59c27e1b7e44b61, 'gtUSDC', 18, 'base'),('Reah Gauntlet WETH Vault', 0x764b5f3616745c38af9dbce2e907e7da41c1d45e, 0x2371e134e3455e0593363cbf89d3b6cf53740618, 'gtWETH', 18, 'ethereum'),('Reah Gauntlet USDC Vault 2', 0x87426f2020a0400c40b742363051b3466b0c3ddb, 0xdd0f28e19c1780eb6396170735d45153d261490d, 'gtUSDC', 18, 'ethereum'),('Reah Gauntlet USDC Prime Vault 2', 0x985b9fbfea318ee0962e7e591288e6423c401142, 0xee8f4ec5672f09119b96ab6fb59c27e1b7e44b61, 'gtUSDC', 18, 'base'),('Reah Gauntlet WETH Vault 2', 0x51a7e70d85668cb3d9f31b6994920ebf0d15f93f, 0x2371e134e3455e0593363cbf89d3b6cf53740618, 'gtWETH', 18, 'ethereum'),('Reah Savings USDS 2', 0xc112341441d7197e908e38296b1457d8c7ce064b, 0x3132e002cd82eb33f120b627e0f49ef5f97c7b90, 'sUSDSg', 18, 'ethereum'),('Reah Spark Savings USDT 2', 0xa360e844790be3a13e72beabb8bb3e94198207bf, 0x583156ff3bb63a70a6a5bb311754fd0d6cb327ba, 'spUSDT', 6, 'ethereum'),('Reah Spark Savings USDC 2', 0x8ead252e5fc3ec2386dfa860f21abf70b4967a75, 0xcde73fadeb398b5d307db0ddef7f37f23459cc87, 'spUSDC', 6, 'ethereum'),('Reah Spark Savings USDC', 0xadcabae264a690a2ecc456e08e26c491ef055557, 0xcde73fadeb398b5d307db0ddef7f37f23459cc87, 'spUSDC', 6, 'ethereum'),('Reah Spark Savings USDT', 0x0856e899dc180c7a9a0d0372852b896800b2a6ad, 0x583156ff3bb63a70a6a5bb311754fd0d6cb327ba, 'spUSDT', 6, 'ethereum'),('Reah Savings USDS', 0x762611701a9e5400af570b85fea05d617f07a268, 0x3132e002cd82eb33f120b627e0f49ef5f97c7b90, 'sUSDSg', 18, 'ethereum')) 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.usdWHERE blockchain IN ('ethereum','base')AND contract_address IN (SELECT DISTINCT asset_address FROM vaults)GROUP BY 1, 2, 3),-- fallback prices for assets without a direct feed:-- sUSDS for the Savings vaults; WETH for gtWETH; 1.0 handled inline for USD-stablesfallback_pricing AS (SELECTDATE_TRUNC('day', minute) AS day,MAX(CASE WHEN contract_address = 0xa3931d71877c0e7a3148cb7eb4463524fec27fbd THEN price END) AS susds_price,MAX(CASE WHEN contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 THEN price END) AS weth_priceFROM prices.usdWHERE blockchain = 'ethereum'AND contract_address IN (0xa3931d71877c0e7a3148cb7eb4463524fec27fbd, -- sUSDS0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2) -- WETHGROUP BY 1),all_logs AS (SELECT 'ethereum' AS blockchain, contract_address, topic0, topic1, data, block_time, tx_hash FROM ethereum.logsWHERE topic0 IN (0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7,0xfbde797d201c681b91056529119e0b02407c7bb96a4a2c75c01fc9667232c8db)UNION ALLSELECT 'base', contract_address, topic0, topic1, data, block_time, tx_hash FROM base.logsWHERE topic0 IN (0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7,0xfbde797d201c681b91056529119e0b02407c7bb96a4a2c75c01fc9667232c8db))SELECTevt_block_time,action,vault_name,