aPrioriuser_profile
Updated 2025-03-14Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
FROM_ADDRESS as wallet
,count(distinct TX_HASH) as tx_count
,count(distinct TO_ADDRESS) as address_count
,count(distinct date(BLOCK_TIMESTAMP)) as tx_date_count
from
(
select
FROM_ADDRESS
,TO_ADDRESS
,TX_HASH
,BLOCK_TIMESTAMP
from monad.testnet.fact_transactions
) a
group by 1
order by address_count desc
QueryRunArchived: QueryRun has been archived