Query editor
WITH msgs AS (SELECTCOALESCE(NULLIF(TRIM(m.project), ''), 'unknown') AS project,COALESCE(DATE(m.ts_source), c.block_date) AS dayFROM layerzero.messages mINNER JOIN dune.canaryprotocol.result_transaction_list_validated_by_lz_canary_dvn cON m.tx_hash_source = CAST(c.tx_hash AS varchar)AND ((c.chain = 'bnb' AND m.source_chain_key = 'bsc')OR (c.chain = 'berachain' AND m.source_chain_key = 'bera')OR (c.chain = 'avalanche_c' AND m.source_chain_key = 'avalanche')OR (c.chain = 'hyperevm' AND m.source_chain_key = 'hyperliquid')OR c.chain = m.source_chain_key)WHERE c.block_date < DATE '2026-07-09'AND c.block_date >= CURRENT_DATE - INTERVAL '400' DAYAND m.state = 'Success'UNION ALLSELECTCOALESCE(NULLIF(TRIM(m.project), ''), 'unknown') AS project,DATE(m._updated_at) AS dayFROM layerzero.messages mWHERE m._updated_at >= GREATEST(DATE '2026-07-09', CURRENT_DATE - INTERVAL '400' DAY)AND m.state = 'Success'UNION ALLSELECTCOALESCE(NULLIF(TRIM(m.project), ''), 'unknown') AS project,COALESCE(DATE(m.ts_source), c.block_date) AS dayFROM layerzero.messages mINNER JOIN dune.canaryprotocol.result_transaction_list_include_fee_paide_to_wbtc_canary_dvn cON m.tx_hash_source = CAST(c.tx_hash AS varchar)AND ((c.chain = 'bnb' AND m.source_chain_key = 'bsc')OR (c.chain = 'berachain' AND m.source_chain_key = 'bera')OR (c.chain = 'avalanche_c' AND m.source_chain_key = 'avalanche')OR c.chain = m.source_chain_key)WHERE c.block_date < DATE '2026-07-09'AND c.block_date >= CURRENT_DATE - INTERVAL '400' DAYAND m.project = 'wBTC'AND m.state = 'Success'),msg_daily AS (SELECT project, day, COUNT(*) AS messagesFROM msgsWHERE LOWER(project) <> 'unknown'GROUP BY 1, 2),vol_daily AS (SELECTproject,block_date AS day,SUM(volume_usd) AS volume_usd,COUNT(*) AS valued_transfer_rowsFROM query_8631911WHERE block_date >= CURRENT_DATE - INTERVAL '400' DAY