Query editor
-- Which tokens does each Glider portfolio deal in? Needed to read exact balances on-chain.WITH legs AS (SELECT "from" AS vault, contract_address AS token FROM erc20_bnb.evt_transferWHERE "to" IN (0x7e2b68118307ec9669573905de52e394c36399c8, 0x7c5bb330ea12806b2340d7ddba2c062b9c840728)AND evt_block_date >= DATE '2026-06-01'UNIONSELECT "to", contract_address FROM erc20_bnb.evt_transferWHERE "from" IN (0x7e2b68118307ec9669573905de52e394c36399c8, 0x7c5bb330ea12806b2340d7ddba2c062b9c840728)AND evt_block_date >= DATE '2026-06-01')SELECT token, COUNT(DISTINCT vault) AS n_vaultsFROM legsGROUP BY 1ORDER BY n_vaults DESC