Query editor
WITH txs AS (SELECTDATE_TRUNC('day', block_time) AS dt,to,hash,indexFROM mantle.transactionsWHERE block_time >= date('2025-01-01')and successand block_time < current_dateand index <> 0 -- System Tx)select dt,sector, count(1) as txsfrom(select dt,coalesce(b.sector,'Others') as sectorfrom txs aleft join query_5956615 b on a.to = b.contract) agroup by 1,2