Query editor
-- USDC vaults on Base with ended reward windows: the weekly rate at which addresses leave a vault entirely, against the rate gap, by account type and deposit size.-- 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.-- An address holds a vault once its balance reaches 10 US dollars and has left once it falls under 1. exit_rate = exits during the week over addresses holding at its start plus those that arrived during it,-- pooled over vault-weeks in each rate-gap band, from the first reward day to 90 days after the last. Size is the address's total deposits into that vault.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'),