avaemaDaily usage of top 10 users
Updated 2022-09-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
with tx_hashes as ( select tx_hash from near.core.fact_actions_events where action_name='DeployContract')
, daily as (select count(*), block_timestamp::date from near.core.fact_transactions where tx_hash in (select tx_hash from tx_hashes)
group by 2)
, weekly as (select count(*), week(block_timestamp::date) from near.core.fact_transactions where tx_hash in (select tx_hash from tx_hashes)
group by 2)
, dayname as (select count(*), dayname(block_timestamp::date) from near.core.fact_transactions where tx_hash in (select tx_hash from tx_hashes)
group by 2)
, dayofmonth as (select count(*), dayofmonth(block_timestamp::date) from near.core.fact_transactions where tx_hash in (select tx_hash from tx_hashes)
group by 2)
, top10contracts as (select count(*), tx_receiver from near.core.fact_transactions where tx_receiver
in (select tx_receiver from near.core.fact_transactions where tx_hash in (select tx_hash from tx_hashes) )
group by tx_receiver
order by 1 DESC
limit 10
)
, top10users as (select count(distinct tx_receiver), tx_signer from near.core.fact_transactions where tx_receiver
in (select tx_receiver from near.core.fact_transactions where tx_hash in (select tx_hash from tx_hashes) )
group by tx_signer
order by 1 DESC
limit 10
)
, top10contracts_chart as (select count(*), tx_receiver,block_timestamp::date from near.core.fact_transactions
where tx_receiver in (select tx_receiver from top10contracts)
group by 2,3)
,top10users_chart as (select count(*), tx_signer,block_timestamp::date from near.core.fact_transactions
where tx_signer in (select tx_signer from top10users)
group by 2,3)
select * from top10users_chart
Run a query to Download Data