Query editor
-- Prepared v9, replacing the unexecuted Optimism-only v8 proposal.-- One Medium execution and one export <=10000 rows. No retries/pagination.-- Three known splitter addresses; all standards retain positive controls-- from independently collected token/native histories. Payouts are not fees.WITH transfers AS (SELECT blockchain, block_date, block_time, block_number, tx_hash, unique_key,"from" AS sender, "to" AS recipient, contract_address, token_standard,substr(symbol,1,32) AS symbol, amount_raw, amount, amount_usd,CASE blockchainWHEN 'optimism' THEN 0xdf0da156dd38077b9562c79a08973786b7439998WHEN 'katana' THEN 0x4a5f22cadb118d845d712b9d540297e295cb9994WHEN 'hyperevm' THEN 0xbf0a95b00ceba984b7c55352a45f7e68deeb6f05END AS splitterFROM tokens.transfersWHERE blockchain IN ('optimism', 'katana', 'hyperevm')AND block_month >= DATE '2026-01-01' AND block_month <= DATE '2026-11-01'AND block_date >= DATE '2026-01-01' AND block_date <= DATE '2026-11-18'AND block_time >= TIMESTAMP '2026-01-01 00:00:00 UTC'AND block_time < TIMESTAMP '2026-11-18 12:00:00 UTC'AND amount_raw > UINT256 '0'AND ((blockchain = 'optimism' AND block_month >= DATE '2026-07-01'AND block_number >= 154793510AND ("to" = 0xdf0da156dd38077b9562c79a08973786b7439998OR "from" = 0xdf0da156dd38077b9562c79a08973786b7439998))OR (blockchain = 'katana'AND ("to" = 0x4a5f22cadb118d845d712b9d540297e295cb9994OR "from" = 0x4a5f22cadb118d845d712b9d540297e295cb9994))OR (blockchain = 'hyperevm' AND block_number >= 17176082AND ("to" = 0xbf0a95b00ceba984b7c55352a45f7e68deeb6f05OR "from" = 0xbf0a95b00ceba984b7c55352a45f7e68deeb6f05)))), directed AS (SELECT *, CASE WHEN sender = splitter AND recipient = splitter THEN 'self_transfer'WHEN recipient = splitter THEN 'incoming' ELSE 'outgoing' END AS directionFROM transfers), grouped AS (SELECT blockchain, splitter, block_date, direction, sender, recipient,contract_address, token_standard, symbol,count(*) AS transfer_count, count(DISTINCT unique_key) AS distinct_transfer_count,count_if(amount_usd IS NOT NULL) AS priced_transfer_count,count_if(amount_usd IS NULL) AS unpriced_transfer_count,sum(amount_raw) AS amount_raw,sum(CASE WHEN amount_usd IS NULL THEN amount_raw ELSE UINT256 '0' END) AS unpriced_amount_raw,sum(amount) AS amount_display, sum(amount_usd) AS priced_transfers_usd,min(tx_hash) AS example_tx_hash,min(block_number) AS first_block_number, max(block_number) AS last_block_numberFROM directed GROUP BY 1,2,3,4,5,6,7,8,9)SELECT blockchain, concat('0x',lower(to_hex(splitter))) AS splitter,CAST(block_date AS VARCHAR) AS utc_day, direction,concat('0x',lower(to_hex(sender))) AS sender,concat('0x',lower(to_hex(recipient))) AS recipient,concat('0x',lower(to_hex(contract_address))) AS token_address,token_standard, symbol, transfer_count, distinct_transfer_count,priced_transfer_count, unpriced_transfer_count,CAST(amount_raw AS VARCHAR) AS amount_raw,CAST(unpriced_amount_raw AS VARCHAR) AS unpriced_amount_raw,CAST(amount_display AS VARCHAR) AS amount_display,CAST(priced_transfers_usd AS VARCHAR) AS priced_transfers_usd,