Query editor
WITH wallets AS (SELECT*FROM (VALUES(FROM_HEX('f3F496C9486BE5924a93D67e98298733Bb47057c'), 'MELENIA ( @qwatio On X )'),(FROM_HEX('45d26f28196d226497130c4bac709d808fed4029'), '$27M 47 vị thế short'),(FROM_HEX('0x20c2d95a3dfdca9e9ad12794d5fa6fad99da44f5'), 'Short ETH 3k pnl $86m'),(FROM_HEX('0xecb63caa47c7c4e77f60f1ce858cf28dc2b82b00'), 'Whale $37M winrate 99%'),(FROM_HEX('0x8cc94dc843e1ea7a19805e0cca43001123512b6a'), 'Whale $7M'),(FROM_HEX('0x8af700ba841f30e0a3fcb0ee4c4a9d223e1efa05'), 'Whale $13m'),(FROM_HEX('0xe4d31c2541a9ce596419879b1a46ffc7cd202c62'), 'Eric'),(FROM_HEX('0x7fdafde5cfb5465924316eced2d3715494c517d1'), 'BobbyBigSize'),(FROM_HEX('0x8589cd7a7b9e0c3ea3552facb8ff11b3135baad7'), 'James Wynn ví mới 2'),(FROM_HEX('0xbc476160765ff70cbd78d5a63aaa885555d575f1'), 'James Wynn ví mới'),(FROM_HEX('0x5078c2fbea2b2ad61bc840bc023e35fce56bedb6'), 'James Wynn'),(FROM_HEX('0x1f250Df59A777d61Cb8bd043c12970F3AFE4F925'), 'Aguila Trade'),(FROM_HEX('0xb83de012dba672c76a7dbbbf3e459cb59d7d6e36'), 'Abraxas Capital wallet 2'),(FROM_HEX('0xcB92C5988b1D4f145a7B481690051F03EaD23a13'), 'Abraxas Capital'),(FROM_HEX('0x5b5d51203a0f9079f8aeb098a6523a13F298C060'), 'Abraxas Capital'),(FROM_HEX('0xecb63caa47c7c4e77f60f1ce858cf28dc2b82b00'), 'Wintermute'),(FROM_HEX('0x7fdafde5cfb5465924316eced2d3715494c517d1'), 'Fasanara Capital'),(FROM_HEX('0x20c2d95a3dfdca9e9ad12794d5fa6fad99da44f5'), 'Resolv USR'),(FROM_HEX('0x020ca66c30bec2c4fe3861a94e4db4a498a35872'), 'Machi Big Brother'),(FROM_HEX('0x1d52fe9bde2694f6172192381111a91e24304397'), '0xtyle.eth'),(FROM_HEX('0x77375a8c9d13bf79afb2a87f1b0ac1dfd5f5bf66'), '投资者.eth'),(FROM_HEX('0xbbbc35dfac3a00a03a8fde3540eca4f0e15c5e64'), '@0xbbbc on Farcaster'),(FROM_HEX('2df1c51e09aecf9cacb7bc98cb1742757f163df7'), '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('f3F496C9486BE5924a93D67e98298733Bb47057c'),FROM_HEX('45d26f28196d226497130c4bac709d808fed4029'),FROM_HEX('0x20c2d95a3dfdca9e9ad12794d5fa6fad99da44f5'),FROM_HEX('0xecb63caa47c7c4e77f60f1ce858cf28dc2b82b00'),FROM_HEX('0x8cc94dc843e1ea7a19805e0cca43001123512b6a'),FROM_HEX('0x8af700ba841f30e0a3fcb0ee4c4a9d223e1efa05'),FROM_HEX('0xe4d31c2541a9ce596419879b1a46ffc7cd202c62'),FROM_HEX('0x7fdafde5cfb5465924316eced2d3715494c517d1'),FROM_HEX('0x8589cd7a7b9e0c3ea3552facb8ff11b3135baad7'),FROM_HEX('0xbc476160765ff70cbd78d5a63aaa885555d575f1'),FROM_HEX('0x5078c2fbea2b2ad61bc840bc023e35fce56bedb6'),FROM_HEX('0x1f250Df59A777d61Cb8bd043c12970F3AFE4F925'),FROM_HEX('0xb83de012dba672c76a7dbbbf3e459cb59d7d6e36'),FROM_HEX('0xcB92C5988b1D4f145a7B481690051F03EaD23a13'),