Query editor
-- USDC vaults on Base with ended reward windows: weekly net flow against the rate gap, from the first reward day to 90 days after the last.-- 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.-- One unit is a vault-week with 100,000 US dollars or more at its start. net_flow = deposits less withdrawals in the week over the balance at its start, pooled over the vault-weeks in each rate-gap band.-- Three readings: all depositors, all but each vault's ten largest depositors, and wallets only (plain wallets, app-factory smart wallets and Safes). The gated vault is left out of the three and shown in its own column.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'),