Query editor
WITH facet AS (-- EthereumSELECTblock_time,tx_hash,'ethereum' AS src_chain,varbinary_to_int256(varbinary_ltrim(varbinary_substring(data, 32 * 8 + 1, 32))) AS dst_chain_id,-- keep as VARBINARY so we can join to tokens.erc20varbinary_ltrim(varbinary_substring(data, 32 * 4 + 1, 32)) AS sending_token,varbinary_ltrim(varbinary_substring(data, 32 * 5 + 1, 32)) AS receiving_token,varbinary_ltrim(varbinary_substring(data, 32 * 6 + 1, 32)) AS receiver,varbinary_to_int256(varbinary_ltrim(varbinary_substring(data, 32 * 7 + 1, 32))) AS amountFROM ethereum.logsWHERE contract_address = 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaeAND topic0 = 0xcba69f43792f9f399347222505213b55af8e0b0b54b893085c2e27ecbe1644f1UNION ALL-- ArbitrumSELECTblock_time,tx_hash,'arbitrum' AS src_chain,varbinary_to_int256(varbinary_ltrim(varbinary_substring(data, 32*8 + 1, 32))),varbinary_ltrim(varbinary_substring(data, 32*4 + 1, 32)),varbinary_ltrim(varbinary_substring(data, 32*5 + 1, 32)),varbinary_ltrim(varbinary_substring(data, 32*6 + 1, 32)),varbinary_to_int256(varbinary_ltrim(varbinary_substring(data, 32*7 + 1, 32)))FROM arbitrum.logsWHERE contract_address = 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaeAND topic0 = 0xcba69f43792f9f399347222505213b55af8e0b0b54b893085c2e27ecbe1644f1UNION ALL-- BaseSELECTblock_time,tx_hash,'base' AS src_chain,varbinary_to_int256(varbinary_ltrim(varbinary_substring(data, 32*8 + 1, 32))),varbinary_ltrim(varbinary_substring(data, 32*4 + 1, 32)),varbinary_ltrim(varbinary_substring(data, 32*5 + 1, 32)),varbinary_ltrim(varbinary_substring(data, 32*6 + 1, 32)),varbinary_to_int256(varbinary_ltrim(varbinary_substring(data, 32*7 + 1, 32)))FROM base.logsWHERE contract_address = 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaeAND topic0 = 0xcba69f43792f9f399347222505213b55af8e0b0b54b893085c2e27ecbe1644f1UNION ALL-- Optimism