Query editor
-- How much of the money deposited into USDC vaults on Base during reward windows had just arrived on Base: USDC minted to the depositing address through the cross-chain transfer protocol in the 7 days before its first deposit in the window.-- Reads USDC transfers on Base from the zero address besides the sources named below. Only mints to the depositing address itself are seen; money bridged another way or to another address is not.-- USDC vaults on Base whose public reward windows have ended: what happened to the money deposited while rewards ran.-- Reads ERC-4626 deposit and withdraw events of every USDC vault on Base, the curated supply table for pooled USDC lending on Base, creation traces and public address lists.-- Reward windows are the public reward listings on each vault, joined into one window where listings follow each other within 14 days. Gated means the listing limited who could earn.-- 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.-- Everything is counted in shares at cost, so yield is in no figure. New shares held at a checkpoint = shares held then less shares held before the window, between zero and the shares-- minted by the window's deposits. New principal = window deposits times new shares held over shares minted. stayed_* = new principal at N days, capped at the last-reward-day amount,-- over new principal on the last reward day. never_left_* uses the lowest share balance between the last reward day and day N, so money that left and came back is not counted.-- Panels: 7, 30 and 90 days on windows that ended 90 days or more before the cutoff; 365 days on windows that ended a year or more before. Share transfers between addresses are not followed.-- Same-day round trips: deposits an address withdrew again from the same vault on the same day are netted out in deposited_usd_net_of_same_day_round_trips; share figures on new principal are not affected by them.-- Safes are split by how many Base USDC vaults the Safe has deposited into; three or more marks an account that is moved between vaults.-- New address: no USDC lending balance on Base (vaults or pooled lending) in the 90 days before its first deposit in the window. Moved: window deposits matched by the same address-- withdrawing USDC from another Base vault or pooled lender in the 7 days before. Wallets = plain wallets, app-factory smart wallets and Safes; Contracts = every other contract and registry allocators.-- One address is one row; an address is not a person. Windows with under 100,000 USDC deposited or under 10 depositing addresses are left out.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'),