Query editor
WITH route_events AS (SELECTevt_tx_hash,evt_block_date,tokenIn,amountIn,chain,referralCodeFROM sushiswap_multichain.routeprocessor11_evt_routeWHERE evt_block_date >= TIMESTAMP '2026-10-15' AND chain = '{{chain}}')SELECTr.evt_block_date AS block_date,SUM(t.amount_usd) AS total_amount_in_usd,CASE r.referralCodeWHEN 1 THEN 'sushi'WHEN 2 THEN 'lifi'WHEN 3 THEN 'relay'WHEN 4 THEN 'bebop'WHEN 5 THEN 'lfg'WHEN 6 THEN 'enso'WHEN 7 THEN 'vfat'WHEN 8 THEN 'rango'WHEN 9 THEN 'beam'WHEN 10 THEN 'orbs'WHEN 11 THEN 'dcent'WHEN 12 THEN 'kensei'WHEN 13 THEN 'extalia'WHEN 14 THEN 'kodachi'WHEN 15 THEN 'houdini'WHEN 16 THEN 'rabby'ELSE 'Unknown'END AS referrerFROM route_events rJOIN tokens.transfers tON t.tx_hash = r.evt_tx_hashAND t.contract_address = r.tokenInAND t.amount_raw = r.amountInAND t.blockchain = '{{chain}}'AND t.block_date = r.evt_block_dateGROUP BY r.evt_block_date, r.referralCodeORDER BY block_date