WITH base_holograph_protocol_bridge_jobs AS (

select

block_timestamp :: date as block_time,

data as msg

from

base.core.fact_event_logs

where

1 = 1 -- and tx_hash=lower('0x0c2cae2891281764f98e13a67309c485ce0bb929432afeff0e5d43e3c7f234e3')

and contract_address in (

lower('0xe8303f9b7d7a3de35f8c9b4405411c5ebfaf4c2c')

,

lower('0xe1dd53589c001982d06247e1259dcc366b8ddb1b')

)

and origin_function_signature = '0xe5585666'

and block_time >= '2023-01-01'

-- and block_time < '2024-01-01'

-- and block_time >= '2024-01-01'

group by

block_time,

msg

),

base_holograph_protocol_bridge_jobs_counter AS (

SELECT

COUNT(msg) AS msg_count,

block_time

FROM

base_holograph_protocol_bridge_jobs

GROUP BY

msg,

block_time

,data_aggregated as