date_trunc('day', block_timestamp) as day,

count(distinct tx_hash)

from near.core.fact_actions_events

where ACTION_NAME='DeployContract'

group by 1