SELECT tx_receiver as contract, a.block_timestamp, tx

from near.core.fact_actions_events a

LEFT JOIN near.core.fact_transactions t ON t.tx_hash = a.tx_hash

where action_name = 'DeployContract'

),

refine as(

SELECT

COUNT(DISTINCT contract) as totals,

COUNT(contract) as total_deployments

from base

SELECT * from refine