SELECT date_trunc('day', created_block_timestamp) as date,

COUNT(DISTINCT ADDRESS) as new_contracts

FROM base.core.dim_contracts

WHERE created_block_timestamp::date >= '2024-01-01'

AND created_block_timestamp::date < current_date

AND name IS NULL

AND symbol IS NOT NULL

GROUP BY 1

ORDER BY 1

),

Users AS (

SELECT date_trunc('day', created_block_timestamp) as date,

COUNT(DISTINCT ADDRESS) as new_wallets

FROM base.core.dim_contracts

WHERE created_block_timestamp::date >= '2024-01-01'

AND created_block_timestamp::date < current_date

AND name IS NULL

AND symbol IS NULL

GROUP BY 1

ORDER BY 1

SELECT projects.date,

projects.new_contracts,

users.new_wallets

FROM Projects

JOIN Users ON projects.date = users.date;