Query editor
WITH wallets AS (SELECT*FROM (VALUES(FROM_HEX('0x940df59ba33f3387deff3c2400fecf1286fcce4c'), 'Stupid 1'),(FROM_HEX('0x153c8444380512cabdc34f6cea09c322e14e319a'), 'Stupid 2'),(FROM_HEX('0x989b96317735d70a7762bf96c034b203713aae18'), 'Stupid 3'),(FROM_HEX('0xeadc152ac1014ace57c6b353f89adf5faffe9d55'), 'Stupid 4'),(FROM_HEX('0xa2ce501d9c0c5e23d34272f84402cfb7835b3126'), 'Stupid 5'),(FROM_HEX('0x2e2b6070bec9be9f50887cfe306ac6ca93002fab'), 'Stupid 6'),(FROM_HEX('0x36ccdef4decfa6ae89707b1737e8fc56d275414f'), 'Stupid 7'),(FROM_HEX('0x523b21f469825d0104ac6a3c762a955eedb75e5b'), 'Stupid 8'),(FROM_HEX('0x2df1c51e09aecf9cacb7bc98cb1742757f163df7'), 'Hyperliquid: Bridge')) AS t(wallet_address, name_tag))SELECTtx.evt_block_time AS tx_time,COALESCE(w1.name_tag, CAST(tx."from" AS VARCHAR)) AS sender,COALESCE(w2.name_tag, CAST(tx."to" AS VARCHAR)) AS receiver,tx.value / 1e6 AS usdc_amount,get_href('https://arbiscan.io/tx/' || TRY_CAST(evt_tx_hash AS VARCHAR), 'tx') AS txhashFROM erc20_arbitrum.evt_Transfer AS txLEFT JOIN wallets AS w1ON tx."from" = w1.wallet_addressLEFT JOIN wallets AS w2ON tx."to" = w2.wallet_addressWHERE(tx."from" = FROM_HEX('2Df1c51E09aECF9cacb7bc98cB1742757f163dF7')OR tx."to" = FROM_HEX('2Df1c51E09aECF9cacb7bc98cB1742757f163dF7'))AND ((tx."from" = FROM_HEX('2Df1c51E09aECF9cacb7bc98cB1742757f163dF7')AND tx."to" IN (FROM_HEX('0x940df59ba33f3387deff3c2400fecf1286fcce4c'),FROM_HEX('0x153c8444380512cabdc34f6cea09c322e14e319a'),FROM_HEX('0x989b96317735d70a7762bf96c034b203713aae18'),FROM_HEX('0xeadc152ac1014ace57c6b353f89adf5faffe9d55'),FROM_HEX('0xa2ce501d9c0c5e23d34272f84402cfb7835b3126'),FROM_HEX('0x2e2b6070bec9be9f50887cfe306ac6ca93002fab'),FROM_HEX('0x36ccdef4decfa6ae89707b1737e8fc56d275414f'),FROM_HEX('0x523b21f469825d0104ac6a3c762a955eedb75e5b')))OR(tx."to" = FROM_HEX('2Df1c51E09aECF9cacb7bc98cB1742757f163dF7')AND tx."from" IN (FROM_HEX('2Df1c51E09aECF9cacb7bc98cB1742757f163dF7'),FROM_HEX('0x940df59ba33f3387deff3c2400fecf1286fcce4c'),FROM_HEX('0x153c8444380512cabdc34f6cea09c322e14e319a'),FROM_HEX('0x989b96317735d70a7762bf96c034b203713aae18'),FROM_HEX('0xeadc152ac1014ace57c6b353f89adf5faffe9d55'),FROM_HEX('0xa2ce501d9c0c5e23d34272f84402cfb7835b3126'),FROM_HEX('0x2e2b6070bec9be9f50887cfe306ac6ca93002fab'),FROM_HEX('0x36ccdef4decfa6ae89707b1737e8fc56d275414f'),FROM_HEX('0x523b21f469825d0104ac6a3c762a955eedb75e5b'))))ORDER BYtx.evt_block_time DESC;