select date(block_timestamp) as day,

count(distinct tx_hash) as no_of_txns,

count(distinct contract_address) as no_of_smart_contracts_deployed,

count(distinct signer) as no_of_signers

FROM(

SELECT ev.tx_hash

, ev.block_timestamp

, action_name

, tx.tx_signer as signer

, tx.tx_receiver AS contract_address

from near.core.fact_actions_events as ev

inner join near.core.fact_transactions AS tx

on tx.tx_hash = ev.tx_hash

where ev.action_name like '%DeployContract%'

)

group by day

order by day desc