Query editor
WITH events AS (SELECT 'Bridged In (Bittensor → HyperEVM)' AS direction,CAST(bytearray_to_uint256(bytearray_substring(data, 33, 32)) AS DOUBLE) / 1e18 AS amount_taoFROM arbitrum.logsWHERE contract_address = 0x3e0424fff005cb57549ae6f9e12d5d583efc9ed2AND topic0 = 0xefed6d3500546b29533b128a29e3a94d70788727f0507505ac12eaf2e578fd9cAND CAST(bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS INTEGER) = 30374AND block_date >= DATE '2026-04-01'UNION ALLSELECT 'Bridged Out (HyperEVM → Bittensor)' AS direction,CAST(bytearray_to_uint256(bytearray_substring(data, 33, 32)) AS DOUBLE) / 1e18 AS amount_taoFROM arbitrum.logsWHERE contract_address = 0x3e0424fff005cb57549ae6f9e12d5d583efc9ed2AND topic0 = 0x85496b760a4b7f8d66384b9df21b381f5d1b1e79f229a47aaf4c232edc2fe59aAND CAST(bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS INTEGER) = 30374AND block_date >= DATE '2026-04-01')SELECTdirection,COUNT(*) AS num_operations,SUM(amount_tao) AS total_taoFROM eventsGROUP BY 1