Query editor
-- Is 0x7c5bb330... really Glider's integrator-fee sink, and who pays into it?-- Every Glider swap should route a small output-side fee here.WITH inflow AS (SELECT 'bnb' AS chain, t."from" AS payer, t.contract_address AS token,CAST(t.value AS double) AS raw_value, t.evt_block_timeFROM erc20_bnb.evt_transfer tWHERE t."to" = 0x7c5bb330ea12806b2340d7ddba2c062b9c840728AND t.evt_block_date >= DATE '2025-01-01'UNION ALLSELECT 'ethereum', t."from", t.contract_address, CAST(t.value AS double), t.evt_block_timeFROM erc20_ethereum.evt_transfer tWHERE t."to" = 0x7c5bb330ea12806b2340d7ddba2c062b9c840728AND t.evt_block_date >= DATE '2025-01-01')SELECT chain,COUNT(*) AS n_fee_payments,COUNT(DISTINCT payer) AS n_distinct_payers,COUNT(DISTINCT token) AS n_distinct_tokens,MIN(evt_block_time) AS first_fee,MAX(evt_block_time) AS last_feeFROM inflowGROUP BY 1