Query editor
WITH bridge_in AS (SELECTCAST(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'),bridge_out AS (SELECTCAST(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'),bridge_in_users AS (SELECT DISTINCT addr_from AS user_idFROM layerzero.messagesWHERE source_contract = '0x3e0424fff005cb57549ae6f9e12d5d583efc9ed2'AND source_chain = 'Subtensorevm'),bridge_out_recipients AS (SELECT DISTINCT bytearray_substring(pkt.data, 242, 32) AS user_idFROM arbitrum.logs sentJOIN arbitrum.logs pktON pkt.tx_hash = sent.tx_hashAND pkt.block_date = sent.block_dateAND pkt.topic0 = 0x1ab700d4ced0c005b164c0f789fd09fcbb0156d4c2041b8a3bfbcd961cd1567fWHERE sent.contract_address = 0x3e0424fff005cb57549ae6f9e12d5d583efc9ed2AND sent.topic0 = 0x85496b760a4b7f8d66384b9df21b381f5d1b1e79f229a47aaf4c232edc2fe59aAND CAST(bytearray_to_uint256(bytearray_substring(sent.data, 1, 32)) AS INTEGER) = 30374AND sent.block_date >= DATE '2026-04-01'AND pkt.block_date >= DATE '2026-04-01'),all_users AS (SELECT user_id FROM bridge_in_usersUNIONSELECT CAST(user_id AS varchar) FROM bridge_out_recipients)SELECT(SELECT COALESCE(SUM(amount_tao), 0) FROM bridge_in)+ (SELECT COALESCE(SUM(amount_tao), 0) FROM bridge_out) AS total_volume_tao,(SELECT COALESCE(SUM(amount_tao), 0) FROM bridge_in) AS bridged_in_tao,(SELECT COALESCE(SUM(amount_tao), 0) FROM bridge_out) AS bridged_out_tao,(SELECT COALESCE(SUM(amount_tao), 0) FROM bridge_in)- (SELECT COALESCE(SUM(amount_tao), 0) FROM bridge_out) AS net_locked_tao,(SELECT COUNT(*) FROM bridge_in) + (SELECT COUNT(*) FROM bridge_out) AS total_operations,(SELECT COUNT(*) FROM all_users) AS unique_users