SELECT

MIN(tr.block_timestamp) AS create_timestamp,

tr.tx_hash,

tr.from_address AS deployer,

tr.to_address AS contract,

t.tx_fee AS deployment_cost

FROM

monad.testnet.fact_traces tr

JOIN

monad.testnet.fact_transactions t

ON

tr.tx_hash = t.tx_hash

WHERE

tr.type ILIKE 'create%'

AND tr.tx_succeeded = TRUE

AND tr.trace_succeeded = TRUE

AND tr.to_address IS NOT NULL

GROUP BY

tr.tx_hash, tr.from_address, tr.to_address, t.tx_fee

SELECT

COUNT(DISTINCT contract) AS new_contracts,

FROM

contract_deployments

WHERE create_timestamp::date >= '2025-02-19'