bachiNEAR contracts2
    Updated 2022-08-03

    select count(distinct tx_hash) as no_of_txns,
    count(distinct contract_address) as no_of_smart_contracts_deployed
    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%'
    )

    Run a query to Download Data