Query editor
-- =====================================================================-- Performance / harvest fee shares minted — REAH vaults only-- Harvested topic0 = 0xe48bba143e2a0b557fa6f3234bd6ffc704518cc98c7de6a2385549fae27d1b75-- data word0 = sharesMinted-- Window: 2026-03-01 .. 2026-07-02 (exclusive)-- =====================================================================WITHvaults AS (SELECT * FROM (VALUES-- client, vault_name, proxy_address, blockchain('Reah', 'Reah Gauntlet USDC Prime Vault', 0xae63325DF4c27376f9D46059fd1C36019c8ad5ac, 'ethereum'),('Reah', 'Reah Gauntlet USDC Prime Vault', 0x0BeAE7EfC6C7C83eab05dB38b2313d81B46059B3, 'base'),('Reah', 'Reah Gauntlet USDC Prime Vault 2', 0xF809FcCC48dF108d92dF4c1Dd3610bA9FEFF47f6, 'base'),('Reah', 'Reah Gauntlet USDC Prime Vault 2', 0x0e6caCC905de5117e131D610B178B28Ef4e84aDc, 'ethereum'),('Reah', 'Reah Gauntlet USDC Vault', 0xe9915E300407CA84910AD976406A0053cABffF6e, 'ethereum'),('Reah', 'Reah Gauntlet USDC Prime Vault', 0x9Fa299522e0075250b94b3e45F0BB769A0560246, 'base'),('Reah', 'Reah Gauntlet WETH Vault', 0x764b5F3616745c38AF9dbCE2E907e7DA41C1D45e, 'ethereum'),('Reah', 'Reah Gauntlet USDC Vault 2', 0x87426F2020a0400c40B742363051b3466b0c3DdB, 'ethereum'),('Reah', 'Reah Gauntlet USDC Prime Vault 2', 0x985b9fbFEA318Ee0962e7e591288e6423C401142, 'base'),('Reah', 'Reah Gauntlet WETH Vault 2', 0x51a7E70D85668Cb3D9F31b6994920eBf0D15F93f, 'ethereum'),('Reah', 'Reah Savings USDS 2', 0xc112341441D7197E908e38296b1457d8C7ce064B, 'ethereum'),('Reah', 'Reah Spark Savings USDT 2', 0xA360E844790Be3A13e72bEabb8Bb3e94198207bf, 'ethereum'),('Reah', 'Reah Spark Savings USDC 2', 0x8eaD252e5fc3eC2386DFA860F21ABf70b4967a75, 'ethereum'),-- v1 vaults (Ethereum)('Reah', 'Reah Spark Savings USDC', 0xAdcabae264A690a2ECc456e08e26C491Ef055557, 'ethereum'),('Reah', 'Reah Spark Savings USDT', 0x0856e899Dc180c7a9a0d0372852B896800b2a6aD, 'ethereum'),('Reah', 'Reah Savings USDS', 0x762611701A9E5400aF570b85fEa05D617F07a268, 'ethereum')) AS t(client, vault_name, proxy_address, blockchain)),harvests AS (SELECT 'ethereum' AS blockchain, l.contract_address,bytearray_to_uint256(bytearray_substring(l.data, 1, 32)) AS shares_mintedFROM ethereum.logs lJOIN vaults v ON v.blockchain = 'ethereum' AND l.contract_address = v.proxy_addressWHERE l.topic0 = 0xe48bba143e2a0b557fa6f3234bd6ffc704518cc98c7de6a2385549fae27d1b75AND l.block_time >= TIMESTAMP '2026-03-01'AND l.block_time < TIMESTAMP '2026-07-03'UNION ALLSELECT 'base', l.contract_address,bytearray_to_uint256(bytearray_substring(l.data, 1, 32))FROM base.logs lJOIN vaults v ON v.blockchain = 'base' AND l.contract_address = v.proxy_addressWHERE l.topic0 = 0xe48bba143e2a0b557fa6f3234bd6ffc704518cc98c7de6a2385549fae27d1b75AND l.block_time >= TIMESTAMP '2026-03-01'AND l.block_time < TIMESTAMP '2026-07-02'),agg AS (SELECTblockchain, contract_address,COUNT(*) AS harvest_count,SUM(CAST(shares_minted AS DECIMAL(38,0))) AS fee_shares_rawFROM harvestsGROUP BY 1, 2)SELECTv.client,