HadisehThe Law Offices of NEAR 4
Updated 2022-08-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with t1 as ( select
min(block_timestamp) as date ,
tx_receiver
from near.core.fact_transactions
where TX_HASH in ( select tx_hash
from near.core.fact_actions_events
where action_name = 'DeployContract' )
group by 2)
,
t2 as ( select date , tx_receiver
from t1
where date::date >= CURRENT_DATE - 90)
select
tx_receiver,
count(DISTINCT tx_hash) as users
from near.core.fact_transactions
where TX_HASH in ( select tx_hash
from near.core.fact_actions_events
where action_name = 'DeployContract' ) and tx_receiver in ( select tx_receiver from t2)
group by 1
order by 2 desc
limit 10
Run a query to Download Data