Query editor
WITH deploy_data AS (SELECTblock_time,tx_hash,FROM_HEX(SUBSTR(CONCAT(CAST(COALESCE(CAST(COALESCE(TRY_CAST(0x AS VARCHAR), '') AS VARCHAR), '') AS VARCHAR),CAST(COALESCE(CAST(COALESCE(TRY_CAST(SUBSTR(TRY_CAST(data AS VARCHAR), 27, 40) AS VARCHAR),'') AS VARCHAR),'') AS VARCHAR)),3)) AS contract_address,FROM_UTF8(FROM_HEX(CAST(SUBSTR(TRY_CAST(data AS VARCHAR), 3+64+cast(bytearray_to_uint256(from_hex(concat('0x',substr(cast(data as varchar),3+64*2,64))))*2 as bigint), 64) AS VARCHAR))) AS token_symbol,FROM_UTF8(FROM_HEX(CAST(SUBSTR(TRY_CAST(data AS VARCHAR), 3+64+cast(bytearray_to_uint256(from_hex(concat('0x',substr(cast(data as varchar),3+64,64))))*2 as bigint), cast(bytearray_to_uint256(from_hex(concat('0x',substr(cast(data as varchar),3+64*3,64))))*2 as bigint)) AS VARCHAR))) AS token_nameFROM arbitrum.logsWHERE topic0 = 0xd9b0c6a1c0de228715ad0fa09f3259686ee84f8cc675e03ef7e47a9cdafa76d6AND contract_address = 0xd29aa2b0584856c2b3b097595e9d4b1cd1242e05AND block_time >= DATE('2025-05-19')),update_data AS (SELECT"to",max_by(hash, block_time) AS hash,max_by(token_symbol, block_time) AS token_symbol,max_by(token_name, block_time) AS token_nameFROM (SELECTblock_time,"to",hash,FROM_UTF8(FROM_HEX(CAST(SUBSTR(TRY_CAST(data AS VARCHAR), 11 + 64 * 4 + cast(bytearray_to_uint256(from_hex(concat('0x',substr(cast(data as varchar),11+64*2,64))))*2 as bigint), 64) AS VARCHAR))) AS token_symbol,FROM_UTF8(FROM_HEX(CAST(SUBSTR(TRY_CAST(data AS VARCHAR), 11 + 64 * 3, cast(bytearray_to_uint256(from_hex(concat('0x',substr(cast(data as varchar),11+64*2,64))))*2 as bigint)) AS VARCHAR))) AS token_nameFROM arbitrum.transactionsWHERE "to" IN (SELECT DISTINCT contract_address FROM deploy_data)AND substring(cast(data as varchar), 1, 10) = '0x51335b50'AND block_time >= TIMESTAMP '2025-05-19 00:00:00') aGROUP BY 1),tokens_raw AS (SELECTa.block_time,tx_hash AS deployed_hash,hash AS update_hash,a.contract_address,REGEXP_REPLACE(coalesce(b.token_symbol, a.token_symbol),'[^[:print:]]', '') AS token_symbol,coalesce(b.token_name, a.token_name) AS token_nameFROM deploy_data aLEFT JOIN update_data bON a.contract_address = b."to"WHERE coalesce(b.token_name, a.token_name) IS NOT NULLAND coalesce(b.token_symbol, a.token_symbol) IS NOT NULLAND cast(to_utf8(coalesce(b.token_name, a.token_name)) AS varchar) <> '0x'),tokens_meta AS (SELECT DISTINCTcontract_address,token_symbol