Query editor
-- Reward size and rate gap for each ended reward window on a USDC vault on Base.-- Reads ERC-4626 deposit and withdraw events of every USDC vault on Base, daily token prices, and the public reward listings (reward token and amount per listing, spread evenly over its days).-- Vault balance = shares outstanding from those events times the last dealt price per share. Native rate = 7-day change in price per share, annualised.-- Reward rate = listed reward per day at that day's token price, times 365, over the vault's average balance of the prior 7 days; a listing with a stated rate ceiling is held to it.-- For gated windows the reward is spread over the whole vault because the eligible balance is not readable, so the rate eligible depositors saw was higher.-- Rate gap = native rate plus reward rate, less the balance-weighted native rate that day of every Base USDC vault with 1 million US dollars or more.-- Rewards in tokens with no price in the daily price table are not counted and the window is flagged.WITH ep (vault, ep_no, win_start, last_day, eligibility, window_kind) AS (VALUES(0x6603a15d26a60868074a586643c4239e6a93d425, 1, DATE '2025-07-16', DATE '2025-07-23', 'Gated', 'Clean'),(0x67f062a12f82c3b42d4ca7a35fb26cbaac28008b, 1, DATE '2025-09-10', DATE '2025-11-10', 'Gated', 'Clean'),(0xbeefa74640a5f7c28966cba82466eed5609444e0, 1, DATE '2025-07-29', DATE '2025-11-20', 'Open', 'Relisted'),(0x085178078796da17b191f9081b5e2fccc79a7ee7, 1, DATE '2025-07-23', DATE '2025-09-27', 'Open', 'Clean'),(0x8773447e6369472d9b72f064ea62e405216e9084, 1, DATE '2025-09-30', DATE '2026-01-27', 'Open', 'Clean'),(0x12afdefb2237a5963e7bab3e2d46ad0eee70406e, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x23479229e52ab6aad312d0b03df9f33b46753b5e, 1, DATE '2025-07-07', DATE '2026-03-23', 'Open', 'Clean'),(0xfc8a325a2403cd940649b48ffcdfc250e084a27c, 1, DATE '2025-08-30', DATE '2026-01-14', 'Open', 'Clean'),(0xbb2f06ceae42cbcf5559ed0713538c8892d977c9, 1, DATE '2025-12-31', DATE '2026-01-31', 'Open', 'Shared schedule'),(0xbeefe1372c0a384acecbe8a0adf3c94c389f6704, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0xebc997b855b9a4e0b6cd06e4758801e6ff068e07, 1, DATE '2025-12-31', DATE '2026-01-28', 'Open', 'Relisted'),(0xebc997b855b9a4e0b6cd06e4758801e6ff068e07, 2, DATE '2026-03-01', DATE '2026-04-01', 'Open', 'Shared schedule'),(0x730c343fa71be75454b720677b18a6697452197c, 1, DATE '2025-07-23', DATE '2025-08-08', 'Gated', 'Clean'),(0x44058d4ed9ecc5752cecd6929a6d20b430f18e78, 1, DATE '2025-07-23', DATE '2025-08-08', 'Gated', 'Clean'),(0xf17182f6f28ded63b77a2bb774c58ade44612be4, 1, DATE '2025-03-31', DATE '2025-07-31', 'Open', 'Clean'),(0xbc246dc3b5e27e9561ebb8179805ca92580b8655, 1, DATE '2025-09-29', DATE '2025-11-29', 'Open', 'Relisted'),(0xbc246dc3b5e27e9561ebb8179805ca92580b8655, 2, DATE '2025-12-31', DATE '2026-04-30', 'Open', 'Clean'),(0xe74c499fa461af1844fca84204490877787ced56, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0xe74c499fa461af1844fca84204490877787ced56, 2, DATE '2026-03-01', DATE '2026-04-01', 'Open', 'Shared schedule'),(0xd37f32464461b51a739e0d8f7a4ab99be6d4fa36, 1, DATE '2025-09-30', DATE '2025-11-20', 'Open', 'Clean'),(0xf6190f97f7ae540234f5924b8992b9c3fd8381b9, 1, DATE '2025-06-04', DATE '2026-05-04', 'Open', 'Clean'),(0xf6190f97f7ae540234f5924b8992b9c3fd8381b9, 2, DATE '2026-09-14', DATE '2026-11-13', 'Open', 'Clean'),(0x8f687de48b35a327bac42ca93328cd07844d5de1, 1, DATE '2025-09-29', DATE '2026-03-27', 'Open', 'Clean'),(0x1401d1271c47648ac70cbcdfa3776d4a87ce006b, 1, DATE '2025-10-31', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x887ab67a3eec0289fefc2cc7fab73473e133866a, 1, DATE '2025-07-16', DATE '2025-07-23', 'Gated', 'Clean'),(0x2c6d169782bf18cc634d076fe639092227b82fda, 1, DATE '2025-09-30', DATE '2026-01-31', 'Open', 'Shared schedule'),(0xcd347c1e7d600a9a3e403497562edd0a7bc3ef21, 1, DATE '2025-07-29', DATE '2025-09-30', 'Open', 'Shared schedule'),(0x3ac2bbd41d7a92326da602f072d40255dd8d23a2, 1, DATE '2025-07-29', DATE '2025-08-29', 'Open', 'Clean'),(0x3ac2bbd41d7a92326da602f072d40255dd8d23a2, 2, DATE '2025-12-31', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x1d3b1cd0a0f242d598834b3f2d126dc6bd774657, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x1d3b1cd0a0f242d598834b3f2d126dc6bd774657, 2, DATE '2026-03-01', DATE '2026-04-01', 'Open', 'Shared schedule'),(0x07954beb7e137101a7cbb3e47864c684aec50524, 1, DATE '2026-06-04', DATE '2026-06-26', 'Open', 'Clean'),(0xcbeef01994e24a60f7dcb8de98e75ad8bd4ad60d, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0xedc817a28e8b93b03976fbd4a3ddbc9f7d176c22, 1, DATE '2024-07-09', DATE '2024-09-03', 'Open', 'Clean'),(0xcddcdd18a16ed441f6cb10c3909e5e7ec2b9e8f3, 1, DATE '2025-07-29', DATE '2025-09-30', 'Open', 'Shared schedule'),(0xcddcdd18a16ed441f6cb10c3909e5e7ec2b9e8f3, 2, DATE '2025-10-31', DATE '2025-12-24', 'Open', 'Relisted'),(0x75e1a1f9535c01cdce25e51ea4aff0d171337e1f, 1, DATE '2025-10-31', DATE '2026-01-31', 'Open', 'Shared schedule'),(0xe1ba476304255353aef290e6474a417d06e7b773, 1, DATE '2025-10-10', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x616a4e1db48e22028f6bbf20444cd3b8e3273738, 1, DATE '2025-07-29', DATE '2026-03-03', 'Open', 'Clean'),(0xc063c3b3625df5f362f60f35b0bcd98e0fa650fb, 1, DATE '2025-01-22', DATE '2025-02-21', 'Open', 'Clean'),(0x50b5b81fc8b1f1873ec7f31b0e98186ba008814d, 1, DATE '2025-07-29', DATE '2025-09-30', 'Open', 'Shared schedule'),(0xef417a2512c5a41f69ae4e021648b69a7cde5d03, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x5752ae1309a19a0d210fd20f4911ca0e1130f4b5, 1, DATE '2025-09-30', DATE '2026-03-27', 'Open', 'Clean'),(0x8a034f069d59d62a4643ad42e49b846d036468d7, 1, DATE '2025-09-30', DATE '2025-12-21', 'Open', 'Relisted'),(0x5435bc53f2c61298167cdb11cdf0db2bfa259ca0, 1, DATE '2025-10-31', DATE '2026-06-30', 'Open', 'Clean'),(0x687dfecd7950a17236c51b517fae2f9279ffc88d, 1, DATE '2025-07-29', DATE '2025-08-30', 'Open', 'Clean'),(0x76238b005dcd48460c2dcce51c92049065702605, 1, DATE '2025-07-29', DATE '2025-09-30', 'Open', 'Shared schedule'),(0x3094b241aade60f91f1c82b0628a10d9501462f9, 1, DATE '2025-09-18', DATE '2025-11-06', 'Open', 'Relisted'),(0x3094b241aade60f91f1c82b0628a10d9501462f9, 2, DATE '2025-12-31', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x3094b241aade60f91f1c82b0628a10d9501462f9, 3, DATE '2026-03-01', DATE '2026-04-01', 'Open', 'Shared schedule'),(0xee8f4ec5672f09119b96ab6fb59c27e1b7e44b61, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x4c1aeda9b43efcf1da1d1755b18802aabe90f61e, 1, DATE '2025-11-10', DATE '2025-11-24', 'Open', 'Clean'),