Query editor
WITH per_tx AS (SELECTevt_tx_hash AS tx_hash,chain,CASE 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'ELSE 'Unknown'END AS referrerFROM sushiswap_multichain.routeprocessor7_evt_routeWHERE evt_block_time >= TIMESTAMP '2025-05-01'UNION ALLSELECTevt_tx_hash AS tx_hash,chain,CASE 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'ELSE 'Unknown'END AS referrerFROM sushiswap_multichain.routeprocessor8_evt_routeWHERE evt_block_time >= TIMESTAMP '2025-05-01'UNION ALLSELECTevt_tx_hash AS tx_hash,chain,CASE 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'ELSE 'Unknown'END AS referrerFROM sushiswap_multichain.routeprocessor9_evt_routeWHERE evt_block_time >= TIMESTAMP '2025-08-21'UNION ALLSELECTevt_tx_hash AS tx_hash,chain,CASE referralCodeWHEN 1 THEN 'sushi'