Query editor
WITHtxs AS (SELECTblock_time,block_number,hash AS transaction_hash,"from" AS tx_from,"to" AS tx_to,NULL AS log_index,NULL AS topic0,NULL AS topic1,NULL AS topic2,NULL AS topic3,data AS tx_input,NULL AS log_data,'transaction' AS row_typeFROM arbitrum.transactionsWHERE "to" = 0xC0e8d7a022cFfff1EE9d9351fE9BfC917004D9f8),logs AS (SELECTblock_time,block_number,tx_hash AS transaction_hash,tx_from,tx_to,"index" AS log_index,topic0,topic1,topic2,topic3,NULL AS tx_input,data AS log_data,'event' AS row_typeFROM arbitrum.logsWHERE contract_address = 0xC0e8d7a022cFfff1EE9d9351fE9BfC917004D9f8)SELECT *FROM (SELECT * FROM txsUNION ALLSELECT * FROM logs) AS combinedORDER BY block_time DESCLIMIT 200;