bachiNEAR contracts2
Updated 2022-08-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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