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'),daily AS (SELECTDATE_TRUNC('day', block_time) AS day,SUM(CASE WHEN direction = 'in' THEN amount_tao ELSE 0 END) AS bridged_in,SUM(CASE WHEN direction = 'out' THEN amount_tao ELSE 0 END) AS bridged_outFROM eventsGROUP BY 1)SELECTday,SUM(bridged_in) OVER (ORDER BY day) AS cumulative_in_tao,SUM(bridged_out) OVER (ORDER BY day) AS cumulative_out_tao,SUM(bridged_in - bridged_out) OVER (ORDER BY day) AS net_locked_taoFROM dailyORDER BY day