Query editor
WITH events AS (SELECT block_time, 'in' 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 block_time, 'out' 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')SELECTDATE_TRUNC('day', block_time) AS day,SUM(CASE WHEN direction = 'in' THEN amount_tao ELSE 0 END) AS bridged_in_tao,SUM(CASE WHEN direction = 'out' THEN amount_tao ELSE 0 END) AS bridged_out_tao,SUM(amount_tao) AS total_tao,COUNT(*) AS num_operationsFROM eventsGROUP BY 1ORDER BY 1