Query editor
WITH date_filters AS (-- Adjust these dates based on your needs to reduce data volumeSELECTDATE('2026-09-01') as start_date,DATE('2026-10-01') as end_date),all_logs AS (-- EthereumSELECT'ethereum' AS chain,logs.tx_hash,logs.topic1 as request_hash,txns.block_time AS date_time,logs.contract_address,txns.to as tx_solver,txns."from" as tx_from,logs.topic0,logs.dataFROM ethereum.logs logsJOIN ethereum.transactions txns ON logs.tx_hash = txns.hashCROSS JOIN date_filters dfWHERE logs.contract_address IN (0xe772551F88E2c14aEcC880dF6b7CBd574561bf82)AND logs.topic0 IN (-- 0x14a241d5b404d2061ceb9a847972acfd690983f1d8a0fef9779b8191aa1b7ef2,0xd83e4fbd120e768f3bb813ecfa1a2b16c323fa7dfa07db1cd6434b3cbc97bc75)and txns.success = trueand txns.block_time >= df.start_dateand txns.block_time <= df.end_dateUNION ALL-- optimismSELECT'optimism' AS chain,logs.tx_hash,logs.topic1 as request_hash,txns.block_time AS date_time,logs.contract_address,txns.to as tx_solver,txns."from" as tx_from,logs.topic0,logs.dataFROM optimism.logs logsJOIN optimism.transactions txns ON logs.tx_hash = txns.hashCROSS JOIN date_filters dfWHERE logs.contract_address IN (0x09DAbdD517Ff1e155DeDEF64EC629Ca0285a31af)AND logs.topic0 IN (-- 0x14a241d5b404d2061ceb9a847972acfd690983f1d8a0fef9779b8191aa1b7ef2,0xd83e4fbd120e768f3bb813ecfa1a2b16c323fa7dfa07db1cd6434b3cbc97bc75)and txns.success = trueand txns.block_time >= df.start_dateand txns.block_time <= df.end_date