Query editor
WITH date_filters AS (-- Adjust these dates based on your needs to reduce data volumeSELECTDATE('2025-06-25') as start_date,DATE('2026-08-01') as end_date),data as(SELECT 'ethereum' AS chain, 1 AS chain_id, DATE_TRUNC('day', logs.block_time) AS dt, contract_address, topic0, logs.tx_hash, tx_from, tx_to,varbinary_to_uint256(varbinary_substring(logs.data, 1, 32)) AS amount1,CASE WHEN varbinary_ltrim(varbinary_substring(logs.data, 33, 32)) = 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee THEN 0x0000000000000000000000000000000000000000 ELSE varbinary_ltrim(varbinary_substring(logs.data, 33, 32)) END AS from_token,CASE WHEN varbinary_ltrim(varbinary_substring(logs.data, 65, 32)) = 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee THEN 0x0000000000000000000000000000000000000000 ELSE varbinary_ltrim(varbinary_substring(logs.data, 65, 32)) END AS to_token,varbinary_to_uint256(varbinary_substring(logs.data, 97, 32)) AS to_chain_id,CASE WHEN varbinary_ltrim(varbinary_substring(logs.data, 129, 32)) = 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee THEN 0x0000000000000000000000000000000000000000 ELSE varbinary_ltrim(varbinary_substring(logs.data, 129, 32)) END AS bridge_used,varbinary_to_uint256(varbinary_substring(varbinary_ltrim(varbinary_substring(logs.data, 225, 32)), GREATEST(1, varbinary_length(varbinary_ltrim(varbinary_substring(logs.data, 225, 32))) - 3), 4)) AS integrator_idFROM ethereum.logs logsJOIN ethereum.transactions txns ON logs.tx_hash = txns.hash CROSS JOIN date_filters dfWHERE logs.contract_address IN (0x3a23F943181408EAC424116Af7b7790c94Cb97a5)AND logs.topic0 IN (0x62e24e0f5ff17555bb43febccccf2721375425fdd421652271b70f05afe0ae64)AND txns.success = true and txns.block_time >= df.start_date and txns.block_time <= df.end_dateUNION ALLSELECT 'optimism' AS chain, 10 AS chain_id, DATE_TRUNC('day', logs.block_time) AS dt, contract_address, topic0, logs.tx_hash, tx_from, tx_to,varbinary_to_uint256(varbinary_substring(logs.data, 1, 32)) AS amount1,CASE WHEN varbinary_ltrim(varbinary_substring(logs.data, 33, 32)) = 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee THEN 0x0000000000000000000000000000000000000000 ELSE varbinary_ltrim(varbinary_substring(logs.data, 33, 32)) END AS from_token,CASE WHEN varbinary_ltrim(varbinary_substring(logs.data, 65, 32)) = 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee THEN 0x0000000000000000000000000000000000000000 ELSE varbinary_ltrim(varbinary_substring(logs.data, 65, 32)) END AS to_token,varbinary_to_uint256(varbinary_substring(logs.data, 97, 32)) AS to_chain_id,CASE WHEN varbinary_ltrim(varbinary_substring(logs.data, 129, 32)) = 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee THEN 0x0000000000000000000000000000000000000000 ELSE varbinary_ltrim(varbinary_substring(logs.data, 129, 32)) END AS bridge_used,varbinary_to_uint256(varbinary_substring(varbinary_ltrim(varbinary_substring(logs.data, 225, 32)), GREATEST(1, varbinary_length(varbinary_ltrim(varbinary_substring(logs.data, 225, 32))) - 3), 4)) AS integrator_idFROM optimism.logs logsJOIN optimism.transactions txns ON logs.tx_hash = txns.hash CROSS JOIN date_filters dfWHERE logs.contract_address IN (0x3a23F943181408EAC424116Af7b7790c94Cb97a5)AND logs.topic0 IN (0x62e24e0f5ff17555bb43febccccf2721375425fdd421652271b70f05afe0ae64)AND txns.success = true and txns.block_time >= df.start_date and txns.block_time <= df.end_dateUNION ALLSELECT 'base' AS chain, 8453 AS chain_id, DATE_TRUNC('day', logs.block_time) AS dt, contract_address, topic0, logs.tx_hash, tx_from, tx_to,varbinary_to_uint256(varbinary_substring(logs.data, 1, 32)) AS amount1,CASE WHEN varbinary_ltrim(varbinary_substring(logs.data, 33, 32)) = 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee THEN 0x0000000000000000000000000000000000000000 ELSE varbinary_ltrim(varbinary_substring(logs.data, 33, 32)) END AS from_token,CASE WHEN varbinary_ltrim(varbinary_substring(logs.data, 65, 32)) = 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee THEN 0x0000000000000000000000000000000000000000 ELSE varbinary_ltrim(varbinary_substring(logs.data, 65, 32)) END AS to_token,varbinary_to_uint256(varbinary_substring(logs.data, 97, 32)) AS to_chain_id,CASE WHEN varbinary_ltrim(varbinary_substring(logs.data, 129, 32)) = 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee THEN 0x0000000000000000000000000000000000000000 ELSE varbinary_ltrim(varbinary_substring(logs.data, 129, 32)) END AS bridge_used,varbinary_to_uint256(varbinary_substring(varbinary_ltrim(varbinary_substring(logs.data, 225, 32)), GREATEST(1, varbinary_length(varbinary_ltrim(varbinary_substring(logs.data, 225, 32))) - 3), 4)) AS integrator_idFROM base.logs logsJOIN base.transactions txns ON logs.tx_hash = txns.hash CROSS JOIN date_filters dfWHERE logs.contract_address IN (0x3a23F943181408EAC424116Af7b7790c94Cb97a5)AND logs.topic0 IN (0x62e24e0f5ff17555bb43febccccf2721375425fdd421652271b70f05afe0ae64)AND txns.success = true and txns.block_time >= df.start_date and txns.block_time <= df.end_dateUNION ALL