Query editor
WITHethereum_lz_messages AS (WITHlz_messages AS (SELECTevt_tx_hash AS tx_hash,count(evt_index) AS lz_message_countFROMlayerzero_ethereum.UltraLightNodeV2_evt_PacketReceivedWHEREevt_block_time >= TIMESTAMP '2023-01-01 00:00:00'AND evt_block_time < TIMESTAMP '2024-01-01 00:00:00'AND contract_address = 0x4d73adb72bc3dd368966edd0f0b2148401a178e2GROUP BY1)SELECTSUM(lz_message_count) AS totalFROMlz_messages),ethereum_hlg_messages AS (WITHhlg_messages AS (SELECTevt_tx_hash AS tx_hash,count(evt_index) AS hlg_message_countFROMholograph_operator_ethereum.HolographOperator_evt_AvailableOperatorJobWHEREevt_block_time >= TIMESTAMP '2023-01-01 00:00:00'AND evt_block_time < TIMESTAMP '2024-01-01 00:00:00'AND contract_address = 0xe8303f9b7d7a3de35f8c9b4405411c5ebfaf4c2cGROUP BY1)SELECTSUM(hlg_message_count) AS totalFROMhlg_messages)SELECT'Holograph' AS "Message Type",COALESCE(ethereum_hlg_messages.total, 0) AS "Messages Received"FROMethereum_hlg_messagesUNIONSELECT'LayerZero' AS "Message Type",(COALESCE(ethereum_lz_messages.total, 0) - COALESCE(ethereum_hlg_messages.total, 0)) AS "Messages Sent"FROMethereum_lz_messagesLEFT JOIN ethereum_hlg_messages ON TRUE