flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
TOP 10 Users With the Most Transactions Count copy
cryptall
TOP 10 Users With the Most Transactions Count copy
Updated 2024-06-25
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
from_address
as
"User"
,
count
(
distinct
tx_hash
)
as
"txn_count"
from
blast
.
core
.
fact_transactions
where
status
=
'SUCCESS'
group
by
1
order
by
2
desc
limit
10
Results
QueryRunArchived: QueryRun has been archived