Query editor
-- Glider's router and fee collector are deployed on Ethereum too. Who trades with them?WITH legs AS (SELECT "from" AS counterparty, evt_block_time, contract_address AS tokenFROM erc20_ethereum.evt_transferWHERE "to" IN (0x7e2b68118307ec9669573905de52e394c36399c8, 0x7c5bb330ea12806b2340d7ddba2c062b9c840728)AND evt_block_date >= DATE '2026-06-01'UNION ALLSELECT "to", evt_block_time, contract_addressFROM erc20_ethereum.evt_transferWHERE "from" IN (0x7e2b68118307ec9669573905de52e394c36399c8, 0x7c5bb330ea12806b2340d7ddba2c062b9c840728)AND evt_block_date >= DATE '2026-06-01')SELECT counterparty, COUNT(*) AS n_legs, COUNT(DISTINCT token) AS n_tokens,MIN(evt_block_time) AS first_seen, MAX(evt_block_time) AS last_seenFROM legsWHERE counterparty NOT IN (0x7e2b68118307ec9669573905de52e394c36399c8,0x7c5bb330ea12806b2340d7ddba2c062b9c840728,0x0000000000000000000000000000000000000000)GROUP BY 1ORDER BY n_legs DESC