rackhaelUntitled Query
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with base as (select tx_receiver,
min(block_timestamp) as first_deployment
from near.core.fact_transactions
where tx_hash in (select tx_hash from near.core.fact_actions_events where action_name = 'DeployContract')
group by 1
having first_deployment > '2022-01-01')
select tx_receiver,
count(distinct(tx_signer)) as contract_user,
count(distinct(tx_hash)) as tx_count
from near.core.fact_transactions
where tx_receiver in (select tx_receiver from base)
group by 1
order by 3 desc
limit 5
Run a query to Download Data