WITH base_holograph_protocol_contract_deployments AS (

select

date_trunc('day', block_timestamp) as date,

concat('0x', substr(topics [1], 27, 64)) as contract

from

base.core.fact_event_logs

where

1 = 1

-- and date >= '2023-01-01'

-- and date < '2024-01-01'

and date >='2024-01-01'

and contract_address in

(

-- lower('0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55')

-- ,

lower('0xf3ddf3dc6ebb5c5dc878c7a0c8b2c5e051c37594')

)

and origin_function_signature = '0xdf6516bd'

group by

date,

contract

),

base_holograph_protocol_contract_deployments_counter AS (

SELECT

COUNT(contract) AS contract_count,

date

FROM

base_holograph_protocol_contract_deployments

GROUP BY

contract,

date

dd.date_day as date,