Query editor
-- USDC vaults on Base: net flow from 14 days before to 30 days after the last reward day of each ended reward window.-- Reads ERC-4626 deposit and withdraw events of every USDC vault on Base, daily token prices, creation traces 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.-- 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. Vaults and vault adapters are not counted as depositors. One address is one row; an address is not a person.-- For each window, cumulative deposits less withdrawals since day -14 over the vault balance on day -14. The median and quartiles are taken across windows of each kind.-- Window kind: Shared schedule = five or more vaults ended on the same day; Relisted = a new listing began on the vault 15 to 90 days after the end; Clean = neither. Windows with 100,000 US dollars or more on day -14.-- A kind of window is shown only where five or more windows of that kind have data. The median and the quartiles are rounded to six decimal places.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'),