Query editor
-- Anchor: accounts whose delegations a Glider agent redeems are definitely Glider.-- Where do those accounts send tokens? Frequent non-DEX recipients reveal Glider's-- own fee collector / router on Base.WITH glider_vaults AS (SELECT DISTINCT bytearray_substring(topic1,13,20) AS vaultFROM base.logsWHERE contract_address = 0xdb9b1e94b5b69df7e401ddbede43491141047db3AND topic0 = 0x40dadaa36c6c2e3d7317e24757451ffb2d603d875f0ad5e92c5dd156573b1873AND topic2 IN (0x000000000000000000000000b01caea8c6c47bbf4f4b4c5080ca642043359c2e,0x000000000000000000000000b42f812a44c22cc6b861478900401ee759ebead6,0x000000000000000000000000c066ac5d385419b1a8c43a0e146fa439837a8b8c)AND block_date >= DATE '2026-09-01'),out AS (SELECT t."to" AS recipient, t.contract_address AS token, t.valueFROM erc20_base.evt_transfer tJOIN glider_vaults g ON g.vault = t."from"WHERE t.evt_block_date >= DATE '2026-09-01')SELECT recipient,COUNT(*) AS n_transfers,COUNT(DISTINCT token) AS n_tokens,APPROX_PERCENTILE(CAST(value AS double), 0.5) AS median_raw_valueFROM outGROUP BY 1ORDER BY n_transfers DESCLIMIT 40