mmdrezaTop 10 Recipient of transactions
Updated 2022-10-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with tab1 as (select
to_address,
count(tx_hash) AS number_of_transactions
from gnosis.core.fact_transactions
where block_timestamp >= current_date-30
group by to_address order by number_of_transactions desc
limit 10)
select
date_trunc('day',block_timestamp) as date,
x.to_address,
count(tx_hash) AS number_of_transactions,
count(distinct from_address) as users
from gnosis.core.fact_transactions x
join tab1 t on t.to_address = x.to_address
where block_timestamp >= current_date-30
and x.to_address in (select to_address from tab1)
group by date ,x.to_address order by number_of_transactions desc
Run a query to Download Data