SELECT

MIN(block_timestamp) AS first_block_timestamp,

contract_address

FROM

kaia.core.fact_event_logs

GROUP BY

contract_address

SELECT

COUNT(DISTINCT contract_address) AS "New Contracts 🆕"

FROM

contract_creation;