Query editor
WITHdays AS (WITHday_array AS (SELECTdays_arrayFROM(VALUESsequence(TIMESTAMP '2023-01-01 00:00:00',CAST(date_trunc('day', now()) AS TIMESTAMP),interval '1' day)) t (days_array)),unset_days AS (SELECT*FROMday_arrayCROSS JOIN UNNEST ("days_array") AS t (day))SELECTCAST(day AS TIMESTAMP) AS dayFROMunset_daysORDER BYday),arbitrum_lz_messages AS (WITHlz_messages AS (SELECTdate_trunc('day', evt_block_time) AS time_stamp,evt_tx_hash AS tx_hash,COUNT(evt_index) AS lz_message_countFROMlayerzero_arbitrum.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,2)SELECTtime_stamp AS day,SUM(lz_message_count) AS totalFROMlz_messagesGROUP BY1),arbitrum_hlg_messages AS (WITHhlg_messages AS (SELECTdate_trunc('day', evt_block_time) AS time_stamp,