Query editor
-- A comparison for the reward windows: the same reading on USDC vaults on Base that had no reward change around the same dates.-- For the six pairs of window start and end dates that hold the most principal, every other Base USDC vault with 5 million US dollars or more of deposits and no reward listing starting or ending-- from 30 days before to 90 days after the end date is given the same dates, and the money wallets deposited between them is followed in the same way. Vaults never listed and vaults listed throughout both qualify.-- 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 epr (vault, ep_no, win_start, last_day, eligibility, window_kind) AS (VALUES(0x12afdefb2237a5963e7bab3e2d46ad0eee70406e, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0xbeefe1372c0a384acecbe8a0adf3c94c389f6704, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0xe74c499fa461af1844fca84204490877787ced56, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x1401d1271c47648ac70cbcdfa3776d4a87ce006b, 1, DATE '2025-10-31', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x2c6d169782bf18cc634d076fe639092227b82fda, 1, DATE '2025-09-30', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x1d3b1cd0a0f242d598834b3f2d126dc6bd774657, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0xcbeef01994e24a60f7dcb8de98e75ad8bd4ad60d, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x75e1a1f9535c01cdce25e51ea4aff0d171337e1f, 1, DATE '2025-10-31', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x616a4e1db48e22028f6bbf20444cd3b8e3273738, 1, DATE '2025-07-29', DATE '2026-03-03', 'Open', 'Clean'),(0xef417a2512c5a41f69ae4e021648b69a7cde5d03, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0xee8f4ec5672f09119b96ab6fb59c27e1b7e44b61, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0xb7890cee6cf4792cdcc13489d36d9d42726ab863, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0xbeef010f9cb27031ad51e3333f9af9c6b1228183, 1, DATE '2025-07-29', DATE '2026-07-22', 'Gated', 'Clean'),(0x050ce30b927da55177a4914ec73480238bad56f0, 1, DATE '2025-10-31', DATE '2026-01-31', 'Open', 'Shared schedule'),(0xbeefe94c8ad530842bfe7d8b397938ffc1cb83b2, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0xc0c5689e6f4d256e861f65465b691aeecc0deb12, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x0a1a3b5f2041f33522c4efc754a7d096f880ee16, 1, DATE '2025-01-07', DATE '2025-06-12', 'Open', 'Clean'),(0xbeefa7b88064feef0cee02aaebbd95d30df3878f, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x236919f11ff9ea9550a4287696c2fc9e18e6e890, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule'),(0x7bfa7c4f149e7415b73bdedfe609237e29cbf34a, 1, DATE '2025-07-29', DATE '2026-01-31', 'Open', 'Shared schedule')),bnd (vault, day) AS (VALUES(0x0000f0bcf156ec9fca2510b3200f87609e34cf5d, DATE '2026-01-15'),(0x0000f0bcf156ec9fca2510b3200f87609e34cf5d, DATE '2026-01-17'),(0x00cc39b44f74ad55fcb958925e2f4978c1466f7c, DATE '2026-01-15'),(0x00cc39b44f74ad55fcb958925e2f4978c1466f7c, DATE '2026-01-31'),(0x00cc39b44f74ad55fcb958925e2f4978c1466f7c, DATE '2026-06-18'),(0x00cc39b44f74ad55fcb958925e2f4978c1466f7c, DATE '2027-01-08'),(0x01afd5fa7e69ce5f506c166d2fcbfb12488412af, DATE '2026-01-15'),(0x01afd5fa7e69ce5f506c166d2fcbfb12488412af, DATE '2026-01-31'),(0x01afd5fa7e69ce5f506c166d2fcbfb12488412af, DATE '2026-06-18'),(0x01afd5fa7e69ce5f506c166d2fcbfb12488412af, DATE '2027-01-08'),(0x0282159eccaaba941bd1f4c518944d8fdcdc0681, DATE '2026-01-21'),(0x0282159eccaaba941bd1f4c518944d8fdcdc0681, DATE '2026-01-31'),(0x050ce30b927da55177a4914ec73480238bad56f0, DATE '2025-10-31'),(0x050ce30b927da55177a4914ec73480238bad56f0, DATE '2026-01-31'),(0x054f6824862b2614a580f572088e9629a5bba66f, DATE '2026-01-15'),(0x054f6824862b2614a580f572088e9629a5bba66f, DATE '2026-01-31'),(0x05d8fcc9ad3538c55b1045f1afae34b807f092ba, DATE '2026-01-15'),(0x05d8fcc9ad3538c55b1045f1afae34b807f092ba, DATE '2026-01-31'),(0x07954beb7e137101a7cbb3e47864c684aec50524, DATE '2026-06-04'),(0x07954beb7e137101a7cbb3e47864c684aec50524, DATE '2026-06-26'),(0x085178078796da17b191f9081b5e2fccc79a7ee7, DATE '2025-07-23'),